Re: Can't create DB

"D.I." wrote:
>
> 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?

And the alert log says?? And the trace files say? There lie your answers, along with the Oracle Error Message docs.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.