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.

Get last 500 lines from a file on windows powershell

Get last 500 lines from a file on windows power shell

Get-Content <File location> -Wait -Tail 500

Oracle E-Business Suite 12.2.10 Now Available

https://blogs.oracle.com/ebstech/oracle-e-business-suite-12210-now-available

 

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

While doing upgrade database from 12c to 19c

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  18.2

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

 

Install & Upgrade’

move the OLD apex to different location or renam apex to apex_old

Extract the apex and copy to oracle home path.

as administrator

@apexins.sql SYSAUX SYSAUX TEMP /i/

 

Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime

refer

Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime (Doc ID 1581549.1)

Oracle Linux 7.4 harddisk partition

You have two HDD and need to make two partition with separate during installation

 

 

 

 

 

 

 

 

 

 

 

 

REST ISG_SERVICE_EXECUTION_ERROR getting error

When we’re trying to post the data using REST service after we add some parameter in existing package, we’re getting the error while post

 

{
“ISGServiceFault”: {
“Code”: “ISG_SERVICE_EXECUTION_ERROR”,
“Message”: “Error while executing service”,
“Resolution”: “System error, please see service log trace for details”,
“ServiceDetails”: {
“ServiceName”: “XXACE_AP_INV_CMS_SOA_PKG”,
“OperationName”: “xxace_main”,
“InstanceId”: “0”
}
}
}

 

Log in error while deploy REST service

PLS-00306: wrong number or types of arguments in call to ‘HAS_DEFAULT’
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Solution :

Functional Administrator –> clear cache

restart service

undeploy and deploy the service again

Now we can able to post data

 

EBS 12.2 Only Allow Access to Oracle WebLogic Server Administration Ports from Trusted Hosts

When i am trying to access the weblogic server console from one of client machine, I am getting the below error

 

 

Solution :

 

If you have applied the Critical Patch Update (CPU) released in April 2019, then you can use the context variable s_wls_admin_console_access_nodes to specify the trusted hosts used by administrators that require access to the Oracle WebLogic Server Administration Console and Fusion Middleware Control. Set this context variable to a list of trusted hosts that are allowed to access the consoles using the Oracle WebLogic Server Administration ports.

 

Run file system, we need to add the client ip or hostname lists in context file

<s_wls_admin_console_access_nodes oa_var=”s_wls_admin_console_access_nodes”>10.0.XX.XX</s_wls_admin_console_access_nodes>

run autoconfig

stop and start service

Now we can able to reach the weblogic server console URL

adop phase=fs_clone

yum install package compilation issue

I created a local repository in redhat 7.6 and then i am trying to install the package but i am getting the dependency issue.

Error :

[root@ebs-117-41 Packages]# yum install glibc-2.17-222.el7.i686
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Resolving Dependencies
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
–> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-222.el7.i686
–> Processing Dependency: libfreebl3.so for package: glibc-2.17-222.el7.i686
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
—> Package nss-softokn-freebl.i686 0:3.34.0-2.el7 will be installed
–> Finished Dependency Resolution
Error: Package: glibc-2.17-222.el7.i686 (customrepo)
Requires: glibc-common = 2.17-222.el7
Installed: glibc-common-2.17-260.el7.x86_64 (@anaconda/7.6)
glibc-common = 2.17-260.el7
Available: glibc-common-2.17-222.el7.x86_64 (customrepo)
glibc-common = 2.17-222.el7
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest

 

Solution :

By mistake I created a local repository with lower version of redhat. so that it’s not compatible when i try to install rpm packages. After i corrected the repository version, it’s okay to install.

In case, If you still continue to see the error after you created the repository with correct version, you need to clean.

 

yum clean all

then execute

yum repolist

Now We can able to install rpm packages on the server using local repository.

 

 

 

New OA Framework 12.2.9 Bundle 2 Available

Please refer

https://blogs.oracle.com/ebstech/new-oa-framework-1229-bundle-2-now-available