Fatal Ni Connect Error 12546 Connecting To
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 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ and in the sqlnet.log getting the following error :- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ *********************************************************************** Fatal NI connect error 12546, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/data1/app/oracle/product/920/bin/oracle)(ARGV0=oracleora92)(ARGS='(DESCRIPTION=(LOCAL=Y ES)(ADDRESS=(
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 http://www.orafaq.com/forum/t/57551/ and both machines are runinng on 0% idle and our websites are unreachable. Untill a few days 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 http://www.verycomputer.com/159_5d5417dcbae24b71_1.htm 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: 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_LI
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing https://scn.sap.com/thread/1951205 and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and https://davidalejomarcos.wordpress.com/2011/01/18/removing-fatal-ni-connect-error-xxxx-from-your-alert-log/ AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket fatal ni with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service fatal ni connect ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise ManagementFinancial ManagementH
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 The problem: alert.log file has many entries for Fatal NI connect error. 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 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: 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: 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 t