My Oracle Support Banner

HDR Installation Error : Cannot connect to database using Sqlplus! (Doc ID 2398640.1)

Last updated on APRIL 01, 2019

Applies to:

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

Symptoms



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:




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.