Home » RDBMS Server » Server Administration » Shutdown Database
Shutdown Database [message #237125] Sat, 12 May 2007 06:25 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
I'm trying to shutdown DB as follows, but I'm not able to stop DB.
SQL> ! ps -ef | grep pmon
  oracle  8311     1  0  Apr 18  ?         1:41 ora_pmon_HC890TST
  oracle 16750     1  0  Mar 16  ?         3:41 ora_pmon_HC890DEV
  oracle 17657     1  0  Mar 16  ?         3:37 ora_pmon_HC890CFG
  oracle 17430     1  0  Mar 16  ?         3:41 ora_pmon_HC890UAT
  oracle 18024     1  0  Mar 16  ?         3:41 ora_pmon_HC890DMO
  oracle  7653  7651  1 16:57:35 pts/1     0:00 grep pmon
  oracle  7651  6622  0 16:57:35 pts/1     0:00 /usr/bin/sh -c  ps -ef | grep pmon

SQL> echo $ORACLE_SID
SP2-0734: unknown command beginning "echo $ORAC..." - rest of line ignored.
SQL> !echo $ORACLE_SID
HC890TST

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>



What could be the problem any idea.

Brayan
Re: Shutdown Database [message #237130 is a reply to message #237125] Sat, 12 May 2007 08:26 Go to previous messageGo to next message
milindss
Messages: 5
Registered: May 2007
Junior Member
Set the parameters below:

LD_LIBRARY_PATH
ORACLE_SID
ORACLE_HOME

run ORAENV
and then run sqlplus and try shutting down.

Milind


Re: Shutdown Database [message #237204 is a reply to message #237125] Sun, 13 May 2007 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shutdown abort?

Regards
Michel
Re: Shutdown Database [message #237225 is a reply to message #237125] Sun, 13 May 2007 10:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
And can you please post
select status from v$instance



Regards
Taj
Re: Shutdown Database [message #237260 is a reply to message #237125] Mon, 14 May 2007 00:16 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Problem is solved. It was pointing to different ORACLE_HOME.

Thanks a lot.

Brayan.
Re: Shutdown Database [message #237266 is a reply to message #237125] Mon, 14 May 2007 00:41 Go to previous messageGo to next message
hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai
Junior Member
The profile has not been set for the instance...! Try runnin ORAENV....or the .profile and then shutdown the instance... Smile
Re: Shutdown Database [message #237566 is a reply to message #237260] Mon, 14 May 2007 23:13 Go to previous message
milindss
Messages: 5
Registered: May 2007
Junior Member
well , I was sure that was the issue .. Wink good to know its resolved
Previous Topic: ORA-07445: exception encountered: core dump [opidsa()+348]
Next Topic: dba_locks
Goto Forum:
  


Current Time: Fri Sep 20 11:44:29 CDT 2024