cancel
Showing results for 
Search instead for 
Did you mean: 

database management

Edgar_8
Regular Advisor

database management

Hi,

We in our IT shop have a DB environment that had different flavours of production RDBMS software running on
different flavours of UNIX/Windows. The mandate given to us is to investigate the feasability of
implementing a consolidated database management solution. Please could you shed some light on:
- has anyone been given a similar mandate?
- how should one address such a mandate?
- does anyone have a working model of the above mandate that could share their experiences?
- is there any solutions/software that addresses the above mandate besides OEM?
- is there any documentation referencing database management solutions to reference?

Your assistance in this regard is most appreciated.

Thanks in advance!
4 REPLIES
harry d brown jr
Honored Contributor

Re: database management


Look into Oracle 10G - it allows you to build a grid of servers that can service your database needs - and you are allowed different instances of databases within the grid - and you can define processing requirements based upon Service Level Agreements.

live free or die
harry
Live Free or Die
Rainer von Bongartz
Honored Contributor

Re: database management

Edgar,

Read this for a starter

http://www-306.ibm.com/software/data/pubs/pdfs/bloor.pdf

Regards
Rainer
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
Eric Antunes
Honored Contributor

Re: database management

I think the first thing to consider is: what happened to have all those separate systems and versions?

After that you must investigate if there is a RDBMS version and OS version supported/certified by all your appplications? For Oracle E-Business Suite you can see the certification matrix on Metalink. For other apps you must consult the respective vendor.

If all apps have one or more supported/certified RDBMS/OS versions then choose the latest!
Each and every day is a good day to learn.
Indira Aramandla
Honored Contributor

Re: database management

Hi Edgar,

I agree with Antunes. It would be better if you consolidated to fit all the applications to the latesest release and reliable flavours of OS.

If the applications are certified and compatibale with the release of RDBMS on the same UNIX OS version then plan for migrating the databases to the stable and reliable environment of UNIX and latest versions of Oracle RDBMS.

You may not be able to do for all the applications in questions but atleast if you got most of them consolidated then you can plan for scripts to be written and scheduled through cron and e-mail any alerts or warnings before hand.

Long time ago we had a similar environment with Oracle databases spaning from 7.3.3 through 8.1.7 and on IBM AIX, Sun Solaris and Windows....etc

We had scripts written to check the storage space for all the tablespaces / datafiles, check the alert logs of all the databases and e-mail the DBA when the storage space exceeds 85% of the total allocated space, errors in the alert logs. These scripts can be scheduled through cron na feequency depending of the type of application and data usage.

IA.
Never give up, Keep Trying