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
