Fix: Oracle Errors

• ORA-00333: redo log read error block 48640 count 4267

• ORA-01081: cannot start already-running ORACLE - shut it down first

• ORA-12154: could not resolve the connect identifier specified

• ORA-011033: initialization or shutdown in progress

sqlplus / as sysdba

SQL>select l.status, member from v$logfile inner join v$log l using (group#);
SQL>recover database using backup controlfile;
				C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_CG5OTNDC_.LOG
				
SQL>alter database open resetlogs;
SQL>shutdown abort
SQL>startup

References:

Tamangg, Dawaa. ORA-00333: redo log read error block count. https://askmedawaa.wordpress.com/2018/02/09/ora-00333-redo-log-read-error-block-count/