Error while creating new Oracle instance in solaris [message #202469] |
Thu, 09 November 2006 23:44 |
shilpa_sudhakar
Messages: 25 Registered: March 2006 Location: Australia
|
Junior Member |
|
|
Hi All,
I am trying to create a new instance of Oracle 9i in Solaris.
I already have 2 instances running.
The new instance name is : CRSG
The steps done are:
1) I create a new folder in /usr/oracle/admin/ as CRSG
Under this folder i create folders bdump,udump,cdump,pfile
Under pfile i create initCRSG.ora,spfileSG.ora,lkSG,orapwSG
and SQL Script cr_crsg.sql
2) I create another folder in /oradata/oracle01/ as CRSG
Under this folder i save the .dbf and .log files
3) Now i set the ORACLE_SID= CRSG
Then I run
sqlplus /nolog
then
conn / as sysdba
Connected as idle instance
Then,
SQL> @'/usr/oracle/admin/CRSG/pfile/cr_crsg.sql'
I get the below error.
ora-00600 : internal error code, arguments: [OSDEP_INTERNAL],[],[],[],[],[],[],[]
ora-27302 : failure occured 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 on device
ora-27302 : failure occured at : sskgpcreates
The sql script cr_crsg.sql is as follows:
STARTUP NOMOUNT PFILE='/usr/oracle/admin/CRSG/pfile/initiCRSG.ora'
CREATE CONTROLFILE SET DATABASE "CRSG" RESETLOGS NOARCHIVELOG
--SET STANDBY TO MAXIMUM PERFORMACE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP1 '/oradata/oracle01/CRSG/redo01.log' SIZE 100M,
GROUP2 '/oradata/oracle01/CRSG/redo02.log' SIZE 100M,
GROUP3 '/oradata/oracle01/CRSG/redo03.log' SIZE 100M,
--STANDBY LOGFILE
DATAFILE
'/oradata/oracle01/CRSG/system01.dbf',
'/oradata/oracle01/CRSG/undotbs01.dbf',
'/oradata/oracle01/CRSG/indx01.dbf',
'/oradata/oracle01/CRSG/tools01.dbf',
'/oradata/oracle01/CRSG/users01.dbf'
CHARACTER SET WE8ISO8859P1;
i checked the space and i see that out of the 34GB space there is 11GB remaining
/oradata - 68%
/users - 49%
Can anyone please tell me what the problem could be.
I have used the same script before to create an instance and it works fine. But now for the new instance it seems to be not working.
Thanks in advance,
Shilpa
[Updated on: Fri, 10 November 2006 00:23] Report message to a moderator
|
|
|
|
|
|