Home » RDBMS Server » Server Administration » Oracle shared memory Realm does not exists
Oracle shared memory Realm does not exists [message #220539] Wed, 21 February 2007 03:00 Go to next message
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.

Re: Oracle shared memory Realm does not exists [message #220541 is a reply to message #220539] Wed, 21 February 2007 03:04 Go to previous messageGo to next message
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
Re: Oracle shared memory Realm does not exists [message #220755 is a reply to message #220541] Wed, 21 February 2007 22:37 Go to previous messageGo to next message
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
Re: Oracle shared memory Realm does not exists [message #220756 is a reply to message #220755] Wed, 21 February 2007 22:42 Go to previous message
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:
  


Current Time: Sun Dec 04 04:36:10 CST 2016

Total time taken to generate the page: 0.04029 seconds