Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Unanswered: Database creation problem

    hi when i run the following sql script

    CREATE DATABASE mydb
    USER SYS IDENTIFIED BY oracle
    USER SYSTEM IDENTIFIED BY oracle
    LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mydb/redo01.log') SIZE 50M,
    GROUP 2 ('/u01/app/oracle/oradata/mydb/redo02.log') SIZE 50M,
    GROUP 3 ('/u01/app/oracle/oradata/mydb/redo03.log') SIZE 50M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    CHARACTER SET AL32UTF8
    NATIONAL CHARACTER SET UTF8
    DATAFILE '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 250M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 250M REUSE
    DEFAULT TABLESPACE user_default
    DATAFILE '/u01/app/oracle/oradata/mydb/default_tab01.dbf' SIZE 250M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
    DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
    SIZE 50M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE '/u01/oracle/oradata/mydb/undotbs01.dbf'
    SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
    /

    the following error message is being shown

    CREATE DATABASE mydb
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    ERROR:
    ORA-03114: not connected to ORACLE

    but out of 8 , 7 files are created in the given path instead SYSAUX file.

    can pls sen me the remedy as soon as possible

    thanx

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Try this article for ideas:

    http://www.adp-gmbh.ch/ora/admin/cre...bmanually.html

    (Then try Google if you're still stuck - in the words of Homer Simpson, "they have the internet on computers now!")
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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