HDR Installation Error : Cannot connect to database using Sqlplus!

(Doc ID 2398640.1)

Last updated on MAY 28, 2018

Applies to:

Oracle Healthcare Data Repository - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 7.0.1 version, Installation Issues

When attempting to install HDR 7.0.1
the following error occurs.

ERROR
-----------------------
Error message: "Cannot connect to database using Sqlplus! Please check database details, make sure SqlPlus is available and try again."

The logfile shows the following:

[oracle@T115PLOHTB01 u04 06:30 PM]$ cat /DB_BACKUP/hdrinstaller/Disk1/stage/ext/scripts/checkSqlplus.sh
#!/bin/sh

echo -n "Password:"
read -s password

sqlplus /nolog <whenever sqlerror exit sql.sqlcode;
connect $1/$password@localhost/$2 as sysdba
HD[oracle@T115PLOHTB01 u04 06:31 PM]$


[oracle@T115PLOHTB01 logs 10:23 AM]$ sqlplus sys/Password@localhost/ETS_DATA as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Apr 16 10:23:19 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Install HDR 7.0.1

BUSINESS IMPACT
-----------------------
N/A

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms