Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01103: database name 'TESTING2' in control file is not'TESTING1..

730694May 7 2010 — edited May 8 2010
Hello all, please help me on this..im using 10.2.0.4.0 , DB created by ex-colleque

while connecting db getting ora 1103 error, and tried to create controlfile using trace but i couldn't

here is the details:

TESTING1 >startup mount;
ORACLE instance started.

Total System Global Area 734003200 bytes
Fixed Size 2141536 bytes
Variable Size 328159904 bytes
Database Buffers 369098752 bytes
Redo Buffers 34603008 bytes
ORA-01103: database name 'TESTING2' in control file is not 'TESTING1'

want to backup ctl file and change the dbname, getting below error..

TESTING1 >alter database backup controlfile to trace;
alter database backup controlfile to trace
*
ERROR at line 1:
ORA-01507: database not mounted

TESTING1:/app/oracle/TESTING1/product/10.2.0.4/dbs >grep db_name initTESTING1.ora
*.db_name='TESTING1'

I have found TESTING2 entries in alert log file..

TESTING1:/app/oracle/TESTING1/admin/bdump >grep TESTING2 alert_TESTING1.log
DBNAME will be changed from TESTING1 to new DBNAME of TESTING2
Database name changed to TESTING2.
Database ID for database TESTING2 changed to 1933958893.

i have tried to create new controlfile and tried to startup..got below error hence i hv mentioned same datafiles path..
ORA-01161: database name TESTING2 in file header does not match given name of TESTING1
This post has been answered by sb92075 on May 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2010
Added on May 7 2010
3 comments
11,710 views