Question

How to check oracle db connection from command prompt

Answer 1

To check the Oracle DB connection from the command prompt, you can use the 'tnsping' utility.

Step-by-step explanation:

To check the Oracle DB connection from the command prompt, you can use the 'tnsping' utility. Here are the steps:

1. Open the command prompt.
2. Type 'tnsping' followed by the name of the Oracle TNS service name or its alias.
3. Press Enter to execute the command.
4. If the connection is successful, you will see a 'OK (0 msec)' message.
5. If the connection fails, you may see an error message indicating the reason for the failure.