Database - RAC/Scalability (MOSC)

MOSC Banner

Network error

edited Apr 18, 2017 5:03AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi,

We are experiencing the below error while we are executing a anonymus block to move file from local server to FTP server.

Error :

ORA-29260: network error: TNS:connection closed

ORA-06512: at "SYS.UTL_TCP", line 201

ORA-06512: at "SYS.UTL_TCP", line 346

ORA-06512: at "TT_INFINET_ADR.FTP", line 80

ORA-06512: at "TT_INFINET_ADR.FTP", line 25

ORA-06512: at line 11

Anonymus block which we are executing in local database machine..

DECLARE

   p_batch_report_id   NUMBER             := 1;

   p_filename          VARCHAR2 (1000)

                                := 'infinet_set_mt_ddr_01022017_00_00_00.csv';

   po_err_code         NUMBER;

   lv_proc_name        VARCHAR2 (30)      := 'sp_sent_ftp';

   glv_conn            UTL_TCP.connection;

   glv_err_msg         VARCHAR2 (1000);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center