8 Replies Latest reply: Jan 25, 2013 8:47 AM by 903079 RSS

    Multi-tenant enbling issue

    903079
      Hi All,

      In the process of enabling multi-tenant,one child process of concurrent request (Setup Multi Tenancy for Database Objects) getting error out. Child request is -Setup Multi Tenancy for Database Objects Child process.

      Log file showing below error :

      Human Resources: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      HRMTOLSSLV module: Setup Multi Tenancy for Database Objects Child process
      ---------------------------------------------------------------------------

      Current system time is 24-JAN-2013 19:00:50

      ---------------------------------------------------------------------------

      **Starts**24-JAN-2013 19:00:50
      ORACLE error 4021 in FDPSTP

      Cause: FDPSTP failed due to ORA-04021: timeout occurred while waiting to lock object
      ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_MULTI_TENANT_INSTALL"
      ORA-06512: at line 1
      .

      The SQL statement being
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Exceptions posted by this request:
      Concurrent Request for "Setup Multi Tenancy for Database Objects Child process" has completed with error.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 24-JAN-2013 19:30:51

      ---------------------------------------------------------------------------



      EBS Version : 12.1.1 with 11.1.0.7 DB
      OS : RHEL 5.3 x86-64
      Reference Doc : Oracle HRMS Multi-Tenant Functionality - An Oracle White Paper [ID 760500.1]

      Anyone can please help ?

      Thanks in advance,

      Regards,
        • 1. Re: Multi-tenant enbling issue
          Hussein Sawwan-Oracle
          **Starts**24-JAN-2013 19:00:50
          ORACLE error 4021 in FDPSTP

          Cause: FDPSTP failed due to ORA-04021: timeout occurred while waiting to lock object
          ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_MULTI_TENANT_INSTALL"
          ORA-06512: at line 1
          The error indicates that you have locks in the database.

          OERR: ORA 4021 time-out occurred while waiting to lock object <name> [ID 19833.1]
          How to Analyze ORA-04021 and ORA-4020 Errors [ID 1486712.1]

          Thanks,
          Hussein
          • 2. Re: Multi-tenant enbling issue
            903079
            Hi Hussein,

            Thanks for reply,

            I tried the same concurrent request again,its completed successfully and All child processes getting normal completion status.
            My query is, this is the process of enabling mullti-tenancy,so can i conclude enabling multitenancy process is in sucesses way.

            Regards,
            • 3. Re: Multi-tenant enbling issue
              Hussein Sawwan-Oracle
              I tried the same concurrent request again,its completed successfully and All child processes getting normal completion status.
              Because there were no locks at this time.
              My query is, this is the process of enabling mullti-tenancy,so can i conclude enabling multitenancy process is in sucesses way.
              Yes -- Assuming that is the only step you need to follow/implement.

              Thanks,
              Hussein
              • 4. Re: Multi-tenant enbling issue
                903079
                Hi Hussein,

                Thanks for your prompt responce and advising me.
                and one more is in the reference document,they mentioned script $PER_TOP/patch/115/sql/ peupdlbl.sql need to run as post requisite.
                But in that location script is not there, is it comes with any patch ?

                Any idea,really appreciate

                Regards,
                • 5. Re: Multi-tenant enbling issue
                  Hussein Sawwan-Oracle
                  900076 wrote:
                  Hi Hussein,

                  Thanks for your prompt responce and advising me.
                  and one more is in the reference document,they mentioned script $PER_TOP/patch/115/sql/ peupdlbl.sql need to run as post requisite.
                  Correct -- Oracle HRMS Multi-Tenant Functionality - An Oracle White Paper [ID 760500.1]
                  But in that location script is not there, is it comes with any patch ?

                  Any idea,really appreciate
                  What is your application release?

                  Thanks,
                  Hussein
                  • 6. Re: Multi-tenant enbling issue
                    903079
                    Applicaton Release : 12.1.1 with 11.1.0.7 DB
                    OS : RHEL 5.3 x86_64

                    Thanks,
                    • 7. Re: Multi-tenant enbling issue
                      Hussein Sawwan-Oracle
                      900076 wrote:
                      Applicaton Release : 12.1.1 with 11.1.0.7 DB
                      OS : RHEL 5.3 x86_64

                      Thanks,
                      Please see (Bug 9955377 : NEED $PER_TOP/PATCH/115/SQL/PEUPDLBL.SQL FILE FOR 12.1.1) -- As per the bug, this script appears to only be available on 12.1.2 (and above). So, please log a SR and ask Oracle support for a patch that would deliver this script and can be applied on top of 12.1.1

                      Thanks,
                      Hussein
                      • 8. Re: Multi-tenant enbling issue
                        903079
                        Hi Hussein,

                        Thanks for reply,

                        1) In our environment,we have two instances one is with fresh database other is with Vision database.

                        yesterday we enabled OLS and multi-tenancy on instance with fresh database.
                        But today we trying to enable multi-tenancy on instance with vision database,we are facing one issue is below.

                        When we running below script facing below error : (As per reference DOC.)

                        BEGIN
                        sa_sysdba.create_policy('HR_ENTERPRISE_POLICY','HR_ENTERPRISE','READ
                        CONTROL,LABELDEFAULT,HIDE')
                        END

                        Error :

                        BEGIN
                        *
                        ERROR at line 1:
                        ORA-12414: internal LBAC error: Uninitialized session context, please connect
                        again
                        Error:
                        ORA-06512: at "LBACSYS.LBAC_SYSDBA", line 111
                        ORA-06512: at "LBACSYS.SA_SYSDBA", line 44
                        ORA-06512: at line 2


                        Is there any limitation for enabling multi-tenancy on vision instance ? why because of on fresh instance we were not faced any issue.
                        Application Release : 12.1.1 & 11.1.10.7 DB on RHEL 5.3 x86_64

                        Can you please suggest us ?

                        Thanks in advance,

                        Regards,