Manual Database Creation in 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Manual Database Creation in 10g

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    12

    Manual Database Creation in 10g

    Hello everyone,

    I'm trying to create an oracle database manually using Create Database command.
    I'm using 10g on Fedora Core 4.

    Here is the command:

    CREATE DATABASE testDb
    USER SYS IDENTIFIED BY secrect
    USER SYSTEM IDENTIFIED BY secret
    LOGFILE GROUP 1 ('/u01/app/oracle/oraData/testDb/redo01.log') SIZE 100M,
    GROUP 2 ('/u01/app/oracle/oraData/testDb/redo02.log') SIZE 100M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE '/u01/app/oracle/oraData/testDb/system01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE '/u01/app/oracle/oraData/testDb/sysaux01.dbf' SIZE 325M REUSE
    DEFAULT TABLESPACE USERS
    DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
    TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
    UNDO TABLESPACE UNDOTBS
    DATAFILE '/u01/app/oracle/oraData/testDb/undo01.dbf' SIZE 200M REUSE
    AUTOEXTEND ON MAXSIZE UNLIMITED;


    and here is the PFILE which I got it from the SPFILE that I'm using:

    testDbInstanceSID.__db_cache_size=92274688
    testDbInstanceSID.__java_pool_size=4194304
    testDbInstanceSID.__large_pool_size=4194304
    testDbInstanceSID.__shared_pool_size=62914560
    testDbInstanceSID.__streams_pool_size=0
    *.audit_file_dest='/u01/app/oracle/admin/testDb/adump'
    *.background_dump_dest='/u01/app/oracle/admin/testDb/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='/u01/app/oracle/oraData/testDb/control01.ctl','/u01/app/oracle/oraData/testDb/control02.ctl','/u01/app/oracle/oraData/testDb/control03.ctl'
    *.core_dump_dest='/u01/app/oracle/admin/testDb/cdump'
    *.db_block_size=8192
    *.db_domain='TestSys'
    *.db_file_multiblock_read_count=16
    *.db_name='testDb'
    *.open_cursors=300
    *.pga_aggregate_target=16777216
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=167772160
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS'
    *.user_dump_dest='/u01/app/oracle/admin/testDb/udump'


    and the SID is "testDbInstanceSID"

    So what I do is like this:


    >sqlplus "/ as sysdba"
    >startup nomount;
    >@/home/oracle/dbCreateScript.sql

    but I get this error in SqlPlus:

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

    and when I check the alert log, I find this:

    .....
    Completed: create tablespace SYSAUX datafile '/u01/app/oracle/oraData/testDb/sysaux01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
    Sat May 6 16:02:31 2006
    CREATE TEMPORARY TABLESPACE TEMPTBLSPC TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
    UNIFORM SIZE 1048576
    Completed: CREATE TEMPORARY TABLESPACE TEMPTBLSPC TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
    UNIFORM SIZE 1048576
    Sat May 6 16:02:31 2006
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
    Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
    Sat May 6 16:02:31 2006
    Errors in file /u01/app/oracle/admin/testDb/udump/testdbinstancesid_ora_14790.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Sat May 6 16:02:31 2006
    Errors in file /u01/app/oracle/admin/testDb/udump/testdbinstancesid_ora_14790.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name


    which I don't really underestand. What is that about? It got to be something obvious.

    Any Idea?

    Thanks in advance

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    I believe you need to create the USERS tablespace first before you specify "DEFAULT TABLESPACE USERS" in the create script.

    Does the trace file mention anything about the USERS tablespace?

  3. #3
    Join Date
    May 2006
    Posts
    12
    ebrian,
    You are right. Thanks a lot.

    I knew it that it got to be something obvious. Daaamn.

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