Oracle Install on Suse Problem ORA-27101 Error

From: YYZZ <Net_at_Net.Net>
Date: Mon, 10 Sep 2001 03:54:24 GMT
Message-ID: <PPWm7.3670$Vy2.1335477@paloalto-snr1.gtei.net>

I ran through an install of Oracle 9i on Suse 7, kernel 2.2.4. I recompiled the kernel to adjust the Shared memory and Semaphores as descriped in the install manual, I *think* i got this right. Here is the output from the ipcs -l command:

Shared Memory Limits -------- max number of segments = 100 max seg size (kbytes) = 2097151 max total shared memory (kbytes) = 12582912 min seg size (bytes) = 1
Semaphore Limits -------- max number of arrays = 127 max semaphores per array = 250 max semaphores system wide = 31750 max ops per semop call = 102 semaphore max value = 32767
Messages: Limits -------- max queues system wide = 16 max size of message (bytes) = 8192 default max size of queue (bytes) = 16384

Here is my directory structure below /opt/oracle which is ORACLE_HOME:

drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 15:27 xdk
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 16:43 wwg
drwxr-xr-x   10 oracle   oinstall     4096 Sep  9 16:56 ultrasearch
drwxr-xr-x   12 oracle   oinstall     4096 Sep  9 15:47 sysman
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 16:44 syndication
drwxr-xr-x    7 oracle   oinstall     4096 Sep  9 15:43 sqlplus
drwxr-xr-x    5 oracle   oinstall     4096 Sep  9 15:28 sqlj
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 15:27 slax
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 17:03 relnotes
drwxr-xr-x   13 oracle   oinstall     4096 Sep  9 17:14 rdbms
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 15:28 precomp
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 15:46 plsql
drwxr-xr-x    4 oracle   oinstall     4096 Sep  9 15:42 owm
drwxr-xr-x    6 oracle   oinstall     4096 Sep  9 15:29 oui
drwxr-xr-x    7 oracle   oinstall     4096 Sep  9 17:02 otrace
drwxr-xr-x   13 oracle   oinstall     4096 Sep  9 15:47 ord
drwxrwxr-x    4 oracle   oinstall     4096 Sep  9 19:02 oradata
drwxr-xr-x    4 oracle   oinstall     4096 Sep  9 15:27 oracore
drwxr-xr-x   10 oracle   oinstall     4096 Sep  9 17:23 oraInventory
drwxr-xr-x   16 oracle   oinstall     4096 Sep  9 17:14 oem_webstage
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 15:27 ocommon
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 15:46 oci
drwxr-xr-x   13 oracle   oinstall     4096 Sep  9 17:13 network
drwxr-xr-x    5 oracle   oinstall     4096 Sep  9 17:03 md
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 17:08 lib
drwxr-xr-x   15 oracle   oinstall     4096 Sep  9 16:44 ldap
drwxr-xr-x    6 oracle   oinstall     4096 Sep  9 15:47 jsp
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 15:27 jre
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 17:01 jlib
drwxr-xr-x    7 oracle   oinstall     4096 Sep  9 17:01 jis
drwxr-xr-x    5 oracle   oinstall     4096 Sep  9 15:27 jdbc
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 15:42 javavm
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 16:47 jar
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 17:14 install
drwxr-xr-x    7 oracle   oinstall     4096 Sep  9 17:14 hs
drwxr-xr-x   10 oracle   oinstall     4096 Sep  9 16:44 ds
drwxr-xr-x    8 oracle   oinstall     4096 Sep  9 15:44 doc
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 15:43 demo
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 21:51 dbs
drwxr-xr-x   10 oracle   oinstall     4096 Sep  9 16:46 ctx
drwxr-xr-x    5 oracle   oinstall     4096 Sep  9 15:35 classes
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 18:25 bin
drwxr-xr-x    2 oracle   oinstall     4096 Sep  9 21:10 autosave
drwxr-xr-x    5 oracle   oinstall     4096 Sep  9 16:56 assistants
drwxrwxr-x    4 oracle   oinstall     4096 Sep  9 19:02 admin
drwxr-xr-x    3 oracle   oinstall     4096 Sep  9 21:48 KDesktop
lrwxrwxrwx    1 oracle   oinstall       21 Sep  9 15:34 JRE ->
/opt/oracle/jre/1.1.8
-rw-------    1 oracle   oinstall      142 Sep  9 14:04 Floppy Device
drwxr-xr-x    4 oracle   oinstall     4096 Sep  9 17:13 BC4J
drwxr-xr-x   10 oracle   oinstall     4096 Sep  9 16:46 Apache

Here is my /etc/profile.local which sets the environment variables as is outlined in the install manual:

# Oracle Environment

ORACLE_HOME=/opt/oracle; export ORACLE_HOME
ORACLE_SID=sid; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

TNS_ADMIN=#ORACLE_HOME/network/admin; export TNS_ADMIN NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG #ORA_NLS33;$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/lib export LD_LIBRARY_PATH
export TMPDIR=/tmp
# Set shell search paths:
PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/openwin:/bin:/o pt/local/GNU/bin:/sbin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin PATH=$PATH:/usr/local/samba/bin:/usr/ucb: export PATH
#CLASSPATH must include the following JRE locations: CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export JAVA_HOME=/usr/lib/jdk1.1.8
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib/classes.zip

Yes, I have the appropriate users and groups created, and have the users in the correct groups, I'll spare the out put from the group file.

Now, just after the install, and not having rebooted yet, I started the listener with the "lsnrcts start" command with no problem. I then started "sqlplus", logged in with the built-in user account scott and password, and got the SQL> prompt.

So all seemed well, then I rebooted. Now the Listener still starts up, but when I try and login using the Scott account I get the following error:

ERROR:
ORA-01314 : ORACLE not available
ORA-27101: Shared memory realm does not exists Linux error: 2: file or directory does not exist.

I've searched the webb high and low, and there seems to be limited information on this at the moment. I'm stumped and fed-up with this install at the moment. Quite complicated and buggy. This comming from someone that had to survive the likes of learning a Novell 3.x install from floppy disks.

Thank you,
YYZZ Received on Sun Sep 09 2001 - 22:54:24 CDT