| svrmgrl problem after an ORA-01034 [message #69212] |
Wed, 21 November 2001 13:04  |
Arnaud
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Hi,
I'm using Oracle8i/NT4. Well, I used to before it all got messed up...
After a system crash, I got the following errors when I tried to log in:
ORA-01034 : Oracle not available
ORA-09243 : smsget: error attaching to SGA
OSD-04101 : SGA incorrect : SGA non initialisée
I tried to use srvmgrl (after checking that the oracle_sid was set correctly), I did a connect internal, and tried a startup pfile=...
All I got was the following messages:
LCC-00201 message 201 not found; product=RDBMS; family=MGR
LCC-00217 message 217 not found; product=RDBMS; family=MGR
I tried this after a shutdown immediate and even a shutdown abort, and then I tried a startup nomount and still got the same result.
Does anyone have an idea on what might be going on?
Any help would by GREATLY appreciated.
Arnaud
----------------------------------------------------------------------
|
|
|
|
| Re: svrmgrl problem after an ORA-01034 -found the solution- [message #69214 is a reply to message #69212] |
Thu, 22 November 2001 09:19  |
Arnaud
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
I found the solution : The V7 was not unistalled after the migration to V8. After the server crash, the previous registry was recovered, so the key for the OracleServiceSID was reset and was pointing the the V7! So the solution was just to change the value of the key and to make it point on the V8 again.
For those who might be interested, the key is in HLMsystelcontrolset000xservicesOracleServiceSID.
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
