-
Platform : HP-UX ver. 10.20
Oracle Server : 8.0.4
Occasion : trying to create another database on the server
Situation : at the moment I have one working database ORCL
Problem : when trying to create another database ORC1 , I get the incoming error from server manager :
ORA-00600 internal error code , arguments : [SKGMBUSY],[1],[0], [0], [0], [0],[] ,[] ,[] ,[]
ORA-27123 Unable to attache to the shared memory segment HP-UX Error :22 : Invalid Argument.
I tried to create the new database from the installer but also failled and when checked the trace file I witnessed the same error .
What could be Wrong ???
-
check your kernal parameters. I would bet one of them is low...
-
Check the init.ora for both the instances to compare what kind of shared_pool_size you are setting.
- Rajeev
-
Thank You All , I just forget to tell that the first database was closed when starting to create the second one.
Thank You
-
Hi,
If appears that you do not have any more shared memory segments available.
Check if some are still in use by typing ipcs command. The database must be down but for some reason the shared memory is not deallocated.
Re-start UNIX and then try creating the database.
Baliga
-
Hi,
I've faced these prblm earlier. Pls check the value of SHMMAX using sam utility of unix. The exact problem is 'cause the sum of the SGA of both Oracle DB is exceeding this value. Try increasing the value of SHMMAX and then start both the DB's