5 Troubleshooting and Disaster Recovery

This chapter includes information for preliminary system troubleshooting and disaster recovery. You will perform these activities before contacting Oracle Support.

Screen Transparency

You set the Screen Transparency in the middle on the right of the Configuration Mode settings screen. The display's transparency level can be set between zero and ninety percent (zero value means full opacity) using the adjustment control in this area. This option is useful when you must view the DIVAdirector Server Status screen while having other dialogs (or screens) open simultaneously, and reduces the amount of screen space required to view both.

The DIVAdirector Server Configuration screen always starts in fully opaque mode. A live demonstration of the effects of changing the transparency level is shown while the adjustment control is being moved. You can visualize the different level's effects before actually accepting the change. When you release the mouse button the dialog reverts back to its opaque state after a short pause; however the last transparency level indicated by the control is temporarily saved. The changed settings are applied to all other server dialogs once you click OK. Click Cancel to discard the temporarily saved transparency level and keep the previous setting (before the changes were made).

Next you will start and stop DIVAdirector Server.

Starting and Stopping DIVAdirector Server

DIVAdirector Server automatically starts as a Windows system service during system startup by default. Native DIVAdirector logs (for example, logs of connections to DIVArchive) are kept as application logs in the System Event Viewer. During troubleshooting activities, you start and stop the server service manually using the Windows menu as necessary.

  • To stop the DIVAdirector Server service, select Start, All Programs, FPDI DIVAdirector 5, and then Stop DIVAdirector Server Service.

  • To start the DIVAdirector Server service, select Start, All Programs, FPDI DIVAdirector 5, and then Run DIVAdirector Server Service.

You can manually start DIVAdirector Server in interactive mode after first stopping the service. The DIVAdirector Server interactive mode application and the DIVAdirector Server service cannot be run simultaneously, so the service must be stopped first before entering interactive mode.

When running in interactive mode the DIVAdirector Server application adds an icon to the Windows System Status Area (System Tray) and displays the current status of the local database and connections to DIVArchive.

When you click the DIVAdirector tray icon, the displayed DIVAdirector Status screen is divided into three sections with specific information in each section.

The General Settings section is located on the top of the screen. This section displays the last date and time the server was started, total number of connections, total number of current connections, the operational mode of the server, last synchronization data and time, and the current server date and time.

The DIVArchive Manager section is located in the middle of the screen. This section displays the connection status of the Oracle DIVArchive Manager and includes the current connection status and the last time the connection was made.

The DIVAdirector Database section is located on the bottom of the screen and includes the Database Source Name (DSN - also known as the Data Source Name) in use, the current connection status, and the last date and time the connection to the database was made.

Command Line Parameters

When necessary during error resolution, you run DIVAdirector Server from the command line (rather than as a Windows system service) by opening a command line window and using the following command:

DIVAdirector Server.exe -parameter

You must enter one of the following valid command line parameters or you will be returned to the operating system prompt.

install (-i)

Installs the DIVAdirector Server service.

uninstall (-u)

Uninstalls the DIVAdirector Server service and removes it from the Windows Services list; however, Interactive Mode can be run instead of the service.

debug (-d)

Run the DIVAdirector Server application in Interactive Mode.

config (-c)

Run the DIVAdirector Server in Configuration Mode (this is a limited mode).

runservice (-r)

Start the DIVAdirector Server service.

stopservice (-s)

Stop the DIVAdirector Server service.

help (-h or ?)

Displays the help dialog with command line syntax and a list of supported parameters.

Use the following procedure to install the DIVAdirector Server service from the command line:

  1. Open a Windows Command prompt (Start, Run, enter cmd, and then click OK).

  2. Run the command DIVAdirector Server.exe -i

  3. In the Installing DIVAdirector Server Service window select either the Local System or This User (DOMAIN\User) option. The options presented in the dialog are:

    Local System

    DIVAdirector will be limited to use only local Proxy storages due to native Windows limitations on the local system account.

    This user (DOMAIN\User)

    Enter your administrative user account in the form DOMAIN\User, the user's password, and confirm the password. The entered user will have access to proxy storage locations that are configured as network shares. The user must belong to the Admin Group and must be granted read and write access rights to NAS-based proxy storage. If no domain (or the '.' domain) is specified, the local system is implied as the account domain.

  4. Click OK to start the DIVAdirector Server service.

Next you will start and stop the DIVAdirector Web Server.

Starting and Stopping the DIVAdirector Web Server

