ORA-12560 error when trying to login to database using sqlplus

Document ID : KB000019229
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The user Get the following error when he run the command sqlplus


SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 16 17:10:23 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Enter user-name: ehealth
Enter password: *********
ERROR:
ORA-12560: TNS:protocol adapter error
sqlplus
  SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 16 17:10:23 2013
  Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 ORA-12560: TNS:protocol adapter error 

Notice that TNSNAMES shows the correct SID etc

Solution:

Since we did the Oracle client/server split, on Windows you have to give the NH_DB_CONNECT_STRING when you sqlplus in.


sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING
or 
sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING
Enter user-name: $NH_USER@$NH_DB_CONNECT_STRING
Enter password  : *********