ORA-12560: TNS: protocol adapter error

1
votes

I have installed oracle client winx64_12102_client and configured tnsnames.ora . when I try to login with connect with sqlplus /nolog and then connect enter username and password. It gives me error 

ORA-12560: TNS: protocol adapter error.

I have been through many forums and have set ORACLE_HOME, PATH and TNS_ADMIN, but I am still getting the error.

In the Oracle net configuration assistant when i test if I am able to connect to database. the test succeeds, but in sqlplus I get this error

1
oracle
does tnsping work? - OldProgrammer
yes it works .. - P S
I am new to Oracle. Please give me the steps how to fix this error to be able to run SQL+ - P S
Please post: 1) tnsping command as executed, and results. 2) sqlplus command as executed and complete results. - OldProgrammer
C:\Users\User1.INTERNAL>tnsping orcl TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-JUL-2 017 13:21:46 Copyright (c) 1997, 2014, Oracle. All rights reserved. Used parameter files: C:\app\oracle\client\user1\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dev3)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl))) OK (20 msec) - P S

1 Answers

0
votes

For client I used username as username@servicename and password and then it worked.