Question Re: oracle problems in Technology Q&A

oracle problems

Former Member — Fri, 15 May 2009 21:40:25 GMT

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?

Re: oracle problems

Former Member — Sat, 16 May 2009 05:48:09 GMT

Hi,

Please check the lsnrctl service.---->

lsnrctl -l .

Also,

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

Regards,

Pankaj

Re: oracle problems

Former Member — Sat, 16 May 2009 08:48:38 GMT

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 .

Re: oracle problems

Former Member — Mon, 18 May 2009 10:26:28 GMT

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

Re: oracle problems

Former Member — Mon, 18 May 2009 11:53:08 GMT

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

Re: oracle problems

Former Member — Mon, 01 Jun 2009 21:36:35 GMT

what happens if you execute:

SQLPLUS> startup[