Oracle Error Ora-12538
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle ora-12222 no such protocol adapter Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Ora-12222 Forms 6i
ORA-12538: TNS: no such protocol adapter
Ora-12154
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 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 legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to up
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://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm 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 76 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
protocol adaptor If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to http://www.dbasupport.com/forums/showthread.php?4692-ora-12538-TNS-no-such-protocol-adaptor register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 10 of 10 Thread: ora-12538:TNS:no such protocol adaptor Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to oracle error Hybrid Mode Switch to Threaded Mode 12-02-2000,02:13 PM #1 charity View Profile View Forum Posts Junior Member Join Date Aug 2000 Location NY Posts 37 Hi Has any bodyever encountered this problem before? Ora: -12538:TNS:no such protocol adaptor. I could not find it under the error messages on documentation. I tried to log on(through SQL*PLUS) to my NT oracle error ora-12538 machine running oracle 8i(8.1.5) and I had this message ORA-12538:TNS:no such protocol adaptor. This is exactly what I did: e.g. USERNAME..................... PASWWORD.................. HOST STRING............... Ora: -12538:TNS:no such protocol adaptor. I logged on as system,sys,internal with all the right passwords but I kept getting the same error message. I went to the dos prompt in attempt to get to the sever manager but that also did not help. This is exactly what I did at the dos prompt: c:\>set oracle_sid=dbname C:\>svrmgrl The name specified is not recognized as an internal or external command, operable program or batch file. Can anybody tell me what's going on here? thanks, charity Reply With Quote 12-02-2000,04:04 PM #2 rpardip View Profile View Forum Posts Member Join Date Sep 2000 Posts 155 Try to look into Net8 error messages and you will find the description for this error. I think the problem is related to incorrect configuration of LISTENER service. Try to open LISTENER.ora file and double-check. Hope this helps Reply With Quote 12-02-2000,04:57 PM #3 ch