Tag: Oracle

How to Automate Killing Inactive Sessions with Resource Manager

Are you manually (or via a script) killing idle sessions on your database? As a consequence, your users are getting error “ORA-00028: your session has been killed” and probably getting angry at you. What about doing it automatically, in a…

Read More >

How To Downgrade Grid 19c Clusterware to 12.1

There may be many reasons for downgrading from Grid 19c to 12.1; however, the reason I am downgrading is to rerun a test requested by Oracle support from the 12.1 clusterware. Here are the steps performed. ### Check cluster: oracle@ol7-121-rac2…

Read More >

Mining GoldenGate Error Logs for Consumption Rates of Trail Files

After resolving Oracle GoldenGate issues, a question typically asked is, “When will the process catch up?” The usual method to find out is to use the lag command; however, I was more interested to see the rate of the trail…

Read More >

Mining Autoupgrade Results

We wanted to define a consistent process for upgrading databases using an autoupgrade method for single instance databases: Create directory for autoupgrade/log: $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log, where $ORACLE_UNQNAME=db_unique_name Create upgrade.config as shown: $ORACLE_BASE/admin/$ORACLE_UNQNAME/${ORACLE_UNQNAME}_upgrade.config global.autoupg_log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.dbname=$ORACLE_UNQNAME upg1.sid=$ORACLE_SID upg1.start_time=NOW upg1.source_home=/oracle/app/product/11.2/dbhome_1 upg1.target_home=/oracle/app/product/12.2/dbhome_1 upg1.upgrade_node=localhost upg1.target_version=12.2 upg1.timezone_upg=no…

Read More >

Do Not Mix Different Patch Types

I was preparing to apply a July 2019 path for a single instance database without ASM. Here are the available patch types for Oracle Database: PSU, SPU(CPU), Bundle Patches (Versions 12.1 & lower) via Doc ID 2118136.2 Review current patch…

Read More >

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 >
Page 4 of 163« First Page...23456...10...Last Page »