How to connect to eHealth Oracle database using SQLplus command

Products

• CA eHealth

Issue/Introduction

Summary: 

Customer wants to run oracle statements on a Oracle SQL prompt but when try to logon receives Logon denied messages that prevent access to SQLPlus prompt.

Background:  

To get connected to SQLPlus prompt is required to know the correct connection string and respective credentials.

eHealth set these values at NH_DB_CONNECT_STRING and NH_USER environment variables of the eHealth installation/owner user.

Environment:  

Windows/Unix,  eHealth 6.3.x

Instructions: 

WINDOWS:

1- Logon as eHealth install user

2- open a command prompt

3- Run command:

    sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%

 

UNIX:

1- Logon as eHealth owner user on a Unix terminal

2- Run command:

    sqlplus $NH_USER/[email protected]$NH_DB_CONNECT_STRING

Additional Information:

Apply to all eHealth 6.3.x versions.

TEC000003300 How To Get Oracle Version and Edition Information

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: