SP2-0310 Error Encountered When Applying InterimFix 31764389 (Doc ID 2710984.1)

Last updated on JULY 13, 2023

Applies to:

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

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