Well, well, well!
It's Haggkvist Dan! Hehe. How have you been? This is what my /etc/system file looks like. I think you need to add the first two parameters listed below and bounce the server (init 6). Let me know what happens.
set noexec_user_stack=1
set rlim_fd_max=65536
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=1500
set semsys:seminfo_semmns=2000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
Have a great Day!
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Haggkvist Dan [mailto:oracledba-ezmlmshield-x32795008.[Email address protected]
Sent: Wednesday, January 31, 2007 7:41 AM
To: LazyDBA Discussion
Subject: FW: Oracle Installation
Hi All,
Hopefully someone will be able to help me with this. Oh and let me first say that I'm fairly new (read novice) when it comes to Oracle).
I'm setting up an older machine to use as a test server. It's a fresh Oracle 9iR2 installation on a Sun Fire V480 Server running Solaris 9i (fully patched).
Sun Fire V480
2x 900 MHz UltraSPARC-III Cu Processors
4Gb Memory
2 x 36 GB 10K-RPM FC-AL Disc Drives
Sun StoreEdge 3310 SCSI Array Rack
12 x 36.4 Gb 120K RPM Disks
I've set up the required folders/permissions/ UNIX account and group. I'm installation oracle in the /usr/local/oracle/product/9.2.0 directory with the database being held in /oradata.
System Parameters has been set to the following:
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=500
set shmsys:shminfo_shmseg=500
set semsys:shminfo_semmns=10000
set semsys:shminfo_semmsl=1000
set semsys:shminfo_semmni=1200
set semsys:seminfo_semopm=250
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semmap=900
set semsys:seminfo_semmnu=1200
and the following environment variables for the oracle account has been added to the
ORACLE_HOME=/usr/local/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_BASE=/usr/local/oracle
export ORACLE_BASE
PATH=$PATH:$ORACLE_HOME/bin:/etc:/usr/ccs/bin:/usr/openwin/bin
export PATH
ORACLE_SID=BB
export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
LD_LIBRARY_PATH=/usr/lib/sparcv9:/usr/ucblib/sparcv9:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_NLS33
The installation goes ok until it sets up / configures the starter database (Standard Installation, Enterprise Edition, AL32UFT8) and then I'm getting the following error messages.
Ora-27302: failure occurred at: skgpwreset1
Ora-27303:additional information: invalid shared ctx
Ora-27146: post/wait initialization failed
Ora-27300: OS System dependent operation: semget failed with status: 28
Ora-27301: OS failure message: No space left of device
Ora-27302: failure occurred at: sskgpcreate
There is plenty of space as you can see on the df -kh below.
Any help would be very, very much appreciated. It's driving me around the bend at the moment.
Thanks and regards,
Daniel
Filesystem size used avail capacity Mounted on
/dev/dsk/c1t0d0s0 24G 1.7G 22G 8% /
/proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
fd 0K 0K 0K 0% /dev/fd
/dev/dsk/c1t0d0s3 4.8G 198M 4.6G 5% /var
swap 24G 48K 24G 1% /var/run
swap 24G 291M 24G 2% /tmp
/dev/dsk/c2t0d1s0 31G 9K 30G 1% /oraexports
/dev/dsk/c2t0d1s1 2.6G 9K 2.5G 1% /rollback
/dev/dsk/c2t0d2s0 472M 9K 424M 1% /redo1a
/dev/dsk/c2t0d2s1 472M 9K 424M 1% /redo2b
/dev/dsk/c2t0d2s3 15G 9K 15G 1% /control1
/dev/dsk/c2t0d2s4 17G 9K 17G 1% /apps
/dev/dsk/c2t0d3s1 472M 9K 424M 1% /redo3a
/dev/dsk/c2t0d3s4 9.9G 9K 9.8G 1% /oraindexes
/dev/dsk/c2t0d3s3 15G 9K 15G 1% /control2
/dev/dsk/c2t0d3s5 7.5G 9K 7.5G 1% /temp
/dev/dsk/c2t0d3s0 472M 9K 424M 1% /redo1b
/dev/dsk/c2t0d4s0 472M 9K 424M 1% /redo2a
/dev/dsk/c2t0d4s1 472M 9K 424M 1% /redo3b
/dev/dsk/c2t0d5s0 28G 9K 27G 1% /archivelog
/dev/dsk/c2t0d4s3 9.9G 11K 9.8G 1% /oradata
/dev/dsk/c2t0d6s0 28G 9K 27G 1% /archivelog2
/dev/dsk/c2t0d4s4 6.9G 9K 6.8G 1% /oraclesan
/dev/dsk/c1t0d0s7 2.9G 2.1M 2.8G 1% /export/home
/dev/dsk/c1t0d0s4 14G 2.4G 12G 18% /usr/local/oracle
This e-mail is private and may be confidential and is for the intended recipient only. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it.
We virus scan all E-mails leaving The University of Northampton but no warranty is given that this E-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor E-mail communications through our networks is reserved by us.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page