Novell Doc: ZENworks 11 SP3 Upgrade Guide - Upgrading the Primary Servers

1.6 Upgrading the Primary Servers

You can upgrade by using a graphical user interface (GUI) program or a command line (Linux only).

IMPORTANT:

Do not use the ZENworks System Update to upgrade the Primary Servers to ZENworks 11 SP3.

Before upgrading the ZENworks server on a Windows device, run the Windows Update on the device to ensure that all the available updates are installed on the device. Subsequently, disable the Windows Update to ensure that there are no further updates on the device when you upgrade the ZENworks server on the device. Windows Update can be enabled after upgrading ZENworks.
Disable the Linux Update to ensure that there are no further updates on the device when you upgrade the ZENworks server on the device.
ZENworks 11 SP3 does not support OEM database on a 32-bit device. If you are using Remote OEM Sybase database, upgrade or migrate the database to a 64-bit OEM Sybase before upgrading the Primary Server. For more information, see Section 1.5, Upgrading the Remote OEM Sybase SQL Anywhere Database.

1.6.1 Using the GUI to Upgrade Linux and Windows Servers

Perform the following procedure on the Primary Server that you want to upgrade to ZENworks 11 SP3 if all the prerequisites explained in Section 1.4, Prerequisites are met:

To start the ZENworks 11 SP3 upgrade program:

Linux: Open a Linux terminal, browse to the root of the ZENworks 11 SP3 installation media, then enter the sh setup.sh command.
Windows: Do one of the following:
- Browse to the root of the ZENworks 11 SP3 installation media, then double-click setup.exe.
- Open a DOS window, browse to the root of the ZENworks 11 SP3 installation media, then enter the setup.exe command.

NOTE:If Audit database needs to be created remotely, enter the setup.sh -c --zcminstall command for Linux or setup.exe -c --zcminstall command for Windows Primary Server. In the Select Database page, select the Audit database, then click Next. You can choose to create the Audit database either locally on the Primary Server or remotely on the database server.

For information on why the Audit database is created using setup.sh -c or setup.exe command, see Section 1.2, Database Considerations.

The supported combination of the ZENworks and Audit database is listed below:

Table 1-1 Combination of the ZENworks and the Audit Database

ZENworks Database	Audit Database
Embedded Sybase SQL Anywhere	Embedded Sybase SQL Anywhere Remote Sybase SQL Anywhere
OEM Sybase SQL Anywhere	OEM Sybase SQL Anywhere (Default) External Sybase SQL Anywhere
External Sybase SQL Anywhere	External Sybase SQL Anywhere (Default) OEM Sybase SQL Anywhere
Microsoft SQL Server	Microsoft SQL Server
Oracle	Oracle

During upgrade, see Table 1-2, Upgrade Information for details on the upgrade data.

If you are using the GUI upgrade, you can also click the Help button for similar information.
Do one of the following on the Windows device:
- If you selected to reboot automatically (you selected the Yes, restart the system option during the upgrade; see Restarting the Server (applicable only for Windows)), continue with Step 5 after the booting process has completed and the services have started.
- If you selected to reboot manually (you selected the No, I will restart the system myself option during the upgrade; see Restarting the Server (applicable only for Windows)), wait for the upgrade to complete and the services to start in order to verify it in Step 4.
After the upgrade is complete and the ZENworks services are restarted, do any of the following to verify that ZENworks 11 SP3 is running:
- Check the Windows services by using the GUI:
  
  On the server, click Start, select Administrative Tools > Services, then review the status of the Novell ZENworks Loader and Novell ZENworks Server services.
  
  If the services are not running, start them. Right-click the Novell ZENworks Server service, select Start, right-click the Novell ZENworks Loader service, then select Start.
  
  Alternatively, you can use the Restart option for Novell ZENworks Server to stop all of the related services, which stops and then starts each of them in their correct order, including Novell ZENworks Loader.
- Launch ZENworks Control Center:
  
  Use the following URL to open ZENworks Control Center in a web browser on any device in your network:
  
  https://DNS_name_or_IP_address_of_Primary_Server:port_number/zenworks
