OCI Storage Refresher

 

I. Object Storage:

  --> Bucket Creation --Data/Object

 --> Managing Buckets/Objects

 --> Multipart Uploads

--> Tiers and Auto Tiering Vs Object Lifecycle Management

--> Object Storage Replication

--> Object Copy and Versioning - how to enable versioining

--> How to configure Retention Rules

--> Security of object storage

     a. Pre-Auth Request

     b. Customer managed Keys

     c. Logging 

II. Block Storage:

Block Volume

a. Performance  and Dynamic Perf Scalability

b. Resize of Block Volume

c. Block Volume vs Clone

d. Replicate BV from one region to other region

Volume attachment types

a. ISCSI

b. Para virtualized

Volume Access Types

Multiple Instance Volume Attachments

Boot Volume

Security 

III. File Storage:

 

1. File System Concepts

2. How to create FS and Mount FS

3. NFS Export Option

4. File System Paths

5. Snapshot of FS

6. Clone FS

7. In-transit Encryption

8. FS Usage and Metering

OCI Compute Refresher

 

Images:

a. Platform

b. Custom

c. Bring your own Image

Shapes:

 GPU Shapes

Bare Metal Vs Virtual Machines vs Dedicated VM Hosts

Generate  - SSH Keypair

Launch Compute Instance & Connect

Capacity Type

a. Preemptible

b. Capacity Reservation

c. Dedicated VM Host

Scaling:

a. Vertical

b. Horizonal - AutoScaling

Operating System Managed Service - OSMS:

a. Instance Console Connection 

Burstable 

Shielded 

Confidential Computing

Infrastructure Maintenance Concepts

OCI Network Refresher

 

                                                              OCI Network Refresher

Ram Nanubalu

I. Virtual Cloud Network (VCN):

a. Route Tables (RT)

b. Gateways (GW)

c. VCN Security

II. IP Management Concepts:

 a. Reserved Public IP

-- Bring your own IP

--Public IP Pools

III. Connectivity:

a. Peering

     i. Local and Remote

b. Dynamic Routing Gateway

c. Site to Site VPN Connection

d. Fast Connect

e. Transit Routing

IV. Load Balancers:

a. Load Balancer

b. Network Load Balancer

c. Web Application Acceleration

V. DNS Management

a. Public DNS vs Private DNS

b. Private View

c. Traffic Management Steering Policies

VI. Network Command Center (NCC):

a. Inter Region Regency (IRR)

b. Network Path Analyzer (NPA)

c. Network Path Visualizer (NPV)

d. Capture Filters

e. Virtual Text Access Points

  

OCI IAM Refresher

 

1. Identity Domains:

2. Users/Groups:

3. Administrator Roles

4. IAM Policies

a. Syntax

b. Policy Actions & Placement

5. Compartments

6. Quotas/Budgets:

7. Granular Access Control

8. Policy Inheritance

Conditional Policies

TBAC

9. Network Source

10. Dynamic Groups

Right size your Exadata system, database, and host with OCI Ops Insights' latest features,

https://blogs.oracle.com/observability/post/right-size-exadata-host-ops-insights-

ETCC Tool for Finding Mandatory EBS 12.2 Patches

 [oracle@lufRAMfebstl011 <RUN> ]$ cp -p txk_R1220_MT_base_bugs.xml /tmp/Ram/mw

Middle Tier: checkMTpatch.sh

Database: checkDBpatch.sh

The ETCC utility can be downloaded via Patch 17537119 from My Oracle Support.

--> Patch 17537119: EBS 12.2 TECHNOLOGY CODELEVEL CHECKER (ETCC)

[oracle@lufRAMfebstl011 <RUN> ]$ ./checkMTpatch.sh

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

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

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |        Application Tier EBS Technology Codelevel Checker      |

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

Using context file from currently set applications environment:

/u01/install/APPS/fs1/inst/apps/TRAM1I_lufRAMfebstl011/appl/admin/TRAM1I_lufRAMfebstl011.xml

Starting Application Tier EBS Technology Codelevel Checker, Version 120.0.12020000.70.

Fri Mar 28 12:57:03 EDT 2025

Log file for this session: /tmp/Ram/log/checkMTpatch_461252.log

Bugfix XML file version: 120.0.12020000.64

This file will be used for identifying missing bugfixes.

./mw/txk_R1220_MT_mappings.xml does not exist.

Extract this file from patch zip file to this script execution directory and rerun the script.

Patch mapping not available.

[WARNING] ETCC: Bugfix XML file (./mw/txk_R1220_MT_base_bugs.xml) is more than

 30 days old.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user:

Connecting to database.

Database connection successful.

