Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    34

    Unanswered: error on create database

    Hi Friends!

    I have the following problem.

    I'm trying to create a database with ORACLE 9.2.0.1:
    CREATE DATABASE PROVA
    Maxinstances 1
    Maxloghistory 1
    Maxlogfiles 10
    MAXLOGMEMBERS 5
    Maxdatafiles 100
    Datafile '/products/oracle92/app/oracle/oracle/product/9.2.0.1/datafile/datafile
    01.dbf'
    size 200M reuse autoextend on next 15M maxsize unlimited
    logfile
    group 1 ('/products/oracle92/app/oracle/oracle/product/9.2.0.1/redo/redo_01.log'
    ) size 75M,
    group 2 ('/products/oracle92/app/oracle/oracle/product/9.2.0.1/redo/redo_02.log'
    ) size 75M,
    group 3 ('/products/oracle92/app/oracle/oracle/product/9.2.0.1/redo/redo_03.log'
    ) size 75M
    default temporary tablespace TEMP
    tempfile '/products/oracle92/app/oracle/oracle/product/9.2.0.1/datafile/temp_01.
    dbf'
    extent management local uniform size 30M;

    then i receive the following error:

    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    help me ,please

    Pappagone

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what is the alter.log showing?
    which platform?

    did you configure the kernel parameters for your unix system properly?

  3. #3
    Join Date
    May 2003
    Posts
    5

    Cool

    Hi there,

    There can be many reason for this

    I think, you should add UNDO tablespace parameter which is mandotary parameter for creating database and temporary tablespace parameter also.

    U should add default charactor set and national charactor also.

    U should have proper rights to create datafiles/tempfiles on disk.

    Ravi

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    Use this template to create a new db instance on Oracle 9i:

    connect SYS/change_on_install as SYSDBA
    set echo on
    spool D:\Oracle\901ee\assistants\dbca\logs\CreateDB_db04 .log
    startup nomount pfile="D:\Oracle\admin\db04\scripts\init.ora";
    CREATE DATABASE db04
    MAXINSTANCES 1
    MAXLOGHISTORY 1
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    DATAFILE 'D:\Oracle\oradata\db04\system01.dbf' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    UNDO TABLESPACE "UNDOTBS" DATAFILE 'D:\Oracle\oradata\db04\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    CHARACTER SET WE8ISO8859P15
    NATIONAL CHARACTER SET UTF8
    LOGFILE GROUP 1 ('d:\Oracle\oradata\db04\redo01.log','d:\Oracle\or adata\db04\redo02.log') SIZE 100M,
    GROUP 2 ('d:\Oracle\oradata\db04\redo03.log','D:\Oracle\or adata\db04\redo04.log') SIZE 100M,
    GROUP 3 ('d:\Oracle\oradata\db04\redo05.log','D:\Oracle\or adata\db04\redo06.log') SIZE 100M;
    spool off
    exit;



    Hope that helps,

    clio_usa - OCP - DBA

    dbaclick.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •