Hi,
Thanks for your help. I solved the problem. For some insane and unknown
reason all the oracle processes (ie smon, pmon lgwr etc) were stuck!
I restarted the server and it worked fine. I don't know why they were stuck!
Regards,
Sujatha
-Original Message-
Sent: Monday, 26 November
Sujatha:
I've seen this happen before under these circumstances:
1) The DB is up and running, started by the Oracle owner.
2) A UNIX user who is a member of the DBA group starts svrmgrl
and tries to start the same instance. Now suddenly there are two
sets of processes for that instance.
Hi,
Thanks. I think that is exactly what happened. Someone has tried to shutdown
and startup the database logged in as the root user. It screwed things up a
bit ... but now they seem fine.
Cheers,
Sujatha
-Original Message-
Sent: Tuesday, 27 November 2001 9:25 AM
To: Multiple
are you running more than one Oracle instance? you should see
ora_sid_smon -- is the value of sid the same as that of the database
that you shutdown?
did the database you think you shut down, shut down properly?
--- Sujatha Madan [EMAIL PROTECTED] wrote:
Hi,
If I have shutdown my database
Hi,
Yes the SID is the same as the one I shut down. Also, when I try and start
the database up it is giving me an ORA-01102 error (Cannot mount database in
exclusive mode at startup).
The other db on the system is shutdown properly.
I had thought that only Win NT gives ORA01102 errors -
Hi
I am not sure if I have understood ur problem
but can u please try this
1. cd $ORACLE_HOME/dbs
2. ls -alt lk*.ora
3. if there is any file by the name
lkdb_name.ora where db_name is the database name
and NOT SID then try removing this file and
starting up