-
Hi Guys
I have the test and production databases on the same server
today morning when i tried to connect to the test database i am getting error like:
ora-01034 Oracle not availabe
ora-09243 Error attaching to SGA
osd-04101 Invalid sga:SGA not initialized
I am working on oracle 7.3.4 and on WIN NT 4.0
Could you please give me any solutions for this as soon as possible
Thanks
Ravi
ravi
-
Are you sure the database is started up?
-
yes.The databse is started.Even i stopped and started the services.
Thanks
Ravi
ravi
-
Connect to Server Manager using Internal
Shutdown immediate;
startup pfile= driver:/........./.........../xxxxxx.ora
Check if it gives any error in the startup. If this successful, you should not get the error.
Good Luck!
-
Sharma is right; Seems like your Oracle service is starting but the database is failing to initialize.
That is the problem with NT Services; it does not tell you when it fails to start the database. Check the Alert Log and it will show you why the database was not started.
Or if you start from the SvrMgr, it will show you the errors.
- Rajeev
-
oracle not available
hi
even it is not allowing me to connect from the svrmgr.Same error is popping up
any suggestions please
Thanks
Ravi
ravi
-
Why don't you check the Alertlog. And it seems your environment has changed.
Thanks
Kishore Kumar
-
also make sure you set oracle_sid before attempting to connect from the Server Manager.
On the DOS prompt --
SET ORACLE_SID = your_sid_name
SVRMGR
If the SID is SET and the related Oracle service (OracleServiceSid_Name) is running then you should be able to connect from Server MAnager.
I think in Oracle 7.3 (for NT) there are 2 services; can you check that both the services are running.
And most importantly check the end of the Alert Log file for the appropriate errors.
- Rajeev
-
hi
Thanks alot guys.I will try this.
Ravi
ravi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|