This content has been marked as final. Show 8 replies
**Starts**24-JAN-2013 19:00:50The error indicates that you have locks in the database.
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
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]
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.
900076 wrote:Correct -- Oracle HRMS Multi-Tenant Functionality - An Oracle White Paper [ID 760500.1]
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 ?What is your application release?
Any idea,really appreciate
900076 wrote: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
Applicaton Release : 12.1.1 with 126.96.36.199 DB
OS : RHEL 5.3 x86_64
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.)
ERROR at line 1:
ORA-12414: internal LBAC error: Uninitialized session context, please connect
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 & 188.8.131.52 DB on RHEL 5.3 x86_64
Can you please suggest us ?
Thanks in advance,