ORA-10997, ORA-09967 and Linux error

Asked By 0 points N/A Posted on -

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.

Answered By 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.

Related Questions