ORA-29285 file write error : URGENT

General discussions about Sharity
RobL
Posts: 3
Joined: Mon Jun 13, 2011 3:05 pm

ORA-29285 file write error : URGENT

Postby RobL » Mon Jun 13, 2011 3:14 pm

We're getting this error on Sharity 3.7 when outputting reports from Oracle (10g R2) under Solaris 10.
The output generally consists of between 100 and 500 files.
The output Sharity filesystem is directly mounted, as we found previously
that Oracle doesn't like working with the automounter.


I've also noticed other ACL-related issues, such as file ownerships changing to nobody:nobody
though full access is still allowed, and commands such as rm and gzip not working without the
-f option.

Any info on this would be appreciated, but the first problem is a show-stopper.

thanks

Rob

RobL
Posts: 3
Joined: Mon Jun 13, 2011 3:05 pm

Re: ORA-29285 file write error : URGENT

Postby RobL » Wed Jun 15, 2011 4:11 pm

As an addendum, we've updated to Sharity v3.9, but the problem persists.

This issue only seems to arise when dumping large numbers of csv files direct from Oracle.
If the files are dumped straight to a unix filesystem, then copied to a Sharity direct mount
via the command line, the issue doesn't arise.

christian
Objective Development
Objective Development
Posts: 1361
Joined: Thu Nov 09, 2006 11:46 am

Re: ORA-29285 file write error : URGENT

Postby christian » Thu Jun 16, 2011 12:23 pm

Without Active Directory integration, Sharity cannot display correct file ownership and groups. Instead, it always returns the user-ID of the process accessing the file as owner of the file.

If you sometimes see "nobody" as owner, the file is probably written or read by a daemon which runs as "nobody" or at least performs this operation as user "nobody".

If you need real ownership, you must enable the option "Convert Windows ACLs" in the "Options" section of Sharity's GUI. This option requires some kind of domain integration, though, so that server and client have the same concept of users and groups.

There are various ways to achieve domain integration. See Sharity's manual, especially the section about Unix Home Directories on SMB Shares.

RobL
Posts: 3
Joined: Mon Jun 13, 2011 3:05 pm

Re: ORA-29285 file write error : URGENT

Postby RobL » Fri Jun 17, 2011 4:02 pm

Christian,

Thanks - but the ownership issue is just an irritation. Most commands (rm, gunzip etc) have a -f option
which get round this problem.

The main issue is the Oracle file error, at which point the Oracle job stops. This can be up to ten hours
into the job. As debug mode seems to create 10Mb of output per minute, we have a problem with
keeping it running for the duration of the job.

Are there any other log levels supported for file logging other than logLevelsDebug?

rgds,

Rob


Return to “Sharity General”

Who is online

Users browsing this forum: No registered users and 2 guests