Product

Kodak^® Prinergy^®, versions earlier than 4.0

Operating system

Microsoft^® Windows^® 2000 Server

Error

ORA-03113: end-of-file on communication channel

Symptoms

Random problems occur with the Prinergy system, such as daemons or tasks failing. The problems usually occur at a busy customer site.

Cause

A known problem in the Oracle^® 8.16 software causes this. It is not caused by the Prinergy software.

An update from Oracle fixes the problem. The update has been found to be stable at several customer sites, but should be installed only if it is actually needed, because it is difficult to remove. The update installer does not have an automated uninstaller; you must remove the update manually.

You must do a manual backup of the database before installing the update. If you need to restore the original Oracle configuration, the process is completely manual.

Solution

To install the Oracle update:

Important: Contact a service representative. Do not install the Oracle update until a support specialist or someone from the product development team (Stan Yoshida, Robyn Lundstrom, or Amy Chan) gives you the go-ahead.

Important: Read the instructions through twice before starting. If you don't understand something, don't start!

1. End any database replication (VSR or Doubletake).
2. Upload the patchset to the customer's system. It will take a while, as it is 64MB. The patchset is located at \\cscfile1\RC_Common\TeamResources\Systems\Tools\Oracle\Oracle8.1.6.3.0Patchset.
3. On the server desktop, right-click My Computer, and select Manage.
4. In the Computer Management dialog box, locate Services and Applications > Services.
5. Stop Prinergy and Oracle.
1. Right-click Araxi, and select Stop.
2. Right-click OracleServiceCreo, and select Stop.
6. Make a backup copy of the D:\Ora816 folder.
7. Make a backup copy of the D:\Program Files\Oracle folder.
8. Extract the update file: p1650087_8163_WINNT.zip.
9. Run the self-extracting WinNT_81630_patchset.exe file and extract the contents to a folder.
10. Run the Oracle Universal Installer wizard (OUI).
    It is located at Programs > Oracle Installation Products > Universal Installer.
11. In the OUI wizard, click Next.
12. On the File Locations screen:
1. In the Source area, locate the folder where you extracted the update, and locate \Disk1\stage\.
2. In the File Name area, select the products.jar file, and click Open.
3. In the Destinations area, make sure that CREO appears and the correct path: D:\Ora816.
13. Click Next to install the update.
14. If any files report that they cannot be updated because they are in use, locate them using Windows Explorer and rename them to filename.old.
15. Restart Oracle and Prinergy.
1. In the Computer Management dialog box, right-click OracleServiceCreo, and select Restart.
2. Right-click Araxi, and select Restart.

To uninstall the update (if necessary):

1. On the server desktop, right-click My Computer, and select Manage.
2. In the Computer Management dialog box, locate Services and Applications > Services.
3. Stop Prinergy and Oracle.
1. Right-click Araxi, and select Stop.
2. Right-click OracleServicearaxi, and select Stop.
4. Disable the OracleServiceCreo service so that it can't start.
1. Right-click OracleServiceCreo service, and select Properties.
2. In the Startup type box, select Disabled.
3. Click OK.
5. Restart the server.
   This ensures that no Oracle files are in use.
6. Replace the D:\Ora816 and D:\Program Files\Oracle folders with the backup copies.
7. Change the OracleServiceCreo service to Automatic, and start the service.
1. In the Computer Management dialog box, right-click OracleServiceCreo service, and select Properties.
2. In the Startup type box, select Automatic.
3. Click OK.
4. Right-click OracleServiceCreo service, and select Restart.
8. Start the database.
• In the Computer Management dialog box, right-click OracleServiceCreo , and select Restart.
9. Start SQLPLUS /NOLOG.
10. Execute the following sql command:

CONNECT INTERNAL/creo@araxidbserver
@D:\Ora816\RDBMS\ADMIN\CATALOG.SQL
@D:\Ora816\RDBMS\ADMIN\CATPROC.SQL
@D:\Ora816\RDBMS\ADMIN\CATEXP.SQL
@D:\Ora816\RDBMS\ADMIN\DBMSDESC.SQL
@D:\Ora816\RDBMS\ADMIN\DBMSSTDX.SQL

CONNECT SYSTEM/MANAGER@araxidbserver
@D:\Ora816\sqlplus\admin\pupbld.sql

CONNECT PRINERGY/ARAXI@araxidbserver

exec DBCS_CompileObjects


11. Restart Prinergy.
• In the Computer Management dialog box, right-click Araxi, and select Restart.

Technical contact(s)

Submitted by

Date submitted

23 Aug 2007