Oracle Error Tns-12538
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of ora-12222 no such protocol adapter this site About Us Learn more about Stack Overflow the company Business ora-12222 forms 6i Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ora-12154 Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to resolve this error on oracle? up vote 1 down vote favorite what is this error, I am trying to import some data into oracle and getting this error on a fresh database. UID-12538: operation generated ORACLE error 12538 ora-12538: TNS:no such protocol adapter oracle share|improve this question asked Sep 28 '15 at 11:28 Sanjeev 114 Welcome to SO! This question is lacking a lot of information - please add the exact command you run, the contents of your tnsnames.ora / sqlnet.ora plus any relevant environment variables (ORACLE_HOME/TNS_ADMIN) that you have changed (and please add this information by 'edit'ing your question, not as a comment) –Frank Schmitt Sep 28 '15 at 13:05 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote 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 envi
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > can not connect to database: TNS-12538: TNS:no such protocol adapter Want to Advertise Here? Solved can not http://stackoverflow.com/questions/32821887/how-to-resolve-this-error-on-oracle connect to database: TNS-12538: TNS:no such protocol adapter Posted on 2006-03-16 Oracle Database 2 Verified Solutions 13 Comments 8,322 Views Last Modified: 2008-01-09 Hello, I'm trying to connect to my database service name : orcl in command line, but I got an error: Q1 ===================================================== C:\>sqlplus system/dba123@orcl Message 133 not found; product=SQLPlus; facility=SP2 : Release 9.0.1.4.0 - https://www.experts-exchange.com/questions/21777291/can-not-connect-to-database-TNS-12538-TNS-no-such-protocol-adapter.html Production on Thu Mar 16 16:02:49 2006 (c) Copyright 2001 Oracle Corporation. All rights reserved. ERROR: ORA-12538: TNS:no such protocol adapter ====================================================== If I do tnsping orcl: the error is: Q2 ====================================================== Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =mypcname.mydomanname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = o rcl))) TNS-12538: TNS:no such protocol adapter ====================================================== My tnsnames.ora file is : ================================================ # tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =mypcanme.mydomainname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ============================================== So there is a service name called : orcl My listener.ora file is : ================================================ # listener.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc)
reply Problem appeared after server reboot. Both database and instance were ok but https://dbacatalog.wordpress.com/2014/11/25/tcp-protocol-error-tns-01153-failed-to-process-string-tns-12538-tnsno-such-protocol-adapter/ listener refused to start with errors in trace: nsglma:Reporting the following error stack: TNS-01150: The address of the specified listener name is incorrect TNS-01153: http://www-01.ibm.com/support/docview.wss?uid=swg21277473 Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) We spent significant time and tried several ways to resolve it (configuring another listeners with different ports, change hostnames, etc) oracle error but none helped. Looked like not a configuration issue. Later when no options left, we just tnsping the listener on another server. This time we got different but more promising error: TNS-12538: TNS:no such protocol adapter Everything was checked one more time - no mistakes in connection string, no network oracle error tns-12538 partitions and no problem with remote listener. Most likely it was caused by protocol itself. So, we did some checks according to oracle doc; (Doc ID 435795.1) by using utility adapters (displays the configured Oracle transport protocols, naming methods, and security options) cd $ORACLE_HOME/bin ./adapters Installed Oracle Net transport protocols are: IPC BEQ Error!!! TCP/IP is not completely installed! Present in libntcp10, but missing from ntcontab.o... Error!!! SSL is not completely installed! Present in libntcps10, but missing from ntcontab.o... RAW Error!!! SDP/IB is not completely installed! Present in libntcp10, but missing from ntcontab.o... Which points a problem with TCP protocol - TCP/IP is not completely installed! As for solution oracle suggest following: 1. connect as the owner of oracle 2. make sure that ORACLE_HOME and LD_LIBRARY_PATH are set correctly ORACLE_HOME= LD_LIBRARY_PATH=$ORACLE_HOME/lib 3. shutdown all Oracle instances and processes running from this Oracle Home 4. execute following
12538 KEY REGISTRY HOME Technote (troubleshooting) Problem(Abstract) Oracle error: ORA-12538: TNS:no such protocol adapter Resolving the problem The data (Software\ORACLE\HOME0) in the oracle.key file located in the directory "c:\oracle\ora817\bin" has to synch up with the entries in the Registry; [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES] "HOME_COUNTER"="1" "DEFAULT_HOME"="Ora817" "LAST_HOME"="0" [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0] "ID"="0" "ORACLE_GROUP_NAME"="Oracle - Ora817" "ORACLE_HOME_NAME"="Ora817" "ORACLE_HOME"="C:\\Oracle\\Ora817" "NLS_LANG"="GERMAN_GERMANY.WE8ISO8859P1" "ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0" Historical Number 10005517 Product Alias/Synonym CONTENT SERVICES Document information More support for: FileNet Content Services Software version: 5.X Operating system(s): Platform Independent Reference #: 1277473 Modified date: 07 June 2006 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility