cd $APPLCSF/$APPLLOG
logfile : l<request id>.req
cd $APPLCSF/$APPLOUT
outfile: o<request id>.out
Thursday 14 March 2013
what is the naming convention of concurrent requests log and out files?
cd $APPLCSF/$APPLLOG
logfile : l<request id>.req
cd $APPLCSF/$APPLOUT
outfile: o<request id>.out
Wednesday 13 March 2013
Stopping the concurrent managers
You stop the concurrent managers from the command line:
CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND
DEACTIVATE or ABORT
DEACTIVATE tells the managers to complete processing of any running
requests before terminating. This is a cleaner way of bringing down the
managers.
ABORT tells the managers to terminate the managers immediately.
When the concurrent managers are terminated through the abort command,
the jobs that they were running will be returned to pending status.
adcmctl.sh apps/password stop
Let see the scenario:
==============
CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND DEACTIVATE or ABORT
[applmgr@apps scripts]$ ps -fu applmgr|grep -i fndlibr
applmgr 607 602 0 19:09 pts/1 00:00:00 FNDLIBR
applmgr 838 764 0 19:10 ? 00:00:00 FNDLIBR
applmgr 839 764 0 19:10 ? 00:00:00 FNDLIBR
applmgr 845 764 0 19:10 ? 00:00:00 FNDLIBR
applmgr 855 764 0 19:10 ? 00:00:00 FNDLIBR
applmgr 856 764 0 19:10 ? 00:00:00 FNDLIBR
applmgr 861 764 0 19:10 ? 00:00:00 FNDLIBR
[applmgr@apps scripts]$ CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND DEACTIVATE
Submitted request 390260 for CONCURRENT FND DEACTIVATE
[applmgr@apps scripts]$
[applmgr@apps scripts]$ ps -fu applmgr|grep -i fndlibr|wc -l
1
You have new mail in /var/spool/mail/applmgr
[applmgr@apps scripts]$
DATABASE OBJECTS BACKUP
View backup
==========
Select dbms_metadata.get_ddl(‘’,’’,’OWNER’) from dual;
set long 100000
spool MTL_SYS_ITEMS_VL.lst
select text from dba_views where VIEW_NAME='MTL_SYS_ITEMS_VL';
spool off
Package Body Backup
===================
set pagesize 0
set linesize 800
set trimspool on
set heading off
set feedback off
spool GEPS_ARCH_PKG.bkp
select text from dba_source where name='GEPS_ARCH_PKG'; and type='PACKAGE';
spool off
exit
Spool in excel format
==========================
SET LINESIZE 4000
SET VERIFY OFF
SET FEEDBACK OFF
SET PAGESIZE 999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SPOOL general.xls
select NAME,VALUE from $parameter;
spool off
exit
Package backup
==============
set pages 0
set linesize 200
set head off.lst
spool GEPS_SO_PRICE_PKG
select text from dba_source where name='GEPS_SO_PRICE_PKG' and type like '%PACKAGE%';
spool off
Backup of a procdure
======================
set heading off
set feedback off
set pages 0
set long 1000000
set linesize 400
select text from dba_source where name='SBR_PREP_AP_INV' and OWNER='APPS' and type='PROCEDURE';
What happens when you run autoconfig when the middle tier service are up and running?
Lets see below senaroi
===================
My application service are up and running and i ran autoconfig.do you think it will make any
harm to the database as well as application.
Answer is no:
you will run autoconfig when you make some changes in the xml file so that it will update the
configuration files and update the profile or etc.
[applmgr@apps scripts]$ adopmnctl.sh status
You are running adopmnctl.sh version 120.6
Checking status of OPMN managed processes...
Processes in Instance: PROD_apps.apps.user.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 437 | Alive
OC4JGroup:default_group | OC4J:forms | 327 | Alive
OC4JGroup:default_group | OC4J:oacore | 32292 | Alive
HTTP_Server | HTTP_Server | 32225 | Alive
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u02/inst/apps/PROD_apps/logs/appl/admin/log/adopmnctl.txt for more information ...
SERVICES ARE UP AND RUNNING AND STATUS ARE ALIVE.
[applmgr@apps scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/inst/apps/PROD_apps/admin/log/03131924/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u02/inst/apps/PROD_apps
Classpath : /u02/apps/apps_st/comn/java/lib/appsborg2.zip:/u02/apps/apps_st/comn/java/classes
Using Context file : /u02/inst/apps/PROD_apps/appl/admin/PROD_apps.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[applmgr@apps scripts]$ ps -fu applmgr|grep -i http|wc -l
11
[applmgr@apps scripts]$
My autoconfig completed successfully and also application services are up and running.
i have done the sanity no issue's at all.
===================
My application service are up and running and i ran autoconfig.do you think it will make any
harm to the database as well as application.
Answer is no:
you will run autoconfig when you make some changes in the xml file so that it will update the
configuration files and update the profile or etc.
[applmgr@apps scripts]$ adopmnctl.sh status
You are running adopmnctl.sh version 120.6
Checking status of OPMN managed processes...
Processes in Instance: PROD_apps.apps.user.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 437 | Alive
OC4JGroup:default_group | OC4J:forms | 327 | Alive
OC4JGroup:default_group | OC4J:oacore | 32292 | Alive
HTTP_Server | HTTP_Server | 32225 | Alive
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u02/inst/apps/PROD_apps/logs/appl/admin/log/adopmnctl.txt for more information ...
SERVICES ARE UP AND RUNNING AND STATUS ARE ALIVE.
[applmgr@apps scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/inst/apps/PROD_apps/admin/log/03131924/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u02/inst/apps/PROD_apps
Classpath : /u02/apps/apps_st/comn/java/lib/appsborg2.zip:/u02/apps/apps_st/comn/java/classes
Using Context file : /u02/inst/apps/PROD_apps/appl/admin/PROD_apps.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[applmgr@apps scripts]$ ps -fu applmgr|grep -i http|wc -l
11
[applmgr@apps scripts]$
My autoconfig completed successfully and also application services are up and running.
i have done the sanity no issue's at all.
Rolling Back an AutoConfig Session.
Rolling Back an AutoConfig Session
1)The database server and the database listener must be up and running during the AutoConfig run.
Only the application tier services should be down.
2)Each AutoConfig run creates a rollback script you can use to revert to the previous configuration settings if necessary.
The script and all backup configuration files from each AutoConfig session are stored in below location.
i)Database Tier $RDBMS_ORACLE_HOME/appsutil/out/MMDDhhmm
ii)Application Tier $INST_TOP/admin/out/MMDDhhmm
3)To roll back an AutoConfig session, execute---
restore.sh
Scenario: in previous example i have change the $APPLCSF/$APPLLOG file location and now i am reverting the previous setting.
1)Current concurret manager logfile location
[applmgr@apps 03081544]$ cd $APPLCSF/$APPLLOG
[applmgr@apps log]$ pwd
/u02/inst/log
[applmgr@apps log]$
2)last time i have ran autoconfig on 8 march and today is 13 march.
[applmgr@apps log]$ cd $INST_TOP/admin/out
[applmgr@apps out]$ pwd
/u02/inst/apps/PROD_apps/admin/out
[applmgr@apps out]$ ls -tlrh
total 36K
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 18:19 03011819
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 18:31 03011831
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 19:17 03011908
drwxr-xr-x 2 applmgr dba 12K Mar 1 19:40 03011917
drwxr-xr-x 2 applmgr dba 12K Mar 8 15:49 03081544
[applmgr@apps out]$
[applmgr@apps 03081544]$ ls -tlrh /u02/inst/apps/PROD_apps/admin/out/03081544/restore.sh
-rwxr-xr-x 1 applmgr dba 25K Mar 8 15:49 /u02/inst/apps/PROD_apps/admin/out/03081544/restore.sh
[applmgr@apps 03081544]$
3)Make sure application services must be down.use below command to check whether any process is running or not.
[applmgr@apps 03081544]$ ps -fu applmgr
UID PID PPID C STIME TTY TIME CMD
applmgr 26737 26736 0 18:03 pts/1 00:00:00 -bash
applmgr 26968 26737 0 18:18 pts/1 00:00:00 ps -fu applmgr
[applmgr@apps 03081544]$
4)when you run restore.sh script it will prompt for apps password.
[applmgr@apps 03081544]$ sh restore.sh
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 13 18:27:27 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter apps password
Connected.
[ GWYUID ]
Application Id : 0
Profile Value : APPLSYSPUB/PUB
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value : PROD
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_DEFAULT_EUL ]
Application Id : 178
Profile Value : EUL
Level Name: SITE
INFO : Updated/created profile option value.
.
[ TWO_TASK ]
Application Id : 0
Profile Value : PRDXBLD9
Level Name: SITE
INFO : Updated/created profile option value.
.
[ PRINTER ]
Application Id : 0
Profile Value : noprint
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_LANGUAGE ]
Application Id : 178
Profile Value : AMERICAN
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_TERRITORY ]
Application Id : 178
Profile Value : AMERICA
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CONC_GSM_ENABLED ]
Application Id : 0
Profile Value : Y
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_WEB_AGENT ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010/pls/PRDXBLD9
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_SERVLET_AGENT ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010/OA_HTML
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_JSP_AGENT ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_FRAMEWORK_AGENT ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO : Updated/created profile option value.
.
[ HELP_WEB_AGENT ]
Application Id : 0
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ HELP_WEB_BASE_URL ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010/OA_HTML/
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_FORMS_LAUNCHER ]
Application Id : 178
Profile Value : http://ap6006ebo.us.oracle.com:3010/forms/frmservlet
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_DISCOVERER_LAUNCHER ]
Application Id : 178
Profile Value : /discoverer/plus?Connect=[APPS_SECURE]
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_DISCOVERER_VIEWER_LAUNCHER ]
Application Id : 178
Profile Value : /discoverer/viewer?Connect=[APPS_SECURE]
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IES_SCRIPTING_SID ]
Application Id : 519
Profile Value : PRDXBLD9
Level Name: SITE
INFO : Updated/created profile option value.
.
[ APPS_PORTAL ]
Application Id : 0
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CZ_UIMGR_URL ]
Application Id : 702
Profile Value :
http://ap6006ebo.us.oracle.com:3010/OA_HTML/configurator/UiServlet
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_CLIENT_IANA_ENCODING ]
Application Id : 178
Profile Value : US-ASCII
Level Name: SITE
INFO : Updated/created profile option value.
.
[ WEB_PROXY_HOST ]
Application Id : 0
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ WEB_PROXY_PORT ]
Application Id : 0
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ WEB_PROXY_BYPASS_DOMAINS ]
Application Id : 0
Profile Value : us.oracle.com
Level Name: SITE
INFO : Updated/created profile option value.
.
[ TCF:PORT ]
Application Id : 0
Profile Value : -1
Level Name: SITE
INFO : Updated/created profile option value.
.
[ TCF:HOST ]
Application Id : 0
Profile Value : http://ap6006ebo.us.oracle.com:3010/OA_HTML
Level Name: SITE
INFO : Updated/created profile option value.
.
[ QP_PRICING_ENGINE_URL ]
Application Id : 661
Profile Value : http://ap6006ebo.us.oracle.com:3010/OA_HTML/pricing
Level Name: SITE
INFO : Updated/created profile option value.
.
[ JTF_DIST_CACHE_PORT ]
Application Id : 690
Profile Value : 12456
Level Name: SITE
INFO : Updated/created profile option value.
.
[ FND_CACHE_PORT_RANGE ]
Application Id : 0
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_SESSION_TIMEOUT ]
Application Id : 178
Profile Value : 30
Level Name: SITE
INFO : Updated/created profile option value.
.
[ POR_CACERT_FILE_NAME ]
Application Id : 178
Profile Value :
/nfs/bld/d26/PRDXBLD9/apps/tech_st/10.1.2/sysman/config/b64InternetCertificate.t
xt
Level Name: SITE
INFO : Updated/created profile option value.
.
[ POR_PROXY_SERVER_NAME ]
Application Id : 178
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ POR_PROXY_SERVER_PORT ]
Application Id : 178
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ EDW_LOGFILE_DIR ]
Application Id : 191
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ AMS_IMP_CTL_PATH ]
Application Id : 530
Profile Value : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/ams/12.0.0/bin/
Level Name: SITE
INFO : Updated/created profile option value.
.
[ AMS_IMP_DATA_PATH ]
Application Id : 530
Profile Value :
/nfs/bld/d26/PRDXBLD9/inst/apps/PRDXBLD9_ap6006ebo/logs/appl/conc/inbound/PRDXBL
D9_ap6006ebo/
Level Name: SITE
INFO : Updated/created profile option value.
.
[ AMS_SERVER_URL ]
Application Id : 530
Profile Value : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO : Updated/created profile option value.
.
[ WSH_DEBUG_LOG_DIRECTORY ]
Application Id : 665
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CLN_DEBUG_LOG_DIRECTORY ]
Application Id : 701
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ OKS_SMTP_DOMAIN ]
Application Id : 515
Profile Value : us.oracle.com
Level Name: SITE
INFO : Updated/created profile option value.
.
[ OKS_SMTP_HOST ]
Application Id : 515
Profile Value : ap6006ebo
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CSF_EMAP_RMI_HOST ]
Application Id : 513
Profile Value : http://ap6006ebo.us.oracle.com:3010/mapviewer/omserver
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IBY_ECAPP_URL ]
Application Id : 673
Profile Value : http://ap6006ebo.us.oracle.com:3010/OA_HTML/ibyecapp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ ICX_PAY_SERVER ]
Application Id : 673
Profile Value : null
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IBY_XML_TEMP ]
Application Id : 673
Profile Value : /nfs/bld/d22/AB/temp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IBY_HTTP_PROXY ]
Application Id : 673
Profile Value : http://:
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IBY_NOPROXY_DOMAIN ]
Application Id : 673
Profile Value : us.oracle.com
Level Name: SITE
INFO : Updated/created profile option value.
.
[ IBY_XML_BASE ]
Application Id : 673
Profile Value : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/iby/12.0.0/xml
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CN_IMP_SERVER_PATH ]
Application Id : 283
Profile Value :
/nfs/bld/d26/PRDXBLD9/inst/apps/PRDXBLD9_ap6006ebo/logs/appl/conc/inbound/PRDXBL
D9_ap6006ebo/
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CN_IMP_CONTROL_PATH ]
Application Id : 283
Profile Value : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/cn/12.0.0/bin/
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CSI_LOGFILE_PATH ]
Application Id : 542
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ CSE_DEBUG_LOG_DIRECTORY ]
Application Id : 873
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
[ EAM_PM_DEBUG_FILE ]
Application Id : 426
Profile Value : /usr/tmp\eampmeng.log
Level Name: SITE
INFO : Updated/created profile option value.
.
[ EAM_ABO_DEBUG_DIR_FILE ]
Application Id : 426
Profile Value : /usr/tmp/eam_abo.log
Level Name: SITE
INFO : Updated/created profile option value.
.
[ EAM_MOI_LOG_DIR_FILE ]
Application Id : 426
Profile Value : /usr/tmp/eam_moi.log
Level Name: SITE
INFO : Updated/created profile option value.
.
[ FTE_PRC_DEBUG_LOG_DIR ]
Application Id : 716
Profile Value : /usr/tmp
Level Name: SITE
INFO : Updated/created profile option value.
.
PL/SQL procedure successfully completed.
56 rows deleted.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
source env
==========
[applmgr@apps appl]$ ls -tlrh APPS*.env
-rw-r--r-- 1 applmgr dba 999 Mar 13 18:27 APPSPROD_apps.env
[applmgr@apps appl]$ . ./APPSPROD_apps.env
[applmgr@apps appl]$ echo $APPLCSF/$APPLLOG
/u02/inst/apps/PROD_apps/logs/appl/conc/log
[applmgr@apps appl]$
autconfig rollback session completes sucessfully.
Monday 11 March 2013
How to run scp in the background/scp as a background process?
Syntax:
$ nohup scp <filename> username@server/ip:path > nohup.out 2>&1
Example:
$ nohup scp 1120.tar.gz oradev@ebsdev.user.com:/u01/oracle/ > nohup.out 2>&1
Then press ctrl + z which will temporarily suspend the command, then enter the command:
$bg
This will start executing the command in backgroud.
scp command to upload and download files?
Scp stands for secure copy.
To transfer/put a file to another server.
scp <filename> username@servername:path
logged in server ebsdev.user.com
========================
scp initebsoltp.ora oraoltp@ebsoltp.user.com:/u01/oracle/11.2.0/
To download a file
=============
To which location you want to download/get a file.
Here in the below example /u02/oracle/.
Suppose i want to get the file from the server ebsdev.user.com from this location /u01/oracle/apscheck.sql to this server ebsoltp.user.com in this location /u02/oracle/
1)logged in to ebsoltp.user.com and location where you want to get file from ebsdev.user.com server.
/u02/oracle/
scp oraodev@ebsdev.user.com:/u01/oracle/apscheck.sql .
To transfer/put a file to another server.
scp <filename> username@servername:path
logged in server ebsdev.user.com
========================
scp initebsoltp.ora oraoltp@ebsoltp.user.com:/u01/oracle/11.2.0/
To download a file
=============
To which location you want to download/get a file.
Here in the below example /u02/oracle/.
Suppose i want to get the file from the server ebsdev.user.com from this location /u01/oracle/apscheck.sql to this server ebsoltp.user.com in this location /u02/oracle/
1)logged in to ebsoltp.user.com and location where you want to get file from ebsdev.user.com server.
/u02/oracle/
scp oraodev@ebsdev.user.com:/u01/oracle/apscheck.sql .
How to use fuser in Linux when you have many files?
find . -name "*.trc" -mtime +0 -exec /sbin/fuser -v {} \;
find . -name "*.req" -mtime +0 -exec /sbin/fuser -v {} \;
Like: l1234856.req:25368o ===> if it is in used.
Note:The output is differ in linux/solaris.
Files which are in used only will be shown in next line in linux.
Friday 8 March 2013
How can we change the location of conc manager logfiles $APPLCSF/$APPLLOG?
1)Make sure service should not be runing.
[applmgr@apps scripts]$ ps -fu applmgr
UID PID PPID C STIME TTY TIME CMD
applmgr 26816 26815 0 14:51 pts/1 00:00:01 -bash
applmgr 27723 26816 0 15:35 pts/1 00:00:00 ps -fu applmgr
[applmgr@apps scripts]$
2)Take the backup of old xml file before you make changes to it.
cp -r PROD_apps.xml PROD_apps.xml_08mar2013
3) $APPLCSF existing location
[applmgr@apps admin]$ echo $APPLCSF/$APPLLOG
/u02/inst/apps/PROD_apps/logs/appl/conc/log
(OR)
Also you can check with the below commands.
To extract one parameter from xml use grep
=========================================
[applmgr@apps log]$ grep -i s_applcsf $CONTEXT_FILE
<APPLCSF oa_var="s_applcsf">/u02/inst/apps/PROD_apps/logs/appl/conc</APPLCSF>
To grep multiple parameter use egrep
=================================================
[applmgr@apps log]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
<APPLCSF oa_var="s_applcsf">/u02/inst/apps/PROD_apps/logs/appl/conc</APPLCSF>
<APPLLOG oa_var="s_appllog">log</APPLLOG>
<APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@apps log]$
4)change the location and run autoconfig
i have changed the value of $APPLCSF in xml file to /u02/inst,$APPLLOG to log and $APPLOUT to out only .once parameters are changed in the xml file
run autoconfig in order to reflect it.
When you grep it .It will show you modified value.
[applmgr@apps admin]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
<APPLCSF oa_var="s_applcsf">/u02/inst</APPLCSF>
<APPLLOG oa_var="s_appllog">log</APPLLOG>
<APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@apps admin]$
Still it will show you the old value as you have not run the autoconfig,just run autconfig to reflect it.
[applmgr@apps admin]$ echo $APPLCSF/$APPLLOG
/u02/inst/apps/PROD_apps/logs/appl/conc/log
Now go to script location and run autoconfig.
===============================
[applmgr@apps inst]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@apps scripts]$ pwd
/u02/inst/apps/PROD_apps/admin/scripts
[applmgr@apps scripts]$ ls -ltrh
total 168K
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 19:17 msc
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 19:17 ieo
-rwx------ 1 applmgr dba 5.6K Mar 1 19:21 adstpall.sh
-rwx------ 1 applmgr dba 5.7K Mar 1 19:21 adstrtal.sh
-rwx------ 1 applmgr dba 7.1K Mar 1 19:21 adalnctl.sh
-rwx------ 1 applmgr dba 17K Mar 1 19:21 adcmctl.sh
-rwx------ 1 applmgr dba 1.5K Mar 1 19:21 adautocfg.sh
-rwx------ 1 applmgr dba 15K Mar 1 19:21 adpreclone.pl
-rwx------ 1 applmgr dba 7.0K Mar 1 19:21 adexecsql.pl
-rwx------ 1 applmgr dba 2.1K Mar 1 19:22 java.sh
-rwx------ 1 applmgr dba 2.2K Mar 1 19:22 gsmstart.sh
-rwx------ 1 applmgr dba 8.5K Mar 1 19:22 adformsctl.sh
-rwx------ 1 applmgr dba 8.0K Mar 1 19:22 adapcctl.sh
-rwx------ 1 applmgr dba 7.1K Mar 1 19:22 adopmnctl.sh
-rwx------ 1 applmgr dba 7.8K Mar 1 19:22 adoafmctl.sh
-rwx------ 1 applmgr dba 7.7K Mar 1 19:22 adoacorectl.sh
-rwx------ 1 applmgr dba 10K Mar 1 19:22 adformsrvctl.sh
-rwx------ 1 applmgr dba 6.1K Mar 1 19:37 jtffmctl.sh
-rwxrwxr-- 1 applmgr dba 6.5K Mar 1 19:38 mwactlwrpr.sh
-rwxrwxr-- 1 applmgr dba 6.5K Mar 1 19:38 mwactl.sh
[applmgr@apps scripts]$
Running autoconfig
============
[applmgr@apps scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/inst/apps/PROD_apps/admin/log/03081544/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u02/inst/apps/PROD_apps
Classpath : /u02/apps/apps_st/comn/java/lib/appsborg2.zip:/u02/apps/apps_st/comn/java/classes
Using Context file : /u02/inst/apps/PROD_apps/appl/admin/PROD_apps.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[applmgr@apps scripts]$
once autoconfig completed successfully source the env file.
[applmgr@apps appl]$ ls -ltrh *.env
-rw-r--r-- 1 applmgr dba 16K Mar 8 15:46 PROD_apps.env
-rw-r--r-- 1 applmgr dba 999 Mar 8 15:46 APPSPROD_apps.env
[applmgr@apps appl]$ . ./PROD_apps.env
[applmgr@apps appl]$ echo $APPLCSF/$APPLLOG
/u02/inst/log
[applmgr@apps appl]$
Concurrent manager logfile location successfully changed to /u02/inst/log .
Re cap
=====
1) Services should not be running
2)Take backup of old xml file
3)change location in xml file.
4)Run autoconfig.sh
5)source env and check location
Please click on the below link to see how to roll back an autoconfig session.
Rolling back autoconfig session
What does APPLCSF stand for ?
APPLCSF stands for Application Common Support/Script Files. In a freshly installed Oracle E-Business Suite environment 11i/R12,
if you cd to $APPLCSF, it will take you to $COMMON_TOP/admin/ directory which has the following subdirectories:
11i fresh installation
==============
cd $APPLCSF ==> $COMMON_TOP/admin
outbound
inbound
install
out
log
scripts
R12 fresh installation
===============
[applmgr@apps log]$ cd $APPLCSF
[applmgr@apps conc]$ pwd
/u02/inst/apps/PROD_apps/logs/appl/conc
[applmgr@apps conc]$ ls -ltrh
total 16K
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 19:12 outbound
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 19:12 inbound
drwxr-xr-x 2 applmgr dba 4.0K Mar 1 20:22 out
drwxr-xr-x 2 applmgr dba 4.0K Mar 2 04:46 log
[applmgr@apps conc]$ d
Thursday 7 March 2013
fnd_conc_clone.setup_clean vs cmclean.sql
fnd_conc_clone.setup_clean
====================
fnd_conc_clone ===> is package
setup_clean ====> it is procedure name
When we run fnd_conc_clone.setup_clean it deletes the information from the below tables.
Delete from fnd_concurrent_queue_size
Delete from fnd_concurrent_queues_tl
Delete from fnd_concurrent_queuesDelete from fnd_nodes;
We use fnd_conc_clone.setup_clean to cleanup fnd_nodes table in the target to clear source node information as part of cloning.
below syntax to execute:
SQL> sho user
USER is "APPS"
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
First run the autoconfig on DB tier and middle tier this will regiser the nodes in fnd_nodes tables.
cmclean.sql
=========
If we stop conc manager using abort options then concurrent requests will be in running state ,Next when we start concurrent manager the processes will not start properly.
To cleanup running and pending requests we use cmclean.sql this script will update the below tables.
UPDATE fnd_concurrent_processes
UPDATE fnd_concurrent_queues
UPDATE fnd_concurrent_requests
UPDATE fnd_conflicts_domain
UPDATE fnd_concurrent_conflict_sets
Download cmclean.sql:
=================
Concurrent Processing - cmclean.sql - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
Note: cmclean.sql and fnd_conc_clone.setup_clean touch different set of concurrent request tables.
Its better idea to run both during the clone.
====================
fnd_conc_clone ===> is package
setup_clean ====> it is procedure name
When we run fnd_conc_clone.setup_clean it deletes the information from the below tables.
Delete from fnd_concurrent_queue_size
Delete from fnd_concurrent_queues_tl
Delete from fnd_concurrent_queuesDelete from fnd_nodes;
We use fnd_conc_clone.setup_clean to cleanup fnd_nodes table in the target to clear source node information as part of cloning.
below syntax to execute:
SQL> sho user
USER is "APPS"
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
First run the autoconfig on DB tier and middle tier this will regiser the nodes in fnd_nodes tables.
cmclean.sql
=========
If we stop conc manager using abort options then concurrent requests will be in running state ,Next when we start concurrent manager the processes will not start properly.
To cleanup running and pending requests we use cmclean.sql this script will update the below tables.
UPDATE fnd_concurrent_processes
UPDATE fnd_concurrent_queues
UPDATE fnd_concurrent_requests
UPDATE fnd_conflicts_domain
UPDATE fnd_concurrent_conflict_sets
Download cmclean.sql:
=================
Concurrent Processing - cmclean.sql - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
Note: cmclean.sql and fnd_conc_clone.setup_clean touch different set of concurrent request tables.
Its better idea to run both during the clone.
Subscribe to:
Posts (Atom)