- Check the Linux services by using the specific service command:
  
  On the server, run the following commands:
```
/etc/init.d/novell-zenserver status
```
```
/etc/init.d/novell-zenloader status
```
  If the services are not running, run the following commands to start the ZENworks services:
```
/etc/init.d/novell-zenserver start
```
```
/etc/init.d/novell-zenloader start
```
- Check the Linux services by using the configuration command:
  
  On the server, run the following command:
```
/opt/novell/zenworks/bin/novell-zenworks-configure ‑c SystemStatus
```
  ZENworks services and their statuses are displayed.
  
  To start the services, run the following command:
```
/opt/novell/zenworks/bin/novell-zenworks-configure ‑c Start
```
To upgrade another Primary Server, repeat from Step 1.

IMPORTANT:Repeat these steps until all Primary Servers in the Management Zone are upgraded.

The Table 1-2 provides the upgrade information for upgrading from ZENworks Configuration Management 10.3.x and ZENworks 11 SP2 to ZENworks 11 SP3.

Table 1-2 Upgrade Information

Upgrade Information	Explanation
License agreement	The Upgrade installer does not proceed if the license agreement is not accepted.
ZENworks Prerequisites	If the required prerequisites are not met, the upgrade procedure does not continue. The requirements that are not met are displayed (GUI) or listed (command line). For more information, see System Requirements in the ZENworks 11 SP3 Server Installation Guide. If the.NET prerequisite is not met, you can click the ZENworks link in the description to install the runtime version that is bundled with ZENworks. Ensure that you install Microsoft .NET 4.0 SP1 framework and all its latest updates. After .NET is installed, the ZENworks upgrade proceeds. NOTE:You must reboot the device after the installation of .NET 4.0.
Upgrade Type	Select Yes if this is the first Primary Server in the Management Zone to be upgraded, else select No. If you select Yes, you are prompted for the Database Details. or If you select No, perform the steps listed in Table 1-3, Upgrade Information - Upgrade of additional Primary Servers.
Zone administrator information	Specify the Management Zone administrator’s login name and password.
Database Purging	The time required to complete the upgrade of the first Primary Server depends on the size of the data present in the database. On Primary Servers that are using an MS SQL or Oracle Enterprise database, the upgrade installer checks the size of unwanted inventory data that can be purged. If there are more than 200,000 records to be purged, the Upgrade installer gives an option to purge the database before upgrading the Primary Server. For other database types, if there are less than 200,000 records to be purged, this page does not open. Purge the database now: If this option is selected, the wizard will continue with purging the database. After the database is purged, re-initiate the upgrade process. Configure the following settings for purging: Remove the deleted products and components older than x day(s): Specify the number of days after which to purge deleted product and component data. The default value is 180 days. Remove the inventory history data older than x day(s): Specify the number of days after which to purge the inventory history. The default value is 180 days. Remove the Software Application Usage data older than x day(s): Specify the number of days after which to purge the software application usage data collected for Asset Management. The default value is 180 days. Remove the Network Software Usage data older than x day(s): Specify the number of days after which to purge the network software usage data collected for Asset Management. The default value is 180 days. Remove the Web Application Usage data older than x day(s): Specify the number of days after which to purge the Web application usage data collected for Asset Management. The default value is 180 days. IMPORTANT:If the purging process is interrupted, the database might become inconsistent. Continue without purging the database: If this option is selected, the wizard continues with the upgrade process.
ZENworks Diagnostic Center	Verify the database using ZENworks Diagnostic Center. For more information, see Running ZENworks Diagnostic Center to Verify the Database Schema. NOTE:Verify the database before you upgrade the first Primary Server to ZENworks 11 SP3. You will not be prompted to verify the database for the subsequent server upgrades. After you verify the database, select Yes, I have verified the database schema using ZDC. This option confirms that you have verified the ZENworks database schema is correct.
Tablespace for ZENworks Database (applicable for Oracle database)	ZENworks 11 SP3 upgrade can use the tablespace that is already configured in 11.2.x or, you can choose to configure the new tablespaces for tables data and indexes. ZENworks 11 SP3 upgrade will automatically move the database objects to the new tablespaces.
Audit Database	See Audit Database Information Using the GUI for information on the combination of the ZENworks and the Audit database.
ZENworks Services Optimization	If ZENworks services are not configured for high performance, this page is displayed. You can select Yes to reconfigure the ZENworks Services setting during installation or select No to ignore. If you select Yes, then the ZENworks upgrade installer increases the RAM configuration settings for ZENServer and ZENloader.
Pre-upgrade summary	The following fields are displayed in the summary: ZENworks Home Directory: Displays the location on the Primary Server where the ZENworks software that is being upgraded is installed. Zone Name: Displays the name of the Management Zone to which this server belongs. Upgrade Database: Indicates the upgrade status of the ZENworks database and automatically checks whether it needs to be upgraded or not. To make changes to any information, click Previous.
Upgrading process	The upgrade process takes several minutes, depending on the capabilities of the hardware and size of data in the database. During the upgrade, you can click Cancel to stop, which leaves changes in the files that were upgraded up to that point. For more information on what to do after canceling, contact Novell Support.
Upgrading errors	If there are errors during the upgrade, this page is displayed. For detailed information, see the log files in the following locations: On Windows %ZENWORKS_HOME%\logs %ZENWORKS_HOME%\logs\ZENworks_Upgrade_<TimeStamp>.log.xml %ZENWORKS_HOME%\logs\loader-messages.log %ZENWORKS_HOME%\logs\system-update-import.log %ZENWORKS_HOME%\logs\system-update\<Update GUID> %ZENWORKS_HOME%\logs\pre-global-actions.log %WINDOWS_SYSTEM_DRIVE%\tmp\err.log On Linux /var/opt/novell/log/zenworks /var/opt/novell/log/zenworks/ZENworks_Upgrade_<TimeStamp>.log.xml /var/opt/novell/log/zenworks/system-update/<Update GUID> /var/opt/novell/log/zenworks/loader-messages.log /var/opt/novell/log/zenworks/system-update-import.log /var/opt/novell/log/zenworks/pre-global-actions.log /tmp/err.log Resolve the errors and restart the upgrade.
Post-upgrade actions	Choose to run the ZENworks System Status utility to launch the ZENworks services heartbeat check before closing the upgrade program. The results are posted in the upgrade log file.
Restarting the Server (applicable only for Windows)	Upon a successful upgrade on a Windows Primary Server, you can select between rebooting immediately or later: Yes, Restart the System: If you select this option, the server is rebooted to complete the upgrade process. No, I Will Restart the System Myself: If you select this option, the upgrade process finishes when you reboot the server for the next time. IMPORTANT:Reboot the server to complete the upgrade process.
Upgrade completion	The actions you selected previously are performed, including: Upgrading the ZENworks database (done when the first Primary Server is upgraded). Upgrading all ZENworks components installed on the Primary Server. Importing System Update into the zone so that you can upgrade the managed devices in the zone.

