ORA-01019

ORA-01019 Error Starting OFSA RQ on Oracle 10g/11g [ID 357464.1]

Applies to:

Oracle Financial Data Manager - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5

Description

When starting the OFSA Request Queue (RQ) using the "rq" or "mrq" scripts in the $OFSA_HOME/bin directory on Oracle 10g or Oracle 11g, the following error may occur:
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function:   [0] - olon(), orlon()
Oracle Error:   [1019] - ORA-01019: unable to allocate memory in the user side
Driver Function:         drv_oci::Connect()
MB(AttachDB()) Error attaching to database: <database name>

Likelihood of Occurrence

If you are running OFSA with Oracle 10g or 11g, you may encounter the ORA-01019 error starting RQ.

Possible Symptoms

The following error occurs when starting rq:
ORA-01019: unable to allocate memory in the user side

Workaround or Resolution

For all but Linux, apply one of the operating system patches listed in the Patch section below.
For Linux, following the workaround below first described in Bug:4959183 "ORA-1019 Starting RQ on AIX or HP in Oracle 10g":
1. Copy the NLS files from an Oracle 9i instance into a directory on the Oracle 10g/11g instance
The Oracle 9i NLS files are located in the following directory:
/<ORACLE 9i HOME>/ocommon/nls/admin/data
Important: Do not replace / overwrite the 10g NLS files.  Simply add the 9i files to a separate directory.
2. Edit the ORA_NLS33 entry in the "rq" or "mrq" script to point to the 9i NLS files
The rq and mrq scripts are located in: $OFSA_HOME/bin
Edit the following section to point to the 9i NLS files:
if [ -f /<OFSA Home>/ocommon/nls/admin/data/lx00001.nlb ]; then
      #  on some platforms NLS files not included yet 11/14/00
     ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
fi
(where $ORACLE_HOME is the Oracle 10g/11g home directory that contains the Oracle 9i library files )

Note:  If the error continues to occur after making the change listed above, remove the "if/then" statement and use a direct assignment of the ORA_NLS33 environment variable. For example:

Replace this:

if [ -f /<OFSA Home>/ocommon/nls/admin/data/lx00001.nlb ]; then
     # on some platforms NLS files not included yet 11/14/00
     ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
fi

With this:

ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33

Patches

Patches are available for IBM AIX, HP-UX, and Solaris:
AIX: Patch:4599183 - 1OFF: ORA-01019 STARTING RQ WITH ORACLE 10G
(Select a platform of AIX Based Systems (32-bit))
HP: Patch:6147921 - ORA-01019 STARTING RQ IN ORACLE 10G ON HP-UX
(Select a platform of HP-UX PA-RISC (32-bit))
Solaris: Patch:6966074 - ORA-01019 STARTING RQ IN ORACLE 10G ON SOLARIS
(Select a platform of Sun Solaris SPARC (32-bit))
Monitor the following bug for updates on Linux:
Bug:7384670 - ERROR WHILE LOADING SHARED LIBRARIES: LIBCLNTSH.SO.9.0 STARTING RQ ON LINUX 10.2

Modification History

09-FEB-2006 - Article created
02-MAR-2007 - Added reference to AIX One Off patch
23-JUN-2008 - Added warning not to replace 10g files
28-SEP-2008 - Implemented remark - added Linux info
14-JAN-2009 - Added patches for HP and Solaris
02-AUG-2010 - Checked for relevance.