How to Resolve PRVF-0002 Error Messageby Ed ChenApril 20, 2019February 13, 2023PRVF-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
How to Resolve ORA-12535: TNS:operation timed outby Ed ChenFebruary 11, 2019June 23, 2023ORA-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 Hangby Ed ChenApril 9, 2017March 25, 2023sqlplus, 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 IPby Ed ChenDecember 20, 2016February 13, 20232 CommentsI 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