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 : TNS listener unable to start dedicated server process*
now we are planning for the re-installation of oracle using the method :
- full database export
- created script to create same tablespace with same users and same
password
- importing the dmp file
Is this method ok?????
On 11/9/05, Ruth Gramolini <rgramolini_at_tax.state.vt.us> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of* Onkar N Tiwary
> *Sent:* Wednesday, November 09, 2005 7:21 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* ORA-12547 : TNS lost contact
>
> Hi guys,
> Since today morning I am facing one problem :
> ORA-12547 : 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 00:33:17 CST