averify.sh TNS Error Connecting to a Plugable Database on 12cR2 (Doc ID 2274627.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.6.0 version, Averify issues

Averify.sh TNS error connecting to a PDB

ERROR
-----------------------
BUILD FAILED
/prj/dba/apps/agile/agile936/averify/config/averify.xml:65: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Ran into an issue while running averify against 9.3.6 agile schema in a PDB.
PBD can only be connected to through service name.
But it looks like averify is still trying to use SID.

Details of the averify.properties config file.

averify.dest.jdbc.url = jdbc:oracle:thin:@xxxxxxxx-scan:1522:AGLPLMDEV
averify.dest.jdbc.driver = oracle.jdbc.driver.OracleDriver
averify.dest.tns.name = AGLPLMDEVPDB
averify.dest.oracle.home = /ora/app/oracle/product/12.2.0.1

AGLPLMDEV:dbagldev:oracle$ vi Averify.log
...
  [exec] TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 05-APR-2017 14:05:45
...
  [exec] Copyright (c) 1997, 2016, Oracle. All rights reserved.
...
  [exec] Used parameter files:
  [exec] /u01/app/oracle/product/12.2.0.1/network/admin/sqlnet.ora
...
  [exec] Used TNSNAMES adapter to resolve the alias
  [exec] Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx-scan)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = AGLPLMDEVPDB)))
  [exec] OK (0 msec)

check-tns-failed:
[AverifyAll] File Deleted
[AverifyAll] File ../scripts/run.sql created
[AverifyAll] Listener refused the connection with the following error:
[AverifyAll] ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
....
BUILD FAILED
/u01/app/oracle/agile/averify/config/averify.xml:65: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

From looking at the listener logs, the constructed string appears to be using the SID instead of the TNS service name?

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Cannot run averify.sh

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