Skip to content

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.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: