Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Documents on Cheetah Python in Oracle

Rajesh123Apr 20 2017 — edited Apr 21 2017

Hi All,

I am completely new to Cheetah Python in Oracle.

can you please share some document on this?

I will need to create form using Cheetah Python

Comments

Kanda-Oracle

Hi JC

Its for the different DB version with different patch levels . There is one release Oracle 12.1.0.2.0 . Please check it and choose it

Thanks

N Kandasamy

Beauty_and_dBest

Thanks Kanda,

I have download the 12.1.0.2 versions, but one patch 28259867 is superseded by a very big patch 28833531 (3Gb).

Patch 28833531 - Database Proactive Bundle Patch 12.1.0.2.190115

pastedImage_1.png

How do you apply this big patch? Do I need to apply this patch? Is ETCC really reliable?

I understand there are lots of conflicts it will take, and need to rollback?

Please help....

Kanda-Oracle

Patch 28833531 is recommend in (Doc ID 1594274.1)

Kanda-Oracle

can you share are you using  Database In-Memory option ?

Beauty_and_dBest

I think we are not using in-memory?

We only use generic cheap server configuration.

Beauty_and_dBest

Hi Kanda, and ALL,

Why does ETCC is listing missing patches but all have conflicts

It seems ETCC is "useless" after all?

Do I just ignore all?

I tried to apply patch  26336977, but it has conflict, and so with all the rest.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

26336977, 26925263, 27322338

Whole composite patch Conflicts/Supersets are:

Patch : 26336977

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

26654363, 26925263, 27322338

Whole composite patch Conflicts/Supersets are:

Patch : 26654363

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

26742604, 27322748

Conflicts/Supersets for each patch are:

Patch : 26742604

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

26925263, 27322338, 28500816

Whole composite patch Conflicts/Supersets are:

Patch : 28500816

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

26925263, 28507324

Whole composite patch Conflicts/Supersets are:

Patch : 28507324

Please help....

Kind regards,

Kanda-Oracle

not sure. DB support team may suggest you to go for latest DATABASE PATCH SET UPDATE .

for example  12.1.0.2.190115

Patch 28729169: DATABASE PATCH SET UPDATE 12.1.0.2.190115

lmu
Answer

Oracle just updated the ETCC yesterday to include the latest update.

Find the patch in the patches and update tab -> Search for the patch.  When the patch page comes up, click the 'Analyze with Opatch' button. That will take you to the patch conflict checker.

You need to upload opatch lsinventory -details..

It gave me details of the merge patches I needed right away.  There was no waiting.   it also gave me the patches I could download.

Marked as Answer by Beauty_and_dBest · Sep 27 2020
Beauty_and_dBest

Thanks Imu,

I will try that...brb

Beauty_and_dBest

Hi Imu,

I download latest ETCC.

Then I run checking and still the same output as before

Can you please explain further the process you have done?

Where do I upload the "opatch lsinventory -detail? to Oracle Support?

Where do I search the missing patch?

Thanks a lot.

$ ./checkDBpatch.sh

+===============================================================+

|    Copyright (c) 2005, 2019 Oracle and/or its affiliates.     |

|                     All rights reserved.                      |

|             Oracle E-Business Suite Release 12.2              |

|          Database EBS Technology Codelevel Checker            |

+===============================================================+

Using context file from currently set database environment:

/u03/ora1228p/P1228/12.1.0/appsutil/P1228_testsvr3.xml

Starting Database EBS Technology Codelevel Checker, Version 120.70

Thu Feb 14 21:05:58 +08 2019

Log file for this session : /u01/PATCH/ETCC/log/checkDBpatch_15692.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database P1228 is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.45

This file will be used for identifying missing bugfixes.

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.20

This file will be used for mapping bugfixes to patches.

Checking Bugfix XML file for 12.1.0.2_BP

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.2.0.1.8.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2.180116ProactiveBP

Patch mapping not available.

Patch mapping data is not available for 12.1.0.2 ProactiveBP

Some required one-off bugfixes are missing from the Database ORACLE_HOME.

The missing bugfixes are:

26336977

26654363

26742604

28507324

28731800

** Refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix. If an overlay patch is needed for any particular patch listed, the footnote for that patch also applies to the overlay patch. **

Apply the missing bugfixes and then rerun the script.

Stored Technology Codelevel Checker results in the database P1228 successfully.

Finished checking fixes for Oracle Database: Thu Feb 14 21:06:20 +08 2019

Log file for this session: /u01/PATCH/ETCC/log/checkDBpatch_15692.log

===============================================================================

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2017
Added on Apr 20 2017
5 comments
503 views