Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to 11.5.10.2
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
    IdM
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management


  • We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Troubleshoot Oracle Apps Web Server and Login Issues
    Wednesday, October 18, 2006
    Register for R12 upgrade
    If you are accessing this page directly without looking at previous post on Web Server log files & basics then my suggestions are that you first go through link

    http://becomeappsdba.blogspot.com/2006/10/oracle-apps-web-server-apache-login.html

    Now by looking at error_log, jserv.log, mod_jserv.log you can find out error message & depending on error message you can try Metalink or Search engine for related error message encountered by others in past.

    Most of the issues happen because of change so try to focus on what changed recently ( See if anything related to change is related) . Once you get first page http://hostname.domain:port
    then there are few automated tool, scripts to check login issues.

    If you don't get first page even i.e. http://hostname.domain:port then focus on error_log. error_log_pls in Apache/Apache/logs and jserv.log , mod_jserv.log in Apache/Jserv/logs

    Once you get first page then when you try to login to application & login is not working then this can be because of number of reasons. In order to understand this you need to understand request flow in Apps . I posted about request flow in August and you can check link at

    http://becomeappsdba.blogspot.com/2006/08/oracle-applications-request-flow.html

    In order to authenticate your user against database in FND_USER table this request is passed from core Apache Module to mod_pls ( plsql) and it uses few files like wdbsvr.app in Apache/modplsql/conf $CONTEXT_NAME.dbc , tnsnames.ora in 806/network/admin/$CONTEXT_NAME , GUEST user & few other file so focus on these files & directories & see what changed recently. These are quite important and thats why you often these questions in apps dba interview .
    Lot of you discussed about difference between GUEST & APPLSYSPUB account ( Both are Public User accounts with very basic access for authentication ). These both are defined in .dbc file under FND_SECURE one for Thin JDBC connection & another for Thick client .

    If you can't login to oracle application by clicking on login link , check if
    --- dbc file in FND_SECURE is correct.
    --- APPL_SERVER_ID in dbc file matches with server ID in FND_NODES table against respective Server
    --- GUEST/ORACLE password is correct & user is not end dated
    --- APPS password is correct in wdbsvr.app file
    --- Check http://hostname.domainnamel:port/pls/$SID and see if package fnd_web can ping & you get output in screen from FND_WEB.ping with correct database_id ( and check if there is correct dbc file in FND_SECURE with name $DATABASE_ID.dbc )

    There is JSP tool test to find most of issues via
    http://host.domain:port/OA_HTML/jsp/fnd/aoljtest.jsp

    Apart from this if you have Metalink access there is very good note at metalink which you can refer

    342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)

    Tell me if you find this information Useful by leaving your comments .

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:13 PM  
    15 Comments:
    • At 6:38 AM, Anonymous Anonymous said…

      Hi Atul,

      Thanks for sharing ur knowledge.Doing a good work helping a lot.This is the first place where i can get lot of information on apps dba without searching for any topics.

      Thanks & Regards,
      From ALL APPS DBA's

       
    • At 7:57 AM, Blogger Atul Kumar said…

      Thanks a lot for your comments.
      Do let me know what else you want to Hear , Few topics in pipeline (Yet to come )

      - SSL Implementation
      - Oracle OCT. CPU patches
      - 10g AS Integration

       
    • At 8:38 AM, Anonymous Anonymous said…

      Atul,

      Thanks for pointing to the link for various apache related files. In one of my earlier project, I saw the following entry in one of the files (not sure if it is oprocmgr.conf or httpd_pls.conf or some other file), I want to know why it was kept so? Apologize, I dont exactly remember the entries.
      One of the entry looked like the one given below. Can you please explain why it was kept so?

      Allow from (ip address1)
      Allow from (ip address2)

      Thanks
      Nagarajan

       
    • At 9:26 AM, Anonymous Anonymous said…

      Atul,

      Looking forward for your post on SSL implementation. Also I would like to know about the following. We have made some changes in a standard oracle package (pls file based on the suggestion from oracle). Now this pls file is compiled and working fine. Is there a way, that I can be notified if I apply a patch which could overwrite the change that I have made to this .pls file. (Like an email which says this patch has overwritten this file after I have applied the patch, so that I can reapply my customization again).

      Thanks
      Nagarajan

       
    • At 9:59 AM, Blogger fhasweh said…

      keep up the good work nice article i would lik hear about having more than one web/forms node how can i reach that.

      fadi

       
    • At 10:00 AM, Blogger Atul Kumar said…

      Fadi,
      Thanks a lot for your inputs . I'll cover it in my future posts.

      Atul

       
    • At 10:01 AM, Blogger fhasweh said…

      thanks and keep up the good work i would like to haer about having more that one web/forms node on an apps env. have more than one access link so i can load balance my users.

      fadi

       
    • At 10:09 AM, Blogger Atul Kumar said…

      Naga,
      Tough question but good one .

      You made changes in Package spec or both or both ? Is this package body wrapped or you can access it.

      I think what you can do it write a Shell script & compare version

      so lets say pls name is test.pls with version 115.12

      variable a=adident test.pls | grep Header

      if a > 115.12 send mail to your mail id .

      You can run this scipt after patch or may be once a week or daily depending on how often you patch .

      You need someone good in shell scripting

      Atul

       
    • At 10:19 AM, Blogger Atul Kumar said…

      Naga Nice Question.

      Some document, files, scripts are very senstive which normal user should not have access to . Like Admin related information & lot many other files related to administration & only administrator should have access. In some cases only a particular server should have access to particular module or file ( in your case mod_proc should only be accessed by core apache & not directly by users )

      So the way to restrict is to use

      Order allow,deny
      Allow from XXXXX
      Deny from XXXXX

      only Allow persons from following IP's or Deny from follwoing IP's

      Order clause determines preferences to given to Allow or Deny if there is overlap.

       
    • At 8:48 AM, Blogger Unknown said…

      Hi atul,

      When we run form server on OAM, If suddenly forms strucked then what we do?

      Thanks
      Asif

       
    • At 9:41 PM, Blogger Atul Kumar said…

      Asif,
      Do you mean during startup or accessing .

      Use adfrmctl.sh command line script.

       
    • At 10:16 AM, Blogger Unknown said…

      Hi Atul,

      Thanks for nice article.
      Here i got a problem with my Apps login. I am running Apps 11.5.10 on my Laptop for the last one year it was working fine but for the last 2 days suddenly it stopped logging in. Services are working fine i can access backend everything fine. It is opening login page http://apps.test:8081/OA_HTML/AppsLocalLogin.jsp after I give UserID and Password there is noresponse even button itself is not showing any progress. Can you please advise on this issue. Really I need your help.

      Thanaks in advance,

      Gopi Krishna

       
    • At 5:18 PM, Anonymous Anonymous said…

      Hi Atu,

      I'm having the same problem as Gopi. By clicking on the 'Login' button, it does not bring me anywhere or the browser does not move at all. It was working before and not sure what's happening now. Please help!!!

      Jac

       
    • At 4:47 AM, Blogger Atul Kumar said…

      Check Jserv logs at $IAS_ORACLE_HOME/Apache/Jserv/logs

       
    • At 8:45 PM, Blogger Kalyan L said…

      I too have the same issue. I could not find any log files under $IAS_ORACLE_HOME/Apache/Jserv/logs

       
    Post a Comment
    << Home
     
    About Me


    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Archives
    Add On
     

    Add to Technorati Favorites

     

     

    Add to Google

     

    Add to My AOL

     

    Subscribe in Bloglines

     

    Subscribe in NewsGator Online

     
    Powered by



    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar