Analysis of tnsping commands in Oracle

OracleNet tool (command) tnsping is an OSI Session Layer tool used to verify name resolution (nameresolution, which is the name of an oracle Network Service)

Oracle Net tool (command) tnsping is an OSI Session Layer tool used to verify name resolution (name resolution, which is the name of an oracle Network Service)

Oracle Net tool (command) tnsping is an OSI Session Layer tool used:

1) Verify the name resolution (name resolution, which is the name of the oracle Network Service)

2) whether the remote listener is enabled

1. Remote tnsping

2. Disable listening

3. Start the listener and verify again

Summary:

1. The tnsping command can check whether the tcp protocol is the same. We call it network communication.

2. Check whether the listener on the server has enabled the tnsping command.

3. The tnsping command does not detect the service name of the listener on the server. Therefore, if the tnsping command is passed, it does not mean that it can be connected.

Recommended reading:

Different users use tnsping + client service name with different results

Differences between listener. ora sqlnet. ora tnsnames. ora in Oracle databases

Non-Default port listening configuration in Oracle RAC (listener. ora tnsnames. ora)

Oracle RAC listener Configuration (listener. ora tnsnames. ora)

Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example

Configure tnsnames. ora in the local Naming Service of Oracle