Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can't create DB

Can't create DB

From: D.I. <x_at_x.x>
Date: Mon, 8 Oct 2001 17:10:15 +0200
Message-ID: <9psfmi$34v$1@news.flashnet.it>


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 - 10:10:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US