Troubleshooting Database Network Issue

Below are couple tips to investigate network traffic and database network connections.

netstat -ptc :  Display the process ID and tcp connections.  If a process with abnormally high in Send-Q, it means that it consumes too much network traffic.  

ping and telnet - if you can't connect the remote servers, contact your network admin.

tnsping - check the remote listener and database to make sure they're up and running.

TNS_ADMIN  - verify the tnsnames.ora file

No comments:

Post a Comment