1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

create database error in oralce 9

Discussion in 'Installation - Unix and Unix Like' started by chuikingman, Oct 3, 2009.

  1. chuikingman

    chuikingman Guest

    Hi,
    I creat new database rman1 and get below error
    pleaseadvice ho to fix ??/

    SQL> CREATE DATABASE rman1
    2 LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
    GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
    GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
    3 4 5 MAXLOGFILES 5
    6 MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    7 8 9 MAXINSTANCES 1
    10 CHARACTER SET US7ASCII
    11 NATIONAL CHARACTER SET AL16UTF16
    12 DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
    13 EXTENT MANAGEMENT LOCAL
    14 DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
    15 16 SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    17 18 DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
    19 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
    CREATE DATABASE rman1
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced