Home » Infrastructure » Unix » Oracle 9.2.0.1 won't start in Solaris 5.8
Oracle 9.2.0.1 won't start in Solaris 5.8 [message #98165] Sun, 18 April 2004 15:22 Go to next message
Nick
Messages: 64
Registered: February 2000
Member
I've used the search button and google and got nothing.
I am by no means a DBA so this is all foreign to me. I did figure out some stuff but have a lot more to go.

This is my problem (from alerter log):

Sun Apr 18 19:14:57 2004
scumnt: failed to lock /u001/OracleDB/OraMYDBA//dbs/lkMYDB exclusive
Sun Apr 18 19:14:57 2004
ORA-09968: scumnt: unable to lock file
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 736
Sun Apr 18 19:14:57 2004
ORA-1102 signalled during: ALTER DATABASE MOUNT...

This is what I do:
connect to sqlplus: sys as sysdba
I do shutdown to stop the instance
lsnrctl stop to stop the listeners
then I do ./dbshut to shut down the database

This all executes without a problem

Then I do:
./dbstart to start up oracle
./lsnrctl to start the listeners
then I connect using sqlplus sys as sysdba
and execute
startup to start the instance.

This is where the problem begins:
SQL> startup
ORACLE instance started.

Total System Global Area 135352820 bytes
Fixed Size 455156 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 679936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

I believe this is all stemming from my $ORACLE_HOME/dbs/lkMYDB file which I removed per someone's suggestion while trying to fix a different problem. (Link here: http://www.orafaq.com/forum/t/40030/0/ )

if I leave it alone, I get the ORA-01102 (above)
if I delete it I get this:
ORA-00205: error in identifying controlfile, check alert log for more info

I can't connect to my database as a normal user either
I get an Oracle not available and an error about shared memory.

Anyone have an idea?

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #98207 is a reply to message #98165] Tue, 11 May 2004 09:53 Go to previous messageGo to next message
Ryan Smith
Messages: 2
Registered: February 2003
Junior Member
I have having very similar problem in Linux AS 3.0. Same errors, same steps. Did you ever get it fixed? Whatcha do?
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #98227 is a reply to message #98207] Sun, 16 May 2004 20:06 Go to previous messageGo to next message
Nick
Messages: 64
Registered: February 2000
Member
Yeah I fixed it.

What I did was ask a real DBA to take a look at it.

If I recall correctly, he moved the files around so that Oracle started with the default control files. After it did that, we moved the files back and it started fine afterwards.
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #98570 is a reply to message #98165] Wed, 05 January 2005 22:28 Go to previous messageGo to next message
prashant
Messages: 122
Registered: September 2000
Senior Member
Do this :-

1>Shutdown the database.

2> Remove the file

rm -f $ORACLE_HOME/dbs/lkMYDB

4> go to sqlplus by issueing
$sqlplus

and issue the command

create spfile from pfile;

file created

3> Start the Database..

I saw you are using scripts so please use the same scripts to shutdown and starup the database.

Thanks
Prashant.
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #123446 is a reply to message #98165] Mon, 13 June 2005 09:23 Go to previous messageGo to next message
saqibmohsin
Messages: 1
Registered: June 2005
Location: MI, USA
Junior Member
Simply,

rename /u001/OracleDB/OraMYDBA//dbs/lkMYDB
touch /u001/OracleDB/OraMYDBA//dbs/lkMYDB
verify permissions
sqlplus "/ as sysdba"
SQL> startup
This would do the job.

Thanks.
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #339575 is a reply to message #98165] Thu, 07 August 2008 20:09 Go to previous messageGo to next message
MJ_ORAFAQ
Messages: 2
Registered: August 2008
Junior Member
This occurs either because there are still database processes that have a lock on the file or because the database processes died and didn't release their lock on the files for some reason.

In my case it was the first one. The processes went rogue - sqlplus said the database instance hadn't started, but the processes were still alive.

For the first case, use connect via sqlplus, run shutdown immediate. Then in Unix, "ps -ef | grep -i oracle" to find the processes, then "kill -9" on each of the process numbers. After that your db should start.

For possibility 2 or if that doesn't fix your problem, do what the other guy said (move the lock file and recreate with 'touch')
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #339576 is a reply to message #98165] Thu, 07 August 2008 20:19 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
MJ_ORAFAQ,
Responding to a 3+ year old post is a waste of electron, in my opinion.
Re: Oracle 9.2.0.1 won't start in Solaris 5.8 [message #339577 is a reply to message #339576] Thu, 07 August 2008 20:28 Go to previous message
MJ_ORAFAQ
Messages: 2
Registered: August 2008
Junior Member
That's nice.

Since I had the same problem, found this post via google and eventually figured out what was going on, someone else might find it via the same means.



Previous Topic: Need 8.1.7 client for AIX 3.5
Next Topic: Error: ORA-01033 ORACLE initialization or shutdown in progress
Goto Forum:
  


Current Time: Sun Sep 21 11:25:08 CDT 2014

Total time taken to generate the page: 0.07852 seconds