Re: Can't create DB

From: D.I. <x_at_x.x>
Date: Tue, 9 Oct 2001 09:45:44 +0200
Message-ID: <9pua0d$6oo$1@news.flashnet.it>

OK I found the log

alert.log

    Mon Oct 8 16:28:37 2001
    Starting ORACLE instance (normal)

    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0

    Starting up ORACLE RDBMS Version: 8.1.7.0.1.     System parameters with non-default values:

      processes                = 10
      shared_pool_size         = 1048576
      large_pool_size          = 614400
      java_pool_size           = 32768
      control_files                =


/opt/oracle/OraHome1/oradata/tsdm01/control01.ctl,

/opt/oracle/OraHome1/oradata/tsdm01/control02.ctl,
/opt/oracle/OraHome1/oradata/tsdm01/control03.ctl

      db_block_buffers         = 1024
      db_block_size            = 8192
      compatible               = 8.1.0
      log_buffer               = 163840
      log_checkpoint_interval  = 10000
      log_checkpoint_timeout   = 1800
      max_enabled_roles        = 30
      remote_login_passwordfile= EXCLUSIVE
      instance_name            = tsdm01
      service_names            = tsdm01
      sort_area_size           = 65536
      sort_area_retained_size  = 65536
      db_name                  = tsdm01
      open_cursors             = 300
      os_authent_prefix        =
      background_dump_dest     = /opt/oracle/OraHome1/admin/tsdm01/bdump
      user_dump_dest           = /opt/oracle/OraHome1/admin/tsdm01/udump
      core_dump_dest           = /opt/oracle/OraHome1/admin/tsdm01/cdump

  udump and cdump are empty
  control01.ctl,control02.ctl,control03.ctl are not created

tsdm011.sh

    #!/bin/sh
    ORACLE_SID=tsdm01
    export ORACLE_SID
    /opt/oracle/OraHome1/bin/svrmgrl << EOF     spool /opt/oracle/OraHome1/admin/tsdm01/create/crdb1.log     connect internal
    startup nomount pfile =
"/opt/oracle/OraHome1/admin/tsdm01/pfile/inittsdm01.ora"

    .
    .

crdb1.log

    Connected.
    ORA-03113: end-of-file on communication channel     CREATE DATABASE "tsdm01"
    *
    ORA-03114: not connected to ORACLE
    ORA-03113: end-of-file on communication channel

I think that I get an error on the startup nomount... Received on Tue Oct 09 2001 - 02:45:44 CDT