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 · Accepted solution]

Hi.. Jan,

I think you got some problem while doing some DB activity and that activity is not completed successfully.

Just try,

1. connect /as sysdba

2. shutdown abort;

and wait for 15 minute.

again login as sysdba,

3. recover database;

4. shutdown immediate

then exit from sql and try to start like following--

connect /as sysdba

startup open;

if it execute without any error. then try to start SAP.

else paste the related log / errors.

Regards,

Abhimanyu