Thursday, July 14, 2016

ORA-01103: database name 'DEVSID' in control file is not 'PRODSID'

startup nomount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             436208520 bytes
Database Buffers          616562688 bytes
Redo Buffers               13905920 bytes
SQL> ALTER SYSTEM SET DB_NAME=PRO0TS SCOPE=spfile;
System altered.
shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>; exit 
SQL>; startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             444597128 bytes
Database Buffers          608174080 bytes
Redo Buffers               13905920 bytes
Database mounted.
Database opened.

No comments: