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.
Oracle LazyDBA home page