Hi All,

lets start with the First Blog.

#1. Oracle Alert Set up Guide.

Lets make it simple and Quick.

Brief Summary:

Oracle Alert gives you an immediate view of the critical activity in your database. It helps you keep on top of important or unusual business events you need to know about.

Steps for set up alert in Oracle:

Step1:

Navigate to responsibility Oracle Manager:

Give the alert name and insert SQL in Select statement block.

Format:

Select all columns which are required into runtime variable like below:

SELECT mp.organization_code, m.atp_flag, m.SEGMENT1, m.CREATION_DATE

into &organization_code &ATP_Check, &Item, &CREATION_DATE

FROM MTL_SYSTEM_ITEMS_B m, mtl_parameters mp WHERE mp.organization_ID = m.organization_ID

and m.organization_ID = 278 and m.atp_flag = 'Y'

and exists (select 1 from v$database where name = 'TEST');

Now go to Action-> Action details:

Assign Action Set: 

Provide to address and columns, along with subject:

Verify SQL:Should not has any syntax Error.

Step 2:

Now run Check Periodic Alert – SRS program, which will take parameter as Alert name:

If program completes with error/ in case you do not receive mail  check the out put.

This will schedule and perform an action if Alert query return any rows.

Make sure Alert manager (FNDICM)is active

Hope this helps. 

thanks for feedback.