Fatal Ni Connect Error 12560 Sqlplus
Contents |
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start fatal ni connect error 12560 connecting to description address protocol beq viewing messages, select the forum that you want to visit from the selection tns-00530 below. Results 1 to 9 of 9 Thread: TNS-12560: TNS:protocol adapter error Tweet Thread Tools Show Printable Version Subscribe to tns error struct this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-11-04,16:43 #1 ramdatts View Profile View Forum Posts Registered User Join Date Aug 2003 tns-12560: tns:protocol adapter error Location Saint Lucia Posts 14 Unanswered: TNS-12560: TNS:protocol adapter error Hi All, I am trying to use oracle from a windows 2000 pc and I get the belows error. SQL Plus works fine but I still get this error. ************************************************** ********************* Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.1 71.25)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=main )(CID=(PROGRAM=c:\bcg\bin\AdminVC6ORA816_31137.exe )(HOST=SLUL125)(USER=kenty.ramdatt)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP
Fatal Ni Connect Error 12537
NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 11-FEB-2004 16:54:56 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNSrotocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 38 nt OS err code: 0 Can anyone help? Cheers Reply With Quote 02-11-04,17:06 #2 gbrabham View Profile View Forum Posts Registered User Join Date Apr 2003 Location Greenville, SC (USA) Posts 1,155 ensure that you can tnsping the instance from command line. check your SQLNET.ORA file and ensure that SQLNET.AUTHENTICATION_SERVICES= (NONE) Ensure that your oracle home is in the path statement... Problem sounds like the tnsnames.ora has a problem in it ... HTH Gregg Reply With Quote 02-11-04,17:19 #3 ramdatts View Profile View Forum Posts Registered User Join Date Aug 2003 Location Saint Lucia Posts 14 Hi, Tnsping is successful. I only have one sqlnet.org file located in the
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury http://www.dbforums.com/showthread.php?982838-TNS-12560-TNS-protocol-adapter-error and Financial Risk ManagementHuman ResourcesOverviewCore Human 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 https://scn.sap.com/thread/709756 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 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 Entert
on troubleshooting connection problem [message #113254] Thu, 31 March 2005 19:11 psteve Messages: 9Registered: March 2005 Location: New England Junior Member HI, any help is greatly appreciated. I have a development environment http://www.orafaq.com/forum/t/42943/ with 9i forms and reports on one machine and a 9.1 database on another. (both Windows) I installed 10g alongside the 9i on the database machine for evaluation several months ago. Recently, I wanted to create a new 9i db, but the 10g was interfering, and the 9i configuration assistant died without ever opening a window. So I decided to just go with 10g. fatal ni I had no trouble making several 10G databases. But I cannot get forms to connect to any of them. 9i is on 1521 only and 10G is on 1526 only. Windows services shows that both listeners are running. I configured TNSNAMES.ora on the development machine and tnsping sees all the 9i and 10g databases just fine. I even get 0 msec and 10 msec response fatal ni connect times. Tnsping prints the names of the files it is using for configuration, and they are the right ones ( the ones in the 9iDS hierarchy---the development machine has an old 8.1.7 db on it, but I don't think that is an issue.) All the 9i and 10g databases are up and accessible from SQL plus running on the database machine. But on the client machine, neither forms, reports, SQL Plus, nor a development tool I use can connect to the 10g databases. They can all connect to the 9i databases. Attempts to connect to the 10G databases always timeout. Since tnsping is working, I am stumped. What should I be trying to troubleshoot this problem? Report message to a moderator Re: need ideas on troubleshooting connection problem [message #113329 is a reply to message #113254] Fri, 01 April 2005 08:22 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator Tnsping check the availability of listener. Thats it. check the sqlnet.ora in the concerned machine and comment out all the entries. try again Report message to a moderator Re: need ideas on tro