ORA-10997, ORA-09967 and Linux error

Asked By y.ned26 0 points N/A Posted on - 07/22/2011

Hi expert,

I have installed Oracle 10.2.0 on open SUSE 11.1 Linux with no errors recorded from the installation. I have started the database listener however, I cannot startup the database. I have used two different methods of startup, and both of them gave me these errors:

ORA-10997: another startup/shutdown operation of this instance in progress

ORA-09967: unable to create or open lock file

Linux Error 2: No such file or directory

In both cases, the ORACLE_HOME and ORACLE_SID variables were set. I have tried ”startup force” command in sqlplus, but I still cannot start up the database. Can someone offer a solution for this problem?

Thanks to all.

• Status: Open
• Question Views: 5342
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By gelorojocal 0 points N/A #84960

ORA-10997, ORA-09967 and Linux error

This error means that the operation failed to get the serialization primitive.

Try these:

• Try to set environment variables> type env | grep ORA
• After setting it, try this command:
• [root@serv2 ~]# chown -R oracle:dba /u01/app/oracle/

If it still won't work, try these:

• Type sqlplus
• / as sysdba
• Then “shutdown abort”
• Startup
• Choose * from v$version
• Exit

Note:  Since you have set you oracle_sid, make sure that the id is not ORACLE_SID=/dev, (does not have a backslash)

If there is:

• export ORACLE_SID
• cd $ORACLE_HOME/dbs
• sqlplus
• / as sysdba
• create pfile from spfile;
• startup
• exit
• cat initasysr11.ora

Hope this helps.

About gelorojocal

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: Oracle Database