Re: ORA-27101 hell!!!

From: Joel Garry <joel-garry_at_home.com>
Date: 8 Oct 2003 15:59:11 -0700
Message-ID: <91884734.0310081459.e08b10d@posting.google.com>

c.clarke_at_talis.com (Chris Clarke) wrote in message news:<10304d3b.0310080705.2bbad09e_at_posting.google.com>...
> Hi all,
>
> I've installed Oracle 8.1.7 EE on RedHat 7.2 (as per install guide,
> v2.1 gcc libs etc.)
>
> I managed to create an instance "O817DB" using dbassist.
>
> I started the instance as follows:
>
> $ sqlplus internal
>
> SQL> startup
>
> The startup procedures gave no errors.
>
> I then tried to get into the DB as follows:
>
> $ sqlplus system/manager
>
> No problems there either. I could run queries, create users, etc.
>
> Now I tried to start the TNS listener:
>
> $ lsnrctl start
>
> Doing:
>
> $ lsnrctl status
>
> ...revealed that I had 1 service handler for O817DB as expected. So I
> tried to connect to the machine again using:
>
> $ sqlplus system/manager_at_O817DB
>
> Bang! Produced this error:
>
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> I found some information in the Net8 installation guide about adding
> the listener to the /etc/services file, which I did as follows:
>
> LISTENER 1521/tcp # Net*8
>
> Rebooted, restarted, same again. The $ORACLE_SID and $ORACLE_HOME are
> correct. The database instance is definately alive as I managed to log
> on locally - I even managed to get "emca" (Enterprise Manager
> Configuration Assistant) to create a repository on the database (using
> localhost:1521:O817DB as a connection string).
>
> Anyone got any ideas before I throw the machine out of the window and
> book myself into the loony bin???

LOL, I recall seeing Datatrieve manuals describing an arc out a doorway one time...

Is $ORACLE_HOME the same when you sub-shell (ie, you remembered to export it?)

The most likely thing is you've defined a service name O817DB in your listener.ora and tnsnames.ora of a service that does not exist - maybe you typoed the hostname or port or protocol or, most likely, the oracle_home in the listener.ora.

example tnsnames.ora:

ADMINX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mercury)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = XYZ)

)
)

example listener.ora from SID_LIST_LISTENER:

(SID_DESC =

      (GLOBAL_DBNAME = XYZ)
      (ORACLE_HOME = /oracle)
      (SID_NAME = XYZ)

)

oracle:TEST_at_mercury /home2/oracle$ sqlplus system/manager_at_adminx

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Oct 8 15:36:52 2003

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory

Enter user-name:
oracle:TEST_at_mercury /home2/oracle$ lsnrctl status|grep XYZ XYZ has 1 service handler(s)

So XYZ has never been started, because it doesn't exist.

--
@home.com is bogus.
http://www.erowid.org/culture/show_image.php3?image=art/images/archive/hoffmann_martina_dmt_oracle.jpg

Received on Wed Oct 08 2003 - 17:59:11 CDT