Table 1-3 Upgrade Information - Upgrade of additional Primary Servers

Installation Information	Explanation
Primary Server and Zone Credentials	You are prompted for the details of the Primary Server that is already upgraded, the Zone credentials, and the SSL port number.
ZENworks Database Details	(Conditional) If the device cannot connect to the database through the Primary Server that is already upgraded, you are prompted for the details to connect directly to the database.
Port Number	A few ports that might be blocked by your firewall need to be opened. You can open them now or you can manually open them later.
Pre-upgrade summary	WARNING:Before the Pre-upgrade summary page is displayed, the ZENworks services will be stopped on the server. If you cancel the upgrade at this time, you will need to restart the ZENworks services manually. The following fields are displayed in the summary: ZENworks Home Directory: Displays the location on the Primary Server where the ZENworks software that is being upgraded is installed. Zone Name: Displays the name of the Management Zone to which this server belongs. Upgrade Database: Indicates whether the ZENworks database will be upgraded. Its status is automatically checked by the program to see whether it needs to be upgraded.
Upgrading process	The upgrade process takes several minutes, depending on the capabilities of the hardware.
Errors during upgrade	If there are errors during the upgrade, this page is displayed. For detailed information, see the log files in the following locations: On Windows %ZENWORKS_HOME%\logs %ZENWORKS_HOME%\logs\ZENworks_Upgrade_<TimeStamp>.log.xml %ZENWORKS_HOME%\logs\loader-messages.log %ZENWORKS_HOME%\logs\system-update-import.log %ZENWORKS_HOME%\logs\system-update\<Update GUID> %ZENWORKS_HOME%\logs\pre-global-actions.log %WINDOWS_SYSTEM_DRIVE%\tmp\err.log On Linux /var/opt/novell/log/zenworks /var/opt/novell/log/zenworks/ZENworks_Upgrade_<TimeStamp>.log.xml /var/opt/novell/log/zenworks/system-update/<Update GUID> /var/opt/novell/log/zenworks/loader-messages.log /var/opt/novell/log/zenworks/system-update-import.log /var/opt/novell/log/zenworks/pre-global-actions.log /tmp/err.log You must resolve the errors and restart the upgrade.
Post-upgrade actions	Before closing the upgrade program, you can run the ZENworks System Status utility to launch a heartbeat check of the ZENworks services. The results are listed in the installation log.
Restarting the Server (applicable only for Windows)	After the upgrade on a Windows Primary Server, you can select either to reboot immediately or later: Yes, Restart the System: Reboots the server to complete the upgrade process. No, I Will Restart the System Myself: Completes the upgrade process, when you reboot the server the next time. IMPORTANT:You must reboot the server to complete the upgrade process.
Upgrade completion	The actions you selected previously are performed, including: Upgrading the ZENworks database (done when the first Primary Server is upgraded). Upgrading all ZENworks components installed on the Primary Server. Importing System Update into the zone so that you can upgrade the managed devices in the zone.

