stick blo

AUDIT

http://docs. cle.com/cd/B10500_01/server.920/a96521/audit.htm#1975

　

Daily Check Report

http://shahiddba.blogspot.in/2012/05/dba-dailyweeklymonthly-or-quarterly.html

　

　

Installation Guyide:

http://www. cledba.org/EBS/install/Install_EBS_R12_on_linux.htm

　

File Count:

ls -1 | wc -l

　

Report Location:rdf

cd $CUSTOM_TOP/resports/US

　

Forms Location:fmx

cd $CUSTOM_TOP/forms/US

　

Forms Location:fmb

cd $AU_TOP/forms/US

　

PLL/PLX Location:

cd $AU_TOP/resources

　

　

Location where you find adcmctl.sh scripts is $COMMN_TOP/admin/scripts/$CONTEXT_NAME/

or $ADMIN_SCRIPTS_HOME

　

adcmctl.sh start/stop/status apps/apps

　

　

Check the Applmgr process Running status:

ps -ef|grep FNDLIBR|grep applmgr

　

need to find that query for which concurrent process becomes slow .Some jobs are taking too long time just need to identify it.

　

find the file type .pls with 1 year old.

find / -type f -name '.pls' -mtime -365 -ls

　

http://dbatalent.com/kbarticles/hot-cloning- cle-e-business-suite-r12/

　

　

AUDIT

http://docs. cle.com/cd/B10500_01/server.920/a96521/audit.htm#1975

　

Daily Check Report

http://shahiddba.blogspot.in/2012/05/dba-dailyweeklymonthly-or-quarterly.html

　

How To make tar:

tar -czvf archive.tar.gz stuff

How to make Untar:

tar -xzvf archive.tar.gz -C /tmp

　

Comand to send file from one seerver to other server:

　

scp -r home.tar root@192.168.1.2:/u02/

　

Clear All cache using Functional Admnistrator:

http:// cleajidba.blogspot.in/2010/05/how-to-clear-all-cache-using-functional.html

　

http://appsr12help.blogspot.in/2012/12/ cle-applications-shortcut-keys.html

　

APPLCSF/APPLLOG LOG:

/uatapps/ cle/product/sky/inst/apps/UAT_skyb010/logs/appl/admin/log

/uatapps/ cle/product/sky/inst/apps/UAT_skyb010/logs/appl/conc/log

/ apps/ cle/product/sky/inst/apps/sky_skyb005/logs

　

　

-------------------------------

aDD TABLE SPACE COMMAND:

　

alter tablespace APPS_TS_TX_DATA add datafile '/ db/ cle/product/SKY/db/apps_st/data/a_txn_data215.dbf' size 9000m;

　

alter tablespace APPS_TS_TX_IDX add datafile '/ db/ cle/product/sky/db/apps_st/data/a_txn_ind127.dbf' size 7000m;

alter tablespace APPS_TS_MEDIA add datafile '/ db/ cle/product/sky/db/apps_st/data/a_media088.dbf' size 3000m;

alter tablespace SYSTEM add datafile ' /uatdb/ cle/product/sky/db/apps_st/data/system088.dbf ' size 4000m

ALTER TABLESPACE APPS_UNDOTS1 ADD DATAFILE '/ db/ cle/product/sky/db/apps_st/data/undo089.dbf' size 4000m;

ALTER TABLESPACE TEMP1 ADD TEMPFILE '/ db_temp/ data/PROD/temp22.dbf' SIZE 4000m;

　

　

JAVA_LOG LOCATION:

/ apps/ cle/product/sky/apps/apps_st/comn/java/classes/logs

　

OACORE LOG FILE:

/ apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/opmn/oacore_default_group_1

　

http://haithanh8x.blogspot.in/2013/03/script-dba_22.html

https://dbasolutions.wikispaces.com/Queries

　

Concurrent Processing - Best Practices for Performance for Concurrent Managers in E-Business Suite (Doc ID 1057802.1)

　

How To Restart The Concurrent Manager In Unix (Doc ID 147449.1)

　

　

/ home/ cle/product/sky/db/adr/diag/rdbms/sky/sky/trace/tail -200f alert_sky.log

　

Purged data from system:

Purge Logs and Closed System Alerts:

　

check log file location with

　

Compile a form:

　

frmcmp_batch userid=apps/apps module=STGI_DISPATCH.fmb output_file=/ apps/ cle/product/sky/apps/apps_st/custom/sky/12.0.0/forms/US/STGI_DISPATCH.fmx module_type=form batch=no compile_all=yes

　

　

Concurrent Processing - Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) ( Doc ID 104282.1)

Doc ID 2267420.1--PATCH GST PHASE 3

cle Financials for India GST Diagnostics (Doc ID 2254221.1)

　

　

All LOg File In Apps Side:

　

tail -200f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/opmn/oacore_default_group_1/oacorestd.err

　

　

tail -200f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/Apache/access_log.1495756800

　

　

tail -200f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/opmn/HTTP_Server~1.log

　

tail -2000f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/appl/rgf/javacache.log

　

tail -200f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/j2ee/oacore/oacore_default_group_1/application.log

　

tail -200f / apps/ cle/product/sky/inst/apps/sky_skyb005/logs/ /10.1.3/opmn/oacore_default_group_1/oacorestd.out

　

tail -200f / home/ cle/product/sky/db/adr/diag/rdbms/sky/sky/trace/alert_sky.log

　

　

========================

　

http://appsdbaworkshop.blogspot.in/2013/02/ cle-apps-r12-cloning-online.html

　

dba bundle

http://dba-tips.blogspot.in/2014/02/ cle-database-administration-scripts.html

　

Concurrent Program Details Report - XML Publisher

　

　

　

https://anand cle.wordpress.com/2012/03/20/cloning-r12- oracle-apps-e-business-suite-pre-clone-steps/

　

oracle sr call

040-66052080

　

welcome1

　

TJPS_AP_INVOICE_160D