| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-27101 hell!!!
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.7ORACLE_TERM=xterm
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
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. > > jgReceived on Thu Oct 09 2003 - 03:56:32 CDT
 |
 |