Home » RDBMS Server » Server Administration » database creation problem
database creation problem [message #271599] Tue, 02 October 2007 02:58 Go to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

We are trying to create a database using DBCA(Oracle 9.2.0.6) on Red hat Linux enterprise edition 4.0. At first it throw an error "ORA-27123: unable to attach to shared memory segment". We increased the kernel.shmmax to 3GB where it was 2GB previously and other parameters in their default values. Next when we are trying to create the database again with a db_block_size of 8192 bytes it is showing a message that the database can only be mounted on 4096 not on 8192. Please recommend me what to do in this type of situation. Do I need to configure the /etc/sysctl.conf or anything else to enable this facility.

Thanks and Regards,
Sam G
Re: database creation problem [message #271601 is a reply to message #271599] Tue, 02 October 2007 03:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
the database can only be mounted on 4096 not on 8192.


Cut and paste the error number as well as screen texts.
Re: database creation problem [message #271602 is a reply to message #271599] Tue, 02 October 2007 03:06 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you use db_block_buffers?
What is your database block size?
What are all the *size parameters?
Do you use an init.ora or spfile?

Regards
Michel
Previous Topic: DB Got Shutdown
Next Topic: Instance failure with Session and Process parameter
Goto Forum:
  


Current Time: Sat Dec 03 12:12:03 CST 2016

Total time taken to generate the page: 0.09328 seconds