DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DB creation error

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    DB creation error

    I've problem with database creation.can anyone help me,how to solve the following problem.

    When i give
    >STARTUP NOMOUNT pfile='c:\newdb\init.ora'
    ORACLE instance started.

    Total System Global Area 122755896 bytes
    Fixed Size 453432 bytes
    Variable Size 96468992 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes

    INIT.ORA File contents
    db_block_size=8192 #8KB
    db_cache_size=25165824 #24M

    open_cursors=100

    db_name=NEWDB

    background_dump_dest=C:\oracle\admin\NEWDB\bdump
    core_dump_dest=C:\oracle\admin\NEWDB\cdump
    timed_statistics=TRUE
    user_dump_dest=C:\oracle\admin\NEWDB\udump

    control_files=("C:\oracle\oradata\NEWDB\CONTROL01.CTL", "C:\oracle\oradata\NEWDB\CONTROL02.CTL", "C:\oracle\oradata\NEWDB\CONTROL03.CTL")

    instance_name=NEWDB

    hash_join_enabled=TRUE

    java_pool_size=25165824
    large_pool_size=25165824
    shared_pool_size=31457280 # 30M

    processes=25

    fast_start_mttr_target=300

    remote_login_passwordfile=EXCLUSIVE

    pga_aggregate_target=25165824
    sort_area_size=524288 #512K

    undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDO


    But when i run the create database script it gives the followin error,
    SQL> create database NEWDB
    2 controlfile reuse
    3 logfile
    4 GROUP 1 ( 'C:\oracle\oradata\newdb\log1a.rdo') SIZE 5M reuse,
    5 GROUP 2 ( 'C:\oracle\oradata\newdb\log2a.rdo') SIZE 5M reuse,
    6 GROUP 3 ( 'C:\oracle\oradata\newdb\log3a.rdo') SIZE 5M reuse
    7 datafile 'C:\oracle\oradata\newdb\data01.dbf' SIZE 20M reuse
    8 undo tablespace UNDO
    9 datafile 'C:\oracle\oradata\newdb\undo01.dbf' SIZE 15M reuse
    10 default temporary tablespace TEMP
    11 tempfile 'C:\oracle\oradata\newdb\temp01.dbf ' SIZE 10M reuse
    12 extent management local uniform size 64k
    13 ;
    create database NEWDB
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced



    Why the ORACLE instance get terminated and Disconnection forced.Is there any problem with the parameter settings?

    Please help me to get out of this problem.

  2. #2
    Join Date
    Feb 2006
    Posts
    1

    Check Alert.log

    Have you checked the alert.log file to have more detailed error message?

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    The alert log being C:\oracle\admin\NEWDB\bdump\alert_NEWDB.log

  4. #4
    Join Date
    Feb 2006
    Posts
    162

    DB creation error

    Thanks for all.I checked the Alert.Log & found out the error & the database is successfully created.

Posting Permissions

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


Click Here to Expand Forum to Full Width