Re: Fatal NI connect error 12170 in alert of Oracle 11gR2 database
Date: Tue, 12 May 2015 00:31:24 -0400
Message-ID: <5551821C.90906_at_yahoo.com>
You have TNS time outs. I have only one question: does everything else works as it should? If the answer is positive, you don't have any problems. If there is a problem, you can try with extending timeouts. Here is the list of sqlnet.ora parameters for your version of database:
https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF006
You can try modifying inbound connect timeout and outbound connect timeout. There are also send and receive timeouts to play with. On LAN configurations, I usually set those to 5 (the values are in seconds) and that should be plenty. I believe that this "problem" is caused by an incorrect default for some of the parameters. However, network usually retries, so an ugly log entry is likely your only problem.
On 05/11/2015 04:32 PM, Mandal, Ashoke wrote:
>
> Hello,
>
> Right after I upgraded my databases from Oracle 10.2.0.4 to Oracle
> 11.2.0.3 I am seeing the following messages in the alert log
> repeatedly. I didn’t see these messages in 10g databases. I tried
> tracking down the IP address but found out that these were computers,
> which had been accessing the database for many years. But these
> messages are being logged into the alter log only after the upgrade to
> 11.2.0.3.
>
> Is it a known behavior in Oracle 11gR2? I did some checking with
> documentation but couldn’t find any explanation. So any help will be
> appreciated.
>
> Thanks,
>
> Ashoke Mandal
>
> Fatal NI connect error 12170.
>
> VERSION INFORMATION:
>
> TNS for Solaris: Version 11.2.0.3.0 - Production
>
> Oracle Bequeath NT Protocol Adapter for Solaris: Version
> 11.2.0.3.0 - Production
>
> TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 -
> Production
>
> Time: 16-APR-2015 06:54:01
>
> Tracing not turned on.
>
> Tns error struct:
>
> ns main err code: 12535
>
> TNS-12535: TNS:operation timed out
>
> ns secondary err code: 12560
>
> nt main err code: 505
>
> TNS-00505: Operation timed out
>
> nt secondary err code: 145
>
> nt OS err code: 0
>
> Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.72.216.138)(PORT=54551))
>
> Thu Apr 16 06:54:01 2015
>
> [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this
> email is proprietary to Medtronic and is intended for use only by the
> individual or entity to which it is addressed, and may contain
> information that is private, privileged, confidential or exempt from
> disclosure under applicable law. If you are not the intended recipient
> or it appears that this mail has been forwarded to you without proper
> authority, you are notified that any use or dissemination of this
> information in any manner is strictly prohibited. In such cases,
> please delete this mail from your records. To view this notice in
> other languages you can either select the following link or manually
> copy and paste the link into the address bar of a web browser:
> http://emaildisclaimer.medtronic.com
>
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 12 2015 - 06:31:24 CEST