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.

when I am going to install apex 21.1 facing this problem, how I can install apex 21.1?

User_8MFICSep 2 2021

C:\oracle\apex>sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 2 23:48:07 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: sys/as sysdba
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> @sqlins apex apex TEMP /i/
SP2-0310: unable to open file "sqlins.sql"
SQL> @apexins apex apex TEMP /i/
...set_appun.sql

PL/SQL procedure successfully comple
...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

Performing installation in multitenant container database in the background.
The installation progress is spooled into apexins_cdb*.log files.

Please wait...

catcon::set_log_file_base_path: ALL catcon-related output will be written to [C:\oracle\apex\apexins_cdb_catcon_1964.lst]
catcon::set_log_file_base_path: catcon: See [C:\oracle\apex\apexins_cdb*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [C:\oracle\apex\apexins_cdb_*.lst] files for spool files, if any
Use of uninitialized value $ENV{"ORACLE_HOME"} in concatenation (.) or string at C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm line 13835.
Diagnostic output produced in conjunction with reporting an error message:
{
2021-09-02 23:54:43 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12372 catcon::catconInit2 - will retain last 1000 log messages by default
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9639 catcon::get_log_file_base_path - no log file directory was specified - using current directory (C:/oracle/apex)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9639 catcon::get_log_file_base_path -
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9644 catcon::get_log_file_base_path - log file base = apexins_cdb
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11724 catcon::set_log_file_base_path - ALL catcon-related output will be written to [C:\oracle\apex\apexins_cdb_catcon_1964.lst]
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11731 catcon::set_log_file_base_path - catcon: See [C:\oracle\apex\apexins_cdb*.log] files for output generated by scripts
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11733 catcon::set_log_file_base_path - catcon: See [C:\oracle\apex\apexins_cdb_*.lst] files for spool files, if any
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path -
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path - !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path -
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path - catcon version: /st_rdbms_19/10
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path - catconInit2: start logging catcon output at 2021-09-02 23:54:44
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path -
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path - !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path -
2021-09-02 23:54:44 INFO> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:11739 catcon::set_log_file_base_path -

2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12413 catcon::catconInit2 - based on the value passed to catconInit2 by the caller, failure to open a PDB
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12413 catcon::catconInit2 - in requested mode will result in PDB being skipped
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12413 catcon::catconInit2 -

2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12443 catcon::catconInit2 - names of specified PDBs and whether they are open WILL be validated
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12443 catcon::catconInit2 - (default behavior)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12443 catcon::catconInit2 -
2021-09-02 23:54:44 VERBOSE> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12457 catcon::catconInit2 - start initializing catcon
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12459 catcon::catconInit2 - base for log and spool file names = C:\oracle\apex\apexins_cdb
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12472 catcon::catconInit2 - running catconInit2(
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - DebugOn = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - EchoOn = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - ErrorLogging = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - ExclCon = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - ExtParallelism = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - GUI = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - InclCon = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12475 catcon::catconInit2 - InternalUser = undefined
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - LogBase = apexins_cdb
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - LogDir = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - NoErrorLoggingIdent = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - NumProcs = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - NumScriptsAndStmts = 1
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12484 catcon::catconInit2 - PerProcEndStmts = <empty array>
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12484 catcon::catconInit2 - PerProcInitStmts = <empty array>
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - RegularArgTag_ref = SCALAR(0x22eddb44f40)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - ScriptDir = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12475 catcon::catconInit2 - ScriptUser = undefined
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - SecretArgTag_ref = SCALAR(0x22eddb45000)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - SeedMode = 99
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - SkipPdbValidation = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - SpoolOn = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - SqlplusDir = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - Upgrade = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12497 catcon::catconInit2 - UserScripts = 0
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12502 catcon::catconInit2 - ) (2021-09-02 23:54:44)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12594 catcon::catconInit2 - running on MSWin32; DoneCmd =
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12594 catcon::catconInit2 - host sqlplus/nolog -v >
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12607 catcon::catconInit2 - LOCAL was not set, so there is not need to unset it
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12616 catcon::catconInit2 - TWO_TASK was not set, so there is no need to unset it
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12752 catcon::catconInit2 - no EZConnect strings supplied - using default instance
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12790 catcon::catconInit2 - User Connect String = / AS sysdba
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12794 catcon::catconInit2 - User password not specified
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12847 catcon::catconInit2 - setting Internal Connect String to User Connect String
2021-09-02 23:54:44 VERBOSE> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12850 catcon::catconInit2 - finished constructing connect strings
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12860 catcon::catconInit2 - no source file directory was specified
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12868 catcon::catconInit2 - locate directory in $PATH that contains sqlplus binary
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12882 catcon::catconInit2 - will use C:\oracle\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE binary
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12901 catcon::catconInit2 - PDB$SEED will be open in READ WRITE mode
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12906 catcon::catconInit2 - All other PDBs will be open in MOUNTED mode
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12915 catcon::catconInit2 - Names of "done" files will start with C:\oracle\apex\apexins_cdb_catcon_1964
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:12983 catcon::catconInit2 - considering EZConnect string
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - running build_connect_string(
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - connStrTemplate = / AS sysdba,
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - EZConnect = )
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string -
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string - return caller-supplied string (/ AS sysdba)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string - as the connect string
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string -
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13008 catcon::catconInit2 - call get_instance_status_and_name
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1050 catcon::exec_DB_script - C:\oracle\apex\apexins_cdb_catcon_1964_exec_DB_script.done did not need to be deleted before running a script
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1078 catcon::exec_DB_script - Created and opened a temporary script file (C:\oracle\apex\apexins_cdb_catcon_1964_exec_DB_script.sql)
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1078 catcon::exec_DB_script -
which will contain statements supplied by the caller
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set newpage 1
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set pagesize 14
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added connect / AS sysdba
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set echo off
2021-09-02 23:54:44 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set heading off
C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10729 catcon::get_affected_containers - supplied; default Container list was validated

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10744 catcon::get_affected_containers - The following Containers will be processed {

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10746 catcon::get_affected_containers - CDB$ROOT

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10746 catcon::get_affected_containers - PDB$SEED

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10746 catcon::get_affected_containers - PDB1

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10749 catcon::get_affected_containers - }

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13411 catcon::catconInit2 - instance orcl1 represented by the only EZConnect
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13411 catcon::catconInit2 - string has all desired Containers open on it
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13411 catcon::catconInit2 -

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13433 catcon::catconInit2 - on instance orcl1, Container names and open indicators are {

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13436 catcon::catconInit2 -
CDB$ROOT -- Y

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13436 catcon::catconInit2 -
PDB$SEED -- Y

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13436 catcon::catconInit2 -
PDB1 -- Y

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13440 catcon::catconInit2 - }

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13446 catcon::catconInit2 - all desired Containers are open on the default instance
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13446 catcon::catconInit2 - (orcl1) - skip the remainder of EZConnect string processing
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13446 catcon::catconInit2 -

2021-09-02 23:54:54 VERBOSE> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13628 catcon::catconInit2 - finished examining instances which can be used to run scripts/SQL statements.

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - running build_connect_string(
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - connStrTemplate = / AS sysdba,
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string - EZConnect = )
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2157 catcon::build_connect_string -

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string - return caller-supplied string (/ AS sysdba)
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string - as the connect string
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:2178 catcon::build_connect_string -

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13653 catcon::catconInit2 - finalized connect strings:
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13653 catcon::catconInit2 - Internal Connect String = / AS sysdba
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13653 catcon::catconInit2 - User Connect String = / AS sysdba
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13653 catcon::catconInit2 -

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:13730 catcon::catconInit2 - call gen_inst_conn_strings to obtain instance connect strings

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1050 catcon::exec_DB_script - C:\oracle\apex\apexins_cdb_catcon_1964_exec_DB_script.done did not need to be deleted before running a script

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1078 catcon::exec_DB_script - Created and opened a temporary script file (C:\oracle\apex\apexins_cdb_catcon_1964_exec_DB_script.sql)
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1078 catcon::exec_DB_script -
which will contain statements supplied by the caller

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set newpage 1

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set pagesize 14

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added connect / AS sysdba

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set echo off

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set heading off

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added set lines 1000

2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - added select 'C:A:T:C:O:N' || instance.instance_name || '@' || '(DESCRIPTION=' || regexp_substr(local_listener.value, '$ADDRESS=(\([^()]+$)+\)', 1, 1, 'i') || '(CONNECT_DATA=(SERVICE_NAME=' || regexp_substr(service_name.value, '[^,]+', 1, 1) || ')))' from gv$instance instance, gv$listener_network local_listener, gv$parameter service_name where instance.inst_id = local_listener.inst_id and instance.inst_id = service_name.inst_id and local_listener.type='LOCAL LISTENER' and service_name.name='service_names' and local_listener.con_id in (0,1) and service_name.con_id in (0,1)
2021-09-02 23:54:54 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:1127 catcon::exec_DB_script - /

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - RecoverFromChildDeath = 0,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - KillSessScript = C:\oracle\apex\apexins_cdb_catcon_kill_sess_1964_ALL.sql,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - DoneCmd =
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - host sqlplus/nolog -v >);
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc -

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9844 catcon::next_proc - Checking if process 0 (id = 3824) is available

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9853 catcon::next_proc - process 0 is available

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10107 catcon::pickNextProc - call sureunlink to remove C:\oracle\apex\apexins_cdb_catcon_3824.done

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:933 catcon::sureunlink - unlink(C:\oracle\apex\apexins_cdb_catcon_3824.done) succeeded after 1 attempt(s)

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:935 catcon::sureunlink - verify that the file really no longer exists

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:946 catcon::sureunlink - confirmed that C:\oracle\apex\apexins_cdb_catcon_3824.done no longer exists after 1 attempts

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15244 catcon::catconExec_int - Process 0 will be involved in executing at least one statement
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15244 catcon::catconExec_int - or script, so its log will be preserved
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15244 catcon::catconExec_int -

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15392 catcon::catconExec_int - issued ALTER SESSION SET APPLICATION MODULE = 'catcon(pid=1964)'

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15401 catcon::catconExec_int - issued ALTER SESSION SET APPLICATION ACTION = 'CDB$ROOT::# #1,2,3#'

2021-09-02 23:55:01 VERBOSE> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:10423 catcon::log_script_execution - executing "@apexins_nocdb.sql #apex# #apex# #TEMP# #/i/# #1,2,3#" in container CDB$ROOT using process 0

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15469 catcon::catconExec_int - sent "
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15469 catcon::catconExec_int - host sqlplus/nolog -v > C:\oracle\apex\apexins_cdb_catcon_3824.done" to process
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15469 catcon::catconExec_int - 0 (id = 3824) to indicate its availability
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15469 catcon::catconExec_int - after completing @apexins_nocdb.sql 'apex' 'apex' 'TEMP' '/i/' '1,2,3'
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:15469 catcon::catconExec_int -

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - running wait_for_completion(ProcsUsed = 1,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - FilePathBase = C:\oracle\apex\apexins_cdb,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - DoneCmd =
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - host sqlplus/nolog -v >,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - Root = CDB$ROOT,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - InternalConnectString = / AS sysdba,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - RecoverFromChildDeath = 0,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - KillSessScript = C:\oracle\apex\apexins_cdb_catcon_kill_sess_1964_ALL.sql,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion - LogLevelDebug = );
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9912 catcon::wait_for_completion -

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9926 catcon::wait_for_completion - waiting for 1 processes to complete

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - running next_proc(ProcsUsed = 1,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - NumProcs = 3,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - StartingProc = 1,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - FilePathBase = C:\oracle\apex\apexins_cdb,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - RecoverFromChildDeath = 0,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - KillSessScript = C:\oracle\apex\apexins_cdb_catcon_kill_sess_1964_ALL.sql,
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - DoneCmd =
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc - host sqlplus/nolog -v >);
2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9702 catcon::next_proc -

2021-09-02 23:55:01 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9844 catcon::next_proc - Checking if process 0 (id = 3824) is available

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9762 catcon::next_proc - process 0 (PID=3824) is dead

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9767 catcon::next_proc - caller has not requested recovery from death of SQL*Plus processes -
2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9767 catcon::next_proc - will release resources and exit
2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9767 catcon::next_proc -

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9777 catcon::next_proc - SIGPIPE will be ignored

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9783 catcon::next_proc - invoking catconWrapUp

2021-09-02 23:55:03 VERBOSE> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:17680 catcon::catconWrapUp - (PID=1964) about to free up all resources

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9414 catcon::end_processes - will end processes 0 to 2

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9433 catcon::end_processes - check if process 0 (id=3824) is alive

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9437 catcon::end_processes - process 0 (id=3824) is dead

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9460 catcon::end_processes - setting FileHandle[0] to undef

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9433 catcon::end_processes - check if process 1 (id=9908) is alive

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9437 catcon::end_processes - process 1 (id=9908) is alive

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9450 catcon::end_processes - write EXIT to process 1 (id=9908)

2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9454 catcon::end_processes - close file handle for process 1 (id=9908)
2021-09-02 23:55:03 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9454 catcon::end_processes -

2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9460 catcon::end_processes - setting FileHandle[1] to undef

2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9433 catcon::end_processes - check if process 2 (id=11460) is alive

2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9437 catcon::end_processes - process 2 (id=11460) is alive

2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9450 catcon::end_processes - write EXIT to process 2 (id=11460)

2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9454 catcon::end_processes - close file handle for process 2 (id=11460)
2021-09-02 23:55:04 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9454 catcon::end_processes -

2021-09-02 23:55:05 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9460 catcon::end_processes - setting FileHandle[2] to undef

2021-09-02 23:55:05 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9479 catcon::end_processes - done with processes 0 to 2

2021-09-02 23:55:05 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9588 catcon::clean_up_compl_files - FileNameBase = C:\oracle\apex\apexins_cdb, FirstProc =0, LastProc = 2

2021-09-02 23:55:05 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:9595 catcon::clean_up_compl_files - call sureunlink to remove C:\oracle\apex\apexins_cdb_catcon_9908.done

2021-09-02 23:55:05 DEBUG> C:\oracle\WINDOWS.X64_193000_db_home/rdbms/admin/catcon.pm:933 catcon::sureunlink - unlink(C:\oracle\apex\apexins_cdb_catcon_9908.done) succeeded after 1 attempt(s)