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.
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.
Windows/Unix, eHealth 6.3.x
1- Logon as eHealth install user
2- open a command prompt
3- Run command:
1- Logon as eHealth owner user on a Unix terminal
2- Run command:
sqlplus $NH_USER/[email protected]$NH_DB_CONNECT_STRING
Apply to all eHealth 6.3.x versions.
TEC000003300 How To Get Oracle Version and Edition Information