My Oracle Support Banner

PEA 8.5.1 Issue:'AACG CA Server Unreachable' Install Error: SQL Error while connecting with oci8 driver to default database: ORA-12547: TNS:lost contact (Doc ID 1198483.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.5.1 to 8.5.1 [Release 8.0]
Information in this document applies to any platform.
***Checked for relevance on 25-MAR-2014***


=== ODM Issue Clarification ===

On :  Application Access Controls Governor (AACG) version

AACG is used to report segregation of duties(SOD) in the business applications. When using Prevention functionality of AACG in the business application E-Business Suite(EBS), the user is given a responsibility, the responsibility is automatically end dated due to the Prevention Functionality enabled and then the end date is removed to run Conflict Analysis(CA) program to see pending policy violations. All other functionality is working as expected,  however, when trying to submit the CA program the following error occurs:

Application Error:
'AACG CA Server Unreachable'

Install Error:

Getting below error while running loadjava/dropjava commands for loading/dropping file:

usmtnnpderpdb17:/dianat2ap/adianat2/aacg_patch/9647454/db> loadjava -user apps/apps -verbose -resolve -force

arguments: '-user' 'apps/apps' '-verbose' '-resolve' '-force' ''

creating : resource

loading  : resource oracle: fatal: /dianat2db/db/10.2.0/lib32/ wrong ELF class: ELFCLASS32

SQL Error while connecting with oci8 driver to default database: ORA-12547: TNS:lost contact

exiting  : could not open connection


Expect behavior is to be able to submit the CA program successfully and remove the end dates on the responsibility assignments.

The issue can be reproduced at will with the following steps:
1. Log into AACG.
2. Create policies or import policies .
3. Go to EBS instance and add responsibilities you created in the policies to a user.
3.  The application puts an end date automatically for the responsibility.
4, Click on Actions and navigate to screen where you can remove end date and click on Initiate Conflict Analysis.
5, This shows a prompt error 'AACG CA Server Unreachable'.

The issue has the following business impact:
Due to this issue, users cannot cannot run the CA program remove end dates from responsibilities assigned to users and it is causing significant issues and causing delay in their Go Live date.  Other functionality of the product are working as expected.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.