Exadata Cloud – Post Provisioning Exadata Configuration – Part 2

This is Part 2 of the Post Provisioning of Exadata Cloud

Here we will update the Tooling software necessary to support Exadata Patching.

Exadata Tooling Update

[root@phxdbm-o3eja1 exadbcpatch]# /var/opt/oracle/exapatch/exadbcpatchsm – list_tools
INFO: non async case
INFO: cmd is: /var/opt/oracle/exapatch/exadbcpatch -list_tools

Starting EXADBCPATCH
Logfile is /var/opt/oracle/log/exadbcpatch/exadbcpatch_2018-02- 28_22:37:23.log
Config file is /var/opt/oracle/exapatch/exadbcpatch.cfg

INFO: oss_container_url is not given, using INFO: tools images available for patching

‘last_async_precheck_txn_id’ => ‘

‘last_async_apply_txn_id’ => ‘ ‘errmsg’ => ”,
‘err’ => ”, ‘current_version’ => ‘180104’, ‘last_async_precheck_patch_id’ ‘current_patch’ => ‘180104’, ‘last_async_apply_patch_id’ => ‘patches’ => [

‘,

‘ ‘,

{
‘patchid’ => ‘17.4.1.2.0BM_180223’, ‘last_precheck_txnid’ => ”, ‘description’ => ‘DBaaSTools for ECS OCI’

} ]

<json begin>{“last_async_precheck_txn_id”:” “,”last_async_apply_txn_id”:” “,”err”:””,”errmsg”:””,”current_version”:”180104″,”last_async_precheck_patch_ id”:” “,”current_patch”:”180104″,”last_async_apply_patch_id”:” “,”patches”:[{“patchid”:”17.4.1.2.0BM_180223″,”last_precheck_txnid”:””,”descr iption”:”DBaaSTools for ECS OCI”}]}<json end>

=> ‘ ‘,

[root@phxdbm-o3eja1 exadbcpatch]# /var/opt/oracle/exapatch/exadbcpatchsm – toolsinst_async ‘17.4.1.2.0BM_180223’
INFO: async case
INFO: patch number given is : 17.4.1.2.0BM_180223

INFO: check for this action toolsinst_async
<start txn>69<end txn>
INFO: command to be run is: /var/opt/oracle/exapatch/exadbcpatch – toolsinst_async -rpmversion=17.4.1.2.0BM_180223
INFO: system cmd is: “nohup /var/opt/oracle/exapatch/exadbcpatch – toolsinst_async -rpmversion=17.4.1.2.0BM_180223 “
[root@phxdbm-o3eja1 exadbcpatch]# /var/opt/oracle/exapatch/exadbcpatchsm – list_tools
INFO: non async case
INFO: cmd is: /var/opt/oracle/exapatch/exadbcpatch -list_tools
Starting EXADBCPATCH
Logfile is /var/opt/oracle/log/exadbcpatch/exadbcpatch_2018-02- 28_22:42:27.log
Config file is /var/opt/oracle/exapatch/exadbcpatch.cfg

INFO: oss_container_url is not given, using the default INFO: tools images available for patching

$VAR1 = {
‘last_async_precheck_txn_id’ => ‘ ‘,

‘last_async_apply_txn_id’ => ‘ ‘,

‘errmsg’ => ‘no applicable dbaastools rpms found: check exadbcpatch.log in /var/opt/oracle/log/exadbcpatch’,

‘err’ => ‘-1’,
‘current_version’ => ‘180223’, ‘last_async_precheck_patch_id’ => ‘ ‘, ‘current_patch’ => ‘180223’, ‘last_async_apply_patch_id’ => ‘ ‘, ‘patches’ => []

};

<json begin>{“last_async_precheck_txn_id”:” “,”last_async_apply_txn_id”:” “,”err”:”-1″,”errmsg”:”no applicable dbaastools rpms found: check exadbcpatch.log in /var/opt/oracle/log/exadbcpatch”,”current_version”:”180223″,”last_async_prech eck_patch_id”:” “,”current_patch”:”180223″,”last_async_apply_patch_id”:” “,”patches”:[]}<json end>

