Error Ora 12222 Tns No Such Protocol Adapter
Contents |
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, ora 12560 tns protocol adapter error mobile and desktop development OpenEdge Build, protect and deploy apps across
Ora 12560 Tns Protocol Adapter Error Visual Studio
any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser
Ora 12560 Tns Protocol Adapter Error 11g Client
or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage
Ora 12560 Tns Protocol Adapter Error Excel
and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with ora 12560 tns protocol adapter error client machine a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6473 CONTACT SALES Knowledge Base 000002290 < Back to sear
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 ora-12538: tns: no such protocol adapter Don Burleson Blog
ora-12222 forms 6i ORA-12538: TNS: no such protocol adapter Oracle Database Tips by Burleson Consulting From the Oracle documentation we see this on the ORA-12538 error: ORA-12538: TNS:no such protocol adapter Cause: The protocol adapter requested (by way of the '(PROTOCOL=..)'; keyword-value pair in a TNS address) is http://knowledgebase.progress.com/articles/Article/3011 unknown. If the supplied address is typographically correct then the protocol adapter is not installed. Action: Install the protocol adapter or correct typographically error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or SQLNET.ORA). Solutions: If TNS_ADMIN is set then you should be able to use http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm a network alias, not the full "(DESCRIPTION..." connect string. The TNS_ADMIN parm tells Oracle clients where to find the tnsnames.ora file. Setting the ORACLE_HOME environment variable incorrectly on a Windows based system will create this problem. �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson ConsuTo Any Database (ORA-12222) TNS No Such Protocol adaptor ….. Posted March 6th, 2013 by faisal & filed under Uncategorized. Applies to: Oracle Net Services – Version: 8.0.6.0.0 to 8.0.6.3.0 Microsoft Windows 2000 Microsoft Windows XP Microsoft Windows http://www.oracleport.com/oracle6i-formsreports-builder-cannot-connect-to-any-database-ora-12222-tns-no-such-protocol-adaptor/ Server 2003 Symptoms – Problem Statement: Oracle Forms6i Builder: 6.0.8.11.3 on Microsoft Windows XP. Server: Oracle10g R2 (10.2.0.3.0) When trying to connect to any database instance using Oracle6i Forms displays the following http://www.nntp.perl.org/group/perl.dbi.users/2001/09/msg5979.html error: ORA-12222: TNS:No such protocol adapter There are no problems connecting to the database from SqlPlus, TOAD, etc that use the same tnsnames.ora file entries. Problem reported with any/all Net Service Name/aliases. Cause protocol adapter The ORA-12222 error is due to the ORACLE_HOME System environment variable being explicitly set to one of the installed Oracle Home locations causing the Oracle Forms/Reports products to look for supporting DLLs in the wrong path location. When using multiple Oracle Homes on Windows platforms, the ORACLE_HOME variable should not be explicitly set in either the User or System Environment Variables. To verify if the ORACLE_HOME ora 12560 tns variable is set in either the User or System Environment Variables: - Right click My Computer from the Windows Desktop. - Select ‘Properties’. - Then click the ‘Advanced’ tab. - Next select the ‘Environment Variables’ button. - Search for the ORACLE_HOME variable in either the User or System Environment Variables sections. Solution – To implement the solution, please execute the following steps: - Right click My Computer from the Windows Desktop. - Select ‘Properties’. - Then click the ‘Advanced’ tab. - Next select the ‘Environment Variables’ button. - Search for the ORACLE_HOME variable in either the User or System Environment Variables sections. - If found, highlight/select the ORACLE_HOME variable and delete it using the ‘Delete’ button below the corresponding windowpane. Important: On Windows 2003 Servers it is also important to cleanly reboot the Windows Server to clear the ORACLE_HOME variable. « Previous Post Next Post » Leave a Reply Cancel reply Your email address will not be published. Required fields are marked * Name * Email * Website Comment You may use these HTML tags and attributes: gurus ! just installed ActivePerl5 (revision 5 version 6 subversion 1) , DBD-Oracle [1.03 ] DBI [1.13 ] Trying to connect to Oracle 8.0.5 DB : $dbh = DBI->connect("dbi:Oracle:","bro/bro@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS T=db53)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))", "") Getting this error : DBI->connect failed: ORA-12222: TNS:no such protocol adapter (DBD: login failed) at C:\MY\perldbi1.pl line 5 All the client connections , except for the perl ones (sql*plus , TOAD , odbc , jdbc etc..) work like a charm . Would U please advise. TIA. DBAndrey * 03-9254520 * 053-464562 * mailto:andreyb@elrontelesoft.com _______________________________________________ Perl-Win32-Database mailing list Perl-Win32-Database@listserv.ActiveState.com http://listserv.ActiveState.com/mailman/listinfo/perl-win32-database Thread Next ORA-12222: TNS:no such protocol adapter by Andrey Bronfin RE: ORA-12222: TNS:no such protocol adapter by Dan Horne nntp.perl.org: Perl Programming lists via nntp and http. Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About