oracle-databasedatabase-connectionconnection-stringsqlplustnsping

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/pass@dw-prod.server.int:1527/pdw1s_servicename

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

Solution

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

    connect user/password@tns_alias