ORA-01103: database name 'TESTING2' in control file is not'TESTING1..
730694May 7 2010 — edited May 8 2010Hello 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