sqlplus Connecting Hang?
SQL*Plus Network Issues At times, we see that some logins and connections are not responding and indefinitely hang in tools like SQL*Plus. In most cases,… Read More »sqlplus Connecting Hang?
Domain Name Server (DNS)
How to Resolve PRKO-2054 : Invalid command line syntax
PRKO-2054 or PRKO-02054 Tried to list configuration of all virtual IP (VIP) in the cluster, but it failed with PRKO-02054. [grid@primary01 ~]$ srvctl config vip… Read More »How to Resolve PRKO-2054 : Invalid command line syntax
How to Resolve PRVG-2048 : no response for name from the DNS server
PRVG-2048 Saw PRVG-2048 when I verify the RAC environment by runcluvfy.sh before actually installing grid infrastructure. [grid@primary01 ~]$ cd $ORACLE_HOME [grid@primary01 grid]$ ./runcluvfy.sh stage -pre… Read More »How to Resolve PRVG-2048 : no response for name from the DNS server
How to Resolve ORA-12545: Connect failed because target host or object does not exist
ORA-12545 and TNS-12545 ORA-12545 is the same as TNS-12545, they all indicate that the destination you provide in the connection string or description is not… Read More »How to Resolve ORA-12545: Connect failed because target host or object does not exist
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
How to Make Forwarders of BIND Named Server Work
Your DNS might not cache all the records of internet, but you can forward the query to external DNS for servicing your clients.There're two entries… Read More »How to Make Forwarders of BIND Named Server Work