OraFAQ Forum: Networking and Gateways » ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exists

Home » RDBMS Server » Networking and Gateways » ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exists

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

ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exists [message #67567]

Thu, 14 October 2004 19:58

MuthukumarMuthian
Messages: 1
Registered: October 2004

Junior Member

Hi!
I have installed ORACLE 8i - 8.1.7 and created db�as muthudb
when ORACLE installed the oracle�connect using system/manager/muthudb
but after restart and connect the�database using sql plus, following errors are imported:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exists

What should i do?
�
�
mail me
�
muthu

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67587 is a reply to message #67567]

Fri, 29 October 2004 10:53

Raj
Messages: 411
Registered: November 1998

Senior Member

unable to get rid of ora 01034 and ora 27101
on advance server with oracle 8.1.0

kindly give clue to takle the problem

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67592 is a reply to message #67587]

Thu, 04 November 2004 11:22

Kim Rojas
Messages: 1
Registered: November 2004

Junior Member

I don't know if this will help, but this happened to me 10 minutes ago and I did a ps -ef to see what processes I had running on my server. I then stopped all processes that were running gracefully. I continued to shutdown the database and then restarted my database. After I restarted the database, I restarted all of my processes and everything seems to be running smoothly now, and I am no longer getting that error. I have a lot of users accessing the database at all times of the day.

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67635 is a reply to message #67567]

Sat, 27 November 2004 18:01

Susmit Sarkar
Messages: 2
Registered: November 2004

Junior Member

Check the Environment variables : ORACLE_SID ORACLE_HOME ORACLE_BASE LD_LIBRARY_PATH etc. All of these should be set in order to bring Oracle DB.

Log into sever manager or sqlplus, connect as internal and then issue the STARTUP command. You can optionally specify the STARTUP command with the PFile argument.

ORACLE_SID is suppose to be set as an environment variable. So just give type set at your shell prompt and it should tell you whether its set or not.

Hope this is of some help.

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67667 is a reply to message #67635]

Mon, 20 December 2004 03:12

P.PRAVEEN KUMAR
Messages: 1
Registered: December 2004

Junior Member

Hello Sir, I am P.Praveen Kumar, from India, I face to this problem in Oracle 9i on Linux9 version
One more request to you sir,
I want ORACLE DBA FAQ'S with answers.
Basically I am poor in Finance, So want to purchase more books.

ok Sir,
Thanking you

P.PRAVEEN KUMAR
Mail: pendyala999_praveen@yahoo.com
pendyala999_praveen@rediff.com

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67682 is a reply to message #67667]

Wed, 05 January 2005 01:34

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

You have not started your database before attempting to connect to it.

Michael Hartley
Openfield Solutions Ltd
www.openfieldsolutions.co.uk

Report message to a moderator

Re: ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not ex [message #67742 is a reply to message #67635]

Tue, 15 February 2005 05:40

rajendra kumar
Messages: 1
Registered: February 2005

Junior Member

Follow these steps to connect to oracle (linux version)
NOTE: A SPACE IS CUMPULSORY AFTER / SYMBOL IN sqlplus / as sysdba.
To start database..

$ lsnrctl start
$ sqlplus / as sysdba
sql> startup

after this the database is initiated & started.

sql> exit

login into user like (scott or system)as

$sqlplus
username: scott
passwd:*****

sql>

steps to stop database:

exit the dbuser scott or system whatever

sql> exit

$ sqlplus / as sysdba

sql> shutdown

sql> exit

$lsnrctl stop

Report message to a moderator

Previous Topic:	reg error ORA-12514
Next Topic:	compile debug with sql navigator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 07:12:51 CDT 2024