[root@phxdbm-o3eja1 ~]# /var/opt/oracle/exapatch/exadbcpatchsm -get_status 8

# /var/opt/oracle/exapatch/exadbcpatchmulti -precheck_async 26737266-GI – sshkey=/home/opc/.ssh/id_rsa -instance1=phxdbm-o3eja1:/u01/app/12.2.0.1/grid -instance2=phxdbm-o3eja2:/u01/app/12.2.0.1/grid -instance3=phxdbm- o3eja3:/u01/app/12.2.0.1/grid -instance4=phxdbm- o3eja4:/u01/app/12.2.0.1/grid

INFO: number of nodes – 4
INFO: Master transaction id is : 70 <json begin>70<json end>
$VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja1’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};
INFO: hostname : phxdbm-o3eja1

INFO: ohomes : /u01/app/12.2.0.1/grid
INFO: sshkey being used is /home/opc/.ssh/id_rsa for phxdbm-o3eja1
INFO: cmd being run is: sudo /var/opt/oracle/exapatch/exadbcpatchsm – precheck_async 26737266-GI -patch_homes=/u01/app/12.2.0.1/grid – txn_fl=/home/opc/txnid_fl.248762
INFO: running on the node phxdbm-o3eja1
INFO: host and txn id given : phxdbm-o3eja1 and 71
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: host and txn id given : phxdbm-o3eja1 and 71
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: host and txn id given : phxdbm-o3eja1 and 71
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: host and txn id given : phxdbm-o3eja1 and 71
INFO: status seen is: Precheck completed
INFO: status of slave txn###: Precheck completed on phxdbm-o3eja1
INFO: -precheck_async completed on phxdbm-o3eja1:/u01/app/12.2.0.1/grid $VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja2’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};
INFO: hostname : phxdbm-o3eja2

INFO: ohomes : /u01/app/12.2.0.1/grid
INFO: sshkey being used is /home/opc/.ssh/id_rsa for phxdbm-o3eja2 INFO: cmd being run is: ssh -q -t -i /home/opc/.ssh/id_rsa -o StrictHostKeyChecking=no opc@phxdbm-o3eja2 sudo /var/opt/oracle/exapatch/exadbcpatchsm -precheck_async 26737266-GI – patch_homes=/u01/app/12.2.0.1/grid -txn_fl=/home/opc/txnid_fl.248762 INFO: running on the node phxdbm-o3eja2
INFO: host and txn id given : phxdbm-o3eja2 and 17

INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja2 ….

INFO: status seen is: Precheck completed
INFO: status of slave txn###: Precheck completed on phxdbm-o3eja2
INFO: -precheck_async completed on phxdbm-o3eja2:/u01/app/12.2.0.1/grid INFO: number of nodes – 4
INFO: Master transaction id is : 72
<json begin>72<json end>
$VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja1’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};

# /var/opt/oracle/exapatch/exadbcpatchmulti -apply_sync 26737266-GI – sshkey=/home/opc/.ssh/id_rsa -instance1=phxdbm-o3eja1:/u01/app/12.2.0.1/grid -instance2=phxdbm-o3eja2:/u01/app/12.2.0.1/grid -instance3=phxdbm- o3eja3:/u01/app/12.2.0.1/grid -instance4=phxdbm- o3eja4:/u01/app/12.2.0.1/grid -run_datasql=1

INFO: number of nodes – 4
INFO: Master transaction id is : 72 <json begin>72<json end>
$VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja1’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};
INFO: hostname : phxdbm-o3eja1