Audit Database Information Using the GUI

If the ZENworks database is Embedded Sybase SQL Anywhere, the Audit database combinations are as follows:
- Embedded Sybase SQL Anywhere: Creates an Audit database on the current device. Select this option, then click Next.
  
  The Pre-Upgrade Tasks page displays recommendations to back up the ZENworks database before the upgrade begins. You can choose to stop the ZENworks services and back up the ZENworks database and other important information. Click Next.
  
  The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
- Remote Sybase SQL Anywhere: Enables you to create an Audit database on a remote device. Specify the following information:
  - Server Address and Port Number of the server that is hosting the existing Audit database that is created using the setup.exe -c command.
  - Database Name of the Audit database, Username and Password of an existing user who has permissions to access the database, and the Server Name of the Audit database device. The Pre-Upgrade Tasks page is displayed.
  - The Pre-Upgrade Tasks page displays recommendations to back up the ZENworks database before the upgrade begins. You can choose to stop the ZENworks services and back up the ZENworks database and other important information. Click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
OEM Sybase: For OEM Sybase, the Audit database combinations are:
- OEM Sybase: Enables you to create an Audit database on an OEM Sybase device. Specify the following information:
  - Server Address and Port Number of the server that is hosting the existing Audit database, created by using the setup.exe -c command.
  - Database Name of the Audit database, Username and Password of an existing user who has permissions to access the database, and the Server Name of the Audit database device. The Pre-Upgrade Tasks page is displayed.
  - The Pre-Upgrade Tasks page displays recommendations to back up the ZENworks database before the upgrade begins. You can choose to stop the ZENworks services and back up the ZENworks database and other important information. Click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
- External Sybase : Enables you to create Audit database on a external Sybase device. Specify the following information are:
  - Server Address and Port Number of the server that is hosting the existing Audit database created using the setup.exe -c command.
  - Database Name of the Audit database, Username and Password of an existing user who has permissions to access the database, and the Server Name of the Audit database device. The Pre-Upgrade Tasks page is displayed.
  - The Pre-Upgrade Tasks page displays recommendations to back up the ZENworks database before the upgrade begins. You can choose to stop the ZENworks services and back up the ZENworks database and other important information. Click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
