DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Tuesday, June 26, 2012

Query for Scheduled request start on prior run less than 5 mins

select cs.request_id,cs.concurrent_program_id,cs.program,cs.argument_text,cr.resubmit_interval_type_code,cs.requestor,resubmit_interval,resubmit_interval_unit_code from fnd_concurrent_requests cr,fnd_conc_req_summary_v cs where
and cs.status_code in ('I','Q')
resubmit_interval_type_code='START' and cr.request_id=cs.request_id
and resubmit_interval_unit_code='MINUTES' and resubmit_interval<5

Wednesday, June 20, 2012

ASMlib for RHEL6

Dear all,

Oracle has not yet released ASMlib for RHEL6 yet.

Oracle's policy about this can be found in the metalink document id 1089399.1

Regarding ASMLIB Oracle mentioned in note 1089399.1 :

For RHEL 6, Oracle will provide ASMLib software and updates only when configured with a kernel distributed by Oracle.

Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL 6.

ASMLib updates will be delivered via Unbreakable Linux Network (ULN), which is available to customers with Oracle Linux support.

ULN works with both Oracle Linux or Red Hat Linux installations, but ASMLib usage will require replacing any Red Hat kernel with a kernel provided by Oracle.

Instead of ASMLIB , We can use Udev for oracle 11G clusters. you can refer to ID 371814.1

Narasimha Rao

Monday, June 11, 2012

Script to find who has changed the sysadmin Password

The below script helps us to find the user_name who has changed the sysadmin password

SELECT substr(d.user_name,1,30) || '~'||substr(f.user_name,1,10)||'~'||substr(d.last_update_date,1,10) key,count(*) value
from apps.fnd_user d, apps.fnd_user f
trunc(d.last_update_date) = trunc(sysdate)
and d.user_name='SYSADMIN'
and d.last_updated_by=f.user_id GROUP BY substr(d.user_name,1,30) || '~'||

! Happy that it helps you :) !.

Narasimha Rao