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?

 
orcun_turkecAsked:
Who is Participating?
 
RindbaekConnect With a Mentor Commented:
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
 
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
RindbaekCommented:
you can monitor standard edition in the GRID control as well
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.