Monday, July 15, 2013

ORA-01103: database name 'BCBL' in control file is not 'TEST'

SQL> STARTUP

ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             239077628 bytes
Database Buffers          364904448 bytes
Redo Buffers                7094272 bytes
ORA-01103: database name 'BCBL' in control file is not 'TEST'

SQL> SHUT IMMEDIATE;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> STARTUP NOMOUNT;

ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             243271932 bytes
Database Buffers          360710144 bytes
Redo Buffers                7094272 bytes

SQL> ALTER SYSTEM SET DB_NAME=BCBL SCOPE=SPFILE;

System altered.

SQL> SHUT IMMEDIATE;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> STARTUP

ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             247466236 bytes
Database Buffers          356515840 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.

SQL>

12 comments:

  1. Thank you, that's the solution.
    Marc

    ReplyDelete
  2. Thank you, it helped me much.
    Lubos

    ReplyDelete
  3. Thanks a lot.. it was a savior :)

    ReplyDelete
  4. Thank you so much. I am grateful

    ReplyDelete
  5. Thank you... this was helpful

    ReplyDelete
  6. Very nice. Thank you very much.

    ReplyDelete
  7. this post resolved my issue. Thanks so much! Dave

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Hi, still get an error. ORA-19838: Cannot use this control file to open database

    ReplyDelete
  10. Thanks much, helped me your post.

    ReplyDelete
  11. thanks so much i have fix several errors on this sit

    ReplyDelete