Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1585
  • Last Modified:

How to make a database monitoring application with Oracle Apex?

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
orcun_turkec
Asked:
orcun_turkec
  • 4
  • 4
1 Solution
 
RindbaekCommented:
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
 
orcun_turkecAuthor Commented:
I' m using Oracle 11G Standard edition.
0
 
RindbaekCommented:
you can monitor standard edition in the GRID control as well
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
orcun_turkecAuthor Commented:
Is it free for monitoring of 50 servers  with oracle 11G standard edition?
0
 
RindbaekCommented:
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
 
orcun_turkecAuthor Commented:
But Apex is free,  do you know how to  develope  such  applications wiyh Apex ?
0
 
RindbaekCommented:
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
 
AnandCommented:
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
 
orcun_turkecAuthor Commented:
Thank you...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now