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