Home » RDBMS Server » Server Administration » Do I need to explicity run datapatch after upgrading (12.1.0.2, Linux x86-64)
Do I need to explicity run datapatch after upgrading [message #677029] Thu, 08 August 2019 03:54 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

I was about to upgrade 11.2.0.4 to 12.1.0.2 and later told that I was supposed to patch it with 20080249

Quote:

Patch Post Install Instructions:

Table 3 Steps to Run the datapatch Utility for Single Tenant Versus Multitenant
(CDB/PDB)
1. Single Tenant (non-CDB/PDB):
1 % sqlplus /nolog
2 SQL> Connect / as sysdba
3 SQL> startup
4 SQL> quit
5 % cd $ORACLE_HOME/OPatch
6 % ./datapatch -verbose
I open up the content of $DB_BASE/product/12.1.0.2/dbhome_1/OPatch/datapatch


ORACLE_HOME/sqlpatch/sqlpatch $@



but both catupgrd.sql and catuppst.sql does not contain sqlpatch, so after upgrading my database from 11.2.0.4 to 12.1.0.2
do I need to explicity run

5 % cd $ORACLE_HOME/OPatch
6 % ./datapatch -verbose


My hunch is probably yes. Can anyone confirm?


many thanks in advance!

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Service name or network name of service icdbXDB in the PDB is invalid or conflicts with an existing
Next Topic: How To View Contents of the Alert Log using a Query
Goto Forum:
  


Current Time: Wed May 01 16:53:57 CDT 2024