foalabs

How to Find which Files Are Backed Up In RMAN Backup Set  Query to find the  Backed Up Logs. SQL> select recid,set_stamp,sequence#,first_change#,next_change#       from  v$backup_redolog; The V$BACKUP_REDOLOG view queries the Control File so this can be done with or without a Catalog. Query to find sequence is kept in which backup piece SQL> select r.sequence#, p.handle from v$backup_piece p, v$backup_redolog r where r.set_stamp = p.set_stamp and r.set_count = p.set_count and r.sequence# = 63 Query to find datafiles  is kept  in which backup piece.   SQL> select d.file#, p.handle from v$backup_piece p, v$backup_datafile d where d.set_stamp = p.set_stamp   and d.set_count = p.set_count   and d.file# = 3

Query to find Session details using SPID with full details Script: set serveroutput on; define uxproc=18677; /* enter your spid here*/ DECLARE   v_sid number;   vs_cnt number;   s sys.v_$session%ROWTYPE;   p sys.v_$process%ROWTYPE;   cursor cur_c1 is select sid from sys.gv_$process p, sys.gv_$session s  where  p.addr  = s.paddr and  (p.spid =  '&uxproc' or s.process = '&uxproc'); BEGIN     dbms_output.put_line('====================================================================='); select nvl(count(sid),0) into vs_cnt from sys.v_$process p, sys.v_$session s  where  p.addr  = s.paddr and  (p.spid =  '&uxproc' or s.process = '&uxproc'); dbms_output.put_line(to_char(vs_cnt)||' sessions were found with '||'&uxproc'||' as their unix process id.');   dbms_output.put_line('====================================================================='); open cur_c1; LOOP...

Concurrent Manager Recovery Wizard In Oracle Application earlier we used CMCLEAN.sql.  This script re-sets the flags for requests to completed to allow the Managers to come up. No longer supported and MUST not be used. Concurrent Manager Recovery Wizard has to be used. It is a OAM managed GUI for recovering Concurrent Manager. It should only be run when the concurrent manager services are down. How to use Concurrent Manager Recovery Wizard. Go to OAM > Site Map > Diagnostics and Repair > Troubleshooting Wizards > Concurrent Manager Recovery Ensure that the Concurrent Manager is down prior to progressing with launching the Wizard This step will let you know if any of the concurrent managers are with status Running via backend tables, we can update directly here if we know for sure that managers are down. This step will let  you know if any of the concurrent processes are running, we can directly update status here in GU...

How to make a FND_USER Non SSO in and SSO enabled EBS Environment Steps: 1) Connect as Apps user 2) SQL> @$FND_TOP/patch/115/sql/fndssouu.sql HIMANSHU.SINGH PL/SQL procedure successfully completed. Commit complete. 3) Set profile  Applications SSO Login Types  at user level to "LOCAL" 4) Reset Password for user using FNDCPASS. Password is changed successfully for user HIMANSHU.SINGH. FNDCPASS completed successfully. 5) Login with Non SSO URL

Query to find Concurrent Request Details from Concurrent Program Name Script SELECT    distinct user_concurrent_program_name,     responsibility_name,     request_date,     argument_text,     request_id,     phase_code,     status_code,     logfile_name,     outfile_name,     output_file_type,     hold_flag,     user_name FROM     fnd_concurrent_requests fcr,     fnd_concurrent_programs_tl fcp,     fnd_responsibility_tl fr,     fnd_user fu WHERE     fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id     and fcr.responsibility_id = fr.responsibility_id     and fcr.requested_by = fu.user_id     --and user_name = upper('HIMSINGH')     and user_concurrent_program_name in  ('Active Users')     and Ph...