ORA-10997, ORA-09967 and Linux error
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.