creating database manually
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: creating database manually

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    creating database manually

    when i pass the following command in the nomount state it gives me an error
    SQL> connect sys/sys@db1 as sysdba
    Connected to an idle instance.
    SQL> startup nomount pfile='e:\oracle\admin\ser\pfile\init.ora'
    ORACLE instance started.

    Total System Global Area 105672596 bytes
    Fixed Size 282516 bytes
    Variable Size 71303168 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes
    SQL> create database ser
    2 datafile 'e:\oracle\oradata\ser\system01.dbf' size 100M
    3 logfile group 1 ('e:\oracle\oradata\ser\redo01.log') SIZE 5M, GROUP 2 ('E:\oracle\oradata\ser\redo02.log') SIZE 5M;
    create database ser
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    please help
    thanks

  2. #2
    Join Date
    May 2001
    Posts
    736
    What is your OS?. Why don't u create a script and run it?
    Where is the Character set?
    Last edited by akhadar; 06-21-2003 at 01:17 AM.

  3. #3
    Join Date
    Apr 2003
    Posts
    46
    i have windows 2000 server.the same error occurs even after specifying the character set.

  4. #4
    Join Date
    May 2001
    Posts
    736
    Why don't u use the DBA configuration asst. to create the database for U?

  5. #5
    Join Date
    Apr 2003
    Posts
    46
    dbca is always there to create databases but if i were to use omf then i have to create it manually.

  6. #6
    Join Date
    May 2001
    Posts
    736
    What the alert.log says?

  7. #7
    Join Date
    Apr 2003
    Posts
    46
    alert.log has not logged anything moreover it will not record since the db is in nomount state and we are creating a new db hence no point in logging in alert.log ( because it will log in which db file if there are more than one db)

  8. #8
    Join Date
    May 2001
    Posts
    736
    can u post your init.ora file.

  9. #9
    Join Date
    Apr 2003
    Posts
    46
    ##############################################################################
    # Copyright (c) 1991, 2001 by Oracle Corporation
    ##############################################################################

    ###########################################
    # Cache and I/O
    ###########################################
    db_block_size=4096
    db_cache_size=31457280

    ###########################################
    # Cursors and Library Cache
    ###########################################
    open_cursors=300

    ###########################################
    # Diagnostics and Statistics
    ###########################################
    background_dump_dest=E:\oracle\admin\ser\bdump
    core_dump_dest=E:\oracle\admin\ser\cdump
    timed_statistics=TRUE
    user_dump_dest=E:\oracle\admin\ser\udump

    ###########################################
    # Distributed, Replication and Snapshot
    ###########################################
    db_domain=""
    remote_login_passwordfile=EXCLUSIVE

    ###########################################
    # File Configuration
    ###########################################
    control_files=("E:\oracle\oradata\ser\control01.ctl", "E:\oracle\oradata\ser\control02.ctl", "E:\oracle\oradata\ser\control03.ctl")

    ###########################################
    # Miscellaneous
    ###########################################
    compatible=9.0.0
    db_name=ser

    ###########################################
    # Network Registration
    ###########################################
    instance_name=ser

    ###########################################
    # Pools
    ###########################################
    java_pool_size=20971520
    shared_pool_size=37748736

    ###########################################
    # Processes and Sessions
    ###########################################
    processes=150

    ###########################################
    # Redo Log and Recovery
    ###########################################
    fast_start_mttr_target=300

    ###########################################
    # Sort, Hash Joins, Bitmap Indexes
    ###########################################
    sort_area_size=524288

    ###########################################
    # System Managed Undo and Rollback Segments
    ###########################################
    undo_management=AUTO
    undo_tablespace=UNDOTBS

  10. #10
    Join Date
    May 2001
    Posts
    736
    comment out the UNDO.once the DB is created u can enable it.

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