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***

Symptoms


=== ODM Issue Clarification ===

On :  Application Access Controls Governor (AACG) version 8.5.1.272:

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:

ERROR
-----------
Application Error:
'AACG CA Server Unreachable'

Install Error:

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



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

arguments: '-user' 'apps/apps' '-verbose' '-resolve' '-force' 'pea.properties'

creating : resource pea.properties

loading  : resource pea.properties

ld.so.1: oracle: fatal: /dianat2db/db/10.2.0/lib32/libskgxp10.so: wrong ELF class: ELFCLASS32

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

exiting  : could not open connection

usmtnnpderpdb17:/dianat2ap/adianat2/aacg_patch/9647454/db>



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


STEPS
-----------------------
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'.

BUSINESS IMPACT
-----------------------
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.

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