My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.