Skip to Main Content

Deutsche

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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,098 views