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

[Former Member]

what happens if you execute:

SQLPLUS> startup[

[Former Member]

Hi,

"SQL> connect /as sysdba

Connected to an idle instance.

SQL> shutdown immediate

ORA-24324: service handle not initialized"

as per your lines database is not running start it up.

Regards,

Rakesh

[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 .

[Former Member]

Hi,

Please check the lsnrctl service.---->

lsnrctl -l .

Also,

Please check oracle alert log. alert<SID>.log

Regards,

Pankaj