INFO: ohomes : /u01/app/12.2.0.1/grid
INFO: sshkey being used is /home/opc/.ssh/id_rsa for phxdbm-o3eja1
INFO: cmd being run is: sudo /var/opt/oracle/exapatch/exadbcpatchsm – apply_async 26737266-GI -patch_homes=/u01/app/12.2.0.1/grid – txn_fl=/home/opc/txnid_fl.290963
INFO: running on the node phxdbm-o3eja1
INFO: host and txn id given : phxdbm-o3eja1 and 73
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: host and txn id given : phxdbm-o3eja1 and 73
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: number of nodes – 4
INFO: Master transaction id is : 72
<json begin>72<json end>
$VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja1’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};
INFO: hostname : phxdbm-o3eja1

INFO: ohomes : /u01/app/12.2.0.1/grid
INFO: sshkey being used is /home/opc/.ssh/id_rsa for phxdbm-o3eja1
INFO: cmd being run is: sudo /var/opt/oracle/exapatch/exadbcpatchsm – apply_async 26737266-GI -patch_homes=/u01/app/12.2.0.1/grid – txn_fl=/home/opc/txnid_fl.290963
INFO: running on the node phxdbm-o3eja1
INFO: host and txn id given : phxdbm-o3eja1 and 73
INFO: status seen is: Running: precheck in progress
INFO: status of slave txn###: Running: precheck in progress on phxdbm-o3eja1 INFO: host and txn id given : phxdbm-o3eja1 and 73
INFO: status seen is: Running: precheck in progress

INFO: status of slave txn###: Running: config in progress on phxdbm-o3eja1 INFO: -apply_async completed on phxdbm-o3eja1:/u01/app/12.2.0.1/grid $VAR1 = {

‘cur_patchid’ => ”,
‘hostname’ => ‘phxdbm-o3eja1’, ‘ohomes’ => ‘/u01/app/12.2.0.1/grid’, ‘new_version’ => ”, ‘patch_completed’ => ”, ‘new_patchid’ => ”,
‘cur_version’ => ”,
‘apply_passed’ => ”

};
INFO: hostname : phxdbm-o3eja1

[grid@phxdbm-o3eja1 OPatch]$ /u01/app/12.2.0.1/grid/OPatch/opatch lspatches 26928563;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:170711) (26928563) 26925644;OCW RELEASE UPDATE 12.2.0.1.0(ID:171003) (26925644) 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) 26737232;ACFS RELEASE UPDATE 12.2.0.1.0(ID:170823) (26737232) 26710464;Database Release Update : 12.2.0.1.171017 (26710464)

OPatch succeeded.
[grid@phxdbm-o3eja1 OPatch]$ pwd
/u01/app/12.2.0.1/grid/OPatch
[grid@phxdbm-o3eja1 OPatch]$ ssh phxdbm-o3eja2 /u01/app/12.2.0.1/grid/OPatch/opatch lspatches
26928563;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:170711) (26928563) 26925644;OCW RELEASE UPDATE 12.2.0.1.0(ID:171003) (26925644) 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) 26737232;ACFS RELEASE UPDATE 12.2.0.1.0(ID:170823) (26737232) 26710464;Database Release Update : 12.2.0.1.171017 (26710464)

OPatch succeeded.
[grid@phxdbm-o3eja1 OPatch]$ ssh phxdbm-o3eja3 /u01/app/12.2.0.1/grid/OPatch/opatch lspatches
26928563;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:170711) (26928563) 26925644;OCW RELEASE UPDATE 12.2.0.1.0(ID:171003) (26925644) 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) 26737232;ACFS RELEASE UPDATE 12.2.0.1.0(ID:170823) (26737232) 26710464;Database Release Update : 12.2.0.1.171017 (26710464)

OPatch succeeded.
[grid@phxdbm-o3eja1 OPatch]$ ssh phxdbm-o3eja4 /u01/app/12.2.0.1/grid/OPatch/opatch lspatches
26928563;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:170711) (26928563) 26925644;OCW RELEASE UPDATE 12.2.0.1.0(ID:171003) (26925644) 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) 26737232;ACFS RELEASE UPDATE 12.2.0.1.0(ID:170823) (26737232) 26710464;Database Release Update : 12.2.0.1.171017 (26710464)

OPatch succeeded.