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

Products

• CA eHealth

Issue/Introduction

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/[email protected]$NH_DB_CONNECT_STRING
or 
sqlplus $NH_USER/[email protected]$NH_DB_CONNECT_STRING
Enter user-name: [email protected]$NH_DB_CONNECT_STRING
Enter password  : *********

Environment

Release:
Component: EHCMD