SQL> SHUTDOWN NORMAL
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Fix Error: ORA-01509: specified name ‘INST03’ does not match actual ‘PROD01’
You want to shutdown the actively running instance PROD01 and you execute the “shutdown normal” but the command may end up with below error.
SQL> shutdown normal
ORA-01509: specified name ‘INST03’ does not match actual ‘PROD01’
SQL>
Cause: The Oracle seem to have got its Ini file loaded with some other DBs PFILE/SPFILE
FIX: is to have Oracle load again with the relevant instance config files as shown below
SQL> STARTUP PFILE=/opt/oracle/product/8.1.6/dbfiles/initinst03.ora
ORA-01081: cannot start already-running ORACLE – shut it down first
SQL> SHUTDOWN NORMAL
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
