During the upgrade/patch of our grid from 12.2 to 18.8 with the below command, we got a failure during the “upgradeSchema -fromversion 12.2.0.1.0” section of…
BEGIN — Prepare the pending area DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE( plan => ‘OLTP_PLAN’ ,group_or_subplan => ‘SYS_GROUP’ ,new_cpu_p1 => 30 ); DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE( plan => ‘OLTP_PLAN’ ,group_or_subplan =>…
1_PDF_RAC1120InstallOnOEL58ZFSDownload
FIND & DELETE Find and delete files with .aud extension in some path older than 14 days: When the number of files is huge, the…
First, let’s create our own audit log table to track the info about the host and time of the attempt: Then create the trigger: Now,…
There might be many reasons to export the Oracle object statistics. For example, you may want to save the current statistics, that is to say,…
12_PDF_121SIOnOEL62OnASMDownload
11_PDF_112SIOnRHEL68OnASMDownload
10_PDF_112SIOnRHEL68Download