If the ZENworks database is External Sybase, then the Audit database combination allowed is External Sybase or OEM Sybase database. Information required to create these databases is specified in the previous combination for ZENworks on an OEM Sybase database.
If the ZENworks database is MS SQL, then the Audit database must be MS SQL. Using this option, you can create a new database or use an existing database that is created by using the setup.exe -c command. Based on this selection, the required database information should be entered in the subsequent pages.
- Create new database: Ensure that the database user has permissions to create a database and user login. Specify the following information:
  - Server Address, Port Number used by the database server for the Audit database, and (optional) Named Instance of the device where the database will be created. Username, Password, and Domain name of the new Audit database user.
    
    Specify whether Windows Authentication or SQL Server Authentication is used. For Windows Authentication, specify the Windows credentials for the Windows device that hosts the database. For SQL Authentication, specify a user name of a valid SQL user. Click Next.
  - Database Location, ensure that the path specified exists on the remote device that hosts the database. Click Next.
  - Database Name, Username, Password, and Domain of the required database user. This option is enabled if Windows Authentication is selected. Choose the type of authentication, Windows or SQL Server. Click Next.
  - A Review page is displayed with the specified information. If there are no further modifications, click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
- Use existing database: Ensure that an Audit database has been created using the setup.exe -c command. Specify the following information:
  - Server Address, Port Number used by the database server for the Audit database and (optional) Named Instance of the external database server where the Audit database exists. Click Next.
  - Database Name, Username, Password, and Domain of the desired database user that was created using the setup.exe -c command. For the Windows Authentication, provide a user name on the current device or in the domain. For SQL Authentication, specify a user name of a valid SQL user. Click Next.
  - Review the Access Username, Server Address, Port Number, Database Name, and Named Instance details. If there are no further modifications, click Next.
  - The Pre-Upgrade Tasks page displays recommendations to back up the ZENworks database before the upgrade begins. You can Stop the ZENworks services and back up the ZENworks database and other important information. Click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
Oracle database: If the ZENworks database is Oracle, then the Audit database must be Oracle.

Using this option, you can create a new database or use an existing database that is created by using the setup.exe -c command on Windows or setup.sh -c command on Linux. If the ZENworks database is Oracle, then Tablespace name for Tables and Tablespace name for Indexes are displayed. By default, it is USERS.
- Create new database: Ensure that the database user has the required permissions to create a database and user login. If the user does not have the required permissions then an error message is displayed with the grant-privilege.sql file.
  
  The grant-privilege.sql file contains the SQL GRANT statements to enable the permissions. For more information, see Prerequisites for External Databases.
  - Connection information for the external database server that hosts the database: Server Address, Port Number used by the database server for the Audit database, and Service Name.
  - Administrators Username and Password.
  - New Audit database user credentials: Username and Password.
  - Select Let ZENworks create the tablespace or Let Oracle DBA create the tablespace. If you want the database administrator to create the tablespace, it is recommended to provide a separate tablespace name for the table and the indexes; however, the ZENworks upgrade installer does not mandate it. It is recommended to have sufficent disk space for both Tablespace name for Tables and Tablespace name for Indexes.
    
    If there is insufficient disk space to accommodate a new tablespace with the same size of the current ZENworks Schema, you can use the existing tablespace. The Upgrade installer automatically moves the data and indexes or the indexes alone into the new tablespace.
    
    Specify the following to create a new tablespace:
    
    Tablespace name for Tables: Ensure that the tablespace name is unique and it starts with [a-z] | [A-Z]. Follow the Oracle tablespace naming conventions.
    
    Tablespace name for Indexes: Ensure that the tablespace name is unique and it starts with [a-z] | [A-Z]. Follow the Oracle tablespace naming conventions.
    
    DBF File location for Tables
    
    DBF File location for Indexes: The specified physical path of the DBF file should be an existing path. The file name extension must be .dbf
  - A Review page is displayed with the specified information. If there are no further modifications, click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.
- Use existing database: Ensure that an Audit database has been created using the setup.exe -c command. Specify the following information:
  - Server Address, Port Number used by the database server for the Audit database and the Service Name of the database server where the Audit database is created using the setup.exe -c command. Click Next.
  - Audit database Username, Password, Tablespace name for Tables, and Tablespace name for Indexes. Click Next.
  - A Review page is displayed with the specified information. If there are no further modifications, click Next.
    
    The Optimization page is displayed. To continue with this procedure, see ZENworks Services Optimization.

