Iam having problems with the archive directory getting full on the Enterprise Server (sun solaris 2.7) causing JDE to crash. Any ideas in automating clear-up of directory?


Legendary Poster

You will need to implement a cron job that will clean up your archive directory archive log files. Before doing this, you need to consider your entire backup strategy (do you do cold or hot backups, what is backed up onto tape and when, how much roll-forward is acceptable in case you need to restore from backups, etc.). Please note that I'm on an HP-UX platform, and things may be a bit different on Sun Solaris.

The following is some sample code to clean up archive log files:

# List archive logs about to be deleted
find /u09/oracledata/archivelogs -name 'arch*.log' -atime +6 -exec ll {} \;
# Delete archive logs
find /u09/oracledata/archivelogs -name 'arch*.log' -atime +6 -exec rm -f {} \;

This code first lists the files about to be deleted, and then deletes them. It assumes that your archive log files are in the /u09/oracledata/archivelogs directory, and that they are the only files named arch*.log in that directory. The +6 selects files that were last accessed over 6 days ago. Of course, you will want to use your own site-specific information for directories, names, and retention days.

Hope this helps.

Don Sauve
Wagstaff, Inc.
OW XE, SP15.1, HP-UX 11.0, Oracle 8.1.6


Active Member
Your mistake was using Oracle. Switch to a database that doesn't require
direct administration or custom automation of those kind of issues. (such as
DB2 on an AS/400).


Has anyone had any issues with XE where the F4102 table is on the Enterprise
server(not Oracle) and the F3411 table is on Oracle?

James Boes
System Application Analyst
Irwin Seating Company


Legendary Poster
Re: RE: Jde+oracle8i

Yeah right! Thanks for being helpful.

LIVE: B732.1 SP12.2, Oracle 806, FormScape 2.1
SANDBOX: Xe SP15 & Update2, Oracle 8i
RS/6000, Citrix