Re: Connecting to a local instance causes weird behaviour

"Alkos" <azerty_at_nospam.org> wrote in message news:<bnt6r5$ll25_at_news.rd.francetelecom.fr>...
> Hello,
>
> Does somebody encounter the same problem :
>
> An instance started with svrmgrl :
> export ORACLE_SID=MYINST
> svrmgrl
> svr>connect internal
> svr>startup
> cannot be accessed through the following statements :
> sqlplus /nolog
> sql>connect system/<mdp>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory
> The instance is started, alive and responds correctly to connection requests
> from remote clients
> using service name and TCP protocol.
> The instance can be stopped with svrmgrl.
> The problem does not occur when instance is started with sqlplus locally
> connected as sysdba.
> Any help or explanation would be welcome.
>
> Bye,
> Alkos

When you get this, usually either the executables have incorrect protection and/or they don't run with the setuid bit on, or you started Oracle using an incorrect account like root.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 31 2003 - 08:56:18 CST