Ora-12222 Error
Contents |
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & ora-12222 no such protocol adapter Deployment DevCraft Leverage a complete UI toolbox for web, mobile
Ora-12222 Forms 6i
and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile ora-12538: tns: no such protocol adapter device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser 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 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 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 Custome
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
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 http://knowledgebase.progress.com/articles/Article/3011 of the '(PROTOCOL=..)'; keyword-value pair in a TNS address) is 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, http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm LISTENER.ORA or SQLNET.ORA). Solutions: If TNS_ADMIN is set then you should be able to use 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 supportTo 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 Server 2003 Symptoms – Problem Statement: http://www.oracleport.com/oracle6i-formsreports-builder-cannot-connect-to-any-database-ora-12222-tns-no-such-protocol-adaptor/ 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 error: ORA-12222: TNS:No such protocol adapter There are no http://grokbase.com/t/perl/dbi-users/019adh4eeb/ora-12222-tns-no-such-protocol-adapter 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 The ORA-12222 error is due to the ORACLE_HOME System environment variable being no such 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 variable is set in either the User or System Environment Variables: - Right click My Computer from the no such protocol 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:
Recommended Books Popular Dowloads Using Fast Formula Comments or questions are welcome. *(denotes required field) Name: * E-Mail Address: * Subject: * Message: * CAPTCHA Code: * Recent Commentsrama on Oracle HR and Payro
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)(HOST=db53)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))", "")Getting this error :DBI->connect failed: ORA-12222: TNS:no such protocol adapter (DBD: loginfailed) at C:\MY\perldbi1.pl line 5All 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 listPerl-Win32-Database@listserv.ActiveState.comhttp://listserv.ActiveState.com/mailman/listinfo/perl-win32-database reply Tweet Search Discussions Search All Groups Perl dbi-users 1 response Oldest Nested Dan Horne Andrey the ora-12222 error normally occurs when there is a syntax error in your connect string. Try using the alias in your tnsnames.ora file instead my $dbh = DBI->connect("dbi:Oracle:$db_sid", $db_user, $dp_pass) where $db_sid is the alias name. When you mentioned that SQL*plus can connect, did you mean using user/pass or user/pass@sid? Dan -----Original Message----- From: Andrey Bronfin [SMTP:andreyb@elrontelesoft.com] Sent: Tuesday, September 11, 2001 2:49 AM To: 'dbi-users@perl.org' Dan Horne at Sep 10, 2001 at 8:42 pm ⇧ Andreythe ora-12222 error normally occurs when there is a syntax error in yourconnect string. Try using the alias in your tnsnames.ora file insteadmy $dbh = DBI->connect("dbi:Oracle:$db_sid", $db_user, $dp_pass)where $db_sid is the alias name. When you mentioned that SQL*plus canconnect, did you mean using user/pass or user/pass@sid?Dan-----Original Message-----From: Andrey Bronfin [SMTP:andreyb@elrontelesoft.com]Sent: Tuesday, September 11, 2001 2:49 AMTo: 'dbi-users@perl.org'Subject: ORA-12222: TNS:no such protocol adapter<< File: ATT00001.txt; charset = windows-1255 >> reply | permalink Related Discussions Trouble using IPC adapter with Oracle 8 make test failed. DBD::Pg::st execute failed: function requires at least protocol version 3.0 Prepare error postgres SSL Newbie Questi