OraFAQ Forum: Server Administration » Unable to startup or shutdown the database

Home » RDBMS Server » Server Administration » Unable to startup or shutdown the database (

) 1 Vote

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

Unable to startup or shutdown the database [message #348237]

Tue, 16 September 2008 03:20

sanei05
Messages: 104
Registered: September 2008

Senior Member

Hi ,

I am unable to start up or shutdown my database

I am getting the below error.

NETMAN3_plxa 9i>/oracle20/app/oracle/product/9.2 : export ORACLE_SID=plxa
NETMAN3_plxa 9i>/oracle20/app/oracle/product/9.2 : sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 16 08:12:52 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
SQL> exit
Disconnected
NETMAN3_plxa 9i>/oracle20/app/oracle/product/9.2 : export ORACLE_SID=testdb2
NETMAN3_testdb2 9i>/oracle20/app/oracle/product/9.2 : sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 16 08:14:01 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

Any solution for this.......Pls urgent

[MERGED by LF]

[Updated on: Tue, 16 September 2008 04:16] by Moderator

Report message to a moderator

Re: Unable to start/shutdown the database [message #348240 is a reply to message #348237]

Tue, 16 September 2008 03:31

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You have never tried to start it.

Report message to a moderator

Re: Unable to start/shutdown the database [message #348242 is a reply to message #348240]

Tue, 16 September 2008 03:44

sanei05
Messages: 104
Registered: September 2008

Senior Member

sorry i tried startup and am getting hanged...
any solution why am getting this error..

Report message to a moderator

Re: Unable to start/shutdown the database [message #348244 is a reply to message #348242]

Tue, 16 September 2008 03:46

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Which error? The only errors you posted are the ones where you tried to shut down the already down database.

Report message to a moderator

Re: Unable to shutdown or startup the database [message #348251 is a reply to message #348237]

Tue, 16 September 2008 03:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediatewrong command at this stage.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

SQL>STARTUP instead of "SHUTDOWN IMMEDIATE".

Report message to a moderator

Re: Unable to start/shutdown the database [message #348254 is a reply to message #348244]

Tue, 16 September 2008 03:55

sanei05
Messages: 104
Registered: September 2008

Senior Member

I am getting the below error(marked in bold) when i am trying to shutdown.

NETMAN3_plxa 9i>/oracle20/app/oracle/product/9.2 : export ORACLE_SID=plxa
NETMAN3_plxa 9i>/oracle20/app/oracle/product/9.2 : sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 16 08:12:52 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
[B]ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

Report message to a moderator

Re: Unable to start/shutdown the database [message #348255 is a reply to message #348254]

Tue, 16 September 2008 03:58

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Off course you get that error. Because the database already is down.

SQL> conn / as sysdba
Connected to an idle instance.

Means the database is down.

Report message to a moderator