Re: Connecting to a local instance causes weird behaviour

Thanks for all your replies.
I managed to find out what was wrong woth that DB. ORACLE_HOME setting was not the expected for the oracle account.

Sorry for having bothered you with such an uninteresting feature.

Alkos

"Alkos" <azerty_at_nospam.org> a écrit dans le 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
>
>
Received on Mon Nov 03 2003 - 03:45:51 CST