From: Alexandre Gorbatchev (alexandre.gorbatchev@avermann.de)
Date: Mon Oct 07 2002 - 09:00:59 CEST
From: "Alexandre Gorbatchev" <alexandre.gorbatchev@avermann.de> Date: Mon, 7 Oct 2002 09:00:59 +0200 Message-ID: <AKEBIHJFGKLHLMGPOKKLIECGCCAA.alexandre.gorbatchev@avermann.de> Subject: RE: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet pleaseadvise
Rob,
You messed up pretty much here. DO follow instructions precisely if you
don't know how it works. You should read Oracle Installation Guide for Linux
and Release Notes. If it's not enough read Oracle Installation Guide for
UNIX - it's more detailed. These give you a sence of what instructions and
why you are following in the guide from suse.com.
Now comments:
SHMMAX should be set every time you reboot, so if you reboot after that -
it's lost. :) orarun9i is installed to be run everytime you reboot, so
install it and reboot. To check if you have it installed run as root: rpm -q
orarun9i - it shows you version installed (you probably have it installed if
you followed installation tips from suse).
take a look at your boot messages in /var/log/boot.msg. You should find:
---- Setting kernel parameters for Oracle from /etc/rc.config.d/oracle.rc.config. See file /etc/rc.config.d/oracle.rc.config for explanations. Shared memory SHMMAX: 2147483647 SHMMNI: 4096 SHMALL: 2097152 Semaphore values SEMMSL: 250 SEMMNS: 32000 SEMOPM: 100 SEMMNI: 256 Kernel parameters are set for Oracle.done ---- Have it? you are fine then. Also your SGA is very small: 40Mb. That's why dbca could stop on 46% - your Oracle instance ran out of memory. And you have 200Kb database buffer size??? That's _VERY_VERY_ small.Advise - run dbca again. If it didn't finish properly, you will never have DB running witout problem anyway. In dbca choose one of standard starter databases and dont change anything - it will use precreated files for databse. Note: before running dbca do "export DISPLAY=localhost:0.0" and don't forget you should run it as "oracle" user.
Good luck, Alexandre
-----Original Message----- From: rob [mailto:robert73@attbi.com] Sent: Monday, October 07, 2002 2:15 AM To: Bennett Leve Cc: suse-oracle@suse.com Subject: Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet pleaseadvise
HI!
>As root: > > # echo 419430400 > /proc/sys/kernel/shmmax >
DONE
>Just add the following after the last "#": > > # Increase SHMMAX for oracle -- rob:/10_06_2002 > echo 419430400 > /proc/sys/kernel/shmmax > >
DONE
Ok I made the changes and even rebooted, somehow I suspect adding the memory to the kernel did not "take" because the memory still shows up in free
Nicole:~ # free total used free shared buffers cached Mem: 513496 226936 286560 0 24300 117088 -/+ buffers/cache: 85548 427948 Swap: 1028120 0 1028120
########################################################## here is boot.local Nicole:/etc/init.d # cat boot.local #! /bin/sh # # Copyright (c) 2002 SuSE Linux AG Nuernberg, Germany. All rights reserved. # # Author: Werner Fink <werner@suse.de>, 1996 # Burchard Steinbild <feedback@suse.de>, 1996 # # /etc/init.d/boot.local # # script with local commands to be executed from init on system startup # . /etc/rc.config # # Here you should add things, that should happen directly after booting # before we're going to the first run level. # echo 419430400 > /proc/sys/kernel/shmmax # # above adds 400meg of ram to the kernal for oracle added on oct 5 2002 by rob; ##########################################################
here is my sql session
oracle@Nicole:~> sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.1.0 - Production on Sun Oct 6 16:49:56 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=/work/9ihome/dbs/init.ora ORACLE instance started.
Total System Global Area 42741800 bytes Fixed Size 450600 bytes Variable Size 41943040 bytes Database Buffers 204800 bytes Redo Buffers 143360 bytes SQL> shutdown immediate ORA-01507: database not mounted
ORACLE instance shut down. SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
keep in mind I dont beleive the db never actually got built I have empty admin and oradata directories... ##########################################################
oracle@Nicole:~> dbca Xlib: connection to ":0.0" refused by server Xlib: No protocol specified
java.lang.NoClassDefFoundError
#############################################################
So it looks like dbca cant run... ;-(
I have a high end system running 1024x786 in n million colors so i dont thing its an obivious display issue
> > #############################################################
Further down the road....
SQL> startup nomount pfile=/work/9ihome/dbs/init.ora ORACLE instance started.
Total System Global Area 42741800 bytes Fixed Size 450600 bytes Variable Size 41943040 bytes Database Buffers 204800 bytes Redo Buffers 143360 bytes
SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
oracle@Nicole:~> lsnrctl reload
LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 06-OCT-2002 17:09:48
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Nicole.local)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused ########################################################
oracle@Nicole:~> cat /work/9ihome/network/admin/tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /work/9ihome/network/admin/tnsnames.ora # Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.LOCAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
so there isnt a db in tnsnames.....
rob -- "The New York Times is read by the people who run the country. The Washington Post is read by the people who think they run the country. The National Enquirer is read by the people who think Elvis is alive and running the country ..." -- Robert J Woodhead
--------------------------------------------------------------------- To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com For additional commands, e-mail: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
--------------------------------------------------------------------- To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com For additional commands, e-mail: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.4 : Mon Oct 07 2002 - 09:01:11 CEST