1.6.2 Using a Command Line to Upgrade a Linux Server

Perform the following on the Primary Server that you want to upgrade from ZENworks Configuration Management 10.3.x to ZENworks 11 SP3:

Ensure that the upgrade prerequisites are met, as explained in Section 1.4, Prerequisites.
Start the ZENworks 11 SP3 upgrade program, open a Linux terminal, browse to the root of the upgrade media, then enter the following command:
```
./setup.sh --console 
```
or
```
./setup.sh -e 
```
Select the language. English is the default language. Select the number corresponding to your language, then press Enter to continue.
Review the introduction, then press Enter to continue.

HINT:Type back and press Enter to return to a previous installation option to make the changes. Type quit to exit the wizard.
To accept the end-user license agreement (EULA), type 1, then press Enter.
To accept the license agreement, type 1, then press Enter.

If you disagree, the upgrade wizard quits.
The Prerequisite check page is displayed. If there are any warning or error messages, resolve the errors, then press Enter to continue.
Type 1 if this is the first Primary Server to be upgraded; otherwise, type 2,then press Enter.
(Conditional) If you typed 1 in the previous page, you will be prompted for the database details. Specify the database details, then press Enter and continue with Step 11.
(Conditional) If you typed 2 in the previous page, you will be prompted for the details of the upgraded Primary Server and the zone credentials. Specify the required details, then press Enter.
- (Conditional) If the device is able to connect to the Primary Server, continue with Step 18.
- (Conditional) If the device is not able to connect to the Primary Server, you will be prompted for the database details. Specify the details and continue with Step 18 .
At the end of the Enter the zone administrative user's name line, press Enter to accept the default (Administrator), or specify an administrator name, then press Enter.
Specify a password for the administrator, then press Enter.

If the device is able to connect to the database server, continue with Step 13. If not, you will be prompted for the database details. Specify the database details, then press Enter.
Run ZENworks Diagnostic Center to verify the database. For more information, see Running ZENworks Diagnostic Center to Verify the Database Schema.

NOTE:Verify the database before you upgrade the first Primary Server to ZENworks 11 SP3. You do not need to verify the database for the subsequent server upgrades.
Confirm that you have verified the ZENworks database schema by using the ZENworks Diagnostic Center. Press Y to continue.

You need to confirm to proceed with the upgrade.
Stop the ZENworks services on all other Primary Servers, then press Enter to stop the services on the local server.

Before the upgrade, you should stop the services on all Primary Servers in the Management Zone. Even if you stop these services manually before starting the upgrade program, you can verify by selecting 1.

Except for the database service, no ZENworks service should be running during the upgrade process.
In the Audit database selection page, specify the required database type, then press Enter. Based on the ZENworks Database, specify the relevant Audit database information. For the supported combination of the ZENworks and the Audit database, see Audit Database Information Using the Console. The ZENworks Optimization option is displayed.
If ZENworks services are not configured for high performance, select 1 to reconfigure the ZENworks services setting during installation or select 2 to ignore.
Review the pre-upgrade summary, then press Enter to continue.

If you are upgrading the other Primary Servers in the Management Zone, the upgrade starts when you press Enter in this step.
When Upgrade Complete is displayed, press Enter to continue.

If errors are displayed, see the installation logs in the /var/opt/novell/log/zenworks or /var/opt/novell/log/zenworks/systemupdate/<Update GUID> file.
Do any of the following to verify that ZENworks 11 SP3 is running:
- Check the Linux services by using the specific service commands
  
  On the server, run the following commands:
```
/etc/init.d/novell-zenserver status
```
```
/etc/init.d/novell-zenloader status
```
  If the services are not running, run the following commands to start the ZENworks services:
```
/etc/init.d/novell-zenserver start
```
```
/etc/init.d/novell-zenloader start
```
- Check the Linux services by using the configuration command
  
  On the server, run the following commands:
```
/opt/novell/zenworks/bin/novell-zenworks-configure ‑c SystemStatus
```
  ZENworks services and their status are listed.
  
  To start the services, run the following command:
