Urgent Please help: ORA-00940: invalid ALTER command

[Former Member]

I am not able to start my oracle db that is running Solaris 10, Oracle 10g.

I made the following changes to Oracle Parameter and now I am not able to start.

alter system set "_fix_control"='5705630:ON' scope=spfile;

I get this error: ORA-00940: invalid ALTER command

I am not even able to reset that parameter back, since oracle db won't start?

I get this error when i run "startsap: on command

Please help

Thanks

Kuamr

Message was edited by:

Kumar Subramaniam

Message was edited by:

Kumar Subramaniam

[Former Member]

Hello Kuamr,

Can you please copy the contents of the alertSID.log file here when you try to start SAP? This file is located under /oracle/SID/saptrace/background

Regards

Andreas

[Former Member]

I have renameed the spfile and try to start sap using initPR2.ora file and it worked fine and then I did this to re-create teh spfile.

sqlplus / assysdba

create spfile from pfile;

shutdown immediate;

startup;

Everything works fine.

Thanks for the quick response.