Due to complex requirements for service relocate and restore as part of patching, I decided to script the process. Requirements: Existing configuration: Save existing services affinity: Note: /tmp/service_hawk*.conf is read-only to prevent accidental overwrite. Patching starts from instance1 and relocate…Read More >
GRID Out Of Place (OOP) patching completed successfully for 126.96.36.199.0. GRID_HOME=/u01/188.8.131.52/grid_2 ORACLE_HOME=/u01/app/oracle/184.108.40.206/db1 Here is an example of the inventory after patching. Run cluvfy was successful, too. GRID OOP Rollback Patching completed successfully for node1. GRID OOP Rollback Patching completed successfully…Read More >
The environment started with a GRID 220.127.116.11 installation, upgraded to 18.104.22.168, and performed out-of-place patching (OOP) to 22.214.171.124. As a result, there are three GRID homes and, ideally, we should remove 126.96.36.199 to save space because it’s longer required. This…Read More >
I was not satisfied with using fuser -mv to identify processes causing DBFS failure to unmount and killing the processes haphazardly. Upon further investigation, mount-dbfs.sh can be used to kill processes causing “Device or resource busy” and unmount DBFS. One…Read More >
So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the following when checking DBFS: I will demonstrate the simple command I used to ensure that all services that are supposed…Read More >
Stop a CRS error with [Stop of ‘ora.crsd’ on ‘host02’ failed.]. I will demonstrate my attempts to troubleshoot and identify the cause for failure. # crsctl stop crs DBFS is registered and managed by CRS: $ $GRID_HOME/bin/crsctl stat res -w…Read More >
WhenI was upgrading Grid to 18c, the final step was to run gridSetup.sh -executeConfigTools, which failed. Unfortunately, the error provided was not very descriptive or useful. In this post, I will demonstrate how I went about troubleshooting the failure. To…Read More >
“Good artists copy, great artists steal” – Pablo Picasso I am currently using Vagrant boxes from Mikael Sandström (oravirt) and unfortunately, it did not have X11 configured. Typically, using CLI is better for automation; however, there may come a time…Read More >
When installing Oracle GoldenGate for Big Data, it’s better to not delete the README file as it provides the version for GoldenGate Java Adapter. The version for GoldenGate ggsci is 188.8.131.52 while the version for Java Adapter is 184.108.40.206. The…Read More >
GoldenGate operates in an active/passive capacity for RAC databases. When installing GoldenGate on a local host, certain directories are required to be on shared storage. I will share my opinions for which directories should be placed on shared storage. Determine…Read More >
© Copyright 2019 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.