```
/opt/novell/zenworks/bin/novell-zenworks-configure ‑c Start
```
- Run ZENworks Control Center
  
  Use the following URL to open the ZENworks Control Center in a web browser on any device in your network:
  
  https://<DNS name of the Primary_Server>/zenworks
  
  or
  
  https://<IP address of the Primary_Server>/zenworks
To upgrade another Primary Server, repeat from Step 2.

For information on the post-upgrade tasks, see Completing Post-Installation Tasks in the ZENworks 11 SP3 Server Installation Guide.

Audit Database Information Using the Console

If the ZENworks database is Embedded Sybase SQL Anywhere, then the Audit database combinations are as follows:
- Embedded Sybase SQL Anywhere: This option creates the database on the current device. Type Y to select this option.
  
  The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  
  If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
- Remote Sybase SQL Anywhere: Allows you to create the Audit database on a remote Sybase device. Specify the following information:
  - Server Address, Port Number used by the database server that hosts the Audit database and the Service Name.
  - Database Name of the Audit database, Username and Password of the existing user with the required permissions, and Service Name of the Audit database device.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
If the ZENworks database is OEM Sybase, then the Audit database combinations are as follows:
- OEM Sybase : Allows you to create the Audit database on an OEM Sybase device. Specify the following information:
  - Server Address and Port Number used by the database server for the Audit database.
  - Database Name of the Audit database, Username and Password of the existing user with permissions, and Service Name of the Audit database device.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
- External Sybase: Allows you to create the Audit database on an external Sybase device. Specify the following information:
  - Server Address and Port Number used by the database server for the Audit database.
  - Database Name of the Audit database, Username and Password of the existing user with sufficient permissions and Service Name of the Audit database device.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
If the ZENworks database is External Sybase, then the Audit database combinations are External Sybase or OEM Sybase Database. Information required to create these databases is specified in the previous combination for ZENworks on OEM Sybase.
If the ZENworks database is MS SQL, then the Audit database must be MS SQL. Using this option, you can create a new database or use an existing database. Type 1 to create a user or Type 2 to use an existing user.
- Create new user: Ensure that the database user has the required permissions to create a database and user login. Specify the following information:
  - Server Address, Port Number used by the database server for the Audit database, Named Instance (optional) of the device where the database is created.
  - Username and Password of the new Audit database administrator user:
    
    Windows Authentication: Specify the Domain name (host name and not the fully qualified domain name). Provide the credentials for the Windows device that hosts the database and ensure that the user already exists.
    
    SQL Authentication: Do not specify value for the Domain.For SQL Authentication, provide a user name that does not exist; this user will be created later by the Upgrade installer.
  - Database Location: Ensure that the path specified exists on the remote server.
  - Database Name, Username, Password, and Domain of the required database access user. Choose type of Authentication, Windows or SQL Server.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
- Use existing user: Specify the following information:
  - Server Address, Port Number used by the database server for the Audit database and (optional) Named Instance of the external database server where the Audit databaseexists.
  - Database Name, Username, Password, and Domain of the required database user. For Windows authentication, provide a user name on the current device or in the domain. For SQL authentication, provide a user name that matches that of a valid SQL user.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
If the ZENworks database is Oracle, then the Audit database must be Oracle. Using this option, you can create a database or use an existing database. Press 1 for Create new database and 2 for Use existing database.

