Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to make a database monitoring application with Oracle  Apex?

Posted on 2010-11-26
9
Medium Priority
?
1,561 Views
Last Modified: 2012-05-10
Hi experts,

I' m trying to make a  web-based database monitoring  application   to monitor 50 servers databases in different locations. The servers are running on Windows 98 with Oracle 11G on them.
Is it possible to make this database monitoring application with Oracle Apex?

 
0
Comment
Question by:orcun_turkec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 8

Expert Comment

by:Rindbaek
ID: 34217071
probably but why dont you have a look at the enterprise manager for grid control
http://www.oracle.com/technetwork/oem/grid-control/overview/index.html

the issue i can see is running oracle 11 on windows 98....
0
 

Author Comment

by:orcun_turkec
ID: 34217241
I' m using Oracle 11G Standard edition.
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 34217251
you can monitor standard edition in the GRID control as well
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:orcun_turkec
ID: 34217593
Is it free for monitoring of 50 servers  with oracle 11G standard edition?
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 34217608
if you pay for one oracle licese yes then it should free http://download.oracle.com/docs/cd/E11857_01/license.111/e11987/toc.htm .
0
 

Author Comment

by:orcun_turkec
ID: 34236461
But Apex is free,  do you know how to  develope  such  applications wiyh Apex ?
0
 
LVL 8

Accepted Solution

by:
Rindbaek earned 1500 total points
ID: 34239087
I haven't build anything like that but depending on what you want then yes it should be able to build it in apex. But you need to decide on a design.

eg
1) Do you want historical data or just a here and now picture
2) How will you retrieve data from the monitored targets?
3) What do you actually want to monitor?


1) Even though you are limited by a 4 GB database size limit so you probably wont have that long a history stored, i would suggest some sort of history (a repository).
2) This could be a database link and a user with access to look only at the objects needed to perform the monitoring.
3) this is the tricky part, you need to define your needs and the figure out how to get the knowledge.

Have you checked the license agreement of the GRID control, because it can offer you both a monitoring and an administrative interface and it is a webbased tool.
0
 
LVL 5

Expert Comment

by:Anand
ID: 34276432
orcun_turkec,
OEM grid control monitoring software is far superior.Even if you develop some software using apex, no way u can match with OEM grid. If you manage the cost/license, OEM will provide lot of benefits like performance reports,monitorng,security compliance reports... so many features.
0
 

Author Closing Comment

by:orcun_turkec
ID: 34316722
Thank you...
0

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question