EBS培训-Oracle EBS DBA-炼数成金-(1-4)weeks

一、课程结构

二、安装

三、架构

四、DB和APP分别在一台物理机

五、File Systems---文件系统

六、INST_TOP

七、apps

八、APPL_TOP

九、PROD_TOP

十、autoconfig

十一、应用层的listener

1、查看：ps -ef |grep tns

[appluat@ebsuat bin]$ ps -ef |grep tns

orauat 2845 1 0 Jul08 ? 00:00:00 /u01/uat/db/12.1.0/bin/tnslsnr ebsuat -inherit
appluat 9122 1 0 Jul08 ? 00:00:00 /u01/uat/ap/fs2/EBSapps/10.1.2/bin/tnslsnr APPS_ebsuat -inherit

2、SID名称：APPS_SID

Service "FNDFS" has 1 instance(s).
Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...
Service "FNDSM" has 1 instance(s).
Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...

有两个服务：

FNDFS:Report Review Agent<111383.1>

FNDSM:Service Manger

3、启动监听的命令

$./$ADMIN_SCRIPTS_HOME/adalnctl.sh start

十一、测试语句

Apache
– $ADMIN_SCRIPTS_HOME/adapcctl.shstatusapps/apps
– $IAS_ORACLE_HOME/Apache/Apache/conf
– http://ebsuat.*.com:8005/OA_HTML/jtflogin.jsp
– http://ebsuat.*.com:8005/OA_HTML/ServletPing
– http://ebsuat.*.com:8005/OA_HTML/jsp/fnd/aoljtest.jsp
– http://ebsuat.*.com:8005/OA_MEDIA/FNDLOGOL.gif
– http://ebsuat.*.com:8005/OA_JAVA/oracle/forms/registry/Registry.dat
DBC file file
– java oracle.apps.fnd.security.AdminAppServer apps/apps status  DBC=$INST_TOP/appl/fnd/12.0.0/secure/ebsuat.dbc
JSP
– http://ebsuat.*.com:8005/OA_HTML/jsp/fnd/fndping.jsp
Forms
- http://ebsuat.*.com:8005/forms

十二、日常检查

1、ConcurrentManagerManager

–ps–ef|grep FNDLIBR
–Concurrent>Manager>Administer
–SQL>@$FND_TOP/sql/afimchk.sql
–OAM

2、Environmentfilecheck

–cd $APPL_TOP;ls APPSVIS_mis7.env

3、OC4J/OPMNcheckcheck

–adopmnctl.shstatusapps/apps
–adoacorectl.shstatusapp/pps/apps
–adformsctl.shstatusapps/apps(formsservletmode)
–adoafmctl.shstatusapps/apps(oracleapplicationsfusionmiddleware

十三、 应用层的listener

– adalnctl.shstatus
Databaseanddatabaselistener
lsnrctl status
LogintoApplications
– http://mis7.myerp.com:8000/OA_HTML/AppsLogin
– Runthe“activeuser”report

十四、重要的log文件

• $LOG HOME ($INST TOP/logs) _HOME($INST_TOP/logs)

• RAPIDINSTALLlogfile: $LOG_HOME/<timestamp>.log

• Concurrent Request related :  $LOG HOME/ _HOME/appl/conc

• Apache,OC4JandOPMNLogs(10.1.3Oracle)

  • $LOG_HOME/ora/10.1.3/Apache:error_log.*andaccess_log.*

  • $LOG_HOME/ora/10.1.3/j2ee- >j2eerelatedlogfiles

    • tailoacore/oacore_default_group_1/log.xml

    • tailoacore/oacore default group 1/application log _default_group_1/application.log

  • $LOG_HOME/ora/10.1.3/opmn - >opmn relatedlogfiles

    • taildefault_group~oacore~default_group~1.log

• Forms & Reports related logs (10 1 2 Oracle Home)

  • $LOG_HOME/ora/10.1.2/forms

  • $LOG_HOME/ora/10.1.2/reports

• Startup/ShutdownLogfileslocation:

  • $LOG_HOME/appl/admin/log

• Patchlogfileslocation:

  • $APPL_TOP/admin/$SID/log/

• Datab l l asealertlog