You can use the following procedure to start and stop the DIVAdirector Web Server manually if issues arise pertaining to the web-based user interface:

  1. Click the Windows Start button.

  2. Click Run and enter inetmgr in the text field, then click OK.

  3. In the Internet Manager, click the system's computer name and then locate DIVAdirector 5 under the Sites menu.

  4. In the Actions panel (on the right of the screen), under the Manage Web Site section, click Start to start the web server, Restart to stop a running server and then start the web server again, or Stop to stop it completely.

    A menu item that is grayed out and not selectable indicates the current state of the web server. For example, if the Start menu item is grayed out, the web server is currently running.

Next you will check the DIVAdirector Server and Drop Folder log files for errors.

Checking Log Files

DIVAdirector creates log files for both the system and for Drop Folders during normal operations. You configured the log file names, sizes and locations in the initial DIVAdirector configuration. Refer to "Logging Configuration" if you need a reminder of the file names and locations you assigned to the logs.

The DIVAdirector Server logs contain information regarding the various server operations and possible operation processing error information. The Drop Folder logs contain information specific to the Drop Folders.

You can find the web server logs in the DIVADirector_HOME\www\logs\log.txt file. The web server logs are used for troubleshooting the system and may be requested by Oracle Support when you request assistance.

The levels you set during initial system configuration may need to be changed to assist in troubleshooting activities. During troubleshooting it may be necessary to raise the logging level higher to assist in locating the source of an error or fault. The recommended log file level settings for normal system operation are as follows:

  • For DIVAdirector Server logs set the log level no higher than Level 2 unless you are trying to locate an error, or instructed to do so by Oracle Support.

  • For Drop Folder logs set the log level no higher than Level 0 unless you are trying to locate an error, or instructed to do so by Oracle Support.

Next you will export the database tables to a flat file format.

Flat File Export

You should export the database tables before performing a database restore. The tables in the database can be exported using the following procedure:

  1. Navigate to the Admin/Backup/Flat File Export screen.

  2. Select the table or tables to export using the check boxes next to each table name in the list.

  3. On the top of the screen select the Separator that will distinguish the fields, and the Enclosure that will encase the statement. Typically the Separator will be a comma and the Enclosure will be double quotations.

  4. If the first row in the table export contains column names, select the check box next to Include columns names as first line (right next to Enclosure on the top line).

  5. Click Refresh on the top right of the screen to refresh the list of tables. This causes the list of tables to be regenerated and re-listed on the page using the selected Separator and Enclosure.

  6. Use the check box next to each table name to select (or deselect) the table for export. Selecting or deselecting the check box at the top will select (or deselect) all tables in the list.

  7. Choose Download All along the screen's header row to save all of the files together in zipped format, or click Export on the top right of the screen to save the files individually.

Next you will perform a manual backup and data restore.

Manual Backup and Data Restore

The manual backup and restore of the database are very important operations in any data system. DIVAdirector provides you a simple way to perform these operations when necessary.

Performing a Manual Backup

Use the following procedure to perform a manual backup of the DIVAdirector database:

  1. Navigate to the Admin/Backup/Manual Backup and Restore screen.

  2. Select Backup on the Manual Backup and Restore screen next to Operation.Browse the directory and select the backup destination folder.

    Note:

    The backup file name DIVAdirector_database_timestamp.lhb is predefined and cannot be modified.

    The time-stamp format is DDMMYY-hhmm and is designated as:

    • DD = day of month

    • MM = month

    • YY = year

    • hh = hour

    • mm = minute

  3. Click Backup Now on the top right of the screen to begin the backup operation.

    A message will appear at the bottom of the screen stating that the backup process has started and normally takes approximately 3-5 minutes to complete (depending on the amount of data in the database). The message displays in red text at the bottom of the Manual Backup and Restore screen.

Performing a Data Restore

Use the following procedure to manually restore the DIVAdirector database:

  1. Select Restore on the Manual Backup and Restore screen next to Operation.

  2. Browse the From area to display the server's remote file system tree.

  3. Select the database snapshot file to be restored (click once on the file name).

  4. Browse the To area and select a restore destination folder, or select Restore to Active Database (logs off all connected users).

    If you select the Restore to Active Database (logs off all connected users) option, the restore process will replace the existing database with the restored database. A confirmation dialog box is displayed notifying you that all connected users will be logged off.

  5. If you have not selected the Restore to Active Database (logs off all connected users) option, click Restore Now to begin the restore process.