| Oracle 9.2.0.1 won't start in Solaris 5.8 [message #98165] |
Sun, 18 April 2004 15:22  |
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 #98227 is a reply to message #98207] |
Sun, 16 May 2004 20:06  |
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 |
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 #339575 is a reply to message #98165] |
Thu, 07 August 2008 20:09 |
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')
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
