Oracle 9i Install Problem

[YYZZ]

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

[Mihalis Tsoukalos]

There is a mailing list for Oracle on SuSE.
I think you can find more help there.

To subscribe to the list, send a message to:
<suse-oracl...@suse.com>

cheers,

---
Mihalis Tsoukalos
mts...@freemail.gr

YYZZ <N...@Net.Net> wrote in message
news:DB1n7.352$9p.3...@paloalto-snr1.gtei.net...

[Gabriele Conrad]

YYZZ <N...@Net.Net> schrieb in im Newsbeitrag:

> 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.
>

> 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
>

Hi,
did you have a look at
http://www.suse.de/en/support/oracle/db/9i_71_72.html ?

There it reads:

orarun9i.rpm: The orarun package we already provided for 8i is back.
Download the package and
install it (as root) with the command rpm -Uvh orarun9i.rpm.
This package
Sets the user environment variables like $ORACLE_HOME at each login
(edit /etc/profile.d/oracle.sh to adapt it to your environment)
Sets the kernel parameters like max. shared memory (SHMMAX) as
required by Oracle (edit /etc/rc.config.d/oracle.rc.config unless the
Oracle recommended default values for a small test database are good
enough for you)
Starts/Stops the Oracle database at startup/shutdown. Also read
/usr/share/doc/packages/orarun9i/README.

This could have saved you some work in the first place.
The site is also a good for tips and tricks about oracle
installations. There also seems to be a forum hosted by oracle, that
is free, but I can't remember the link, since I use the metalink-site

apart from that, I can't offer you any help with your problem, but
you've got my sympathie, I did an install of 8.1.7 2 weeks ago and it
nearly drove me mad, but with other errors than yours.

Bye,
Gabi

[YYZZ]

Thanks for the information, I somehow missed that in my intense search for
answers.

~YYZZ

"Gabriele Conrad" <gabriel...@web.de> wrote in message
news:9niead$fu$1...@news.netcologne.de...