ORA-01504: Control File
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-01504: Control File

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    86
    I am able to connect to database.
    I bring the database to NOMOUNT and then try to do the following thing.
    I am trying to create the control file, but it's pointing towards AAAA. I have already made the change to init.ora file db_name = "BBBB".

    Still I am getting this error.

    HELP HELP

    SQL> CREATE CONTROLFILE REUSE SET DATABASE BBBB RESETLOGS NOARCHIVELOG
    2 MAXLOGFILES 32
    3 MAXLOGMEMBERS 2
    4 MAXDATAFILES 254
    5 MAXINSTANCES 1
    6 MAXLOGHISTORY 1809
    7 LOGFILE
    8 GROUP 1 'C:\ORACLE\ORADATA\BBBB\REDO01.LOG' SIZE 1M,
    9 GROUP 2 'C:\ORACLE\ORADATA\BBBB\REDO02.LOG' SIZE 1M,
    10 GROUP 3 'C:\ORACLE\ORADATA\BBBB\REDO03.LOG' SIZE 1M,
    11 GROUP 4 'C:\ORACLE\ORADATA\BBBB\REDO04.LOG' SIZE 1M
    12 DATAFILE
    13 'C:\ORACLE\ORADATA\BBBB\SYSTEM01.DBF',
    14 'C:\ORACLE\ORADATA\BBBB\RBS01.DBF',
    15 'C:\ORACLE\ORADATA\BBBB\USERS01.DBF',
    16 'C:\ORACLE\ORADATA\BBBB\TEMP01.DBF',
    17 'C:\ORACLE\ORADATA\BBBB\TOOLS01.DBF',
    18 'C:\ORACLE\ORADATA\BBBB\INDX01.DBF',
    19 'C:\ORACLE\ORADATA\BBBB\DR01.DBF'
    20 CHARACTER SET WE8ISO8859P1;
    CREATE CONTROLFILE REUSE SET DATABASE BBBB RESETLOGS NOARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01504: database name 'BBBB' does not match parameter db_name 'AAAA'

    Thanks
    Harry

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    check ORACLE_SID
    check initSID.ora filename
    check your startup syntax and pfile specified

  3. #3
    Join Date
    Apr 2002
    Posts
    86
    (1)How to check Oracle_sid..?

    Now I am getting this error.

    SQL> startup nomount pfile='c:\oracle\ora81\initBBBB.ora';
    LRM-00109: could not open parameter file 'c:\oracle\ora81\initBBBB.ora'
    ORA-01078: failure in processing system parameters

    Thanks
    Harry

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ORACLE_SID is set in registry or windows enviroment variables

    the error says there is no such file

    if file exists then check new parameters you have added

  5. #5
    Join Date
    Apr 2007
    Posts
    1
    SQL> CREATE DATABASE dbpro
    DATAFILE '/opt/app/dbpro/oradata/oracle/system01.dbf' SIZE 100M REUSE AUTOEXTEND ON
    UNDO TABLESPACE undotbs1 DATAFILE '/opt/app/dbpro/oradata/oracle/undotbs1.dbf' SIZE 50M REUSE AUTOEXTEND ON
    default temporary tablespace temp tempfile '/opt/app/dbpro/oradata/oracle/temp01.dbf' size 10m reuse autoextend on
    LOGFILE GROUP 1 '/opt/app/dbpro/oradata/oracle/redo01.log' SIZE 10M,
    GROUP 2 '/opt/app/dbpro/oradata/oracle/redo02.log' SIZE 10M;

    CREATE DATABASE dbpro
    *
    ERROR at line 1:
    ORA-01501: CREATE DATABASE failed
    ORA-01504: database name 'DBPRO' does not match parameter db_name 'oracle'

    pls help me

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the db_name parameter you have set in the parameter file 'oracle' does not match what you are actually trying to create 'dbpro' fix one or the other

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    set env ORACLE_SID in O.S. level like:
    SET ORACLE_SID=BBBB

    before recreating controlfile.
    ---------------

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by reydp
    set env ORACLE_SID in O.S. level like:
    SET ORACLE_SID=BBBB

    before recreating controlfile.
    the first post is 5 years old - id imagine he has fixed that. The guy who has re-opened this thread has a new problem - and what you posted there wont have helped either

  9. #9
    Join Date
    Jan 2007
    Posts
    231
    set as db_name=dbpro in pfile;
    then redo the same process.

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