Even though your kernel parameters may be set correctly, are you sure you enough
free memory to create the SGA? Any time I have come across the ORA-03113 error
at startup, the problem was a lack of free memory. Please check the amount of
free memory before you start the database create statement and make sure it
significantly larger than the size of the SGA for the instance you are creating.
If you are not sure, then shut down some other processes or reduce the size of
the SGA and try creating the database again.
HTH......
Patrick
In article <9psfmi$34v$1_at_news.flashnet.it>, D.I. says...
>
>Hi, my OS is SUSE 7.2 and when i try to lunch the script for create a DB it
>return to me the next log
>
> oracle_at_linux:~/OraHome1/assistants/dbca > ./creatsdm01.sh
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
> JServer Release 8.1.7.0.1 - Production
>
> SVRMGR> SVRMGR> Connected.
> SVRMGR> ORA-03113: end-of-file on communication channel
> SVRMGR> 2> 3> 4> 5> 6> 7> 8> 9>
>10> CREATE DATABASE "tsdm01"
> *
> ORA-03114: not connected to ORACLE
> SVRMGR> ORA-03113: end-of-file on communication channel
> SVRMGR> SVRMGR> Server Manager complete.
>
>All kernel parameter are set
>
>my shm.h
> .
> .
> #define SHMMAX 0x2000000 /* max shared seg size (bytes) */
> #define SHMMIN 1 /* min shared seg size (bytes) */
> #define SHMMNI 4096 /* max num of segs system wide */
> #define SHMALL (SHMMAX/PAGE_SIZE*(SHMMNI/16)) /* max shm system wide
>(pages) */
> #define SHMSEG SHMMNI /* max shared segs per process */
> .
> .
>
>my sem.h
> .
> .
> #define SEMMNI 128 /* <= IPCMNI max # of semaphore
>identifiers */
> #define SEMMSL 2048 /*was 250 | <= 8 000 max num of
>semaphores per id */
> #define SEMMNS (SEMMNI*SEMMSL) /* <= INT_MAX max # of semaphores in
>system */
> #define SEMOPM 200 /* was 32| <= 1 000 max num of ops per semop
>call */
> #define SEMVMX 32767 /* <= 32767 semaphore maximum value */
> .
> .
>
>my initSID.ora
> db_name = "tsdm01"
> instance_name = tsdm01
> service_names = tsdm01
> control_files = ("/opt/oracle/OraHome1/oradata/tsdm01/control01.ctl",
>"/opt/oracle/OraHome1/oradata/tsdm01/control02.ctl",
>"/opt/oracle/OraHome1/oradata/tsdm01/control03.ctl")
> open_cursors = 300
> max_enabled_roles = 30
> db_block_buffers = 1024
> shared_pool_size = 1048576
> large_pool_size = 614400
> java_pool_size = 0
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> processes = 10
> log_buffer = 163840
> background_dump_dest = /opt/oracle/OraHome1/admin/tsdm01/bdump
> core_dump_dest = /opt/oracle/OraHome1/admin/tsdm01/cdump
> user_dump_dest = /opt/oracle/OraHome1/admin/tsdm01/udump
> db_block_size = 8192
> remote_login_passwordfile = exclusive
> os_authent_prefix = ""
> compatible = "8.1.0"
> sort_area_size = 65536
> sort_area_retained_size = 65536
>
>My swap memory area is less than 400MB it's about 138MB
>
>
>Can you help me?
>
>
Received on Mon Oct 08 2001 - 12:20:38 CDT
