Re: ORACLE Server not available

Stephen Miller wrote:
>
> Environment: UNIX AIX 4.2
> ORACLE 7.2.3
>
> Whenever I attempt to access ORACLE I get the following errors:
>
> +---------------------------------------------------------------------+
> | sqldba mode=line |
> | |
> | SQL*DBA: Release 7.2.3.0.0 - Production on Sun May 25 18:38:46 1997 |
> | |
> | Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. |
> | |
> | Oracle7 Server Release 7.2.3.0.0 - Production Release |
> | With the distributed and parallel query options |
> | PL/SQL Release 2.2.3.0.0 - Production |
> | |
> | SQLDBA> connect internal |
> | Connected. |
> | SQLDBA> shutdown immediate |
> | DBA-00342: unable to complete internal login |
> | ORA-01034: ORACLE not available |
> | ORA-07320: smsget: shmat error when trying to attach sga. |
> | IBM AIX RISC System/6000 Error: 13: Permission denied |
> | SQLDBA> |
> +---------------------------------------------------------------------+
>
> It looks like my SGA has somehow gotten corrupted, but I am unable to
> shutdown the database. Short of a KILLing the processes, how can I bring
> down and restart this instance? And what is the significance of the UNIX
> errors?
>
> Stephen Miller
> ISM, Montreal

Stephen,

   Three things come to mind:

1. The database is already shutdown. (I doubt that is the case.)
2. $ORACLE_SID is not defined for the database you are trying to shutdown.
3. You are not logged into a Unix account that is in the dba group (which is usually 'dba').

Hope this helps. Received on Tue May 27 1997 - 00:00:00 CDT