oracle problems

[Former Member]

We have an oracle problem. We had an space problem, which is solved now.

When trying to startsap(on linux) we get

"Log file: /home/pi2adm/startdb.log

/usr/sap/PI2/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

"

when trying to stop oracle(and restart it after) we get:

"SQL> connect /as sysdba

Connected to an idle instance.

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

"

when trying to:shutdown abort with "ora" user we get

"SQL> connect /as sysdba

Connected to an idle instance.

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

"

What to do?

[Former Member]

ORA-01089 means u'h run already shutdown but not successfully excute command. now ur trying again shutdown.

u can check " ps -aeg|grep ora " some oracle process may be running

U have two option . leave the command till excute (internal process still running)

second

SQL> shutdown abort;

After shutdown media recovery may be require .

if still problm then paste some bottom lines from alert_log_file .