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>
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>
Thank you, that's the solution.
ReplyDeleteMarc
Thank you, it helped me much.
ReplyDeleteLubos
Thanks a lot.. it was a savior :)
ReplyDeleteThank you so much. I am grateful
ReplyDeleteThank you... this was helpful
ReplyDeleteVery nice. Thank you very much.
ReplyDeletethis post resolved my issue. Thanks so much! Dave
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi, still get an error. ORA-19838: Cannot use this control file to open database
ReplyDeleteThanks much, helped me your post.
ReplyDeletethanks so much i have fix several errors on this sit
ReplyDeleteyou are master piece
ReplyDelete