ORA-01103: Oracle database
- By Preneesh AV --
- 18-Mar-2015 --
- 3 Comments
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.