Oracle not coming up : ORA-49100

[Former Member]

Hi Gurus,

I stopped our SAP system with regular stopsap command

While starting the SAP system, Oracle DB is not coming up

Its giving :

SQL> STARTUP

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-49100: Failed to process event statement [38068 ,level 100]

ORA-49601: syntax error: found ",": expecting one of: "End-of-Statement" etc..

Can anyone advice on this

R..../-

Sandy

[Former Member · Accepted solution]

Hi all,

Any inputs on this. Its very urgent and I have not been able to find anything on SCn or Google or SAP Notes

Please advice

R..../-

Sandy

[former_member182657 · Accepted solution]

Hi Sandy,

Please share alert_<SID>.log file first.

Also are you able to run startup mount command means instead of STARTUP use STARTUP MOUNT .

Thanks,

Gaurav

[Former Member · Accepted solution]

Hi Gaurav and all,

Issue is resolved

Some event parameters were added in spfile with command ALTER SYSTEM SET EVENT = '10027','10028','10142','10183','10191','38068 ,level 100','38085','38087','44951 ,level 1024','10995 ,level 2' scope = SPFILE;

This command had syntax errors in it and thus the problem had occurred

Copying the entire string from our Production server did not help nor did the manual editing of spfile (/oracle/SID/112_64/dbs/spfileSID.ora

Finally pfile from (/oracle/SID/112_64/dbs/initSID.ora) was edited and the event parameters which were shown in the error were removed. Then the DB was brought up with command

STARTUP pfile = /oracle/SID/112_64/dbs/initSID.ora

Once the DB opened, spfile was created from pfile by command

create spfile from pfile

Then once again the DB was bounced with

shutdown immediate

startup

Once the DB started, once again the missing parameters were added with ALTER SYSTEM SET EVENT command.

Then once again the DB was bounced with

shutdown immediate

startup

Thanks all

R..../-

Sandy