Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Get shared memory realm does not exist when connecting remotely

Re: Get shared memory realm does not exist when connecting remotely

From: michael ngong <mngong_at_yahoo.com>
Date: 22 Feb 2002 11:03:45 -0800
Message-ID: <ecf365d5.0202221103.60ed25b9@posting.google.com>


condjp_at_chp.edu (Joe Condle) wrote in message news:<64a5ef9b.0202220701.3e6b8cf_at_posting.google.com>...
> I have just installed oracle 8.1.7 on a Sun Ultra10 running Solaris 8.
> All went well. I created by database and can connect to it with
> sqlplus. The databse is up and running. All the oracle process our
> present and so is the listener. My problem starts when I try to
> connect throught sqlnet.
> One post said to look at shared memory with the ipcs commad
>
>
> when I do the following
> sqlplus username/password_at_chp
> I GET
> ERROR
> ORA-01034: ORACLE not available
> ORA-27101: shared memory relam does not exist
> SVR4 Error: 2: No such file or directory
>
> When I run ipcs to look at shared memory I get the following:
> Message Queues:
> Shared Memory:
> m 0 0x5000087c --rw-r--r-- root root
> m 201 0xa0fe0a2c --rw-r----- oracle oinstall
> Semaphores
> s 720896 0xb60d98d0 --ra-r----- oracle oinstall
> I am not sure what the above means.
>
> The posts I have read talk about the ORACLE_SID and/or ORACLE_HOME not
> being set right. I have checked that but that does not seem to be the
> problem.
> Any thoughts.
>
> Joe
> Children's Hospital of Pgh

set path too path=$ORACLE_HOME/bin:$PATH and try again Bliss
Michael T Ngong( Sr DBA) Received on Fri Feb 22 2002 - 13:03:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US