I checked for the alert.log also but no error reported there. the problem is errupting when a user is trying to connect to server from the client pc but on the server i am able to connect but that too without using connect string. I was wondering it might be a problem because of the patch as I had told earlier also that before we had been using 9.2.0.1 <http://9.2.0.1>without any such error but when we applied a patch on this and upgraded to 9.2.0.6 <http://9.2.0.6> then we started getting the error. Now after wasting a lot time on this issue, we were in a position to resolve this problem but then we had been another error *ORA-12500 (See ORA-12500.ora-code.com) : TNS listener unable to start dedicated server process* now we are planning for the re-installation of oracle using the method : 1. full database export 2. created script to create same tablespace with same users and same password 3. importing the dmp file Is this method ok????? On 11/9/05, Ruth Gramolini <rgramolini@(protected)> wrote: > > Did you check the alert log? Just a thought. Here is the details on this > error: > 12547, 00000, "TNS:lost contact" > // *Cause: Partner has unexpectedly gone away, usually during process > // startup. > // *Action: Investigate partner application for abnormal termination. On > an > // Interchange, this can happen if the machine is overloaded. > HTH, > Ruth > -- --Original Message-- -- > *From:* oracle-l-bounce@(protected) [mailto: > oracle-l-bounce@(protected)]*On Behalf Of* Onkar N Tiwary > *Sent:* Wednesday, November 09, 2005 7:21 AM > *To:* oracle-l@(protected) > *Subject:* ORA-12547 (See ORA-12547.ora-code.com) : TNS lost contact > > Hi guys, > Since today morning I am facing one problem : > ORA-12547 (See ORA-12547.ora-code.com) : TNS lost contact > when i re-started my server, i worked for couple of seconds and then > again i was getting the same error. I searched on metalink which says its a > bug which has been fixed in 9.2.0.3 <http://9.2.0.3/> and 10g and my db is > 9.2.0.6 <http://9.2.0.6/>. however we had patched our database yesterday > and since then we are getting this error. i reconfigured the listener on > different port also but then too same error. > Db is : 9.2.0.6 <http://9.2.0.6/> > os : win 2k adv. server > any help??????????????? > > -- > Thanks & Regards, > T. Onkar Nath > OneAPPS Enterprise Technology Pvt. Ltd. > to_onkar@(protected) > onkarnath.tiwary@(protected) >
<div>I checked for the alert.log also but no error reported there. the problem is errupting when a user is trying to connect to server from the client pc but on the server i am able to connect but that too without using connect string. I was wondering it might be a problem because of the patch as I had told earlier also that before we had been using <a href="http://9.2.0.1">9.2.0.1</a> without any such error but when we applied a patch on this and upgraded to <a href="http://9.2.0.6">9.2.0.6</a> then we started getting the error. Now after wasting a lot time on this issue, we were in a position to resolve this problem but then we had been another error </div> <div> </div> <div><strong>ORA-12500 (See ORA-12500.ora-code.com) : TNS listener unable to start dedicated server process< /strong></div> <div>now we are planning for the re-installation of oracle using the method :< /div> <div> </div> <div>1. full database export</div> <div>2. created script to create same tablespace with same users and same password</div> <div>3. importing the dmp file</div> <div> </div> <div>Is this method ok?????</div> <div> </div> <div><span class="gmail_quote">On 11/9/05, <b class="gmail_sendername">Ruth Gramolini</b> <<a href="mailto:rgramolini@(protected)">rgramolini@(protected) .state.vt.us</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div><span><font face="Arial" size="2">Did you check the alert log? Just a thought. Here is the details on this error:</font></span></div> <div><span><font face="Arial" size="2">12547, 00000, "TNS:lost contact "<br>// *Cause: Partner has unexpectedly gone away, usually during process <br>// startup.<br>// *Action: Investigate partner application for abnormal termination. On an <br>// Interchange, this can happen if the machine is overloaded. </font></span></div> <div><span><font face="Arial" size="2"></font></span> </div> <div><span><font face="Arial" size="2">HTH,</font></span></div><span class="sg"> <div><span><font face="Arial" size="2">Ruth</font></span></div></span> <div><span class="e" id="q_10775d35c99b194d_2"> <div><font face="Times New Roman" size="2">-- --Original Message-- --<br><b >From:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l-bounce@(protected) .org </a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l-bounce@(protected) .org</a>]<b>On Behalf Of</b> Onkar N Tiwary<br><b>Sent:</b> Wednesday, November 09, 2005 7:21 AM <br><b>To:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:oracle-l@(protected)" target="_blank">oracle-l@(protected)</a><br><b >Subject:</b> ORA-12547 (See ORA-12547.ora-code.com) : TNS lost contact<br><br></font></div>
<div>Hi guys,</div> <div> </div> <div>Since today morning I am facing one problem :</div> <div> </div> <div>ORA-12547 (See ORA-12547.ora-code.com) : TNS lost contact</div> <div> </div> <div>when i re-started my server, i worked for couple of seconds and then again i was getting the same error. I searched on metalink which says its a bug which has been fixed in <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://9.2.0.3/" target="_blank"> 9.2.0.3</a> and 10g and my db is <a onclick="return top.js.OpenExtLink(window ,event,this)" href="http://9.2.0.6/" target="_blank">9.2.0.6</a>. however we had patched our database yesterday and since then we are getting this error. i reconfigured the listener on different port also but then too same error. </div> <div> </div> <div>Db is : <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://9.2.0.6/" target="_blank">9.2.0.6</a></div> <div>os : win 2k adv. server</div> <div> </div> <div>any help???????????????<br clear="all"><br>-- <br>Thanks & Regards,<br >T. Onkar Nath<br>OneAPPS Enterprise Technology Pvt. Ltd.<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:to_onkar@(protected)" target="_blank"> to_onkar@(protected)</a><br> <a onclick= "return top.js.OpenExtLink(window,event,this)" href="mailto:onkarnath.tiwary @(protected)" target="_blank">onkarnath.tiwary@(protected)</a><br> </div></span ></div></blockquote></div> <br><br clear="all"><br>-- <br>Thanks & Regards,<br>T. Onkar Nath<br >OneAPPS Enterprise Technology Pvt. Ltd.<br> <a href="mailto:to_onkar@(protected)">to_onkar@(protected)</a><br>   ; <a href="mailto:onkarnath.tiwary@(protected)"> onkarnath.tiwary@(protected)</a><br>
