469,126 Members | 1,312 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

Oracle Not Available

:confused: We have Oracle 9i installed on Windows 2000 Server , It was working fine , suddenly when we log it is giving Oracle Not Available Shared Memory Realrm dose not exists.

When we try to log with sqlplus nolog
we get the SQL Prompt but when we connect to dba as
connect sys as sysdba

we get an error Message :- TNS: Unable to Connect to destination

If any one can help please

Thanks in Advance
Aug 29 '06 #1
1 3325
268 100+
Hai try this
Check the event for viewer to cross-check whether all the Oracle background (like PMON) have started successfully.. If so, then ur instance startup mode could be manual. For this you have 2 options :

1) drop and re-create service for the database in automatic mode => using Oradim
2)write a command line scipt to start the database from the SQL+ when running it

Try issuing the following commands..

sqlplus /nolog

connect / as sysdba

(just check whether it says "Connected to an idle instance")

shutdown immediate


This will start the database..
Aug 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by michael newport | last post: by
11 posts views Thread by Charlie Martin Beta program | last post: by
28 posts views Thread by prunoki | last post: by
5 posts views Thread by NormaJean Sebastian via DBMonster.com | last post: by
4 posts views Thread by Francis Awofeso | last post: by
8 posts views Thread by =?Utf-8?B?RGF2aWQrKw==?= | last post: by
19 posts views Thread by Gregor =?UTF-8?B?S292YcSN?= | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.