Home » RDBMS Server » Server Administration » ORA-01034: Oracle Not Available (merged)
ORA-01034: Oracle Not Available (merged) [message #314193] Wed, 16 April 2008 00:57 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
after restarting, the services are running correctly,
but not able to login, still same error
Re: ORA-01034: Oracle Not Available [message #314234 is a reply to message #314193] Wed, 16 April 2008 02:31 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
SQL> conn /as sysdba
SQL>startup
Re: ORA-01034: Oracle Not Available [message #314240 is a reply to message #314234] Wed, 16 April 2008 02:43 Go to previous messageGo to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
here also i am getting the same errors
Re: ORA-01034: Oracle Not Available [message #314242 is a reply to message #314240] Wed, 16 April 2008 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste the whole SQL*Plus session.
Copy and paste the last lines of alert.log file.

Regards
Michel
Re: ORA-01034: Oracle Not Available [message #314266 is a reply to message #314242] Wed, 16 April 2008 04:22 Go to previous messageGo to next message
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 206 times)
ORA-27101 Shared memory realm does not exit [message #314271 is a reply to message #314193] Wed, 16 April 2008 04:49 Go to previous messageGo to next message
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 201 times)
Re: ORA-27101 Shared memory realm does not exit [message #314275 is a reply to message #314271] Wed, 16 April 2008 04:59 Go to previous messageGo to next message
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).
Re: ORA-27101 Shared memory realm does not exit [message #314282 is a reply to message #314275] Wed, 16 April 2008 05:08 Go to previous messageGo to next message
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?
Re: ORA-01034: Oracle Not Available [message #314285 is a reply to message #314193] Wed, 16 April 2008 05:10 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
deinstal oracle and reinstall.
Re: ORA-27101 Shared memory realm does not exit [message #314286 is a reply to message #314271] Wed, 16 April 2008 05:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

sqlplus / as sysdba
startup
Re: ORA-27101 Shared memory realm does not exit [message #314288 is a reply to message #314271] Wed, 16 April 2008 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Even if you post with different ID the answer is the same.

Regards
Michel
Re: ORA-27101 Shared memory realm does not exit [message #314305 is a reply to message #314288] Wed, 16 April 2008 05:47 Go to previous messageGo to next message
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


Re: ORA-01034: Oracle Not Available (merged) [message #314310 is a reply to message #314193] Wed, 16 April 2008 05:52 Go to previous messageGo to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
Even 2 time i have formatted my system installed windows xp sp2

still same error occurs....
Re: ORA-01034: Oracle Not Available (merged) [message #314318 is a reply to message #314193] Wed, 16 April 2008 06:11 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Try once more and post the install.log file
Re: ORA-01034: Oracle Not Available (merged) [message #314599 is a reply to message #314193] Thu, 17 April 2008 04:45 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Do you have any other database in the same machine ?
Re: ORA-01034: Oracle Not Available (merged) [message #314712 is a reply to message #314310] Thu, 17 April 2008 09:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. Did you check service type ?
2. Did you check registry value for ORA_<SID>_AUTOSTART=?
Previous Topic: How to investigate this ORA-01555
Next Topic: sga & pga optimum settings
Goto Forum:
  


Current Time: Sun Dec 11 00:33:54 CST 2016

Total time taken to generate the page: 0.24055 seconds