Query to get source code in database from back end
set verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…
Read MoreQuery to get SQL changed Performance
SPO sql_performance_changed.txt; DEF days_of_history_accessed = ’31’; DEF captured_at_least_x_times = ‘1’; DEF captured_at_least_x_days_apart = ‘1’; DEF med_elap_microsecs_threshold = ‘1e4’; DEF min_slope_threshold = ‘0.1’; DEF max_num_rows = ’20’; SET lin 500 ver…
Read MoreQuery to get concurrent Manager status from back end.
SELECT DECODE ( CONCURRENT_QUEUE_NAME, ‘FNDICM’, ‘Internal Manager’, ‘FNDCRM’, ‘Conflict Resolution Manager’, ‘AMSDMIN’, ‘Marketing Data Mining Manager’, ‘C_AQCT_SVC’, ‘C AQCART Service’, ‘FFTM’, ‘FastFormula Transaction Manager’, ‘FNDCPOPP’, ‘Output Post Processor’, ‘FNDSCH’, ‘Scheduler/Prereleaser…
Read MoreRestore the database from AVAMAR backup
As root user in Target Node: Step 1 : /usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt Make a note of recent Seq in our case it is 124980 . Step 2 : /usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt Get the control file name using above command. In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00” As Oracle user in Target Node: Step 3 : Step 4 : Create a pfile with db_name=PROD. Step 5 : Start the database in nomount. SQL> startup nomount pfile=’initPROD.ora’; Step 6 : Connect Rman and execute below command RMAN > set DBID=193295451; run{ allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’; send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘; restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’; } #### Control file taken from step 2. Step 7 : SQL> alter database mount; Step 8: RMAN> list backup; Take recent LOW SCN number. 181267677438…
Read MoreHow to activate Periodic Alert Scheduler in Oracle EBS Application
How to activate Periodic Alert Scheduler in Oracle EBS Application Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility We need to Login the Oracle EBS Application…
Read MoreFORM is not opening after the clone
ERROR: FORM session is not opening after the clone SOLUTION: Go to FORMS node if it is multi node. cd $ORACLE_HOME/lib32 ls -lrt ldflags unlink ldflags ln -s /devweb/oracle/TEST/apps/tech_st/10.1.2/lib32/ldflags ldflags…
Read MoreRC-50204: Error: – Web Listener Port in use: Port Value = 8009
ERROR: RC-50204: Error: – Web Listener Port in use: Port Value = 8009 CAUSE: When cloning we have faced this error. This is due to some other process is using…
Read MoreMonitoring Progress of a SQL Execution Plan / sql query is really hanged or not
Monitoring Progress of a SQL Execution Plan / sql query is really hanged or not How to check the progress of a query is making from within the execution plan…
Read MoreRe-link error while applying optach
Error: Re-link fails on target “client_sharedlib”. Re-link fails on target “client_sharedlib”. Re-link fails on target “ldapmoddn”. Re-link fails on target “ldapmodifymt”. Re-link fails on target “ldapaddmt”. Re-link fails on target…
Read MoreORA-19909: datafile 1 belongs to an orphan incarnation
ERROR: ORA-19909: datafile 1 belongs to an orphan incarnation When I tried to Flashback on in standby database then suddenly below message found in alert log and standby database not…
Read More