Fatal Ni Connect Error 12514 Connecting To Oracle
Contents |
have a script to monitor the alert.log file for any ORA-xxxx errors. With 11g we found out many entries in regards of: Fatal NI connect error
Tns-12564 Connection Refused
The problem: alert.log file has many entries for Fatal NI connect error. tns-12564: tns:connection refused standby Examples: *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=nnn))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=sss)(CID=(PROGRAM=oracle)(HOST=xxx)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production fatal ni connect error 12514 connecting to data guard TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production Time: 17-JAN-2011 10:20:45 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code:
Fatal Ni Connect Error 12170 Tns-12535
0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Error 12514 received logging on to the standby Mon Jan 17 10:21:45 2011 *********************************************************************** or *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux:
Error 12514 Received Logging On To The Standby
Version 11.2.0.2.0 - Production Time: 18-JAN-2011 15:13:08 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: 110 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.x.xx)(PORT=nnnn)) Tue Jan 18 15:40:20 2011 The solution: We will have an entry on the alert.log file every time a client connection of any kind fails to complete or is aborted. One way to minimize the impact is by using the parameter SQLNET.INBOUND_CONNECT_TIMEOUT (default to 60 seconds on 10gR2 and 11g) but, sometimes, this value is not adequate. Oracle also mentions the occurrence of this error if you use DB Console or Enterprise Manager to monitor your databases and the emagent will try to connect to the target database repeatedly and, statistically, some will fail (frequency will depend on how busy your system is). Most of the time (certainly for DB Console and Enterprise Manager Agent) the application will try to connect again and it will succeed. To fix the problem you could increase the value of S
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not fatal ni connect error 12505 work correctly without it enabled. Please turn JavaScript back
Tns-12564 Dataguard
on and reload this page. Please enter a title. You can not post tns-12564 data guard a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is https://davidalejomarcos.wordpress.com/2011/01/18/removing-fatal-ni-connect-error-xxxx-from-your-alert-log/ archived 7 Replies Latest reply on Oct 1, 2010 6:02 AM by 570628 TNS-12564: TNS:connection refused 570628 Oct 1, 2010 3:54 AM Hi, I have some PHP applications which connect to Oracle database. I sometime receive the following error message. Fatal NI connect error 12516, https://community.oracle.com/thread/1351844 connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=httpd)(HOST=r33188.ovh.net)(USER=nobody)))(ADDRESS=(PROTOCOL=TCP)(HOST=178.32.113.43)(PORT=1521))) VERSION INFORMATION: TNS for Linux: Version 10.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production Time: 29-JUL-2010 18:01:45 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 I already had that error message in the past. At that time, I looked at the V$RESOURCE_LIMIT view and I saw session and process parameters were too small so I increased its. Now, I checked again to these parameters and values never went nearly the max values. RESOURCE_NAMECURRENT_UTILIZATIONMAX_UTILIZATIONINITIAL_ALLOCATIONLIMIT_VALUE processes21183400400 sessions29191445445 enqueue_locks132354705470 enqueue_resources13442176UNLIMITED ges_procs0000 ges_ress000UNLIMITED ges_locks000UNLIMITED ges_cache_ress000UNLIMITED ges_reg_msgs000UNLIMITED ges_big_msgs000UNLIMITED ges_rsv_msgs0000 gcs_resources0000 gcs_shadows0000 dml_locks0731956UNLIMITED temporary_table_locks03UNLIMITEDUNLIMITED transactions16489UNLIMITED branches00489UNLIMITED cmtcallbk01489UNLIMITED sort_segment_locks58UNLIMITEDUNLIMITED max_rollback_segments111148965535 max_shared_servers47UNLIMITEDUNLIMITED parallel_max_servers0003600 Is it pos
connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBSID_DGB)(CID=(PROGRAM=oracle)(HOST=hostname)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production http://oracletechdba.blogspot.com/2015/06/primary-database-alertlog-giving-below.html TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - http://www.orafaq.com/forum/t/185768/ Production Time: 01-JUN-2015 11:12:47 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 fatal ni nt OS err code: 0 Solution: When checking the service in DR using lsnrctl status, you are not able to see the service "DBSID_DGB". sologgedin to the Standby db and modify the parameter, SQL> alter system set "__dg_broker_service_names" = 'DBSID_DGB' scope=both; System altered. ++Check the values. SELECT a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value" FROM fatal ni connect x$ksppi a, x$ksppcv b, x$ksppsv c WHERE a.indx = b.indx AND a.indx = c.indx AND a.ksppinm LIKE '/__dg%' escape '/' / ------------------ __dg_broker_service_names DBSID_DGB DBSID_DGB ++Then check the lsnrctl status,You can see the services("DBSID_DGB"). $lsnrctl status LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 01-JUN-2015 11:11:26 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 01-JUN-2015 10:29:23 Uptime 0 days 0 hr. 42 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u
E-mail to friend not able to get data of primary in standby database (dataguard) [message #574866] Wed, 16 January 2013 05:11 mohib3088 Messages: 1Registered: January 2013 Junior Member Hi all, i have configured physical standby in my local system, to check logshipping i created a table at primary db, wen i tried to check in standby, it says table does not exist.. below are primary & standby alert entries.. Primary alert log Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.98)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STAND)(SERVER=dedicat ed)(CID=(PROGRAM=d:\oracle11g\app\administrator\product\11.1.0\db_1\bin\ORACLE.EXE)(HOST=A960M)(USER=SYSTEM))(SERVER=dedicated))) VERSION INFORMATION: TNS for 64-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production Time: 16-JAN-2013 16:20:12 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Error 12514 received logging on to the standby Errors in file d:\oracle11g\app\administrator\diag\rdbms\prod\prod\trace\prod_arcm_8836.trc: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor PING[ARCm]: Heartbeat failed to connect to standby 'STAND'. Error is 12514. Wed Jan 16 16:25:13 2013 Standby alert log ARCg: Thread not mounted Wed Jan 16 15:17:26 2013 ARC9: Thread not mounted Wed Jan 16 15:17:26 2013 ARCm: Thread not mounted Wed Jan 16 15:32:24 2013 db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup