Wednesday, July 30, 2008

Locations

Scripts location: $COMMON_TOP/admin/scripts/TRIAL_dba2
To start all the servers, script is adstrtal.sh apps/apps
To stop all the servers, script is adstpall.sh apps/apps

Apache
adapcctl.sh start/stop/status
1) adapcctl.sh status
2) ps –ef grep http
3) ps –ef grep –i apache

Conf file $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf
LOG file $IAS_ORACLE_HOME/Apache/Apache/conf/error.log, access.log
JServer
Uses apachectl script
Uses apache commands
$IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties
log file $IAS_ORACLE_HOME/Apache/Jserv/logs/mod_jserv.log
Mod PL/SQL
Uses apache ctl script
Uses apache commands
$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
log file $IAS_ORACLE_HOME/Apache/modplsql/log
Apps listener
adalnctl.sh start/stop/status
ps –ef grep lsnrgrep APPS_
invokes FNDFS executable located at $FND_TOP/bin (starts Report Reviewing Agent (RRA) responsible for viewing CM log and output files)
Forms
adfrmctl.sh start/stop/status
1) adfrmctl.sh status
2) ps –ef grep f60
3) ls –of grep
$COMMON_TOP/html/bin/appsweb_$CONTEXT_NAME.cfg
log file
$ORACLE_HOME/forms60/log/TRIAL-dba or
$COMMON_TOP/admin/log/TRIAL-dba2
Reports
adrepctl.sh start/stop/status
1) adrepctl.sh status
2) ps –ef grep –i rep
3) ps –ef grep rwmts
$ORACLE_HOME/reports60/server/
CGIcmd.dat
Log file
$ORACLE_HOME/reports60/server/REP60_XX.log
or
$COMMON_TOP/admin/log/xxxx/rep60_xxx.txt
Concurrent Manager
adcmctl.sh start/stop/status apps/passwd
1) adcmctl.sh status apps/pwd
2) ps –ef grep FNDLIBR
Uses startmgr and batchmgr parameters
Located at $FND_TOP/bin

Discoverer
addisctl.sh start/stop/status
1) addisctl.sh status
2) ps –ef grep –i disco
Log file
$ORACLE_HOME/discwb4/util/locator.log
And
Oad.log
And
Osagent.log
Database Tier Scripts:

Scripts location: $ORACLE_HOME/appsutil/scripts/TRIAL_dba2
addbctl.sh stop
addbctl.sh start
ps –ef grep smon
Listener
adlnctl.sh start
adlnctl.sh stop
ps –ef grep tns grep –i

No comments:

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT0...