-
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 ???
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
-
check your kernal parameters. I would bet one of them is low...
Jeff Hunter
-
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
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
-
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
A Winner never Quits, A Quitter never Wins
Ganesh .R
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|