Oracle Application Server Scripts

Hi Bpeterse,

First of all I am very thankful for your reply. And it's my pleasure to get knowlledge from you regarding Application Server.

Actually, I have gone thru EM and I get those information on my screen. I need that source of infomation/required information from where OEM provides. For e.g. if we create database we know that catalog.sql and catproc.sql runs. ok? If we want to creat some additional dbms package we have to run some script. right? same way I need source of those scripts which show results on OEM for Oracle AS.
As you have suggested, we have already change em_mode = 1 and we have created trace group which generates session wise trace file. But I need the scripts - sql scripts which will be run thru sql plus and I get information regarding forms, application etc.

Can you please provide some information on this regards?
It's great help if you provide me. I am very thank ful if you give your expert suggestions on this regards.

Thanks again.

Regards,
Paresh Rathod

Paresh,
Sorry about the delay in getting back to this question.  To my knowledge, forms & reports are still coded in C which is why they aren't yet 'clusterable' like the other portions of the 10gAS.  If you are desiring to use sql queries, then you will be querying the database; I know of no sql scripts being used on the app server.  The app server utilizes XML and text config files, shell scripts and binaries to make everything work together.  

Like I said previously however, if the applications utilize unique (e.f. WAN) logins to access the application, then you could create your list of users querying the database.

For reports, you'll have to enable tracing and create a shell script or program to filter through the logs for info - but I'm not sure when reports are called if user information is even included in the trace output.

For forms, the following is a one-liner that will give you the PID, connect time and IP address of the "frmweb" users (you may have to change the field numbers depending on your unix version or ps output):

ps -fu oracle|grep frmweb|nawk 'BEGIN { FS="  | |\t|," }; { printf("%-8s %-8s\t %-8s\n", $3, $6, $18)}'

And - reviewing your original question, I guess that last bit of code won't help you one whit since you're on windows.... sorry!

Hello Bpeterse,

Thank you very much for clearance. Can you please provide me your personal mail id. My mail ID is
paresh@semaphore-software.com.

Again Thank you very much for your help and suggestions.

Regards,
Paresh Rathod

Paresh,
Thanks for the offer, but I prefer to keep the questions & answers on this forum.  I hope you don't take offense.
Regards,
bp

I think that perhaps the dcmctl command line tool will be best suited for getting the list of application servers, apps and so on that run on a specific instance. Also, dcm can also be used to get all the information on all the servers in the farm

Hi,

Thank you for replying.

Can you please provide me some details with example?

I will also try to get materials to refer as you have suggested here.

Thank you again. Awaiting positive reply from your side as soon as possible.

Regards,
Paresh Rathod

dcmctl listApplications apparently doesn't tell you anything more than what you can get from EM - I just tested it on mine and got actually less than what I can see on the EM console.  Perhaps if you have a cluster of app servers, then dcmctl would be more useful.