Re: ORA-12547 : TNS lost contact
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2005 12:01:10 +0530
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 :
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of* Onkar N Tiwary
> *Sent:* Wednesday, November 09, 2005 7:21 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Other related posts:
