Product

Kodak^® Prinergy^®, all versions up to and including 3.1.0.x

Platform

Dell or Data General

Operating system

Windows 2000

Error

Symptoms

When Prinergy starts, the Prinergy Disk Monitor displays the warning message.

Cause

The Prinergy Disk Monitor software checks the database size and disk space size.

TMP1CREO.ORA file: A warning message about this file means that the temp tablespace has at some point used up the maximum amount of bytes allocated to it, even though the information in the temp tablespace gets cleaned out when Oracle restarts. The datafile stays at the largest size that it has grown to. The database reports normally use the most space in the temp tablespace because they generate reports for all the jobs in the database. If you see messages in the creoALRT.log file indicating that it couldn't allocate extents in the SYSTMP1 tablespace, then you must expand the tablespace.

Solution

Extend the table by running the following commands in Oracle^® Server Manager.

Note: You do NOT need to shut down Prinergy or the database to perform this procedure.

Note: Only increase the TMP1CREO.ORA tablespace if you get errors running the database reports. For information, see the Cause section above.

To extend the table:

1. Record the file path of the table that has reached the maximum allowed size, as it appears in the warning message.
   For example, in the message above, the file is J:\Orant\Oracle\Data\User1Creo.ORA

Note: If you closed the message box without writing down the table file that needs to be extended, you can check the warning in Event viewer, application log, or Araxi log.

2. Open a command prompt and type SVRMGRL to log on to Oracle Server Manager.

The D:\>SVRMGRL prompt appears.
3. Type connect internal/creo
4. Type select a.maxbytes, b.bytes, a.tablespace_name, a.file_name from dba_data_files a,

   v$datafile b where a.file_name = b.name;

A table appears, with the MAXBYTES column displaying the maximum size of each datafile and the BYTES column displaying the current datafile usage. Sample table.

5. Type alter database datafile '<file that needs extendeding>' autoextend on maxsize <maximum size you want to set>;

For example, if you want to extend the User1Creo.ora file to 5Gb, type
alter database datafile 'J:\ORANT\ORACLE\DATA\USR1CREO.ORA' autoextend on maxsize 5120000K;

Note: Do not increase the size limit to 16 GB (16384MB) or greater. If the datafile extends to 16 GB, the database will become corrupted by Oracle bug # 1668488.

6. Type the command from Step 4. In the table that appears, locate the file that needs extending and check that the maximum value in the MAXBYTES column is changed.
7. Type exit.

Note: Ensure that there is always enough space available on the RAID for the tablespace.

PRs for fixing this: CKOR-0000066 and KBAI-0000022.

Permanent fix:

Technical contact(s)

Amy Chan

Submitted by

Amy Chan

Date submitted

06 Sep 2001