Fatal Ni Connect Error 12546
Error in setting Automatic Oracle Export Backup in Cron of Unix [message #154495] Mon, 09 January 2006 01:09 ekampreet Messages: 3Registered: December 2005 Junior Member We are facing a problem in our Oracle Installation, actually we want to configure the Oracle Export Backup as CRON entry in our Unix System , but we are getting error in doing so , as export command is not running through root user. I m copying the content of the script i m using to take the backup which is as follow :- #################################################################### DISPLAY=hostName:0.0 HOME=/app/oracle LD_LIBRARY_PATH=/data1/app/oracle/product/920/lib:/lib:/usr/lib LOGNAME=root MANPATH=/usr/opt/networker/man:/usr/share/man:/usr/dt/share/man:/usr/local/man ORACLE_BASE=/data1/app; export ORACLE_BASE ORACLE_HOME=/data1/app/oracle/product/920 ; export ORACLE_HOME ORACLE_SID=ora92; export ORACLE_SID PATH=/app/oracle/bin:/usr/bin:.:/usr/opt/java131/bin:/bin:/data1/app/oracle/product/920/bin:/usr/bin:/etc:/usr/bin/X11:/usr/ccs/bin:/ usr/local:/sbin:/usr/sbin SHELL=/bin/sh TEMP=/var/tmp TERM=dtterm TNS_ADMIN=/data1/app/oracle/product/920/network/admin; export TNS_ADMIN USER=oracle; export USER exp mms/mms123 file=/app/orclbackup/mms.dmp log=/app/orclbackup/mms.log rows=yes indexes=yes exp common/common123 file=/app/orclbackup/common.dmp log=/app/orclbackup/common.log rows=yes indexes=yes ########################################################## but when i execute this script as root user , i m getting following error at the promt : - @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Export: Release 9.2.0.1.0 - Production on Thu Dec 8 11:19:14 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 12546 encountered ORA-12546: TNS:permission denied EXP-00000: Export terminated unsuccessfully Export: Release 9.2.0.1.0 - Production on Thu Dec 8 11:19:14 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 12546 encountered ORA-12546: TNS:permission denied EXP-00000: Export terminated unsuccessfully @@@@@
So I will post my whole current situation in the hope someone will be able to help. This server acts as a database connected to a Dynamo and Netscape webserver. At this moment the server is *very* sensitive for access, when we have several concurrent users the load exceeds it's limits and the CPU load is 0% idle. In return the netscape-server will do the same and both machines are runinng on 0% idle and our websites are unreachable. Untill a few days http://www.orafaq.com/forum/t/57551/ ago everything was fine (a high load of 40% idle) and no new sites where added In my client.log I receive the following error at least a couple of times per minute: ************** CLIENT.LOG ******************************************* Fatal NI connect error 12546, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=%ORACLE_HOME%/bin/oracle) (ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS= (PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=) (HOST=hostname)(USER=root)))) VERSION INFORMATION: TNS for Solaris: Version 8.0.5.0.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: http://www.verycomputer.com/159_5d5417dcbae24b71_1.htm Version 8.0.5.0.0 - Production Time: 09-JAN-01 17:58:13 Tracing not turned on. Tns error struct: nr err code: 12206 TNS-12206: TNS:received a TNS error during navigation ns main err code: 12546 TNS-12546: TNS:permission denied ns secondary err code: 12560 nt main err code: 516 TNS-00516: Permission denied nt secondary err code: 13 nt OS err code: 0 ********************************************************* Permissions on the listener.log are set to -rw-r--r-- and that it is owned by oracle group dba, also permissions on /var/opt/.oracle are set to 777 and is owned by oracle group dba and permissions on /var/tmp/.oracle are set to rwxrwxrwx and the directory is owned by the oracle account. my listener.ora it says the following: =========================== LISTENER.ORA =============================== LISTENER = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP.world) (PROTOCOL = TCP) (HOST = oracle) (PORT = 1521) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = SPRO) (ORACLE_HOME = $ORACLE_HOME) ) **** CUT Some other SID's (like above only different names) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 LOG_DIRECTORY _LISTENER = $ORACLE_HOME/network/log LOG_FILE_LISTENER = listener.log TRACE_LEVEL_LISTENER = OFF TRACE_DIRECTORY_LISTENER = $ORACLE_HOME/network/log TRACE_FILE_LISTENER = listener.trc ==================================================================== $ORACLE_HOME is chan
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 Blog
http://www.dba-oracle.com/t_fatal_ni_connect_error_12170.htm fatal ni connect error 12170 Oracle Database Tips by Burleson Consulting November 5, 2015 Question: Below error getting in alert 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 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: fatal ni 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 error: ORA-12170: TNS:Connect timeout occurredCause: The client failed to establish a connection and complete authentication in fatal ni connect 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 setting the SQLNET.INBOUND_CONNECT_TIMEOUT parameter Action: If the error occurred due to system or network delays that are normal for the particular environment, then perform this steps:Turn on tracing to determine where clients are ti