Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Accessing files on remote machines from oracle server

Accessing files on remote machines from oracle server

From: RandallG <rgouge_at_doncarsys.com>
Date: 14 Apr 2005 11:35:02 -0700
Message-ID: <a79cb708.0504141035.5cbdb4b1@posting.google.com>


Hi;

   I am trying to do the following. Check to see if a file exists on another server to ftp and then update a logfile from within Oracle.

   From PL/SQL using the DBMS_LOB.FILEEXISTS function. If the file is not local to the filesystem the operation fails with an error. (utl_filedir = * in the init.ora file) Do mapped drives work?

   I also tried creating a Java Source which checked for the existence of a file on a remote machine, again unsuccessful though the same function run at the command line has no problem.

   I finally tried using an external procedure to start an ftp session to ftp the remote files .. then examine the contents of the ftplog to determine whether the ftp was successful or not. Remote files could not be sent when running the ftp batch from within oracle .. file not found .. but the same batch when run at the command line works fine.

   My Question is:

   Is this a permissions problem .. the OracleService running is logged on as the local system account and does not have permissions to access files on remote machines .. if so, is it possible to have the account under which the OracleService is run be a domain account that can be assigned permissions .. I have tried this with no success, so if you could forward me to an article that describes how to go about this, or have any other advice, we would be very greatful.

Ultimately I want to be able to ftp the files and log that they have been ftp'ed. Received on Thu Apr 14 2005 - 13:35:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US