Recovery from oracle with un-clean shutdown
Aug 22, 2016
sometimes we will occurs power outage or server reboot unexpectedly, it was an un-clean shutdown to oracle server.
then when we try to access oracle, we will get ORA-12518, TNS:listener could not hand off client connection
SOLUTION:
1.) re-start the listener.
2.) get in rman
or sqlplus
to manipulate recovery.1$ rman target 'sys/sys@<your-db-name> as sysdba' nocatalog
3.) startup as normal1RMAN> startup;
or start step by step to check if any issues there.123RMAN> startup nomount;RMAN> alter database mount;RMAN> alter database open;