DB creation problem

[DoubleH]

Hi,
In my application, someone has accidentally ran a db_create script which is supposed to remove all the db files and then create a new database. But, in between the db_create had failed saying problem in shmmax. So, if we change the kernel parameter to a higher value, will it work?..
Another question is, if the control file is deleted accidentally, can we create the file even when the database is down?.

Thanks & Regards,
DoubleH

 

[ThomVF]

From:

http://developer.netscape.com/docs/manuals/pubxpert/pub25/Gs/ndxBOracleInst.htm

Edit the /etc/system file to allocate shared memory and semaphores for Oracle. Choose a value for shminfo_shmmax that is appropriate for your machine and the memory you want to use for Oracle shared memory.

If your system has only 32MB of main memory, set shmsys:shminfo_shmmax to 16MB or 24 MB

If your main memory is 64 MB, set shmmax to 32 or 48 MB
Oracle's total SGA should be less than shmmax. The following are some figures for different shmmax values
Main Memory
Shared Memory Setting

16 MB
shmsys:shminfo_shmmax=16777216

24 MB
shmsys:shminfo_shmmax=25165824

32 MB
shmsys:shminfo_shmmax=33554432

48 MB
shmsys:shminfo_shmmax=50331648

64 MB
shmsys:shminfo_shmmax=67108864

128 MB
shmsys:shminfo_shmmax=134217728


/etc/system Settings for shared memory

Your file should look something like this:
set shmsys:shminfo_shmmax=67108864
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=600
set shmsys:shminfo_shmseg=100

set semsys:seminfo_semmap=100
set semsys:seminfo_semmni=400
set semsys:seminfo_semmns=400
set semsys:seminfo_semmnu=300
set semsys:seminfo_semume=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semopm=100

set msgsys:msginfo_msgmap=1024
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmni=1024
set msgsys:msginfo_msgssz=2048
set msgsys:msginfo_msgtql=1024
set msgsys:msginfo_msgseg=4096

Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com