Connect Error 12538
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted!
Ora 12222 No Such Protocol Adapter
Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don ora-12222 forms 6i Burleson Blog
ORA-12538: TNS: no such protocol adapter Oracle tips by Burleson 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 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 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 legprotocol adapter [message #143383] Thu, 20 October 2005 04:26 devarajraja Messages: 2Registered: October 2005 Junior Member Hi, I am using SQL*Plus 8.0.6 on Win XP to connect to Oracle server 9.2.0 on HP-UX. I get the following error message ORA-12203: TNS:unable to connect to destination. I tried tnsping80 which reported the follwoing error TNS:12538:TNS: no such protocol adapter. I reinstalled sqlplus and installing again, I reinstalled the protocol adapter. But still the error http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm persist. I checked for duplicate TNSNAMES.ora but only one exists. Can anyone help me in this regard. Thanks and Regards, Devaraj. Report message to a moderator Re: TNS-12538: TNS:no such protocol adapter [message #143422 is a reply to message #143383] Thu, 20 October 2005 07:31 Frank Naude Messages: 4502Registered: April http://www.orafaq.com/forum/t/53795/ 1998 Senior Member Hi, $ oerr tns 12203 12203, 00000, "TNS:unable to connect to destination" // *Cause: Invalid TNS address supplied or destination is not listening. // This error can also occur because of underlying network transport // problems. // *Action: Verify that the service name you entered on the command line // was correct. Ensure that the listener is running at the remote node and // that the ADDRESS parameters specified in TNSNAMES.ORA are correct. // Finally, check that all Interchanges needed to make the connection are // up and running. $ oerr tns 12538 12538, 00000, "TNS:no such protocol adapter" // *Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)" // keyword-value pair in a TNS address) is unknown. If the supplied address // is typographically correct then the protocol adaptor is not installed. // *Action: Install the protocol adapter or correct typographically error, // as appropriate. Note: if the supplied address was derive
Support Search GitHub This repository Watch 14 Star 94 Fork 45 kubo/ruby-oci8 Code Issues 7 Pull requests 1 https://github.com/kubo/ruby-oci8/issues/55 Projects 0 Wiki Pulse Graphs New issue SSL connection - ORA-12538: TNS:no such protocol adapter #55 Closed davidtcook opened this Issue May 9, 2014 · 9 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants davidtcook commented May 9, 2014 Environment : Solaris 10, ruby 1.9.1, ruby-oci8 2.1.6, Oracle connect error client 11.2.0.3.0, connecting to databases also on 11.2.0.3.0. Database connection details/aliases are in tnsnames.ora, username/password details are stored in an Oracle Wallet (i.e. ewallet.p12, cwallet.sso). Environment variables TNS_ADMIN and WALLET_DIR are set correctly. The situation : 1. All connections (non-SSL and SSL) can be made successfully using "sqlplus" from the command-line using Oracle Wallet entries or connect error 12538 explicit username/password 2. Connections via ruby-oci8 to non-SSL DBs can be made successfully using the same Wallet as in 1, or with explicit username/password. 3. Connections via ruby-oci8 to SSL DBs using either Oracle Wallet or specified username/password fail with this message : OracleInterface::CategoryClassMethods#full_path: ORA-12538: TNS:no such protocol adapter Minimal program to reproduce the issue (connection string redacted) - if I replace the connection string with "ABC123_USER" (where that references a Wallet entry /tnsnames.ora entry for a non-SSL database), this program works : require 'dbi' require 'oci8' begin dbenv = OCI8.new(nil, nil, "XYZ123_SSL_USER") rescue OCIException => e puts "OracleInterface::CategoryClassMethods#full_path: #{e}" end Note that both command-lines work: sqlplus /@ABC123_USER sqlplus /@XYZ123_SSL_USER In summary: This problem only occurs when using ruby-oci8 to attempt to connect to a DB over an SSL connection. Please let me know if you need any further information to help track down this issue. Owner kubo commented May 9, 2014 Could you post the output of the following command or send it to kubo@jiubao.org?