The command TNSPING can be used to get information about an alias for an Oracle server. Below you can see a screenshot from the command being executed in the command prompt for Windows.
In the command prompt you write: tnsping <the alias of your Oracle server>
TNSPING will return the
| HOST | Showing you the name of the physical host of the Oracle server. |
| PORT | Showing you the port of the Oracle server on the physical host. 1521 is the default port for an Oracle server. |