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
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 22.214.171.1242:
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:
'AACG CA Server Unreachable'
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms