Fatal Ni Connect Error 12560 Connecting To
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title.
Fatal Ni Connect Error 12560 Connecting To Description Address Protocol Beq
You can not post a blank message. Please type your message and tns-00530 try again. More discussions in Oracle Provider for OLE DB All PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE
Tns Error Struct
DB This discussion is archived 9 Replies Latest reply on Oct 12, 2012 1:48 PM by 966341 ORA-12560 966341 Oct 5, 2012 7:32 AM Hello, i'm working on Windows2003-Server and installed tns-12560: tns:protocol adapter error oracle full client to connect to an Oracle-DB 11g on Unix. I can connect using SQL-Plus but not with Oracle Ole DB. The programs i use, are C#-Programs with NET-Version 2.0. The connection string i use in the program is "Provider=OraOLEDB.Oracle;Persist Security Info=False;Password=xxx;User ID=XXX; DataSource=vgdb;Extended Properties=". I tried several connection strings, but i always get the error ORA-12560. This connection-string works already on fatal ni connect error 12537 other machine. But here its a fully installation of oracle database 10g on windows and i can also connect from here to Oracle-DB 11g on Unix. Configuration of sqlnet.ora: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) ADR_BASE = O:\app\admin\product\11.2.0\client_1\log Entry in tnsnames.ora: vgdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.156.199)(PORT = 1523)) ) (CONNECT_DATA = (SID = svgdb) ) ) I have the same question Show 0 Likes(0) 21317Views Tags: none (add) This content has been marked as final. Show 9 replies 1. Re: ORA-12560 dataseven Oct 5, 2012 8:00 AM (in response to 966341) hi, check if db listener is running go to services and look for a service OracleOraListener and start it. OR go to command prompt and run lsnrctl, then enter 'start' to start the listener regards, Like Show 0 Likes(0) Actions 2. Re: ORA-12560 966341 Oct 5, 2012 9:51 AM (in response to dataseven) Hi, i checked the client and the server. On the client there is a service OracleOraClient11gHomeTNSListener which is started. I restarted it and it didn't help. lsnrctl start says already started. lsnrctl status says listener is started
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any
Ora-12560
questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site https://community.oracle.com/thread/2450196 for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Connection error while connecting http://dba.stackexchange.com/questions/145250/connection-error-while-connecting-to-oracle-xe to Oracle XE up vote 0 down vote favorite This just started happening this morning, and I'm not sure what the cause is. IT just installed some sort of Windows update but I'm not sure if this is related to the issue. Basically, when I try to connect to Oracle I get a connection timeout error. When I start to connect, I immediately see the following error message in the alert_xe.log file: *********************************************************************** Fatal NI connect error 12560, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production Time: 28-JUL-2016 09:04:38 Tracing not turned on. Thu Jul 28 09:04:38 2016 *********************************************************************** Tns error struct: Fatal NI connect error 12560, connecting to: (LOCAL=NO) ns main err code: 12560 VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.2.0 - Production Oracle Beq
and https://scn.sap.com/thread/709756 SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing http://www.ora00600.com/wordpress/scripts/databaseconfig/tns-12560/ and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human fatal ni Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance fatal ni connect ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service 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 Collabor
Problem Running Oracle 11g database on a Windows platform you are trying to log onto the database using the listener and you receive the following error message: Fatal NI connect error 12560, connecting to: (LOCAL=NO) You decide to try a local connection, which just means that you connect directly to the database without going via the listener. In Windows, you would do it as follows: SET ORACLE_SID=TESTDB sqlplus "sys/password as sysdba" This assumes that the database name is TESTDB. When attempting to make the connection in this way it works and you can connect to the database without the 12560 error message. Next, you check the listener.log file which can be found (by default) in ORACLE_HOME\network\log or if you are running 11g and using a diagnostic destination you might find it in ORACLE_BASE\diag\tnslsnr\'servername'\'listenername'\listener.log and you find the following information: Time: 12-MAR-2013 09:31:34 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (14996) as a result of ORA-609 Mar 12 09:31:34 2013 Stopping background process CJQ0 The Cause There can be many reasons why you come across this TNS 12560 error message. The reason for this particular case was because I was running the Windows service for the database as a non-local system account so that it could write out to a file share, but I hadn't changed the listener used to connect to this database to run as a non-local system account. The Solution Change the user account that the listener is running as to the same as the one that the database service runs as, restart the listener and this should resolve the issue. Other Causes of the ORA-12560: TNS:protocol adapter error Listener Not Started If your OS is Windows then you should check that the service is started. Here is what happens if you attempt a connection, without using the listener, to a database whose service is not started: set oracle_sid=TESTDB sqlplus "sys as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 20 14:47:12 2012 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: ERROR: ORA-12560: TNS:protocol adapter error It's always best to run through the most basic checks first, such as are all the services started for the database and listener, do the configuration files exist, are they correct and have any changes been made recently to any of them. No Username in Connection String - Using a Variable to Connect? Another example is that you might not be specifying the a us