Master Script

SCRIPTS

1. DR Log sync

--Checking Logs

select max(sequence#) from v$archived_log where applied='YES';
select sequence# from v$archived_log where applied='NO';


--TO STOP
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;


--TO START
alter database recover managed standby database disconnect from session;


--TO CHECK WHERE IT IS STUCK

select sequence#,process,status from v$managed_standby;


###### Check lastlogs ####
SELECT
RECID,
NAME,
SEQUENCE#,
BLOCKS,
REGISTRAR,
APPLIED,
 to_char(COMPLETION_TIME,'HH24:MI:SS AM')
FROM V$ARCHIVED_LOG  where COMPLETION_TIME  between sysdate-15/24 and sysdate-12/24
/


2. Get Linux version
####

cat /etc/redhat-relase

3. Get EBS version

select release_name from apps.fnd_product_groups;

4. vi is not working properly

####
export TERM=xterm
resize

:set term=cons25

5. How to check run file location on EBS
--To check which is the run
echo $FILE_EDITION.
-- http://oracledbascriptsfromajith.blogspot.tw/2014/05/everything-about-oracle-apps-r122.html --check this out

6. ########## FORMS ###################
frmcmp_batch  userid=apps/backtohomefnd  module=XXWIPPICKLIST.fmb  output_file=XXWIPPICKLIST.fmx module_type=form  batch=no  compile_all=special

cp XXWIPPICKLIST.??? /prismapps/applmgr/ORAP/fs1/EBSapps/appl/mwip/12.0.0/forms/US

############## REPORTS  ##################
rwconverter  userid=apps/backtohomefnd  source=CUXPOXDLPDT.rdf  stype=rdffile  dtype=rdffile  overwrite=yes   compile_all=yes   batch=yes


#############WORKFLOW##################3
WFLOAD apps/r12t1fnd 0 Y UPLOAD /upgrade/R12_R12T1/fs1/EBSapps/appl/minv/12.0.0/wf/EI_APP.wft


6. How to check if an account is loc

SELECT username, account_status, created, lock_date, expiry_date
  FROM dba_users
 WHERE username='SYSTEM';

SELECT username, account_status, created, lock_date, expiry_date
  FROM dba_users
 WHERE username='SYS';

7. Change APPS password
on miasma

cd $ADMIN_SCRIPTS_HOME

./adstpall.sh

FNDCPASS apps/r12d1fnd 0 Y system/phoenixii SYSTEM APPLSYS r12d1fnd -- this is for apps change
FNDCPASS apps/r12d1fnd 0 Y system/phoenixii user VDEXTER r12d1xed

Chaning User product schema password
===================================
FNDCPASS apps/r12d1fnd 0 Y system/phoenixii ORACLE AP  AP1

Change APPS SYSADMIN
FNDCPASS apps/hrd2fnd 0 Y system/phoenixii user SYSADMIN Blackwat3r

FNDCPASS apps/r12d1fnd 0 Y system/phoenixii user SYSADMIN Blackwat3r

Change APPS password
FNDCPASS apps/hrphermesfnd 0 Y system/phoenixii SYSTEM APPLSYS hrd2fnd

Change System Password


8. Compile Forms and Reports

Reports:
rwconverter  userid=apps/xxxxx  source=XXWIPPICKLIST.rdf  stype=rdffile  dtype=rdffile  overwrite=yes   compile_all=yes   batch=yes

Forms:
frmcmp_batch  userid=apps/xxxxxx  module=XXOMSHPCFM2.fmb  output_file=XXOMSHPCFM2.fmx  module_type=form  batch=no  compile_all=special
frmcmp_batch  userid=apps/backtohomefnd  module=XXQAROHS.fmb output_file=XXQAROHS.fmx  module_type=form  batch=no  compile_all=special


9.Which version of EBS do I have

SQL> select release_name from apps.fnd_product_groups;

10. Troubleshoot Apps

http://labarbara.ecp.priv:8070/OA_HTML/jsp/fnd/aoljtest.jsp

http://labarbara.ecp.priv:8070/pls/orap11i/FND_WEB.PING -- TO CHECK IF MOD_PLSQL IS functioning

11.  net use x: \\phailortfs10\shared

12. To know what codelevel you are
SELECT codelevel FROM apps.AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');

13. How to check if patch has been applied
select ad_patch.is_patch_applied('R12',-1,24008424) from dual;

14. Delete 90 day old *.arc files
find *.out -mtime +90 -exec rm {} \;

15. Get top 10 biggest files


du -a /prismapps | sort -n -r | head -n 10
du -a /dbapps | sort -n -r | head -n 10
du -a /upgrade | sort -n -r | head -n 10
du -a /dbaredo | sort -n -r | head -n 10


du -a /dba0A | sort -n -r | head -n 10

16. Kill processes

kill `ps -ef | grep applmgr | grep -v grep | awk '{print $2}'`

find * -mtime +30 -exec rm {} \;
find * -mtime +90 -exec rm {} \;
find * -mtime +10 -exec rm {} \;


17. For pyre
find /prismapps/applmgr/ORAP/fs_ne/inst/ORAP_pyre/logs/appl/conc/out/ -type f -mtime +31 -exec rm {} \;

find /prismapps/applmgr/ORAP/fs_ne/inst/ORAP_pyre/logs/appl/conc/out/ -type f -mtime +20 -exec rm {} \;

find /upgrade/R12_R12D1/fs_ne/inst/R12D1_miasma/logs/appl/conc/out -type f -mtime +5 -exec rm {} \;


find /upgrade/R12_R12D2/fs_ne/inst/R12D2_lich/logs/appl/conc/log -type f -mtime +5 -exec rm {} \;

find /upgrade/R12_R12D2/fs_ne/inst/R12D2_lich/logs/appl/conc/out -type f -mtime +5 -exec rm {} \;

find /prismapps/applmgr/ORAP/fs_ne/inst/ORAP_pyre/logs/appl/conc/out/ -type f -mtime +20 -exec rm {} \;

find /dbapps/oracle/diag/rdbms/hrp/HRP/trace -type f -mtime +30 -exec rm {} \;

find /upgrade/R12_R12T1/fs_ne/inst/R12T1_rend/logs/appl/conc/out -type f -mtime +10 -exec rm {} \;

DWHP


find /dbapps/oracle/diag/rdbms/dwhp/DWHP/trace -type f -mtime +30 -exec rm {} \;
18.
SQL> exec ad_zd_table.upgrade('MONT','MONT_EXPLODED_BOM');
Example :
SQL> ALTER TABLE mont.MONT_EXPLODED_BOM
  ADD (WOFE_OTHER_RESERV_QTY NUMBER,
  RCT_ONHAND_QTY NUMBER );
SQL> exec ad_zd_table.patch('MONT','MONT_EXPLODED_BOM');​

19. Delete old folders 90 days

find . -type d -ctime +90 -exec rm -rf {} +  

find . -name "*.aud" -delete