If the ZENworks database is Oracle, then the Tablespace name for Tables and Tablespace name for Indexes are populated. By default, it is USERS. Press Enter.
- Create new database: Specify the following information:
  - The connection information for the external database server that will host the database. Server Address, Port Number and Service Name (used by the database server for the Audit database) .
  - Administrators Username and Password who has permission to create a database.
  - New Audit database user credentials, Username and Password.
  - Select the option 1 for ZENworks to create the tablespace or 2 for the DBA to create the tablespace.
    
    It is recommended to provide separate tablespace name for the table and the indexes; however, ZENworks upgrade does not mandate it. If there is insufficient disk space to accommodate a new tablespace with the same size of the current ZENworks Schema, then you can use the existing tablespace. The Upgrade wizard automatically moves the data and indexes or indexes alone into a new tablespace.
    
    The following details are required to create a new tablespace:
    
    Tablespace name for Tables (Note: Ensure that the Tablespace name is unique and it starts with [a-z] | [A-Z]. Oracle tablespace naming conventions must be followed.)
    
    Tablespace name for Indexes (Note: Ensure that the Tablespace name is unique and it starts with [a-z] | [A-Z]. Oracle tablespace naming convention must be followed.)
    
    DBF File location for Tables.
    
    DBF File location for Indexes (Note: The specified physical path of the DBF file should be an existing path. The file name extension must be .dbf.)
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.
- Use existing database:
  - Specify the Server Address, Port number, and Service name of the database server where the Audit database exists.
  - Specify the Audit database username, password, and Tablespace name for tables and indexes for the Audit database.
  - The Pre-Upgrade Task page recommends to back up the ZENworks database before the upgrade begins. You can stop the ZENworks services on other servers to back up the ZENworks database and other important information. Type Y to proceed.
  - If the required port is blocked by the firewall, then the wizard prompts you to open the port or continue without opening it. Press Y to open and N to continue without opening the port.

1.6.3 Running ZENworks Diagnostic Center to Verify the Database Schema

The first time you upgrade any Primary Server to ZENworks 11 SP3, you must verify the database schema. You need not perform this procedure for the subsequent server upgrades.

Verifying an Embedded Sybase or OEM Sybase Database Schema

At the Primary Server’s console prompt, run the following commands:
- On Windows
  
  cd to MEDIA_ROOT\Common\tools\zdc
  
  zdc_verifyDB.bat
- On Linux
  
  cd to MEDIA_PATH/Common/tools/zdc
  
  ./zdc_verifyDB
ZENworks Diagnostic Center runs the diagnostic tests and generates the results in HTML format. On a Windows Primary Server, the reports are stored in the following location: %ZENWORKS_HOME%\logs\zdcreports\%SESSION%

On a Linux Primary Server the reports are stored in the following location:

/var/opt/novell/log/zenworks/zdcreports

To view the reports, open index.html, located in the report directory.

The complete log of diagnostic tests is stored in the following locations:

On Windows: %ZENWORKS_HOME%\logs\zdcreports\zdc_zen11_verify_%SESSION%.log

On Linux: /var/opt/novell/log/zenworks/zdcreports

Verifying an External Database Schema

Perform the following steps to verify an external database schema such as external Sybase, MS SQL, or Oracle database schema:

At the Primary Server’s console prompt, run the following commands:
- On Windows
  
  cd to MEDIA_PATH/Common/tools/zdc
  
  zdc_verifyDB.bat -d check
- On Linux
  
  cd to MEDIA_PATH/Common/tools/zdc
  
  ./zdc_verifyDB -d check
  
  NOTE:The -d check parameter must be used only when you migrate the database from one device to another. Do not use the -d check parameter if the database is upgraded on the same device.
Specify the type of database. Type the relevant number based on the database type:
- (1) Sybase
- (2) MS-SQL
- (3) Oracle
Specify the following database credentials:
- Database Server IP
- Port Number
- Database Access Username
  NOTE:If you are using an MS SQL database, based on the type of authentication you choose to log in, enter the user name in the relevant format:
  Windows Authentication: <name>@<domain>
  
  SQL Server Authentication: <name>
- Database Access Password
- Database Name
(Conditional) If the database is not embedded Sybase, enter the Database Engine Name.

ZENworks Diagnostic Center runs the diagnostic tests and generates the results in HTML format. On a Windows Primary Server the reports are stored in the following location: %ZENWORKS_HOME%\logs\zdcreports\%SESSION%

On a Linux Primary Server the reports are stored in the following location:

/var/opt/novell/log/zenworks/zdcreports

To view the reports, open index.html, located in the report directory.

The complete log of diagnostic tests is stored in the following locations:

On Windows: %ZENWORKS_HOME%\logs\zdcreports\zdc_zen11_verify_%SESSION%.log

On Linux: /var/opt/novell/log/zenworks/zdcreports