The installed AD.C.15 codelevel supports storing the results in the database.

Checking for existence of ETCC results table.

Table to store results already exists in database.

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

Oracle Forms and Reports

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

Now examining Oracle Forms and Reports.

Oracle Home: /u01/install/APPS/fs1/EBSapps/10.1.2.

Product version: 10.1.2.3.0.

Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.

All required bugfixes are present for Oracle Forms and Reports.

These results have been stored in the database.

Identified DST version: 23

: integer expression expectedr RSF 10.1.0.5.0 in Oracle Forms../checkMTpatch.sh: line 161: test: 23

  Missing Bugfix: 13417321

The above list shows missing bugfixes for RSF 10.1.0.5.0 in Oracle Forms.

These results have been stored in the database.

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

Oracle Fusion Middleware (FMW) - Web Tier

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

Now examining Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home: /u01/install/APPS/fs1/FMW_Home/webtier.

Product version: 11.1.1.9.0.

Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.

All required bugfixes are present for FMW - Web Tier.

These results have been stored in the database.

Identified DST version: 23

: integer expression expectedr RSF 11.1.0.7.0 in FMW Web tier../checkMTpatch.sh: line 161: test: 23

  Missing Bugfix: 13417321

The above list shows missing bugfixes for RSF 11.1.0.7.0 in FMW Web tier.

These results have been stored in the database.

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

Oracle Fusion Middleware (FMW) - Oracle Common

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

Now examining Oracle Fusion Middleware (FMW) - Oracle Common.

Oracle Home: /u01/install/APPS/fs1/FMW_Home/oracle_common.

Product version: 11.1.1.9.0.

Checking required bugfixes for FMW - Oracle Common 11.1.1.9.0.

  Missing Bugfix: 34714760

The above list shows missing bugfixes for FMW - Oracle Common.

These results have been stored in the database.

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

Oracle WebLogic Server (WLS)

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

Now examining WLS.

Oracle Home: /u01/install/APPS/fs1/FMW_Home/wlserver_10.3.

Product version: 10.3.6.0.231017.awk: fatal: cannot open file `./mw/txk_R1220_MT_mappings.xml' for reading (No such file or directory)

awk: fatal: cannot open file `./mw/txk_R1220_MT_mappings.xml' for reading (No such file or directory)

awk: fatal: cannot open file `./mw/txk_R1220_MT_mappings.xml' for reading (No such file or directory)

awk: fatal: cannot open file `./mw/txk_R1220_MT_mappings.xml' for reading (No such file or directory)

