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 next message
juniordbanewbie
Messages: 239
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!

Re: Do I need to explicity run datapatch after upgrading [message #677030 is a reply to message #677029] Thu, 08 August 2019 04:21 Go to previous messageGo to next message
John Watson
Messages: 8046
Registered: January 2010
Location: Global Village
Senior Member
If the readme says to run datapatch, then you had better do so. However, why are you applying that patch at all? Should you not be applying the latest quarterly RU, released in July?
Re: Do I need to explicity run datapatch after upgrading [message #677032 is a reply to message #677030] Fri, 09 August 2019 00:40 Go to previous messageGo to next message
juniordbanewbie
Messages: 239
Registered: April 2014
Senior Member
Dear John,

are you saying that it should be a practice to apply the latest quarterly patch?

I was told to apply the patch. Normally my company practice is that we only apply patches when told to do so.

I just apply patch 20080249. it fails.


SQL> exec ctx_ddl.create_preference('CTXSYS.JSONREST_ENGLISH_LEXER', 'AUTO_LEXER');
BEGIN ctx_ddl.create_preference('CTXSYS.JSONREST_ENGLISH_LEXER', 'AUTO_LEXER'); END;

*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10701: preference CTXSYS.JSONREST_ENGLISH_LEXER already exists
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVLSB", line 17
ORA-06512: at "CTXSYS.CTX_DDL", line 22
ORA-06512: at line 1


seems that I might have to rollback this patch and applies the latest quarterly patch which I believe would have resolve the issues that I encounter

I will also inform my company head that we should apply latest quarterly patch.

many thanks in advance!
Re: Do I need to explicity run datapatch after upgrading [message #677036 is a reply to message #677032] Fri, 09 August 2019 23:34 Go to previous messageGo to next message
juniordbanewbie
Messages: 239
Registered: April 2014
Senior Member
Dear all,

when I clicked the latest patchset I have the following list:

Quote:


Oracle 12.1.0.2.190716 RDBMS Server (rdbms)

Oracle 12.1.0.2.190716 for ACFS RDBMS Server (rdbms)

Oracle 12.1.0.2.190716 for OCW RDBMS Server (rdbms)

Oracle 12.1.0.2.190716 OJVM Database RDBMS Server (rdbms)

Oracle 12.1.0.2.190716 Proactive BP
which one should I choose

Oracle 12.1.0.2.190716 RDBMS Server (rdbms)
or
Oracle 12.1.0.2.190716 Proactive BP

many thanks in advance
Re: Do I need to explicity run datapatch after upgrading [message #677041 is a reply to message #677036] Sun, 11 August 2019 01:15 Go to previous message
John Watson
Messages: 8046
Registered: January 2010
Location: Global Village
Senior Member
Oracle 12.1.0.2.190716 RDBMS Server (rdbms) and Oracle 12.1.0.2.190716 OJVM Database RDBMS Server (rdbms)
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: Mon Nov 11 23:55:07 CST 2019