OraFAQ Forum: Server Administration » Do I need to explicity run datapatch after upgrading

Home » RDBMS Server » Server Administration » Do I need to explicity run datapatch after upgrading (12.1.0.2, Linux x86-64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do I need to explicity run datapatch after upgrading [message #677029]

Thu, 08 August 2019 03:54

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!

Report message to a moderator

Re: Do I need to explicity run datapatch after upgrading [message #677030 is a reply to message #677029]

Thu, 08 August 2019 04:21

John Watson
Messages: 8960
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?

Report message to a moderator

Re: Do I need to explicity run datapatch after upgrading [message #677032 is a reply to message #677030]

Fri, 09 August 2019 00:40

juniordbanewbie
Messages: 250
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!

Report message to a moderator

Re: Do I need to explicity run datapatch after upgrading [message #677036 is a reply to message #677032]

Fri, 09 August 2019 23:34

juniordbanewbie
Messages: 250
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

Report message to a moderator

Re: Do I need to explicity run datapatch after upgrading [message #677041 is a reply to message #677036]

Sun, 11 August 2019 01:15

John Watson
Messages: 8960
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)

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 06:49:35 CST 2024