Re: ERROR: ORA-07318: smsget: open error when opening sgadef.dbf file

In article <3ii5c5$f6b_at_news.starnet.net> Neil Greene <neil_at_bMD.com> writes:

> $ sqlplus account/pw
> ERROR: ORA-01034: Oracle not available
> ORA-07318: smsget: open error when opening sgadef.dbf file
> HP/UX Error: 13: Permission denied.
>
> OS: HP/UX 9.05
> Oracle: 7.1.3
>
> I can not figure out why Oracle is suddently running like it is
> in EXCLUSIVE mode only. Again, I can log in under any Oracle
> account using the ORACLE unix uid, while any other unix uid
> that attempts to connect to Oracle fails with the above error.
> Of course, the above file does not exist. The correct SGA file
> is "sgadefbmd.dbf". But, I can't figure out what happened to
> change things. I don't see any errors in the rdbms log which
> leads me to believe anything is wrong. The system initializes itself,
> mounts exclusive to handle any recovery required, moves on and then
> mounts the database open.

The oracle executable ($ORACLE_HOME/bin/oracle) has to be a set-uid program. Someone might have relinked this executable and forgot to reset the right permission.

--
"And this is all I have to say about that..."   - F. Gump
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
|  Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel