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! ora-12222 no such protocol adapter Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson
Ora-12222 Forms 6i
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 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 publish12538 KEY REGISTRY HOME Technote (troubleshooting) Problem(Abstract) Oracle error: ORA-12538: http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm 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 http://www-01.ibm.com/support/docview.wss?uid=swg21277473 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: 2006-06-07 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
protocol adaptor If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum http://www.dbasupport.com/forums/showthread.php?4692-ora-12538-TNS-no-such-protocol-adaptor 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 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 error ora could not find it under the error messages on documentation. I tried to log on(through SQL*PLUS) to my NT 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 error ora 12538 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 charity View Profile View Forum Posts Junior Member Join Date Aug 2000 Location NY Posts 37 I think I have found out what the problem is but I am having a difficult time trying to solve it. I checked in services, all the oracle service are supposed to start automatically, but none of them started. So I clicked on them and clicked on the START button but it returned this error message: could not start the oracleservice PROD on DDDDDD Error 003: The system cannot find the path specified. Note: PROD is the name of the service and DDDDD is the name of the computer(system) CAn any body help with the spaecifics? Reply With Quote 12-02-2000,05:42 PM #4 pando