We were recently required to install database software to /u01/app/oracle/12.2/db1. However, when using GUI to install database, software was installed to /u01/app/oracle/220.127.116.11/db1 by mistake. This post will demonstrate an incorrect method to resolve the issue, and then the correct method….Read More >
According to the Oracle documentation About Oracle Database AutoUpgrade, AutoUpgrade utility identifies issues before upgrades, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database. I am currently working on a project to upgrade a database from 18.104.22.168 to…Read More >
The clone.pl script has been deprecated – Database Upgrade Guide: Deprecation of clone.pl Script To clone Oracle software, use createGoldImage and then install the software as usual. DEMO for DB: Source: /u01/app/oracle/product/19.0.0/dbhome_1 Target: /u01/app/oracle/product/19.0.0/dbhome_2 DEMO for GI: Source: /u01/app/19.0.0/grid Target:…Read More >
At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running multiple commands, information can be gathered using one simple command. This should work with srvctl version: 22.214.171.124.0 or higher. oracle@ol7-19-rac2 ~]$ echo $ORACLE_HOME…Read More >
I made an error when creating an Oracle ASM disk group which resulted in not being able to drop or mount the disk group because the ASM header_status was FORMER. The following steps were performed to modify the ASM header_status…Read More >
Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of Oracle you are using. For 19c, GIMR is not required – About the Grid Infrastructure Management Repository However, GIMR is being created to…Read More >
One method to prepare for a Grid Infrastructure (GI) upgrade is to execute runclufy.sh (Cluster Verification Utility). Here, I will demonstrate how I executed runclufy.sh to verify the upgrade, as well as some issues that I encountered. The above is…Read More >
The project I have been working on is migrating GoldenGate trails from DBFS and ACFS. Now that the migration has completed and DBFS database has been dropped, the next step is to reclaim ASM disks. DBFS is running on 2…Read More >
In reviewing Grid Infrastructure Installation and Upgrade Guide for Linux, I discovered the dry-run upgrade mode to test upgrades. With dry-run being a new feature, I tested it first using GUI. From the response file above grid_2019-08-06_00-20-31AM.rsp, create dryRunForUpgradegrid.rsp: Create…Read More >
Starting with 12c, running datapatch may be required after creating a database, depending on the database version and method for creating the database. Instead of having to remember all the variations, it’s much simpler just to run datapatch -prereq after creating…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.