| Issue | When attempting to create an Aveksa System Report (ASR), it fails to generate. An examination of the Aveksa server log file shows an ORA-04030 error, as does the Oracle database alert log.
Aveksa server log
To access the Aveksa server log file,
- Login to the UI as the administrator.
- Navigate to Admin > System > Server Nodes (tab) > Logs (column)
- The per Node Name row has links to the migrate.log, reporting-user-synonyms.log, aveksaServer.log, aveksaServerInfo.log and WorkPoint.log file.
From the aveksaServer.log
...
01/12/2017 16:17:21.735 ERROR (GuiSystemReportObjectStore) [com.aveksa.server.db.persistence.PersistenceServiceProvider] Executing Procedure:
java.sql.SQLException: ORA-00603: ORACLE server session terminated by fatal error
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 108
Additional information: 1835008
ORA-04030: out of process memory when trying to allocate 1032 bytes (qmxlu subheap,qmemNextBuf:alloc)
...
FAILED method=runStoredProcedure System_Report.Run, [ProcedureParameter[direction = IN name = null value = <SECTION REFERENCE='101'>
...
Oracle database alert log
To examine the Oracle database alert log,
- Login as the owner of the Oracle home.
- Issue the following command to find the log:
find . -name alert_AVDB.log -print
From the alert_AVDB.log
Thu Dec 08 13:15:21 2016
Errors in file /u01/app/oracle/diag/rdbms/avdb/AVDB/trace/AVDB_ora_7081.trc (incident=180976):
ORA-04030: out of process memory when trying to allocate 1032 bytes (qmxlu subheap,qmemNextBuf:alloc)
Incident details in: /u01/app/oracle/diag/rdbms/avdb/AVDB/incident/incdir_180976/AVDB_ora_7081_i180976.trc
|
| Resolution | For customers using the RSA-supplied Oracle database software
The Oracle database Patch 19678658 is included in the Appliance Update, starting with the December 2017 version. Please check for the latest RSA Identity Governance and Lifecycle Updater, for your platform.
For customers using their own Oracle database software
Download and apply Oracle database Patch 19678658 from the Oracle Support portal, for your specific Operating System and version of Oracle database software.
Checking if Oracle database patch 19678658 has been applied
To check if the patch has been applied, perform the following steps.
- Login as the owner of the Oracle home.
- Navigate to $ORACLE_HOME/Opatch
- Run the following command:
opatch lsinventory
In a typical RSA Identity Governance and Lifecycle installation, the results would look similar to the following:
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 19678658 : applied on Mon Mar 20 22:13:50 EDT 2017
Unique Patch ID: 19261499
Created on 20 Aug 2015, 14:51:46 hrs PST8PDT
Bugs fixed:
19678658
Patch 19509982 : applied on Mon Oct 03 12:49:01 EDT 2016
Unique Patch ID: 18265206
Created on 11 Feb 2015, 14:07:42 hrs PST8PDT
Bugs fixed:
19509982
--------------------------------------------------------------------------------
|
on Mar 29, 2017