Home » RDBMS Server » Server Administration » ORA-27101
ORA-27101 [message #51141] Thu, 02 May 2002 09:18 Go to next message
Madhuri Reddy
Messages: 3
Registered: May 2002
Junior Member
I get the following message when starting up sqlplus right after installing Oracle 9i

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

Please help.
Re: ORA-27101 [message #51169 is a reply to message #51141] Sun, 05 May 2002 23:15 Go to previous messageGo to next message
kothari Alpesh
Messages: 27
Registered: December 2001
Junior Member
ORA-01034
Oracle was not started. Possible causes include the following:
The SGA requires more space than was allocated for it.
The operating-system variable pointing to the instance is improperly defined.
Due to above error this error is generated.
so pl upgrade ur server or PC and add more memory to it

Alpesh Kothari
cheers
Re: ORA-27101 [message #51189 is a reply to message #51141] Mon, 06 May 2002 10:54 Go to previous messageGo to next message
Jyothi Babu Balaka
Messages: 2
Registered: May 2002
Junior Member
Hi,

it is not necessarily be due to insufficient memory allocation for SGA, If you try using svrmgrl it might work, if that is the reason you can try the following

try to comment out this in your sqlnet.ora and try the same.

--SQLNET.AUTHENTICATION_SERVICES= (NTS)

hope the above works

Regards,
Jyothi@Springs industries INC
Re: ORA-27101 [message #53451 is a reply to message #51141] Fri, 20 September 2002 07:02 Go to previous message
Ruby Bath
Messages: 1
Registered: September 2002
Junior Member
Hi Folks,
i had similar problem that after installing oracle 9i and rebooting . it was giving me following error
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

i looked in couple of log files and found out that that my oracle instance was looking for intialization file under Oracleora92database. as soon as i moved my init.ora file in this directory and rebooted. the oracle started the database.

hope it helps
Ruby
Previous Topic: QUERY HELP
Next Topic: Create DB Instance
Goto Forum:
  


Current Time: Fri Sep 20 01:31:08 CDT 2024