| database creation problem [message #271599] |
Tue, 02 October 2007 02:58  |
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 #271602 is a reply to message #271599] |
Tue, 02 October 2007 03:06  |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
