11 Replies Latest reply on Aug 26, 2010 7:29 AM by 609456

    ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_

    609456
      Hi All,

      We are following Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle Database 10g Release 2

      note: 362205.1

      Source OS = AIX
      Target OS = RHEL 5
      DB version = 10.2.0.4

      At Section 5: Update the imported Applications Release 11i database instance
      Perform post-import steps outlined in the Interoperability documents

      At post-import step: Implement and run AutoConfig

      Completed the below tasks:
      Copied the appsutil.zip file to to new OS ORacle home
      Generated the Database Context File

      While Running adconfig get the error


      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : ORADB
      sDbDomain : quest-global.com
      sDbPort : 1521
      sDbSid : TST
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@ORADB.quest-global.com:1521:TST
      Connection obtained

      -------------------ADX Database Utility Finished---------------

      Result : Failed to upload the Context file to the DataBase
      ----------------------------------------------------------------

           Uploading Context file and its templates to the database...FAILED


      StackTrace:
      java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: SQLException : ORA-04063: package body "APPS.FND_GSM_UTIL" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_UTIL"
      ORA-06512: at line 1

           at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:685)
           at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
           at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1579)
           at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:661)

      Updating rdbms version in Context file to db102
      Updating rdbms type in Context file to 64 bits


      Kindly suggest

      Regards,
      SK
        • 1. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
          Hussein Sawwan-Oracle
          Hi,
          StackTrace:
          java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: SQLException : ORA-04063: package body "APPS.FND_GSM_UTIL" has errors
          ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_UTIL"
          Please verify if this packages exists or not. If the package is available, please verify the status (make sure it is VALID). If the package status is INVALID, compile it manually and check then.

          Thanks,
          Hussein
          • 2. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
            609456
            HI,


            SQL> select object_name, owner, status, object_type, timestamp from dba_objects where object_name='FND_GSM_UTIL';

            OBJECT_NAME
            --------------------------------------------------------------------------------
            OWNER STATUS OBJECT_TYPE TIMESTAMP
            ------------------------------ ------- ------------------- -------------------
            FND_GSM_UTIL
            APPS VALID PACKAGE 2010-08-11:09:01:29

            FND_GSM_UTIL
            APPS INVALID PACKAGE BODY 2010-06-02:10:30:44


            the object FND_GSM_UTIL is INVALID, tried to compile it

            SQL> alter package APPS.FND_GSM_UTIL compile body;

            Warning: Package Body altered with compilation errors.



            Regards,
            SK
            • 3. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
              Hussein Sawwan-Oracle
              Hi,
              SQL> alter package APPS.FND_GSM_UTIL compile body;

              Warning: Package Body altered with compilation errors.
              Issue "show error" command directly after compiling the package and post the error message here.

              Thanks,
              Hussein
              • 4. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                609456
                HI,

                SQL> show error
                Errors for PACKAGE BODY APPS.FND_GSM_UTIL:

                LINE/COL ERROR
                -------- -----------------------------------------------------------------
                316/10 PL/SQL: Statement ignored
                316/10 PLS-00201: identifier 'DBMS_LOCK' must be declared
                318/5 PL/SQL: Statement ignored
                318/17 PLS-00201: identifier 'DBMS_LOCK' must be declared
                331/11 PL/SQL: Statement ignored
                331/23 PLS-00201: identifier 'DBMS_LOCK' must be declared
                350/8 PL/SQL: Statement ignored
                350/20 PLS-00201: identifier 'DBMS_LOCK' must be declared
                SQL>


                i am following doc 362205.1 , do you suggest performing the step 'Compile invalid objects ' before implementing Autoconfig on the Target OS Database?
                i have got around 10,000 invalid objects after importing the database

                Thanks
                SK
                • 5. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                  Hussein Sawwan-Oracle
                  Hi,
                  350/8 PL/SQL: Statement ignored
                  350/20 PLS-00201: identifier 'DBMS_LOCK' must be declared
                  i am following doc 362205.1 , do you suggest performing the step 'Compile invalid objects ' before implementing Autoconfig on the Target OS Database?
                  i have got around 10,000 invalid objects after importing the database
                  Yes, please do so then implement AutoConfig then.

                  Also, see the suggested solution in (Utlspadv.Sql Fails With 'Pls-00201: Identifier 'Dbms_lock' Must Be Declared' [ID 945355.1]).

                  Thanks,
                  Hussein
                  • 6. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                    609456
                    Hi HUssein,

                    i was able to compile the package and run autoconfig on target OS database.

                    Now if i start the apps service. how do i confirm that it is link to the new target OS database and not the old Source OS database?

                    Please suggest

                    Thanks
                    SK
                    • 7. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                      Hussein Sawwan-Oracle
                      Hi,
                      Now if i start the apps service. how do i confirm that it is link to the new target OS database and not the old Source OS database?

                      Please suggest
                      You can tell from the application context file or from FND_NODES table. Or, simply stop the database on the source node and see if the application is still functioning properly or not :)

                      Thanks,
                      Hussein
                      • 8. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                        609456
                        HI,

                        As per note 369693.1 - Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 2
                        Section 4: Post-Migration Tasks

                        Reconfigure the application tier to connect to the target database machine
                        i have updated the context file parameters s_dbhost, s_dbdomain, s_dbport, s_apps_jdbc_connect_descriptor, s_isDB

                        but will running autoconfig i get the error

                        Making database connection using DBUtil

                        ---------------------------------------------------------------
                        ADX Database Utility
                        ---------------------------------------------------------------

                        getConnectionUsingAppsJDBCConnector() -->
                        APPS_JDBC_URL='NULL'
                        Trying to connect using APPS_JDBC_URL
                        Exception occurred: java.sql.SQLException: No suitable driver
                        Trying to get connection using SID based connect descriptor
                        getConnection() -->
                        sDbHost : oradb
                        sDbDomain : quest-global.com
                        sDbPort : 1521
                        sDbSid : TST
                        sDbUser : APPS
                        Trying to connect using SID...
                        getConnectionUsingSID() -->
                        JDBC URL: jdbc:oracle:thin:@oradb.quest-global.com:1521:TST
                        Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                        Trying to connect using SID as ServiceName
                        getConnectionUsingServiceName() -->
                        JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb.quest-global.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TST)))
                        Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                        Trying to connect using SID as ServiceName.DomainName
                        getConnectionUsingServiceName() -->
                        JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb.quest-global.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TST.quest-global.com)))
                        Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                        Connection could not be obtained; returning null

                        -------------------ADX Database Utility Finished---------------

                        Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database


                        StackTrace:
                        java.sql.SQLException: Could not get connection to the database
                             at oracle.apps.ad.tools.configuration.CVMHelper.processNewContextFile(CVMHelper.java:884)
                             at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1714)
                             at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1516)
                             at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:661)


                        is there any check we can do to test the DB conection?

                        Thanks
                        SK
                        • 9. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                          Hussein Sawwan-Oracle
                          Hi,

                          Is the database listener up and running?

                          Do you have proper entry in the hosts file?

                          Thanks,
                          Hussein
                          • 10. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                            609456
                            HI,

                            Yes the new Target host DB , DB listener is up and running
                            host file entry


                            # Do not remove the following line, or various programs
                            # that require network functionality will fail.
                            127.0.0.1 localhost.localdomain localhost
                            192.168.5.106 oradb.quest-global.com oradb
                            [root@oradb etc]#

                            Source OS(AIX) have APPS tier host name test
                            Target OS(RHEL5) have DB tier host name oradb

                            i have edited the listener and tnsnames.ora file on the target OS to point to new ORacle DB home

                            Regards,
                            SK
                            • 11. Re: ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_
                              609456
                              HI Hussein,

                              i was able to run autoconfig on APPS tier .. ran adcfgclone to link the apps tier to the correct new database

                              Thanks for your great support

                              Regards,
                              Sk