awk: fatal: cannot open file `./mw/txk_R1220_MT_mappings.xml' for reading (No such file or directory)

grep: ./mw/txk_R1220_MT_mappings.xml: No such file or directory

Note: For WLS, patches rather than bugfixes are verified.

Checking required patches for WLS 10.3.6.0.231017../checkMTpatch.sh: line 249: test: too many arguments

All required patches are present for WLS.

These results have been stored in the database.

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

Apply the required bugfixes and rerun this script.

See Doc ID 2877607.1 for any special instructions regarding these patches.

Footnotes in Doc ID 2877607.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for file edition: run.

Fri Mar 28 12:58:00 EDT 2025

Log file for this session: /tmp/Ram/log/checkMTpatch_461252.log

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

References:

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

Files Extract - NBP

 

cd scripts/

506  ls -ltr *get*

  507  ./get_range_files.sh 202208020900 202208030900

./get_range_files.sh 202502082330 202502110008

2/8/2025 23:30 2/11/2025 0:08 AM

Dates:  10/25 - 6 PM to 10/26 – 6 PM

  508  ls -ltr

  509  ./Rangefiles_from_202208020900_to_202208030900.sh

  510  ls -ltr

  511  cd /tmp

gtar -xvf NBP1.gz>REQ0059765.log

find . -type f | wc -l  >REQ0069675.log   

rm  -rf `find . -type f`

chmod -R 777 *

find . -mtime -1 -ls |wc -l

find . -mtime -1 -print

OPP - Heap Space per process

 select DEVELOPER_PARAMETERS from apps.fnd_cp_services where service_id=(select manager_type from apps.fnd_concurrent_queues where concurrent_queue_name='FNDCPOPP');

update apps.fnd_cp_services set DEVELOPER_PARAMETERS='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx3072m' where service_id=(select manager_type from apps.fnd_concurrent_queues where concurrent_queue_name='FNDCPOPP');

OS Quick Tit Bits

1,$s/^/###Ram###/g - disable

1,$s/^###Ram###/g - enable

admanagedsrvctl.sh stopall oacore

admanagedsrvctl.sh stop oacore_server1

$EBS_DOMAIN/servers/

tfactl alertsummary

=====

ps -eo pcpu,pid,user,args|tail -n +2|sort -k1 -r -n|head -20

netstat -a|grep 7001

ps -eaf|grep 7001

du -sh *|grep G

ps -ef|grep -i tns

find .  -type f -size +100M -exec ls -lh {}\;|awk \{print $5,$9}'

find . -type f -mtime +8  -exec ls -ltr {}\;

select to_char(RESETLOGS_TIME, 'DD-MON-YYYY, hh24:mi:ss') from v$database;

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

select originating_timestamp, inst_id, record_id,message_text from sys.X$DBGALERTEXT where originating_timestamp>systimestamp-1 and regexp_like(message_text, '(ORA-|error|fatal|Reason=alter system kill session)') and message_text not like '%opiodr aborting process unknown ospid%' and message_text not like '%E-Business Suite Patch Edition does not exist%';

======

. $RUN_BASE/../EBSapps.env RUN

. $RUN_BASE/../EBSapps.env PATCH

. $RUN_BASE/../../ETCC/CheckMTpatch.sh

==========

SELECT distinct t.user_concurrent_program_name,

r.REQUEST_ID,u.USER_NAME,

to_char(r.ACTUAL_START_DATE,'dd-mm-yy hh24:mi:ss') "Started at",

to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss') "Completed at",round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60)) Etime,

decode(r.PHASE_CODE,'C','Completed','I','Inactive','P ','Pending','R','Running','NA') phasecode,

decode(r.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M',

'No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",r.argument_text "Parameters"

FROM

apps.fnd_concurrent_requests r ,

apps.fnd_concurrent_programs p ,

apps.fnd_concurrent_programs_tl t,

apps.fnd_user u, apps.fnd_conc_req_summary_v v

WHERE 

r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID

AND r.actual_start_date >= (sysdate-103)

--AND r.requested_by=22378

AND   r.PROGRAM_APPLICATION_ID = p.APPLICATION_ID

AND t.concurrent_program_id=r.concurrent_program_id

AND r.REQUESTED_BY=u.user_id

AND v.request_id=r.request_id

--AND r.request_id ='2260046' in ('13829387','13850423')

and t.user_concurrent_program_name like '%Purge%'

order by to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss')

G-Invoicing SYSTEM ID Update

 -- profile option for G-Invoicing Service Host at site level

spool /tmp/ECC_post_clone_steps.log

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('IGT_HOST','qa.ws.igt.ram.gov','SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

/

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM1' where ORG_ID=81;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM2' where ORG_ID=1290;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM3' where ORG_ID=3977;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM4' where ORG_ID=2937;

commit;

update apps.IGT_SSL_CONTEXT_INFO set KEYSTORE_PATH='/u01/install/CUSTOM/ginvoicing/hhsginvoicing.pfx',

TRUSTSTORE_PATH='/u01/install/CUSTOM/ginvoicing/hhsginvqaserver.jks',

IGT_SCHEMA_ORDER_PATH='/u01/install/CUSTOM/ginvoicing/Order_2_3/accounting/Order.xsd',

IGT_SCHEMA_PERF_PATH='/u01/install/CUSTOM/ginvoicing/Performance_2_1/accounting/Performance.xsd';

commit;

spool off;

Kill Session - PID

 for pid in $(ps -ef | grep "/home/oracle/scripts/get_stale_stats_TRAMFI.sh"|awk '{print $2}'); do kill -9 $pid; done

SELECT a.request_id,

       d.sid,

       d.serial#,

       d.osuser,

       c.spid      AS db_spid,

       d.inst_id   AS rac_instance

FROM   apps.fnd_concurrent_requests   a

JOIN   apps.fnd_concurrent_processes  b ON a.controlling_manager = b.concurrent_process_id

JOIN   gv$process                     c ON c.pid = b.oracle_process_id

JOIN   gv$session                     d ON d.audsid = b.session_id

WHERE  a.request_id = 142555872;

SELECT concurrent_program_id,

              user_concurrent_program_name

FROM fnd_concurrent_programs_tl

WHERE user_concurrent_program_name LIKE '%TAS%BETC%';

UPDATE fnd_concurrent_requests

SET phase_code   = 'C',   -- Completed

    status_code  = 'X',   -- Terminated

    completion_text = 'Forcefully terminated by Ram'

WHERE concurrent_program_id = 346365

  AND phase_code = 'R';

COMMIT;

SELECT *

FROM fnd_concurrent_requests

WHERE concurrent_program_id = 346365 --and completion_text like '%Ram'

ORDER BY request_id DESC;