Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't Login to APEX

W.LionelMar 5 2019 — edited Mar 7 2019

Hello All:

I tried to refine my APEX login page and caused problems I have no idea how to resolve.

I logged into  INTERNAL as ADMIN.

Edited the Login Message ----> under Manage Instance -> Login message

and applied the changes. Logged out. Then on logging back in to the APEX application got the following error:

ERR-1002 Unable to find item ID for item "username" in application "4550".

Unexpected error, unable to find item name at application or page level.

With this error message popping up every time I try to login to undo the change,

I can't login at all.

Is there any way to log back in given the situation?
This post has been answered by Scott Wesley on Mar 5 2019
Jump to Answer

Comments

DK2010

Hi,

It means  some session accessing that table. you can Query from v$access

Find that sid and kill that sid  and drop the table

HTH

unknown-698157
Answer

For sure there are locks, as the table is in use.

Drop table wants an exclusive lock on the corresponding dictionary record(s).

Whenever the table is in use there will be a row-share lock on that record in the dictionary.

Did you consult gv$access ?

Please do so now.

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

Sybrand Bakker

Senior Oracle DBA

Marked as Answer by User_KWXZ9 · Sep 27 2020
1 person found this helpful
Niket Kumar

http://abeytom.blogspot.in/2012/08/finding-and-fixing-ora-00054-resource.html

User_KWXZ9

Sybrand ,

Thanks alot for your help . gv$access resolved the issue .

Regards

DBApps

1 - 4

Post Details

Added on Mar 5 2019
#apex-discussions
11 comments
3,834 views