Tag: Oracle

How To Resolve Database Software Install To Incorrect Location

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/12.2.0.1/db1 by mistake. This post will demonstrate an incorrect method to resolve the issue, and then the correct method….

Read More >

How reliable is autoupgrade.jar analyze mode?

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 11.2.0.4 to…

Read More >

How to fix Error: OMSPatcher finds that previous patching session is not yet completed

When planning a patch for a client’s OMS, I found the following: OMSPatcher finds that previous patching session is not yet completed. Please refer log file “/u01/app/oracle/middleware/cfgtoollogs/omspatcher/28018178/omspatcher_2019-07-09_23-44-58PM_deploy.log” for the previous session and execute the script “/u01/app/oracle/middleware/.omspatcher_storage/oms_session/scripts_2019-07-09_23-44-39PM/run_script_singleoms_resume.sh” to complete the previous…

Read More >

Custom fix required for txkCfgOC4JApp.pl when using latest JDK with Oracle E-Business Suite R12.1.3

A while back, we had a seasonal technology stack update for one of our client’s R12.1.3 Oracle E-Business Suite instance. One of the changes introduced was Oracle JDK 7 Update 241, which has a lot of known SSL/TLS protocol and…

Read More >

How to fix EBS weblogic admin console when not accessible after CPU patching

With the recent CPU patching on Oracle E-Business suite R12.2, many customers faced issues with accessible weblogic admin console from browser. This security enhancement started with the April 2019 CPU via Patch 29524595 using weblogic connection filters. More details on…

Read More >

How to install Vertica for test purposes

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The following instructions show how to create a Vertica database…

Read More >

How to use createGoldImage For Cloning in 19c

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 >

Oracle E-Business Suite and 12cR1 database in Extended support – What to do?

If you are one of the folks who have already upgraded the production E-Business Suite database to 19c Certified, then you are a superhero and this post is not for you. The majority of us are still running the good…

Read More >

How to Find Clusterware Configuration Details Using srvctl

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: 18.0.0.0.0 or higher. oracle@ol7-19-rac2 ~]$ echo $ORACLE_HOME…

Read More >

How To Fix ASM Disk Header Status from “FORMER” To “MEMBER”

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 >
Page 3 of 16212345...10...Last Page »