Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Couldn't shutdown oracle server. why?

Re: Couldn't shutdown oracle server. why?

From: Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de>
Date: 1998/02/10
Message-ID: <34E0C6C9.74142530@KirchGruppe.de>#1/1

Did you try "connect internal" from root because there are two processes (oracleREM P:4096,5,8) running under root? Every user doing "connect internal" must belong to the group where the oracle user belongs to (at our site it is called "dba"). If root does not belong to that group "connect internal" should fail.

Another weird error we had: each connect internal will generate a *.aud file in audit_dump_dest directory (see init*.ora). If this directory does not exist or is not writeable, connect internal would normally ask for a password, but perhaps it may also react this way.

Martin Haltmayer

feng wrote:
>
> 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
Received on Tue Feb 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US