Link to home
Start Free TrialLog in
Avatar of DrAske
DrAskeFlag for Jordan

asked on

ORA-29260:network error:TNS lost contact

Hi Experts,

i'm using utl_tcp in my code to open a connection then i enter the username and password, i put a loop in my code so i can send the commands to this connection using oracle pipes, but some times i got this error message, ORA-29260:network error:TNS lost contact, please i appreciate if some one tell me what is the problem is it a connection problem or a bug in utl_tcp package.

part of the code
.....
c := UTL_TCP.open_connection (remote_host=> Pipaddress,
remote_port=> Pportnumber,
CHARSET => 'US7ASCII');

-- login
ret_val := UTL_TCP.write_line (c,'LOGIN:' || Puser|| ',' || Ppass|| ';');
.........
LOOP
.........
RESULT := DBMS_PIPE.RECEIVE_MESSAGE (p_name);
DBMS_PIPE.UNPACK_MESSAGE (his_msg_cmd);
DBMS_PIPE.UNPACK_MESSAGE (his_msg_params);
.........
ret_val := UTL_TCP.write_line (c, his_msg_cmd || ':' || his_msg_params || ';');
.........
END LOOP;
.........
ret_val := UTL_TCP.write_line (c, 'LOGOUT:;');
UTL_TCP.close_connection (c);
........
END;
SOLUTION
Avatar of DLyall
DLyall

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DrAske

ASKER

Thanx for reply,

sometimes the command works successfully -and I get response from the server- and sometimes doesn't!!
I don't think the problem in the firewall.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial