"Error 1 while running Oracle connectonly.sql" (ORA-12560) using CA Gen 8.6 Windows/Oracle 19c CSE Configuration

book

Article ID: 214298

calendar_today

Updated On:

Products

CA Gen

Issue/Introduction

CA Gen Complete (WKS86200/SO09618) with "ORACLE 19C CERTIFICATION FOR CSE" PTF installed (CSN86204/SS14886)
Running the CSE Configuration program (cse_config.exe) and the Encyclopedia Database Connection fails with "Error 1 while running Oracle connectonly.sql":



The corresponding log file C:\ProgramData\CA\Gen 8.6\logs\CSE\connectonly.log shows:
+++
Run CSE Oracle command file Connect.sql on database dbcse1 for user ency 

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 5 02:42:29 2021
Version 19.3.0.0.0

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

ERROR:
ORA-12560: TNS:protocol adapter error
+++

Oracle 19c 64-bit database and Oracle 19c 32-bit client are installed per CA Gen 8.6 >Technical Requirements > Development Platform Environments - see "CSE & Host Encyclopedia"
In the Windows PATH, the 32-bit client bin directory is also ahead of the 64-bit database bin directory.

Environment

Release: CA Gen 8.6 (Complete)

Component: CA Gen Client Server Encyclopedia

Resolution

The 32-bit client connection to the 64-bit database must be done via the Oracle net service name connecting to the TNS Listener for the target database.

1. Ensure the 32-bit client installation file ...\network\admin\tnsnames.ora has an Oracle net service name (alias) defined for the target database
e.g. in this example, DBCSE1 is the net service name for target database dbcse1 (alias):
DBCSE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dbcse1)
    )
  )

2. Then to resolve the connection error, use that alias in the User ID field with syntax [email protected]alias e.g. for the above alias DBCSE1 use [email protected] (NOTE: the alias is case-independent)



The corresponding log file C:\ProgramData\CA\Gen 8.6\logs\CSE\connectonly.log will then show:
+++
Run CSE Oracle command file Connect.sql on database dbcse1 for user [email protected] 

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 5 03:41:06 2021
Version 19.3.0.0.0

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

Connected.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
+++

Additional Information

CA Gen Windows Oracle CSE Configuration with a 64-bit Oracle Database

CA Gen 8.6 Windows CSE Oracle 19c support with PTF CSN86204 (SS14886)

CA Gen 8.6 Solutions & Patches

Attachments