Fatal Ni Connect Error 12545 Connecting To Local=no
Contents |
error 12545, connecting to: [message #208449] Sun, 10 December 2006 23:15 sureshkhadloya@yahoo.com Messages: 4Registered: September 2006 Junior Member All, I have installed oracle 9.2.0.1.0 client on solaris 9. I have fatal ni connect error 12170 tns-12535 configured tnsnames.ora REFDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST
Fatal Ni Connect Error 12637 Connecting To (local=no)
= 10.111.11.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = g08) ) ) When i do tns ping, its shows status ns main err code: 12535 as "ok" ---------------------------------------------------------------- $ tnsping REFDB TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 08-DEC-2006 11:58:24 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: /opt/oracle/u01/app/products/9.2.0/network/admin/sqlnet.ora Used TNSNAMES
Ns Main Err Code: 12564
adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.111.11.11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = g08))) OK (0 msec) ---------------------------------------------------------------- Now, when i use sqlplus to connect to DB, i get ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory and following entry in fatal ni connect error 12547 connecting to local no sqlnet.log Fatal NI connect error 12545, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/oracle/u01/app/products/9.2.0/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION =(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=dev09)(USER=oracle)))) VERSION INFORMATION: TNS for Solaris: Version 9.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Solaris: Version 9.2.0.1.0 - Production Time: 11-DEC-2006 03:57:36 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 515 TNS-00515: Connect failed because target host or object does not exist nt secondary err code: 2 nt OS err code: 0 Can anyone please let me know, what can be potential problems? Regards SKK Report message to a moderator Re: Fatal NI connect error 12545, connecting to: [message #208452 is a reply to message #208449] Sun, 10 December 2006 23:32 Mohammad Taj Messages: 2412Registered: September 2006 Location: Dubai, UAE Senior Member hi ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist sql>startup bcoz ur database is not open. TNS-12545: Connect failed because target host or object does not exist Post ur listener.ora file. and check in listener.ora
and get tips & solutions from a community of 418,550 IT Pros & Developers. It's quick & easy. TNS 12545 urgent !! P: n/a Deepak
Tns-12564: Tns:connection Refused
I have my Oracle 9i database running on my XP box. I can
Ns Secondary Err Code: 12606
connect to it from Solaris 5.8. I am able to connect from sqlplus. But during a install, script is fatal ni connect error 12514 connecting to data guard not able to establish connection. My sqlnet.log Fatal NI connect error 12545, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION= (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO)) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=dee pak)))) VERSION INFORMATION: TNS for Solaris: Version 8.1.5.0.0 - Production Oracle Bequeath NT Protocol Adapter for http://www.orafaq.com/forum/t/73735/ Solaris: Version 8.1.5.0.0 - Production Time: 24-NOV-03 18:41:38 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 515 TNS-00515: Connect failed because target host or object does not exist nt secondary err code: 2 nt OS err code: 0 https://bytes.com/topic/oracle/answers/64860-tns-12545-urgent I can connect using sqlplus from both XP and solaris. That means ip, port, username, password, SID, service name, etc. are correct. Also this means my listener and service are running fine on XP. Does the log point to any potential problems? Jul 19 '05 #1 Post Reply Share this Question 3 Replies P: n/a Frank Deepak wrote: I have my Oracle 9i database running on my XP box. I can connect to it from Solaris 5.8. I am able to connect from sqlplus. But during a install, script is not able to establish connection. My sqlnet.log Fatal NI connect error 12545, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION= (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO)) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=dee pak)))) VERSION INFORMATION: TNS for Solaris: Version 8.1.5.0.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: Version 8.1.5.0.0 - Production Time: 24-NOV-03 18:41:38 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 515 TNS-00515: Connect failed because target host or object does not exist nt secondary err code: 2 nt OS err code: 0 I can connect using sqlplus from
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson http://www.dba-oracle.com/t_fatal_ni_connect_error_12170.htm Blog
fatal ni connect error 12170 Oracle Database Tips by Burleson Consulting November 5, 2015 Question: Below error getting in alert http://www.unix.eng.ua.edu/~crutcher/class/cs457/sqlnet.log log file every day, but database is working fineWhat are the reason for this Fatal ni connect error 12170? Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version fatal ni 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 28-MAY-2012 19:20:02 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 Answer: The fatal ni connect error 12170 is related to the ORA-12170 fatal ni connect error: ORA-12170: TNS:Connect timeout occurredCause: The client failed to establish a connection and complete authentication in the time specified by the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in the sqlnet.ora file. This error may be a result of network or system delays, or it may indicate that a malicious client is trying to cause a denial-of-service attack on the database server. The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP). See Also: "Configuring the Listener and the Oracle Database To Limit Resource Consumption By Unauthorized Users" for further information about setDNS server returned: Name Error: The domain name does not exist. This means that the cache was not able to resolve the hostname presented in the URL. Check if the address is correct. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 17:05:00 GMT by s_ac15 (squid/3.5.20)