Skip to Main Content

Deutsche

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.

ORA-04021: timeout occurred while waiting to lock object - grant select on sys.gv_$instance to APEX

user2858440Apr 19 2019

Hi,

I'm installing APEX. The script wants to grant select to gv_$ views and gets timeout.

Any solution?

Thank you.

Ludvik

$ sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Fri Apr 19 12:01:50 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> CONNECT SYS as SYSDBA

Enter password:

Connected.

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

...set_appun.sql

PL/SQL procedure successfully completed.

...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

Session altered.

FOO3

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

install2019-04-19_12-02-21.log

. ORACLE

.

. Application Express (APEX) Installation.

..........................................

.

...set_appun.sql

... Checking prerequisites (MANUAL)

.

. SYSDBA Privilege

.   pass - Connection with SYSDBA privilege.

. Database rolling upgrade

.   pass - No rolling upgrade.

. DB components

.   pass - CATPROC: version=12.1.0.1.0

.   pass - XDB: version=12.1.0.1.0

. XDB

.   pass - is valid

. PL/SQL Web Toolkit

.   pass - version 10.1.2.0.9

. Tablespaces

.   pass - found SYSAUX

.   pass - found SYSAUX

.   pass - found TEMP

. PHASES (1,2,3)...

PL/SQL procedure successfully completed.

.

... Prerequisite checks passed.

.

...set_ufrom_and_upgrade.sql

...gen_adm_pwd.sql

Phase 1 (Installation)

...setting session environment

Proceeding with new installation.

...Creating APEX_180200

Installing SYS views

...sys_core_views.sql

core_grants.sql

...grant APEX owner core privileges

grant select  on sys.gv_$instance                   to APEX_180200

                     *

ERROR at line 1:

ORA-04021: timeout occurred while waiting to lock object

Comments

Post Details

Added on Apr 19 2019
2 comments
1,405 views