CODEWITHSUNDEEP
oracle-databasedatabase-connectionconnection-stringsqlplustnsping
Arvinth
Arvinth

Reputation: 70

I am able to connect to Oracle Db using Toad but connection using sqlplus is not working. Getting TNS timeout error

I am able to connect to Oracle DB using Toad with Datasource name and username/password. Oracle client 12 as Oracle driver. oracle database path is set properly in the environment variables. sqlnet.ora, listener.ora and tnsnames.ora is present in ORACLE\ORANT\NETWORK\ADMIN folder and configured properly. I tried to query using Sqlplus in cmd prompt using following command:

 connect User/[email protected]:1527/pdw1s_servicename

I am getting ORA-12170: TNS Connect timeout error. Please help.

Upvotes: 0

Views: 2143

Answers (2)

Emrah
Emrah

Reputation: 27

If your password contains specific characters like @ or ! probably you are getting the error for this

Upvotes: 0

user11869600
user11869600

Reputation:

In SQL*Plus, just need to connect using the TNS alias.

connect user/password@tns_alias

Upvotes: 1

Related Questions