manual create 9i database problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: manual create 9i database problem

  1. #1
    Join Date
    Aug 2003
    Posts
    54

    manual create 9i database problem

    Hi all,

    I am on 9.2.0.4 running Linux Rehat Advance Server 2.1 and I tried to create 9i database manually and I have some problem, below is the error I got:

    Created Undo Segment _SYSSMU10$
    ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u01/ora...
    Tue Sep 16 09:09:49 2003
    Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Tue Sep 16 09:09:49 2003
    Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5166
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Instance terminated by USER, pid = 17792
    ORA-1092 signalled during: create database test
    controlfile reuse


    When I looked into ORA-01519, It said "Try the system installation procedure again or contact customer support", Does it mean my o/s and Oracle software is messed up????

    Everything went successful during my installation. DBCA ran successull to create the database

    any thoughts???
    Last edited by candyman; 09-16-2003 at 10:27 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Show the database creation script. Did you mention the 'create undo tablespace' command to create the undo tablespace ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Aug 2003
    Posts
    54
    adewi,

    below is my creation scripts:

    startup nomount pfile=/home/oracle/admin/HULAND01/pfile/initHULAND01.ora

    create database HULAND01
    controlfile reuse
    logfile ('/u01/oradata/HULAND01/log1HULAND01_A.log',
    '/u01/oradata/HULAND01/log1HULAND01_B.log') size 20M,
    ('/u01/oradata/HULAND01/log2HULAND01_A.log',
    '/u01/oradata/HULAND01/log2HULAND01_B.log') size 20M,
    ('/u01/oradata/HULAND01/log3HULAND01_A.log',
    '/u01/oradata/HULAND01/log3HULAND01_B.log') size 20M
    maxdatafiles 1022
    maxlogfiles 32
    maxlogmembers 5
    maxinstances 10
    character set "WE8ISO8859P1"
    EXTENT MANAGEMENT LOCAL
    datafile '/u01/oradata/HULAND01/system01.dbf' size 400m
    DEFAULT TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
    SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
    UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
    size 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k;



    one thing on my init.ora I have as follow:

    undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDOTBS1

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by candyman
    adewi,

    below is my creation scripts:

    startup nomount pfile=/home/oracle/admin/HULAND01/pfile/initHULAND01.ora

    create database HULAND01
    controlfile reuse
    logfile ('/u01/oradata/HULAND01/log1HULAND01_A.log',
    '/u01/oradata/HULAND01/log1HULAND01_B.log') size 20M,
    ('/u01/oradata/HULAND01/log2HULAND01_A.log',
    '/u01/oradata/HULAND01/log2HULAND01_B.log') size 20M,
    ('/u01/oradata/HULAND01/log3HULAND01_A.log',
    '/u01/oradata/HULAND01/log3HULAND01_B.log') size 20M
    maxdatafiles 1022
    maxlogfiles 32
    maxlogmembers 5
    maxinstances 10
    character set "WE8ISO8859P1"
    EXTENT MANAGEMENT LOCAL
    datafile '/u01/oradata/HULAND01/system01.dbf' size 400m
    DEFAULT TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
    SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
    UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf' <--
    size 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k;



    one thing on my init.ora I have as follow:

    undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDOTBS1
    Change the following line in your creation script.

    UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf'

    to

    UNDO TABLESPACE undotbs1 DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Aug 2003
    Posts
    54
    thanks for prompt reply.

    I did make the change and I run into problem with password file,

    Successfully onlined Undo Tablespace 1.
    Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/or
    Tue Sep 16 10:23:32 2003
    CREATE TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
    SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
    Completed: CREATE TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u0
    Tue Sep 16 10:23:32 2003
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_01
    Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_0
    Tue Sep 16 10:23:33 2003
    SMON: enabling tx recovery
    Tue Sep 16 10:23:35 2003
    Errors in file /home/oracle/admin/HULAND01/udump/huland01_ora_18242.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01990: error opening password file '/home/oracle/product/9.2.0/dbs/orapw'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    Tue Sep 16 10:23:35 2003
    Error 1990 happened during db open, shutting down database
    USER: terminating instance due to error 1990
    Instance terminated by USER, pid = 18242
    ORA-1092 signalled during: create database HULAND01
    controlfile reuse


    I did create the password file and it's there on dbs folder, how come it's still looking for orapw file???

    Please tell me how to fix this
    Last edited by candyman; 09-16-2003 at 12:23 PM.

  6. #6
    Join Date
    Jun 2000
    Posts
    295
    Your password file should be:
    orapw$ORACLE_SID

    Also try to comment out
    remote_login_passwordfile
    from init.ora file first.
    After database created, use orapwd to create a new one and change
    remote_login_passwordfile to execlusive

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