OraFAQ Forum: Server Administration » ORA-01034: Oracle Not Available (merged)

Home » RDBMS Server » Server Administration » ORA-01034: Oracle Not Available (merged)

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

ORA-01034: Oracle Not Available (merged) [message #314193]

Wed, 16 April 2008 00:57

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

After restart, I am not able to work on oracle

the error msg is: ORA-01034 Oracle Not Available
ORA-27101 Shared memory realm does not exist.

[Updated on: Wed, 16 April 2008 01:44] by Moderator

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314214 is a reply to message #314193]

Wed, 16 April 2008 01:44

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check if Oracle service is started.

Regards
Michel

[Updated on: Wed, 16 April 2008 01:44]

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314220 is a reply to message #314214]

Wed, 16 April 2008 01:53

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

after restarting, the services are running correctly,
but not able to login, still same error

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314234 is a reply to message #314193]

Wed, 16 April 2008 02:31

varu123
Messages: 754
Registered: October 2007

Senior Member

SQL> conn /as sysdba
SQL>startup

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314240 is a reply to message #314234]

Wed, 16 April 2008 02:43

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

here also i am getting the same errors

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314242 is a reply to message #314240]

Wed, 16 April 2008 02:46

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste the whole SQL*Plus session.
Copy and paste the last lines of alert.log file.

Regards
Michel

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314266 is a reply to message #314242]

Wed, 16 April 2008 04:22

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

i have uploaded the alter_xe.log file

Attachment: alert_xe.log
(Size: 0.54KB, Downloaded 1268 times)

Report message to a moderator

ORA-27101 Shared memory realm does not exit [message #314271 is a reply to message #314193]

Wed, 16 April 2008 04:49

veeru_ds
Messages: 2
Registered: April 2008
Location: Bangalore

Junior Member

Not able to login in sqlplus,
Oracle service is running,
attaching spfile

Attachment: SPFILEXE.ORA
(Size: 2.50KB, Downloaded 1257 times)

Report message to a moderator

Re: ORA-27101 Shared memory realm does not exit [message #314275 is a reply to message #314271]

Wed, 16 April 2008 04:59

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Copy and paste about the errors and of the screen messages.

It is useless to attach a binary file(spfile).

Report message to a moderator

Re: ORA-27101 Shared memory realm does not exit [message #314282 is a reply to message #314275]

Wed, 16 April 2008 05:08

veeru_ds
Messages: 2
Registered: April 2008
Location: Bangalore

Junior Member

ORA-01034 : Oracle not available
ORA-27101 : shared memory realm does not exist

this message is coming after restart my computer and services are running. what should I do?

Report message to a moderator

Re: ORA-01034: Oracle Not Available [message #314285 is a reply to message #314193]

Wed, 16 April 2008 05:10

varu123
Messages: 754
Registered: October 2007

Senior Member

deinstal oracle and reinstall.

Report message to a moderator

Re: ORA-27101 Shared memory realm does not exit [message #314286 is a reply to message #314271]

Wed, 16 April 2008 05:10

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

sqlplus / as sysdba
startup

Report message to a moderator

Re: ORA-27101 Shared memory realm does not exit [message #314288 is a reply to message #314271]

Wed, 16 April 2008 05:13

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Even if you post with different ID the answer is the same.

Regards
Michel

Report message to a moderator

Re: ORA-27101 Shared memory realm does not exit [message #314305 is a reply to message #314288]

Wed, 16 April 2008 05:47

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

after deinstalled and reinstalled

first time it is connecting...

once i restarted my system

i am not able to connect
i am getting the same error

i am not even able to do the following command...

sqlplus / as sysdba
startup

Report message to a moderator