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