Querying the JAS servers outside of Server Manager

altquark

altquark

Legendary Poster
Has anyone successfully queried the JAS servers outside of Server Manager or SAW ?

I am trying to send a query to a JDE JAS Server directly - maybe through an API perhaps - to try and determine how many users are on the JAS server at that instant of time. I do not want to do this through the Server Manager because I want to collect these statistics or use the information in a script.

Has anyone successfully done something like this ? Or perhaps this is a novelty ?!
 
I'm still trying to do this too ;-)

It was easier with the Enterprise Server...
 
After also putting in a ticket to Oracle (and getting nowhere) - I tried looking at all the tools that come with Server Manager. Evidently the port 1450x stream is a JMX stream - and I even downloaded the sun JDK so I could run jconsole. Unfortunately it doesn't connect.

I thought I had a bit of a brainstorm earlier - whereas I used the server manager monitors to output the information to a file by creating a "monitor" and putting the threshold to 1 - which seemed to work as soon as I went OVER 1 - but then the monitor seems to just stop monitoring. I even clicked "autostart". That would have worked for me, because the monitor creates an XML file on the Server Manager server (in our case, the deployment server) which I can parse using a script. I'm hesitant putting in yet another ticket before exploring other avenues.

I even tried using OPMNCTL with the "status" and different options. Not much use there - since that only queries what servers are running.

Lastly, I found something called "EMCLI" - but I think this might have something to do with the original Enterprise Manager under earlier OAS versions. Also, looking to see what users are connected through OAS directly is NOT a reliable figure.

I know I can use WGET to "get" the web page from the server manager into a file, then use AWK or something similar to parse out the information - but thats quite messy, and I really wanted a simple query command...

If anyone knows how to do this, I'd appreciate it ! Alex - if you can get a tool in place that can send instructions from the command line to the server manager - that'd be TOTALLY valuable...we'd be able to schedule startup of JVM's, disable users, query information - a whole host of stuff !

Oracle is usually big into command line tools. I'm a little disappointed that the Server Manager developers don't subscribe to the same mentality. Us "techies" like command line !
 
Indeed.

In fact, they have even taken steps to make it harder to use - it uses SSL encryption in all comms...
 
Not that it's an entirely dead end, of course.

They have always had very imaginative passwords - BATMAN, ROBIN, POOH, and now "The Goose Flies At Dawn" - this last one certainly gave me a laugh ;-)
 
"POOH" was actually Foosballs' dogs' name. It was hardcoded deep in the system - thats why that password stayed around for so long. I haven't checked to see if its still working under 9.0...
 
Well, without any answers, I developed a solution for this myself. In effect, a command line utility that can automatically change settings on the Server Manager - such as grab the number of users, disable the JAS servers, refresh the web cache - all can now be scheduled or be a part of a larger "reset" script. Contact me if theres any interest!
 
Wow. I am a little taken back by the response for this !

Last week, I developed a "mock up" of two command line tools for server manager - getstats "counts" the number of users for an Java instance - and "JVMable" will enable or disable a specific JVM instance from the command line.

It's definitely a major issue that the JAS servers cannot be managed from scripts, so, based on the number of inquiries, I decided to expand my little tool to something a little more solid and reliable than what I currently have - able to control almost every aspect of the server manager from the command line.

When I made my little post, I was shocked at the number of inquiries I received. Since I've given away so much freebies in the past (used without a word of thanks by Big-4 consultants, often incorrectly), I decided that with the number of queries, to license this as an actual product. If there is demand, then it'll be available for sale for commercial use.

I'm collecting everyones information, and we'll see if theres a market for this.

Jon Steel
EnterpriseOne Technical Specialist
erpSOURCING LLC
http://www.erpsourcing.com
 
hmmmm......since you're now selling this tool can we all have input? (I'm not charging for design specs).

How about recording not just the number of users per JVM but also the applications that they are using and pipe this out to a CSV file?

Perhaps you can add the log on date/time and when each application was opened/closed. Afterall this is really what people want recorded.

How about a command line tool to clear the cache?

Server Manager can be pretty slow once you get past 20 - 30 instances so a command line tool work well in these cases.

As for the lack of kudos.....geez they could atleast by you a cup of coffee!
 
[ QUOTE ]

How about a command line tool to clear the cache?

[/ QUOTE ]

Done. Thats definitely one thing that many people want to see.

[ QUOTE ]

How about recording not just the number of users per JVM but also the applications that they are using and pipe this out to a CSV file?

Perhaps you can add the log on date/time and when each application was opened/closed. Afterall this is really what people want recorded.


[/ QUOTE ]
This IS possible - but a little tricky. I'm looking into this - perhaps with Version 2. The problem is that the command line will only print out information at a "point in time" - so if you're trying to monitor what applications are being run, by whom and when, then this is probably not the best way to do this.

Instead, putting a "select" trigger on the versions table (F983051) is the only sure-fire, guaranteed way to get who/when is opening up applications. Not sure how to get the information when an application is being "closed" though !

[ QUOTE ]
As for the lack of kudos.....geez they could atleast by you a cup of coffee!

[/ QUOTE ]
Dunkin' Donuts Coffee is always welcome...
 
[ QUOTE ]

How about a command line tool to clear the cache?

[/ QUOTE ]

I'm still working on this tool.

So far, I've been able to achieve the following from the command line:

1. List the number of users by instance name
2. Disable logins by instance name (all JVM's)
3. Enable logins by instance name (all JVM's)
4. Perform garbage collection by instance
5. Delete cache by instance

I'm trying to find out what other functions are available to "play" with. There might be some "undocumented" features in server manager - we can only hope !

Once I finish this, I'll be able to compile this tool and it should work on 8.97 and 8.98 server managers. Very exciting, since it completely automates a lot of standard CNC procedures - and helps with ensuring a clean java server environment !
 
Back
Top