Re: "Oracle not available" and "Shared memory realm does not exist".

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 19 Jan 2003 13:45:24 -0000
Message-ID: <3e2aabf6$0$221$cc9e4d1f@news.dial.pipex.com>

"karan9199" <member22980_at_dbforums.com> wrote in message news:2408928.1042969959_at_dbforums.com...

>

> Thanks Rauf Sarwar for your reply.
> Actually I had problem during instalation stage inself.
> It promt message such as 'DataControl file error.
> After that it prompt message such as Database not mounted.
> Ok, well this is caused by Oracle 8i does not support WIndows XP, then I
> tried to install it in windows 2000 svc pck 3.
> It still shows the same problem.

Could you do the following in a command window.

1. type SET ORACLE_SID=<yoursid>
2. type sqlpus /nolog - this should put you into sqlplus
3. type connect sys/<password of sys> as sysdba
4. type startup

Then can you tell us what *exact* messages you get.

It looks to me as if you don't have a control file for your database (maybe you don't even have a database) but the exact sequence of steps above should start the database, or else give us the exact error you are getting.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Sun Jan 19 2003 - 07:45:24 CST