RE: OPatchAuto failed
Date: Fri, 4 Oct 2019 02:47:39 -0700
Message-ID: <0f0501d57a98$c3556970$4a003c50$_at_comcast.net>
Try applying the patches manually as grid user with opatch instead of opatchauto.
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29423125
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29496791
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29509318
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sameer Choudhari
Sent: Friday, October 4, 2019 2:33 AM
Tried executing opatchauto but failed. Attached trace text file for your reference. thanks
[root_at_uat-db-002 oracle]#
To: dimensional.dba_at_comcast.net
Cc: Oracle-L_at_freelists.org
Subject: Re: OPatchAuto failed
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# echo $ORACLE_HOME
/u01/g01/grid/12.1
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# env |grep PATH
MANPATH=:/opt/puppetlabs/puppet/share/man
PATH=/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/d01/db/12.1.0/bin:/u01/d01/db/12.1.0/OPatch:/u01/g01/grid/12.1/bin
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# env |grep PATH
MANPATH=:/opt/puppetlabs/puppet/share/man
PATH=/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/d01/db/12.1.0/bin:/u01/d01/db/12.1.0/OPatch:/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/OPatch
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# ls -l $ORACLE_HOME/OPatch/opatchauto
-rwxr-x---. 1 oracle dba 1442 Apr 12 17:57 /u01/g01/grid/12.1/OPatch/opatchauto
[root_at_uat-db-002 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629 -analyze
OPatchauto session is initiated at Fri Oct 4 19:12:27 2019
System initialization log file is /u01/g01/grid/12.1/cfgtoollogs/opatchautodb/systemconfig2019-10-04_07-12-33PM.log.
Session log file is /u01/g01/grid/12.1/cfgtoollogs/opatchauto/opatchauto2019-10-04_07-13-17PM.log The id for this session is 895B
Executing OPatch prereq operations to verify patch applicability on home /u01/d01/db/12.1.0
Executing OPatch prereq operations to verify patch applicability on home /u01/g01/grid/12.1 Patch applicability verified successfully on home /u01/d01/db/12.1.0
Patch applicability verified successfully on home /u01/g01/grid/12.1
Verifying SQL patch applicability on home /u01/d01/db/12.1.0 SQL patch applicability verified successfully on home /u01/d01/db/12.1.0
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:uat-db-002
RAC Home:/u01/d01/db/12.1.0
Version:12.1.0.2.0
==Following patches were SKIPPED:
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/26983807 Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29423125 Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29496791 Log: /u01/d01/db/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-10-04_19-13-46PM_1.log
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29509318 Log: /u01/d01/db/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-10-04_19-13-46PM_1.log
Host:uat-db-002
CRS Home:/u01/g01/grid/12.1
Version:12.1.0.2.0
==Following patches were SKIPPED:
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/26983807 Reason: This patch is already been applied, so not going to apply again.
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29423125 Log: /u01/g01/grid/12.1/cfgtoollogs/opatchauto/core/opatch/opatch2019-10-04_19-13-46PM_1.log
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29496791 Log: /u01/g01/grid/12.1/cfgtoollogs/opatchauto/core/opatch/opatch2019-10-04_19-13-46PM_1.log
Patch: /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629/29509318 Log: /u01/g01/grid/12.1/cfgtoollogs/opatchauto/core/opatch/opatch2019-10-04_19-13-46PM_1.log
OPatchauto session completed at Fri Oct 4 19:18:17 2019
Time taken to complete the session 5 minutes, 50 seconds
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# ls -lrt /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629
total 184
drwxr-xr-x. 5 oracle dba 4096 Jul 1 16:04 29423125 drwxr-xr-x. 27 oracle dba 4096 Jul 1 16:09 29496791 drwxr-xr-x. 5 oracle dba 4096 Jul 1 16:10 29509318 drwxr-xr-x. 2 oracle dba 4096 Jul 1 16:10 automation drwxr-xr-x. 4 oracle dba 4096 Jul 1 16:10 26983807 -rw-r--r--. 1 oracle dba 0 Jul 1 16:10 README.txt -rw-r--r--. 1 oracle dba 155859 Jul 1 16:33 README.html-rw-rw-r--. 1 oracle dba 4987 Jul 1 16:59 bundle.xml
[root_at_uat-db-002 oracle]# cd /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255
[root_at_uat-db-002 29699255]#
[root_at_uat-db-002 29699255]# ls -l $ORACLE_HOME/OPatch/opatchauto
-rwxr-x---. 1 oracle dba 1442 Apr 12 17:57 /u01/g01/grid/12.1/OPatch/opatchauto
[root_at_uat-db-002 29699255]#
[root_at_uat-db-002 29699255]# strace -o /tmp/opatchauto.txt $ORACLE_HOME/OPatch/opatchauto apply /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629
OPatchauto session is initiated at Fri Oct 4 19:27:30 2019
System initialization log file is /u01/g01/grid/12.1/cfgtoollogs/opatchautodb/systemconfig2019-10-04_07-27-36PM.log.
Session log file is /u01/g01/grid/12.1/cfgtoollogs/opatchauto/opatchauto2019-10-04_07-28-19PM.log
The id for this session is B6B8
Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host uat-db-001 due to : java.lang.Exception: Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
OPatchAuto failed.
OPatchauto session completed at Fri Oct 4 19:28:43 2019 Time taken to complete the session 1 minute, 13 seconds
opatchauto failed with error code 42
[root_at_uat-db-002 29699255]#
[root_at_uat-db-002 29699255]#
Cheers,
Sameer
On Fri, 4 Oct 2019 at 19:16, <dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net> > wrote:
You have two different homes in your path
PATH=/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/d01/db/12.1.0/bin:/u01/d01/db/12.1.0/OPatch:/u01/g01/grid/12.1/bin
I don’t see the
/u01/g01/grid/12.1/OPatch
In that path.
I would reset your path as
Export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/OPatch
Then try it again.
If it still doesn’t would I would run (Since you already set OPatch in the path then you do not need to fully path opatch in your command run.
strace -o /tmp/opatchauto.txt opatchauto apply /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629
From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of Sameer Choudhari
Sent: Friday, October 4, 2019 2:01 AM
To: dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net>
Cc: Oracle-L_at_freelists.org <mailto:Oracle-L_at_freelists.org>
Subject: Re: OPatchAuto failed
Was the original $ORACLE_HOME = /u01/g01/grid/12.1/OPatch ------> YES. OPatch version is same on each nodes and each homes
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# echo $ORACLE_HOME
/u01/g01/grid/12.1
[root_at_uat-db-002 oracle]# env |grep PATH
MANPATH=:/opt/puppetlabs/puppet/share/man
PATH=/u01/g01/grid/12.1/bin:/u01/g01/grid/12.1/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/d01/db/12.1.0/bin:/u01/d01/db/12.1.0/OPatch:/u01/g01/grid/12.1/bin
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# echo $ORACLE_HOME/OPatch
/u01/g01/grid/12.1/OPatch
[root_at_uat-db-002 oracle]# /u01/g01/grid/12.1/OPatch/opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# cd /home/oracle/
[root_at_uat-db-002 oracle]# . ./UATEBS2_uat-db-002.env
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]#
[root_at_uat-db-002 oracle]# echo $ORACLE_HOME/OPatch
/u01/d01/db/12.1.0/OPatch
[root_at_uat-db-002 oracle]# /u01/d01/db/12.1.0/OPatch/opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[root_at_uat-db-002 oracle]#
Cheers,
Sameer
On Fri, 4 Oct 2019 at 18:51, <dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net> > wrote:
You set the PATH twice
[root_at_uat-db-002 .ssh]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root_at_uat-db-002 .ssh]# export PATH=$PATH:/u01/g01/grid/12.1/OPatch
Was the original $ORACLE_HOME = /u01/g01/grid/12.1/OPatch or something else
Run
Env | grep PATH
Does the path have different paths to OPatch?
Whatever is the first one in the PATH variable will be used first.
Is the version of opatchauto/opatch the same on each node and the required version?
From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of Sameer Choudhari
Sent: Thursday, October 3, 2019 8:41 PM
To: Oracle-L_at_freelists.org <mailto:Oracle-L_at_freelists.org>
Subject: OPatchAuto failed
Team
I am applying JULY 2019 Proactive Bunble Patch on our UAT env.
Env :
DB : 12.1.0.2.0 (2 node rac)
OS : Oracle Linux 7
I am able to patch node-1 i.e. uat-db-001 without any issue but got below error while patching node -2 i.e. uat-db-002 .
[root_at_uat-db-002 .ssh]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root_at_uat-db-002 .ssh]# export PATH=$PATH:/u01/g01/grid/12.1/OPatch
[root_at_uat-db-002 .ssh]# cd /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255
[root_at_uat-db-002 29699255]# $ORACLE_HOME/OPatch/opatchauto apply /u01/stage/COMBO_JVM_DBBP_JUL2019/29699255/29698629
OPatchauto session is initiated at Fri Oct 4 13:13:54 2019
System initialization log file is /u01/g01/grid/12.1/cfgtoollogs/opatchautodb/systemconfig2019-10-04_01-14-00PM.log.
Session log file is /u01/g01/grid/12.1/cfgtoollogs/opatchauto/opatchauto2019-10-04_01-14-44PM.log
The id for this session is LBTP
Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host uat-db-001 due to : java.lang.Exception: Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
OPatchAuto failed.
OPatchauto session completed at Fri Oct 4 13:15:08 2019 Time taken to complete the session 1 minute, 14 seconds
opatchauto failed with error code 42
[root_at_uat-db-002 29699255]#
Checked MOS and Google but no help. I have shared partial session log below i.e. /u01/g01/grid/12.1/cfgtoollogs/opatchauto/opatchauto2019-10-04_01-14-44PM.log . Could you please let me know what could be the issue.
Oct 04, 2019 1:15:06 PM com.oracle.cie.remote.linux.LinuxCommandExecutionHelper getSSHCmd INFO: SSH path::/bin/ssh Oct 04, 2019 1:15:06 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommandINFO: Command execution command: /bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=no -o NumberOfPasswordPrompts=0 uat-db-001 ls /u01/g01/grid/12.1 > /dev/null Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: Command execution return code: 0
Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: command execution message:
Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: command executon failure message:
*** Authorized uses only. All activity may be monitored and reported. ***
Oct 04, 2019 1:15:07 PM com.oracle.helper.remote.ssh.SSHEquivalenceCommandExecutor executeAndNotify INFO: Executing command on host uat-db-001 : /u01/g01/grid/12.1//perl/bin/perl /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl -GRID_HOME=/u01/g01/grid/12.1 -OBJECTLOC=/u01/g01/grid/ 12.1//cfgtoollogs/opatchautodb/hostdata.obj -CRS_ACTION=check -CLUSTERNODES=uat-db-001,uat-db-002 -JVM_HANDLER=oracle/dbsysmodel/driver/sdk/productdriver/remote/RemoteOperationHelper
Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxCommandExecutionHelper getSSHCmd INFO: SSH path::/bin/ssh Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommandINFO: Command execution command: /bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=no -o NumberOfPasswordPrompts=0 uat-db-001 /u01/g01/grid/12.1//perl/bin/perl /u01/g0 1/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl -GRID_HOME=/u01/g01/grid/12.1 -OBJECTLOC=/u01/g01/grid/12.1//cfgtoollogs/opatchautodb/hostdata.obj -CRS_ACTION=check -CLUSTERNODES=uat-db-001 ,uat-db-002 -JVM_HANDLER=oracle/dbsysmodel/driver/sdk/productdriver/remote/RemoteOperationHelper Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: Command execution return code: 2
Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: command execution message:
Oct 04, 2019 1:15:07 PM com.oracle.cie.remote.linux.LinuxSSHUserEquivalenceConnHandlerImpl executeCommand INFO: command executon failure message:
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6 4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2. BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Oct 04, 2019 1:15:07 PM com.oracle.helper.remote.ssh.SSHEquivalenceCommandExecutor executeAndNotify
WARNING: Error while executing command "/u01/g01/grid/12.1//perl/bin/perl /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl -GRID_HOME=/u01/g01/grid/12.1 -OBJECTLOC=/u01/g01/grid/12.1/
/cfgtoollogs/opatchautodb/hostdata.obj -CRS_ACTION=check -CLUSTERNODES=uat-db-001,uat-db-002 -JVM_HANDLER=oracle/dbsysmodel/driver/sdk/productdriver/remote/RemoteOperationHelper " on host uat-db-001 :
Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6
4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
Oct 04, 2019 1:15:07 PM com.oracle.helper.remote.ssh.SSHEquivalenceCommandExecutor executeAndNotify
WARNING: Exception while executing command "" on host uat-db-001 : Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6
4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
Oct 04, 2019 1:15:07 PM com.oracle.helper.remote.ssh.SSHEquivalenceThreadHandler$SSHEquiCommandListener notifyResult
INFO: Received command execution result for host uat-db-001
Oct 04, 2019 1:15:07 PM oracle.dbsysmodel.driver.sdk.productdriver.remote.HostDataCollector notifyResult
INFO: Consolidating result from host : uat-db-001
Oct 04, 2019 1:15:07 PM oracle.dbsysmodel.driver.sdk.productdriver.remote.HostDataCollector notifyResult
INFO: Execution failed for host uat-db-001 due to : Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6
4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output:
Oct 04, 2019 1:15:07 PM oracle.dbsysmodel.driver.sdk.productdriver.remote.HostDataCollector performRemoteOperForActions
INFO: Remote node list for home /u01/g01/grid/12.1 : []
2019-10-04 13:15:07,859 INFO [1] oracle.dbsysmodel.driver.sdk.util.OsysUtility - Output message ::: 2019-10-04 13:15:07,870 INFO [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Remote command execution failed due to *** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6
4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output: '}
2019-10-04 13:15:07,873 INFO [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport - Space available after session: 33580 MB
2019-10-04 13:15:07,996 SEVERE [1] com.oracle.glcm.patch.auto.OPatchAuto - OPatchAuto failed.
com.oracle.glcm.patch.auto.OPatchAutoException: oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host uat-db-001 due to : java.lang.Exception: Remote command exe
cution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6 4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2. BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2. Command output:
at com.oracle.glcm.patch.auto.OPatchAuto.prepareOrchestration(OPatchAuto.java:775)
at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:397)
at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:344)
at com.oracle.glcm.patch.auto.OPatchAuto.main(OPatchAuto.java:212)
Caused by: oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host uat-db-001 due to : java.lang.Exception: Remote command execution failed due to
*** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6 4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2. BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2. Command output:
at oracle.dbsysmodel.driver.sdk.productdriver.OUIDriver.checkForException(OUIDriver.java:846)
at oracle.dbsysmodel.driver.sdk.productdriver.OUIDriver.handleExceptions(OUIDriver.java:832)
at oracle.dbsysmodel.driver.sdk.productdriver.OUIDriver.fetchRemoteHostData(OUIDriver.java:791)
at oracle.dbsysmodel.driver.sdk.productdriver.OUIDriver.fetchRemoteNodeData(OUIDriver.java:690)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.DBPatchingHelper.fetchPreInitiatedNodes(DBPatchingHelper.java:899)
at com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation.isFirstNodeOfPatching(RemoteGIStatusValidation.java:274)
at com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation.validate(RemoteGIStatusValidation.java:185)
at com.oracle.glcm.patch.auto.db.product.validation.DBValidationController.invoke(DBValidationController.java:91)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.CRSTopologyBuilder.validate(CRSTopologyBuilder.java:367)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.AbstractTopologyBuilder.buildTopology(AbstractTopologyBuilder.java:117)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.CRSTopologyBuilder.buildTopology(CRSTopologyBuilder.java:112)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport.loadTopology(DBBaseProductSupport.java:192)
at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBProductSupport.loadTopology(DBProductSupport.java:69)
at com.oracle.glcm.patch.auto.OPatchAuto.loadTopology(OPatchAuto.java:1732)
at com.oracle.glcm.patch.auto.OPatchAuto.prepareOrchestration(OPatchAuto.java:730)
... 3 more
2019-10-04 13:15:07,999 INFO [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverE xception: Execution failed for host uat-db-001 due to : java.lang.Exception: Remote command execution failed due to *** Authorized uses only. All activity may be monitored and reported. ***
Can't locate Cwd.pm in _at_INC (_at_INC contains: /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/g01/grid/12.1/perl/lib/site_perl/5.14.1 /u01/g01/grid/12.1/perl/lib/5.14.1/x86_6
4-linux-thread-multi /u01/g01/grid/12.1/perl/lib/5.14.1 .) at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /u01/g01/grid/12.1/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
Command output: '}
2019-10-04 13:15:08,003 INFO [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPatchAuto failed.'}
[root_at_uat-db-002 29699255]#
So far , I tried
For "Can't locate Cwd.pm in _at_INC" , I checked it's there. Also, checked the permission for /u01/g01/grid/12.1/cfgtoollogs/opatchautodb and its owned by grid home user.
[root_at_uat-db-002 29699255]# find / -name Cwd.pm
/usr/lib64/perl5/vendor_perl/Cwd.pm /u01/g01/grid/12.1/perl/lib/5.14.1/x86_64-linux-thread-multi/Cwd.pm /u01/g01/grid/12.1/perl/lib/5.14.1/Cwd.pm /u01/d01/db/12.1.0/perl/lib/5.14.1/x86_64-linux-thread-multi/Cwd.pm /u01/em_agent/agent_13.2.0.0.0/perl/lib/5.14.4/x86_64-linux-thread-multi/Cwd.pm
[root_at_uat-db-002 29699255]#
Cheers
Sameer
This is an email from Ezidebit Pty Ltd. The email and any attachments may be confidential, legally privileged and/or subject to copyright. If you are not the intended recipient, you must not disclose or use the information contained in this e-mail. If you have received this email in error, please notify us immediately and delete the email and all copies. We do not guarantee that this email and any attachments are free from virus or other errors. We will not be responsible for loss or damage resulting (either directly or indirectly) from any such virus or error. We will only be responsible for a change to a document if we made the change. The content of and opinions expressed in non-business emails are not that of Ezidebit Pty Ltd and are that of the sender.
This is an email from Ezidebit Pty Ltd. The email and any attachments may be confidential, legally privileged and/or subject to copyright. If you are not the intended recipient, you must not disclose or use the information contained in this e-mail. If you have received this email in error, please notify us immediately and delete the email and all copies. We do not guarantee that this email and any attachments are free from virus or other errors. We will not be responsible for loss or damage resulting (either directly or indirectly) from any such virus or error. We will only be responsible for a change to a document if we made the change. The content of and opinions expressed in non-business emails are not that of Ezidebit Pty Ltd and are that of the sender.
This is an email from Ezidebit Pty Ltd. The email and any attachments may be confidential, legally privileged and/or subject to copyright. If you are not the intended recipient, you must not disclose or use the information contained in this e-mail. If you have received this email in error, please notify us immediately and delete the email and all copies. We do not guarantee that this email and any attachments are free from virus or other errors. We will not be responsible for loss or damage resulting (either directly or indirectly) from any such virus or error. We will only be responsible for a change to a document if we made the change. The content of and opinions expressed in non-business emails are not that of Ezidebit Pty Ltd and are that of the sender.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 04 2019 - 11:47:39 CEST