topic Re: database management in Operating System - HP-UX

database management

Edgar_8 — Tue, 03 Aug 2004 05:32:09 GMT

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!

Re: database management

harry d brown jr — Tue, 03 Aug 2004 07:28:20 GMT

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

Re: database management

Rainer von Bongartz — Tue, 03 Aug 2004 08:00:14 GMT

Edgar,

Read this for a starter

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

Regards
Rainer

Re: database management

Eric Antunes — Wed, 04 Aug 2004 10:17:13 GMT

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!

Re: database management

Indira Aramandla — Wed, 04 Aug 2004 21:29:17 GMT

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.