Re^3: SQLPLUS connect database

The TNSPING utility can be used to test an Oracle Service Name. To use it:

1.Open a Command Prompt (click Start, click Run, type cmd, and then click OK).

2.Type tnsping <service name> (for Oracle 7.3 or Oracle 8i and later) or tnsping80 <service name> (for Oracle 8.0), and then press enter.

The TNS Ping Utility will result in an "OK" or a "Connect failed" message. [...]

This was basically the first result searching for "oracle test connection command line" btw. Sauce

holli

You can lead your users to water, but alas, you cannot drown them.

Comment on Re^3: SQLPLUS connect database

Replies are listed 'Best First'.
Re^4: SQLPLUS connect database by ytjPerl (Scribe) on Jul 24, 2019 at 17:03 UTC
I tried tnsping, it only shows me whatever I configured in tnsnames.ora	[reply]
Re^5: SQLPLUS connect database by holli (Abbot) on Jul 24, 2019 at 17:06 UTC
Maybe it does that wenn you run it without arguments. Did you pass the <service name> in as it says in the docs? holli You can lead your users to water, but alas, you cannot drown them.	[reply] [d/l]