发现以下信息:
Can't spawn "cmd": No such file or directory at D:\ORACLE\product\12.2.0\dbhome_1\rdbms\admin\catctl
在 catupgrd1R0.log 文件中,有以下信息:
Unexpected error encountered in catctlMain; Error Stack Below; exiting
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at D:\ORACLE\product\12.2.0\dbhome_1\rdbms\admin/catcon.pm line 653.
at D:/oracle/product/12.2.0/dbhome_1/perl/lib/IPC/Open3.pm line 336, <STDIN> line 1.
参考MOS:
datapatch or upgrade on Windows Fails with Error:”open2: IO::Pipe: Can’t spawn-NOWAIT: No such file or directory $ORACLE_HOME\\rdbms\admin/catcon.pm” (Doc ID 1989321.1)
In this Document
Symptoms
Changes
Cause
Solution
APPLIES TO:
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Microsoft Windows x64 (64-bit)
SYMPTOMS
datapatch Fails with Error:”open2: IO::Pipe: Can’t spawn-NOWAIT: No such file or directory $ORACLE_HOME\\rdbms\admin/catcon.pm”
Example:
Executing Datapatch command for bundle patch 20315685 (12.1.0.2.2) fails with error:
D:\oracle\product\12.1.0.2\dbhome_1\OPatch>datapatch -verbose
SQL Patching tool version 12.2.0.0.0 on Thu Feb 26 12:26:18 2015
Copyright (c) 2014, Oracle. All rights reserved.
Connecting to database…OK
catcon: ALL catcon-related output will be written to C:\temp/sqlpatch_catcon__catcon_10336.lst
catcon: See C:\temp/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See C:\temp/sqlpatch_catcon__*.lst files for spool files, if any
open2: IO::Pipe: Can’t spawn-NOWAIT: No such file or directory at D:\oracle\product\12.1.0.2\dbhome_1\\rdbms\admin/catcon.pm line 470
or
Database Upgrade fails with error:
%ORACLE_HOME%\rdbms\admin>dbupgrade
Can't spawn "cmd.Bxe": No such file or directory at F:\app\dbaadmin\product\12.2.0\dbhome_1\rdbms\admin\catctl.pl line 9666.
DERIVED ORACLE HOME catctl = [F:\app\dbaadmin\product\12.2.0\dbhome_1]
Can't spawn "cmd.Bxe": No such file or directory at %ORACLE_HOME%\rdbms\admin\catctl.pl line 9666.
Can't spawn "cmd.Bxe": No such file or directory at %ORACLE_HOME%\rdbms\admin\catctl.pl line 9666.
SOLUTION
Add path “c:\Windows\System32″ in 'PATH' environment variable.
set PATH=c:\windows\system32;%ORACLE_HOME%\perl\bin;%ORACLE_HOME%\bin;%PATH%
echo %PATH%
c:\windows\system32;D:\oracle\product\12.1.0.2\dbhome_1\bin;D:\oracle\product\12.1.0.2\dbhome_1\perl\bin
And then execute datapatch or upgrade command as required.