Re: ORACLE Server not available

Kelly Young wrote:
>
> 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.

Suggest you do a shutdowm abort and then a normal startup (Oracle will perform instance recovery though) Received on Tue May 27 1997 - 00:00:00 CDT