ORA-01019 Error Starting OFSA RQ on Oracle 10g [ID 357464.1] |
When starting the OFSA Request Queue (RQ) using the "rq" or "mrq" scripts in the $OFSA_HOME/bin directory on Oracle 10g, 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, 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 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 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
Niciun comentariu:
Trimiteți un comentariu