Troubleshoot Oracle Apps Web Server and Login Issues

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

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

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

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

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

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

Atul

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

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

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.

Hi atul,

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

Thanks
Asif

Asif,
Do you mean during startup or accessing .

Use adfrmctl.sh command line script.

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

Dear : Mr.Atul

my Qn is ,can v do the 4 node(DB/Conc+rep+admin/Web/frm) installation by using rapid wiz? and wch would define frist in rapid wiz ?

bye 4 now

cheers:
murali

Yes Murali,
You can do this configuration

Check Install Guide at http://download.oracle.com/docs/cd/B25516_18/current/acrobat/r115102ins.pdf

under chapter 3 Page 65, first install Database and any other services on that node (like CM) and rest other servers you can install in any order

Atul

Dear Atul
Except for couple of users, I want to disable access to our Apps instance. How could I achieve this objective. Thanks & regards
P Ahuja

I am getting the following message while navigating some of the menus in the Oracle GRC Manager

Exception
The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.

Is GRC manager you are running on windows ?

Check metalink note # 215255.1 Unable to Connect to Database with Oracle Client Software for Windows

Thanks A lot men for you help to all

Hi,

I was trying to log in to Oracle Apps R12. It is not able to show me the login page. Says Error 404. Could you help me out in this issue so as not to loose all the setup i had already done on ORACLE HRMS.

System parameter file is /apps/demodb/9.2.0/network/admin/DEMO_apps11i/listener.ora
Log messages written to /apps/demodb/9.2.0/network/admin/demo.log
Trace information written to /apps/demodb/9.2.0/network/admin/demo.trc
Trace level is currently 0

Started with pid=19050
24-JAN-2013 10:56:52 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCDEMO))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

System parameter file is /apps/demodb/9.2.0/network/admin/DEMO_apps11i/listener.ora
Log messages written to /apps/demodb/9.2.0/network/admin/demo.log
Trace information written to /apps/demodb/9.2.0/network/admin/demo.trc
Trace level is currently 0

Started with pid=19050
24-JAN-2013 10:56:52 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCDEMO))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

please solve my issue