ODI - Sql query to monitor TEMP size and resize

Query to monitor the temp total, used and free space in mb:

Select A.tablespace_name tablespace , D.mb_total, SUM(A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total - SUM(A.used_blocks * D.block_size) / 1024 / 1024 mb_free

From v$sort_segment A, ( select B.name, C.block_size, SUM(C.bytes) / 1024 / 1024 mb_total from v$tablespace B, v$tempfile C where B.ts#= C.ts#

Group by B.name, C.block_size) D

Where A.tablespace_name = D.name

Group by A.tablespace_name, D.mb_total

Query to Resize the temp file space:

Alter Database TEMPFILE 'tempfile' RESIZE 300G

ODI 11g and 12c Architecture

 

ODI 12c - Standalone and J2ee agent configuration

Steps to configure Standalone and J2ee agent:

Go to ODI installed path Oracle/Middleware/Oracle_Home/oracle_common/common/bin and run config 

Create a new domain.

Select templates to be installed required for Agents

Create an Admin server

Create ODI manage servers.

Create Machine

Create Standalone agent

Run installNodeMgrSvc

Services.msc in run and start it

Odiconsole 

Start the standalone agent

Once weblogic started, login console and check alll servers, deployment etc and test your created both standalone and j2ee agent.

From Weblogic, you can go to Deployments -- OracleDIAgent -- testing  to test the oracle j2ee agent.

ODI 12c - CKM with Flow control and Static control and Recycle errors

Here, we will show the setups required for Flow control , Static control and Recycle errors.

Brief steps:

1. Create a Primary key constraint on target data store.

2. Create a map and Select flow or static or recycle errors option

Flow diagram for LKM, IKM,CKM:

Implementation steps:

Step1: open the target data store constraints and control tab to checj if there is any duplicate rows.

Step2: Create  a new map and prividd LKM, IKM and Flow control as False and Statc control as true and run. You will see the the duplicate or null errors in E$_EMP table.

Step3: Now make Flow control also True

Step4: Now make Recycle errors as True