Oracle Error 12538
Contents |
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 this site About Us Learn more about Stack Overflow the company
Ora-12222 No Such Protocol Adapter
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ora-12222 forms 6i Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers,
Ora-12154
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 environment variable incorrectly on a Windows based system will create this problem. share|improve this answer answered Sep 28 '15 at 11:30 Heru-Luin 1,388621 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, yo
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search http://stackoverflow.com/questions/32821887/how-to-resolve-this-error-on-oracle News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-12538 Error Description: TNS:no such protocol adapter Error Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is http://psoug.org/oraerror/ORA-12538.htm 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). There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 64 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
and get tips & solutions from a community of 418,615 IT Pros & Developers. It's quick & easy. https://bytes.com/topic/oracle/answers/606754-oracle-error-12538-a Oracle Error -12538 P: 1 jack16377 pls give me the solution for the following error message... Error while trying to retrieve text for error ORA-12538 regards jack Feb 23 '07 https://dbacatalog.wordpress.com/2014/11/25/tcp-protocol-error-tns-01153-failed-to-process-string-tns-12538-tnsno-such-protocol-adapter/ #1 Post Reply Share this Question 2 Replies 100+ P: 579 vijaydiwakar pls give me the solution for the following error message... Error while trying to retrieve text for error oracle error ORA-12538 regards jack jack show the qry and desc of thy tbl and some data from it Feb 23 '07 #2 reply Expert 100+ P: 534 michaelb 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 oracle error 12538 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). Feb 23 '07 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics ORACLE 10G R1 on SLES 9SP1 Problem with Information Integrator/Federated Datase - Oracle Asp.net / iis / oracle problem ASP.net and Oracle error System.Data.OleDb.OleDbException Oracle Adventures Export Access Data to Oracle Linked Server (Oracle 9i) Oracle Connection Pooling Error in starting Oracle agent and ORA:01031 on SQLPLUS Oracle 8.1.7 on Mandrake 9.1 install problems Browse more Oracle Database Questions on Bytes Question stats viewed: 6199 replies: 2 date asked: Feb 23 '07 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Oracle Database Answers Sitemap | Oracle Database Insights Sitemap Follow us to get the Latest Bytes Updates
reply Problem appeared after server reboot. Both database and instance were ok but 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: 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) 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 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 commands: $ script /tmp/relink_adapt.out $ cd $ORACLE_HOME/bin $ ./gennttab $ cd $ORACLE_HOME/network/lib $ make -f ins_net_client.mk ntcontab.o $ cd $ORACLE_HOME/bin $ genclntsh $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_