SP2-0310 Error Encountered When Applying InterimFix 31764389
(Doc ID 2710984.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.5.2 and laterInformation in this document applies to any platform.
Symptoms
On Oracle Life Sciences Data Management Workbench (DMW) 2.5.2, while applying Interim Fix for bug 31764389, the following error is encountered:
The problem can be reproduced by executing the following steps:
1. Use a computer with an Oracle Client that can be connected to the DMW Database server using SQLPLUS.
2. Create a folder where to store the InterimFix_31764389.zip file:
mkdir /tmp/InterimFix_31764389
3. Copy InterimFix_31764389.zip archive file to /tmp/InterimFix_31764389 folder.
4. In this folder, extract the files contained in the InterimFix_31764389.zip archive, by executing the command:
unzip InterimFix_31764389.zip
5. Check the files available in the working directory by executing the command:
ls -ltr
The following files should be displayed:
- cdrexinscntrlrb.pls
- InterimFix_31764389.sql
- InterimFix_31764389_readme.txt
6. Change the working directory.
7. Log into the SQLPLUS with the command sqlplus /nolog.
sqlplus /nolog
8. Connect as APPS by executing the command:
connect apps/<apps_password>@<tnsnames or connect string>
9. Execute the InterimFix_31764389.sql using the full path to this file:
@/tmp/InterimFix_31764389/InterimFix_31764389.sql
The script will print the current version of the package files, cdrexinscntrlrb.pls and ask for confirmation before proceeding:
********************** START Bug 31764389 - InterimFix : Slowness across System post 2.5.2 (from 2.4.8.4) Upgrade ***********************************
FILENAME
--------------------------------------------------------------------------------------------------------------------------------------------
MAX(VERSION_SEGMENT1)||'.'||MAX(VERSION_SEGMENT2)
---------------------------------------------------------------------------------
cdrexinscntrlrb.pls
120.116
VERIFY THE cdrexinscntrlrb.pls version=120.116
if correct press [Enter] else [Ctrl + C]
10. Press "Enter" key.
The following error is displayed:
VERIFY THE cdrexinscntrlrb.pls version=120.116
if correct press [Enter] else [Ctrl + C]
************ RECOMPILING cdrexinscntrlrb.pls v 120.116 **********************
SP2-0310: unable to open file "cdrexinscntrlrb.pls"
******************* cdrexinscntrlrb.pls v 120.116 RECOMPILED ***************
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |