681216315def8e70df.png (184.35 KB, 下载次数: 183)
2022-9-5 19:35 上传
手工执行也报错：
448726315df2150776.png (241.3 KB, 下载次数: 180)
2022-9-5 19:36 上传
发现以下信息：
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.
初步判断是环境变量 path 出现问题，检查，发现 path 中，没有c:\windows\system32
291316315df6f9e8bf.png (75.04 KB, 下载次数: 185)
2022-9-5 19:37 上传
修改环境变量，加上 c:\windows\system32 后，再去升级，问题解决。
241746315df907a8eb.png (109.35 KB, 下载次数: 180)
2022-9-5 19:37 上传
58476315dfa994d17.png (311.27 KB, 下载次数: 188)
2022-9-5 19:38 上传
参考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.
catctlGetOrabase = [C:\Users\dbaadmin\AppData\Local\Temp]
Analyzing file %ORACLE_HOME%\rdbms\admin\catupgrd.sql
Log file directory = [C:\Users\dbaadmin\AppData\Local\Temp\cfgtoollogs\upgrade20180912113238]
catcon: ALL catcon-related output will be written to [C:\Users\dbaadmin\AppData\Local\Temp\cfgtoollogs\upgrade20180912113238/catupgrd_catcon_3676.lst]
catcon: See [C:\Users\dbaadmin\AppData\Local\Temp\cfgtoollogs\upgrade20180912113238/catupgrd*.log] files for output generated by scripts
catcon: See [C:\Users\dbaadmin\AppData\Local\Temp\cfgtoollogs\upgrade20180912113238/catupgrd_*.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 %ORACLE_HOME%\rdbms\admin/catcon.pm line 653.
at %ORACLE_HOME%\perl\lib/IPC/Open3.pm line 336.
eval {...} called at %ORACLE_HOME%\perl\lib/IPC/Open3.pm line 335
CHANGES
CAUSE
c:\Windows\System32 was not part of the ‘PATH’ environment variable
echo %PATH%
D:\oracle\product\12.1.0.2\dbhome_1\bin;D:\oracle\product\12.1.0.2\dbhome_1\perl\bin
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.
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |