How to Resolve PRVF-0002 Error Message
PRVF-0002 could not retrieve local node name First of all, I need to clarify the error codes for you. The error code PRVF-0002 (three zeros… Read More »How to Resolve PRVF-0002 Error Message
Hostname Resolution
How to Resolve ORA-12535: TNS:operation timed out
ORA-12535 and TNS-12535 ORA-12535 is the same as TNS-12535, they all indicate that the connection between the client and the listener has been timed out.… Read More »How to Resolve ORA-12535: TNS:operation timed out
Why Tnsping Hang
sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases to share with you. Those hanging all… Read More »Why Tnsping Hang
How to Resolve Endpoint Listener is Not Listening to Public IP
I found that I can connect the database via VIP or SCAN, but not Public IP. I checked the endpoint listener. It did not listen… Read More »How to Resolve Endpoint Listener is Not Listening to Public IP