HOME > > Oracle 11i Apps DBA Daily Activity

Oracle 11i Apps DBA Daily Activity

Anup - Thursday, April 1, 2010
Check Web Server is Up :

Oracle Applications DBA Field Guide

Check in browser http://hostname.domainname:port where hostname.domain_name is Machine Name on which Web Server is running.

Check Jserv is Up :

Oracle Applications DBA Field Guide

Check if you can access OAM (Oracle Application Manager) page. http://hostname.domainname:port_number/servlets/weboam/oam/oamLogin If you can't access login screen for OAM, check logs.

Check mod_pls is working fine :

Oracle Applications DBA Field Guide

http://hostname.domainname:port/pls/$SID so if you installed vision instance with SID as VIS11I your SID here is VIS11II this sometime in documents also called as TWO_TASK. You should see output from procedure FND_WEB.PING . If not check that -
A) database listener is Up
B) GUEST User is not end dated & password is correct.
C) dbc (database connect descriptor) file is corerct at $FND_TOP/secure
D) apps password is correct in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg

Login to Application :

Oracle Applications DBA Field Guide

Login to application with Application User to confirm login is working fine , if not check mod_pls for any issues.

Check Form Server is working :

Oracle Applications DBA Field Guide

Click on any Core Responsibility like "System Administrator", If you are facing any problem opening form Applet
A) Check jinitiator is installed, if not do you have access to install jinitiator
B) Try clearing cache from jinitiator
C) Check forms server parameters are configured properly in appsweb_$CONTEXT_NAME.cfg
D) Check if form server listener is Up : netstat -an | grep form_server_port

Check Concurrent Manager is Up & Running :

Oracle Applications DBA Field Guide

Select "Administer Concurrent Manager" & check if "Actual" & "Target" are same.

Check Reports can display properly :

Oracle Applications DBA Field Guide

Change "Active Users" reports output from "Text file" to "PDF" from Define Concurrent Request Screen. Submit Active Users request & click on Output , check if you can se report in PDF format.

Check Apps Listener is Up :

Oracle Applications DBA Field Guide

Apps listener is different from database listener, Apps Listener is used for various purpose one is to check output & log files in concurrent requests. Check if apps listener is fine by clicking on log file & output file for Active Users request you submitted in Step 7 on previous page. If you encounter any issues while trying to access Log & Output file issue might be with Oracle Apps Listener. Check if adalnctl.sh (where ad is apps dba, aln is apps listener and ctl is control) on application tier started successfully. If yes then check this query (select logfile_name, logfile_node_name, outfile_name, outfile_node_name from fnd_concurrent_requests where request_id=[your request id number].

Check if Workflow is Up :

Oracle Applications DBA Field Guide

Login to OAM (Oracle Application Manager) using url mentioned in step 2 in previous page. After login, On top right of page from "Nevigate to" select "Workflow Manager" from drop down menu and click on GO button. Check "Notification Mailers" is Up .

Check if Discoverer 4i is Up : There are two type of discoverer 4i
Discoverer Viewer - Check http://yourhostname:port/discoverer4i/viewer
Discoverer Plus Check http://yourhostname:port/discwb4/html/english/welcome.htm

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me