OraFAQ Forum: Server Administration » Oracle shared memory Realm does not exists

Home » RDBMS Server » Server Administration » Oracle shared memory Realm does not exists

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle shared memory Realm does not exists [message #220539]

Wed, 21 February 2007 03:00

varadha7
Messages: 3
Registered: February 2007

Junior Member

Hi

I have installed oracle 9i in windows xp . I made few changes to init.ora file but later reverted them.But ,on reboot when i tried to connect to oracle its showing

Not connected to oracle
Shared memory realm does not exists.

How to make oracle startup automatic on reboot of server.

Report message to a moderator

Re: Oracle shared memory Realm does not exists [message #220541 is a reply to message #220539]

Wed, 21 February 2007 03:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

start > run > services.msc

check OracleService<sid> and change STARTUP type AUTOMATIC.

some do for listener,dbconsole,isqlplus services.

regards
Taj

Report message to a moderator

Re: Oracle shared memory Realm does not exists [message #220755 is a reply to message #220541]

Wed, 21 February 2007 22:37

varadha7
Messages: 3
Registered: February 2007

Junior Member

Hi

Its already set to automatic only.

Still,when i boot my system and try logging in to oracle its showing as

Oracle not available
Shared memory realm does not exists

Pls advice

Report message to a moderator

Re: Oracle shared memory Realm does not exists [message #220756 is a reply to message #220755]

Wed, 21 February 2007 22:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Just follow below procedure.


C:\>SQLPLUS SYS AS SYSDBA
PASSWORD : *****

[B]SQL>STARTUP[/B]

REGARDS
Taj

[Updated on: Wed, 21 February 2007 22:42]

Report message to a moderator

Previous Topic:	Upgradation from 8.1.7.4 to 9.2.0.8
Next Topic:	is CPU insufficient ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:32:46 CDT 2024