Home » RDBMS Server » Server Administration » Error while creating new Oracle instance in solaris
Error while creating new Oracle instance in solaris [message #202469] Thu, 09 November 2006 23:44 Go to next message
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

Re: Error while creating new Oracle instance in solaris [message #202515 is a reply to message #202469] Fri, 10 November 2006 02:57 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
ORA-600 = Talk to Oracle Support.

That said, the error messages suggest that it thinks it has run out of space on one of the drives.
Re: Error while creating new Oracle instance in solaris [message #202711 is a reply to message #202469] Sat, 11 November 2006 04:16 Go to previous messageGo to next message
KenJ
Messages: 69
Registered: July 2006
Location: London
Member
Hi,
This is a memory/semaphore issue within the OS. Please get your SA to check that you have enough memory and also that you have the correct semaphore settings in the /etc/system file.
HTH,
Ken.
Re: Error while creating new Oracle instance in solaris [message #202867 is a reply to message #202711] Mon, 13 November 2006 02:17 Go to previous message
shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia
Junior Member
Hi All,

I restarted my solaris OS and the database creation worked fine.

Thanks,
Shilpa
Previous Topic: Regarding Segment Statistics
Next Topic: How do I add a datafile to a tablespace with '-' in the name
Goto Forum:
  


Current Time: Fri Sep 20 06:34:47 CDT 2024