Re: Couldn't shutdown oracle server. why?

>Subject: Couldn't shutdown oracle server. why?
>From: feng <feng_at_chiefs.northbrook.aieg.mot.com>
>Date: 2/3/98 5:12PM GMT
>Message-id: <34D74FF2.F57E1EFC_at_chiefs.northbrook.aieg.mot.com>
>
>Hello all,
>
>I am a new Oracle DBA. I am getting a strange problem and I really
>need help from this group.
>
>We are running Oracle 7.1.4 on HP-UX 9.05 (model 735). We couldn't
>shutdown the oracle server. Below are the transcript:
>
>Oracle7 Server Release 7.1.4.1.0 - Production Release
>With the distributed and parallel query options
>PL/SQL Release 2.1.4.0.0 - Production
>
>SQLDBA> connect internal
>Connected.
>SQLDBA> select * from v$database;
>DBA-00342: unable to complete internal login
>ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>HP-UX Error: 2: No such file or directory
>SQLDBA> select * from dba_users;
>DBA-00342: unable to complete internal login
>ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>HP-UX Error: 2: No such file or directory
>SQLDBA> shutdown
>DBA-00342: unable to complete internal login
>ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>HP-UX Error: 2: No such file or directory
>SQLDBA> shutdown abort
>ORACLE instance shut down.
>SQLDBA> exit
>SQL*DBA complete.
>
>
>Although I got the message "oracle instance shut down",
>when I checked the ps, I still found the
>oracle processes running. Here are the output:
>
>$ ps -ef |grep oracle
>oracle 13853 13691 2 21:16:23 ttys4 0:00 ps -ef
>oracle 4327 1 0 Nov 5 ? 1:27 ora_dbwr_REM
>oracle 4335 1 0 Nov 5 ? 0:08 ora_d000_REM
>oracle 4334 1 0 Nov 5 ? 0:00 ora_s000_REM
>root 4640 4639 6 Nov 5 ? 151:47 oracleREM P:4096,5,8,
>oracle 4326 1 0 Nov 5 ? 0:21 ora_pmon_REM
>oracle 4332 1 0 Nov 5 ? 4:25 ora_smon_REM
>oracle 4329 1 0 Nov 5 ? 0:33 ora_lgwr_REM
>root 3927 3917 6 Nov 5 ? 0:17 oracleREM P:4096,5,8,
>oracle 4333 1 0 Nov 5 ? 0:01 ora_reco_REM
>oracle 13691 13541 1 21:13:13 ttys4 0:00 ksh
>oracle 13854 13691 1 21:16:23 ttys4 0:00 grep oracle
>
>Anybody can give me some suggestions? I really appreciate it.
>
>Thanks
>
>Linda
>feng_at_chiefs.northbrook.aieg.mot.com
>
>
>
>
>
>
>

I can think of 2 possibilities, I apologise if the first seems insulting, but I've done it before now so it's not impossible. 1) Are you absolutely certain that the ORACLE_SID environment variable was set to REM before you entered Server Manager ? 2) Have you recently upgraded this database, in which case it is possible that the oratab file still points to the old ORACLE_HOME.

HTH
  Rob Received on Tue Feb 10 1998 - 00:00:00 CST