Re: ORA-27101 hell!!!

Have you checked...

1. bbserver resolves to the correct IP addy ( try putting the IP address in tnsnames instead )
2. there's no strange setting in sqlnet.ora that's causing you grief ( like names.default_domain )
3. oracle _is_ running ( ps -fuoracle should show tasks like ora_lgwr_O817DB )
4. Have you reconfigured the kernel to run Oracle? ( shared memory and semaphore resources are increased ).

$0.02

Steve

On 9 Oct 2003 01:56:32 -0700, c.clarke_at_talis.com (Chris Clarke) wrote:

>Hi guys,
>
>Thanks for your help so far. Here are my env and tnsnames.ora files as
>suggested:
>
>env:
>
>PWD=/home/oracle
>ORACLE_SID=0817DB
>LD_ASSUME_KERNEL=2.2.5
>LDEMULATION=elf_i386_glibc21
>HOSTNAME=bbserver
>LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib:/lib:/usr/lib:/usr/local/lib
>QTDIR=/usr/lib/qt-2.3.1
>GCC_EXEC_PREFIX=/usr/i386-glibc21-linux/lib/gcc-lib/
>CLASSPATH=/u01/app/oracle/product/8.1.7/jdbc/lib/classes12.zip:/u01/app/oracle/product/8.1.7/JRE:/u01/app/oracle/product/8.1.7/jlib:/u01/app/oracle/product/8.1.7/rdbms/jlib:/u01/app/oracle/product/8.1.7/network/jlib:.
>LESSOPEN=|/usr/bin/lesspipe.sh %s
>KDEDIR=/usr
>USER=oracle
>LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;3
>:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
>MACHTYPE=i386-redhat-linux-gnu
>KDE_MULTIHEAD=false
>MAIL=/var/spool/mail/oracle
>INPUTRC=/etc/inputrc
>GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc
>XMODIFIERS=@im=none
>LANG=en_GB
>ORACLE_BASE=/u01/app/oracle
>JAVA_HOME=/usr/local/java
>ORACLE_HOME=/u01/app/oracle/product/8.1.7
>ORACLE_TERM=xterm
>COLORTERM=
>DISPLAY=:0.0
>LOGNAME=oracle
>SHLVL=3
>SESSION_MANAGER=local/bbserver:/tmp/.ICE-unix/1862
>ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data
>SHELL=/bin/bash
>HOSTTYPE=i386
>QT_XFT=1
>OSTYPE=linux-gnu
>HISTSIZE=1000
>HOME=/home/oracle
>TERM=xterm
>PATH=/u01/app/oracle/product/8.1.7/bin:/opt/bin:/bin:/usr/bin:/usr/local/bin:/usr/sbin:/usr/X11R6/bin:/usr/local/java/bin:.
>NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
>TNS_ADMIN=/u01/app/oracle/product/8.1.7/network/admin
>ORACLE_OWNER=oracle
>_=/usr/bin/env
>
>and the tnsnames.ora:
>
># TNSNAMES.ORA Network Configuration File:
>/u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
># Generated by Oracle configuration tools.
>
>O817DB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = O817DB)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
> )
> )
>
>BBDATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = bbdata.localhost)
> )
> )
>
>INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = bbdata.localhost)
> (PRESENTATION = http://admin)
> )
> )
>
>EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>ORACLE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = oracle.localhost)
> )
> )
>
>Cheers guys,
>
>Chris
>
>joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0310081459.e08b10d_at_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
>>
>> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>>
>> 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.
>>
>> jg
Received on Thu Oct 09 2003 - 05:06:52 CDT