Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Murzda Absent Member.
Absent Member.
1783 views

Database Fault Tolerance questions?

Just wondering,

Is the only way to achieve Fault Tolerance for the ZCM database installing it on two clustered servers? Also, is it fully supported in a clustered environment?

If I were to lose the Primary Server hosting the database in a non clustered setup, could I restore it to a second Primary server in the Zone or would I have to reinstall the first Primary server then restore the database?

What fault tolerance is built into ZCM by default if any? If my database is down, what happens to all of my users if I lose the Primary Server hosting the database?

Thanks for answering all of my questions.

Chris

Labels (2)
0 Likes
3 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Database Fault Tolerance questions?

It is recommended to use an External Database and configure Fault Tolerance
for the Database through means supported by the External DB whether it be
MS-SQL or Sybase.
Support for Oracle will be coming shortly as well.

There is no need to Cluster your primary servers, since the Agents will
detect a downed primary and just move to another that is up.
The built-in OEM Sybase Database is not clusterable.

--
Craig Wilson - MCNE, MCSE, CCNA
Novell Support Forums Volunteer Sysop

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.

"Murzda" <Murzda@no-mx.forums.novell.com> wrote in message
news:Murzda.369jnd@no-mx.forums.novell.com...
>
> Just wondering,
>
> Is the only way to achieve Fault Tolerance for the ZCM database
> installing it on two clustered servers? Also, is it fully supported in
> a clustered environment?
>
> If I were to lose the Primary Server hosting the database in a non
> clustered setup, could I restore it to a second Primary server in the
> Zone or would I have to reinstall the first Primary server then restore
> the database?
>
> What fault tolerance is built into ZCM by default if any? If my
> database is down, what happens to all of my users if I lose the Primary
> Server hosting the database?
>
> Thanks for answering all of my questions.
>
> Chris
>
>
> --
> Murzda
> ------------------------------------------------------------------------
> Murzda's Profile: http://forums.novell.com/member.php?userid=76
> View this thread: http://forums.novell.com/showthread.php?t=315976
>



0 Likes
Highlighted
baltazb Absent Member.
Absent Member.

Re: Database Fault Tolerance questions?

Hi Craig,
My organization is also worried about fault tolerance for the zcm database. we are trying to find answers on how to have fault tolerance and high availability. So, my question is, How long do the agents try to log into the downed server before they move on to the next available server? Also, do you have any recommendations on how to go about moving the MS SQL database to another server? We would like to have primary server separate from the database.

Any advise that you can give me would greatly appreciated.

Thank you.
0 Likes
jaredljennings Absent Member.
Absent Member.

Re: Database Fault Tolerance questions?

baltazb said on 5/21/2008,

>also, do you have any recommendations on how to go about
>moving the MS SQL database to another server? We would like to have
>primary server separate from the database.


This is actually a fairly easy process.

Use the normal MS procedures to move the database using sql admin studio.
Modify "/etc/opt/novell/zenworks/datamodel/zdm.xml" and reference the new
server for the database.

You may also need to create a new login on the new database server and
give it full permissions to the database. If so, you must also modify
dmaccounts.properties in the same location as above. An account will be
listed in the file with a hashed password. Change the password to a
clear-text password that you specified when you created the login. The
password will be re-hashed when the ZCM service is restarted.
--
Jared Jennings - Data Technique, Inc.
Novell Support Forums Sysop
My Blog and Wiki with Tips, Tricks, and Tutorials
http://jaredjennings.org
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.