Fatal NI connect error 12547 [message #619535] |
Wed, 23 July 2014 04:30 |
|
Subbu19
Messages: 15 Registered: July 2014 Location: Chennai
|
Junior Member |
|
|
Hi,
Following message occurs on alert.log file
Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 23-JUL-2014 04:18:15
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (12900) as a result of ORA-609
|
|
|
|
|
|
|
|
|
Re: Fatal NI connect error 12547 [message #619574 is a reply to message #619568] |
Wed, 23 July 2014 08:26 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Subbu19 wrote on Wed, 23 July 2014 14:25Yes, can do a tnsping and hostname
Don't just tell, show us.
Post, from the client platform that received this error, the tnsnames.ora entry and the result of:
ping <the server in this entry>
tnsping <the entry name>
sqlplus xxx/yyy@<the entry name>
[Updated on: Wed, 23 July 2014 10:32] Report message to a moderator
|
|
|
|
|
Re: Fatal NI connect error 12547 [message #619656 is a reply to message #619583] |
Thu, 24 July 2014 01:26 |
|
Subbu19
Messages: 15 Registered: July 2014 Location: Chennai
|
Junior Member |
|
|
Hi All,
Following is the ping status from the client machine(Application server)
C:\Users\peowcproe>ping peo-pwc-02 (Database server)
Pinging peo-pwc-02.XXXXXX.com [10.122.161.91] with 32 bytes of data:
Reply from 10.122.161.91: bytes=32 time<1ms TTL=128
Reply from 10.122.161.91: bytes=32 time<1ms TTL=128
Reply from 10.122.161.91: bytes=32 time<1ms TTL=128
Reply from 10.122.161.91: bytes=32 time<1ms TTL=128
Ping statistics for 10.122.161.91:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Then i can able to do telnet peo-pwc-02 1521 (Database Server machine name with port number)
Can't able to do tnsping, because no oracle client is installed. Our Application software automatically connects with JDBC driver connection
-
Attachment: 1.png
(Size: 11.24KB, Downloaded 19931 times)
[Updated on: Thu, 24 July 2014 01:29] Report message to a moderator
|
|
|
|
|
|