seldonca Absent Member.
Absent Member.
949 views

ZCM database

I've grown tired of having to stand on my head and spit nickels to get my Linux ZENworks server updated and patched to get all the new driver updates and PRUs installed so I've decided to replace it with a windows server. I've gotten it mostly completed, both are up to the same support pack level (11.2.4). I'm having problems withe database though, on the install on the windows server it never asked me about installing a database so now I'm trying to install an external database. I'm running the setup off the install disk with the -0 flag. All goes well until I get to the page that asks for the installation directory which I leave the default and I get and error popup saying select a valid path, the specified directory does not seem to have any database files. Given this a new database I wouldn't expect to be any database files in there. I've tried copying the backup files I created when I backed up the existing database on the Linux server in there and I get a little bit further, It asks me for the database name and credentials which I provide having run zman dgc on the linux server. But it then tell me the credentials are invalid and I'm stuck there. Have I missed a step somewhere in the process? Or is this not possible?
Labels (2)
0 Likes
1 Reply
Knowledge Partner
Knowledge Partner

Re: ZCM database

Hi,

Sure, it should be possible to move the database. Have done this a couple of times without issues.

I'm assuming it's a Sybase database you are using?

Where (was)(is) it running, and as Embedded database or remote OEM?

In any case and in a nutshell, the procedure is to;

- setup a new remote OES database service using the same details (zcm database name and user credentials) as used during install of the original one.
- after that base database service install you should be able to swap out the newly setup database with the one you have from the "live" setup.
- with the database moved to the new server, run the procedure to move/change the ZCM primary configuration to point it to the new location.
- If the current setup is using the embedded type, you also need to remove or move the database role from the primary server where it was running.

All these steps are well documented:
https://www.novell.com/documentation/zenworks114/zen11_sys_db_mgmt/data/bfxpyv3.html

NOTE that as you are running 11.2.x you don't have to consider moving the audit database. You don't have that one, just the zcm database (audit db only applies to 11.3 and later).

Hope that helps,
Willem
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.