This discussion is archived
8 Replies Latest reply: Jan 25, 2013 6:47 AM by 903079 RSS

Multi-tenant enbling issue

903079 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    **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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points