 | |
ORA-03135: connection lost contact
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: ORA-03135: connection lost contact -
06-23-2008
, 03:08 AM
|
"vijay" <vksingh... (AT) gmail (DOT) com> wrote in message news:85462944-39ae-49b4-a148-ac284e4416ef (AT) a9g2000prl (DOT) googlegroups.com... OS – Windows 2003 server Database – Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on SQL*Plus UI on M2 which return result successfully. SQL*Plus UI remain opened on machine M2 for 2 hours. After that when I executed same query, SQL*Plus report error "ORA-03135: connection lost contact". This problem occurs frequently. My problem is that why I am getting error "ORA-03135: connection lost contact” when I kept open SQL*Plus UI for two hours. It will be great if some one help me to resolve issue. Thanks in advance, Vijay Singh We had a similar problem where I work. *I don't have the details but it turned out to be a firewall issue that was timing processes (either inactive or long-running) after two hours. |
session timeout. I hope this helps you.
#12
| |||
| |||
|
|
"vijay" <vksingh... (AT) gmail (DOT) com> wrote in message news:85462944-39ae-49b4-a148-ac284e4416ef (AT) a9g2000prl (DOT) googlegroups.com... OS – Windows 2003 server Database – Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on SQL*Plus UI on M2 which return result successfully. SQL*Plus UI remain opened on machine M2 for 2 hours. After that when I executed same query, SQL*Plus report error "ORA-03135: connection lost contact". This problem occurs frequently. My problem is that why I am getting error "ORA-03135: connection lost contact” when I kept open SQL*Plus UI for two hours. It will be great if some one help me to resolve issue. Thanks in advance, Vijay Singh We had a similar problem where I work. *I don't have the details but it turned out to be a firewall issue that was timing processes (either inactive or long-running) after two hours. |
session timeout. I hope this helps you.
#13
| |||
| |||
|
|
"vijay" <vksingh... (AT) gmail (DOT) com> wrote in message news:85462944-39ae-49b4-a148-ac284e4416ef (AT) a9g2000prl (DOT) googlegroups.com... OS – Windows 2003 server Database – Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on SQL*Plus UI on M2 which return result successfully. SQL*Plus UI remain opened on machine M2 for 2 hours. After that when I executed same query, SQL*Plus report error "ORA-03135: connection lost contact". This problem occurs frequently. My problem is that why I am getting error "ORA-03135: connection lost contact” when I kept open SQL*Plus UI for two hours. It will be great if some one help me to resolve issue. Thanks in advance, Vijay Singh We had a similar problem where I work. *I don't have the details but it turned out to be a firewall issue that was timing processes (either inactive or long-running) after two hours. |
session timeout. I hope this helps you.
#14
| |||
| |||
|
|
"vijay" <vksingh... (AT) gmail (DOT) com> wrote in message news:85462944-39ae-49b4-a148-ac284e4416ef (AT) a9g2000prl (DOT) googlegroups.com... OS – Windows 2003 server Database – Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on SQL*Plus UI on M2 which return result successfully. SQL*Plus UI remain opened on machine M2 for 2 hours. After that when I executed same query, SQL*Plus report error "ORA-03135: connection lost contact". This problem occurs frequently. My problem is that why I am getting error "ORA-03135: connection lost contact” when I kept open SQL*Plus UI for two hours. It will be great if some one help me to resolve issue. Thanks in advance, Vijay Singh We had a similar problem where I work. *I don't have the details but it turned out to be a firewall issue that was timing processes (either inactive or long-running) after two hours. |
session timeout. I hope this helps you.
#15
| |||
| |||
|
|
"vijay" <vksingh... (AT) gmail (DOT) com> wrote in message news:85462944-39ae-49b4-a148-ac284e4416ef (AT) a9g2000prl (DOT) googlegroups.com... OS – Windows 2003 server Database – Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on SQL*Plus UI on M2 which return result successfully. SQL*Plus UI remain opened on machine M2 for 2 hours. After that when I executed same query, SQL*Plus report error "ORA-03135: connection lost contact". This problem occurs frequently. My problem is that why I am getting error "ORA-03135: connection lost contact” when I kept open SQL*Plus UI for two hours. It will be great if some one help me to resolve issue. Thanks in advance, Vijay Singh We had a similar problem where I work. *I don't have the details but it turned out to be a firewall issue that was timing processes (either inactive or long-running) after two hours. |
session timeout. I hope this helps you.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.