Archive for

Apex upgrade during database upgrade

While doing upgrade from oracle database 12.2 to 19c, we need to do the upgrade apex as per preupgrade recommendation

Upgrade Oracle Application Express (APEX) manually before the database
upgrade.

  The database contains APEX version 5.0.4.00.12. Upgrade APEX to at least
  version 18.2.0.00.12.

  Starting with Oracle Database Release 18, APEX is not upgraded
  automatically as part of the database upgrade. Refer to My Oracle Support
  Note 1088970.1 for information about APEX installation and upgrades.

Solution :

Download apex

https://www.oracle.com/tools/downloads/apex-downloads.html

you can able to download older apex too.

Unzip apex software

move older apex version directory to somewhere and copy the apex to oracle 12c home path.

From command prompt, go to apex directory location and then execute the following command from sql as sysdba

before that , you need to know

There are two types of APEX installations: development and runtime only. To determine which type is currently installed, run the following query:

select count(*) from <SCHEMA>.WWV_FLOWS where id = 4000;

<SCHEMA> — curent APEX schema Example APEX_5000

If the query returns 0, it is a runtime only installation, and apxrtins.sql should be used for the upgrade. If the query returns 1, this is a development install and apexins.sql should be used.

As administrator command prompt

@apexins.sql SYSAUX SYSAUX TEMP /i/

It will take sometime to upgrade

can’t spawn cmd.exe no such file or directory Database upgrade to 19c

When i am trying to upgrade database from 12.2.0.1.0 to 19.3.0.0.0 using dbua which is running on window server 2016. I am facing the below issue during upgrade.

the database upgrade component failed during 28% of the upgrade process. So i looked the upgrade log file, the below errors occured

Can’t spawn “cmd.exe”: No such file or directory at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 11024.

DERIVED ORACLE HOME catctl = [E:\app\WINDOWS.X64_193000_db_home]
Can’t spawn “cmd.exe”: No such file or directory at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 11024.
Can’t spawn “cmd.exe”: No such file or directory at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 11024.
catctlGetOraBaseLogDir = [C:\Users\mazar\AppData\Local\Temp\5]

Analyzing file E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catupgrd.sql

Log file directory = [E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\SIEBUATDB]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\SIEBUATDB\catupgrd3R_catcon_26224.lst]

catcon::set_log_file_base_path: catcon: See [E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\SIEBUATDB\catupgrd3R*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\SIEBUATDB\catupgrd3R_*.lst] files for spool files, if any

Unexpected error encountered in catctlMain; Error Stack Below; exiting
open2: IO::Pipe: Can’t spawn-NOWAIT: No such file or directory at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 1137.
at E:/app/WINDOWS.X64_193000_db_home/perl/lib/IPC/Open3.pm line 336, line 1.
eval {…} called at E:/app/WINDOWS.X64_193000_db_home/perl/lib/IPC/Open3.pm line 335
IPC::Open3::_open3(“open2”, GLOB(0x171befc2c88), GLOB(0x171befc2c70), “>&STDERR”, “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE /nolog”) called at E:/app/WINDOWS.X64_193000_db_home/perl/lib/IPC/Open2.pm line 117
IPC::Open2::open2(GLOB(0x171befc2c70), GLOB(0x171befc2c88), “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE /nolog”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 1137
catcon::exec_DB_script(ARRAY(0x171befc3bc0), “C:A:T:C:O:N”, “\x{a}host sqlplus/nolog -v >”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 1408
catcon::get_instance_status_and_name(ARRAY(0x171bf4b9e78), “\x{a}host sqlplus/nolog -v >”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 13012
catcon::catconInit2(HASH(0x171bf91a8f0)) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 12249
catcon::catconInit(“sys”, undef, “E:\app\WINDOWS.X64_193000_db_home\rdbms\admin”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “catupgrd3R”, 0, 0, 4, …) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 3696
main::catctlDBLogon(“E:\app\WINDOWS.X64_193000_db_home\rdbms\admin”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “catupgrd3R”, 0, 0, 4) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 3774
main::catctlLogon() called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1414
main::catctlMain() called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1362
eval {…} called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1360
at E:/app/WINDOWS.X64_193000_db_home/perl/lib/IPC/Open2.pm line 117, line 1.
IPC::Open2::open2(GLOB(0x171befc2c70), GLOB(0x171befc2c88), “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE /nolog”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 1137
catcon::exec_DB_script(ARRAY(0x171befc3bc0), “C:A:T:C:O:N”, “\x{a}host sqlplus/nolog -v >”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 1408
catcon::get_instance_status_and_name(ARRAY(0x171bf4b9e78), “\x{a}host sqlplus/nolog -v >”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “E:\app\WINDOWS.X64_193000_db_home\bin\sqlplus.EXE”) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 13012
catcon::catconInit2(HASH(0x171bf91a8f0)) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin/catcon.pm line 12249
catcon::catconInit(“sys”, undef, “E:\app\WINDOWS.X64_193000_db_home\rdbms\admin”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “catupgrd3R”, 0, 0, 4, …) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 3696
main::catctlDBLogon(“E:\app\WINDOWS.X64_193000_db_home\rdbms\admin”, “E:\app\oracle\cfgtoollogs\dbua\upgrade2020-10-07_04-54-01PM\S”…, “catupgrd3R”, 0, 0, 4) called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 3774
main::catctlLogon() called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1414
main::catctlMain() called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1362
eval {…} called at E:\app\WINDOWS.X64_193000_db_home\rdbms\admin\catctl.pl line 1360

Solution :

system32 path variable not set properly. Even If i tried to run as administrator in command prompt from explorer, its not work. usually if we’re open run as administrator from explorer, it will go to C:\Windows\System32> path. but my system, its gone to default path my user.

go to

C:\Windows\System32\cmd as run as administrator, now its working.