Showing posts with label Patching and upgrading. Show all posts
Showing posts with label Patching and upgrading. Show all posts
Friday, July 12, 2024

Datapatch seems to "hang" or taking an extraordinary long time to complete. What could be wrong?

›
When using the utility datapatch to either apply or rollback patches in my Oracle 19c ORACLE_HOME, I was suprised at the time it took to (i...
Sunday, February 19, 2023

How to identified active files/executables when using opatch to deinstall software

›
During a opatch rollback operation, we saw the following error message in the opatch logfile: [Feb 19, 2023 2:29:51 PM] [INFO] Prerequi...
Thursday, September 15, 2022

What is the catcon.pl script used in a Multitenant Database installation?

›
What is the catcton.pl script? From Doc ID 1932340.1: Oracle has provided script catcon.pl to execute scripts at Container and Pluggable...
Wednesday, February 23, 2022

How to fix the pending_dst_session error when running the preupgrade script

›
If you receive an error during the precheck-phase of an upgrade from 18c to 19c, which points to "pending_dst_sessions", like thi...
Friday, June 25, 2021

utlu122s.sql is replaced from version 19c

›
During upgrades, you will notice that any old script that you've assembled to upgrade 12c and 18c databases, will break when they try ...
Monday, November 4, 2019

What do do when an upgrade from 12cR1 to 18c is seemingly frozen in Phase #:50

›
During an upgrade from 12.1 to 18.0 my upgrade process seemed to be completely frozen at stage 50: Restart Phase #:47 [proddb01] Files...
Tuesday, June 4, 2019

What is the admsi.pl utility that is used during EBS patching?

›
Thanks to the blog post by Atul Kumar for explain this. It's a tool for generating instance-specific patch installation instructions...
Friday, September 21, 2018

Parameters that can be removed after upgrade to 12.2

›
From Information For Parameters _upgrade_optim and _upgrade_capture_noops (Doc ID 2182783.1): Below parameters gets added after upgrade t...
Saturday, September 9, 2017

What is the "datapatch" utility released in Oracle 12c?

›
From Datapatch: Database 12c Post Patch SQL Automation (Doc ID 1585822.1): Datapatch is the new tool that enables automation of post-patch...
3 comments:
Wednesday, September 2, 2015

How to unzip multiple files on a Unix-based operating systems

›
When extracting multiple zip files, remember to use single quotes to mask the zip-files: unzip '*.zip' For example, when unpacking...

Oracle 11g out-of-place vs. in-place database upgrades

›
Starting with Oracle 11gR2, Oracle changed their patching strategy. Previously, a patch set was supposed to be downloaded and installed in...

How to fix error thrown by OPatch: java.lang.NullPointerException

›
Problem: Opatch throws the following error when you are querying the inventory: [oracle@lx01 ~]$ opatch lsinventory Oracle Interim Patc...
Wednesday, June 11, 2014

How to disable an event parameter in the database

›
During an Upgrade from 11.2.0.3 to 11.2.0.4 I had to remove an event-parameter in the database. The syntax for this is: alter system set ...
Wednesday, May 14, 2014

How to confirm that the latest PSU has been applied to your ORACLE_HOME

›
Use opatch lsinventory to extract the information. In my case: hostname:PRODDB01>opatch lsinventory | egrep -i 'PSU|DATABASE PATCH ...