Error Ora 12538 Tns No Such Protocol Adapter
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting ora-12222 no such protocol adapter PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion
Ora-12222 Forms 6i
Excel-DB Don Burleson 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 shouldto friend TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged) [message #220953] Thu, 22 February 2007 19:39 shahnazurs Messages: 240Registered: June 2005 Location: India Senior Member Hi. I am facing exactly same proble, but no solution till now i installed oracle 9i release 2 on windows xp professional then i installed form 6i in different home. i copied tnsnames.ora file from ORACLE_HOME\network\admin to forms home NET80\admin folder.... Once i installed both i can see in the PATH variable both homes then bin directory.... ORACLE_HOME/bin FORMS_HOME/bin in these two locations you can find sqlplus.exe file, when i try to login from the command prompt like http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm below sqlplus "/as sysdba" it is not going, instead it is coming to command prompt... if i remove FORMS_HOME/bin from the PATH variable i can able to do that...just keep this problem aside. When i try to connect oracle from the forms it is giving error like "ORA-12222 TNS no such protocol adapter...." could you please tell me why? what is need to do to get rid of this? Thanks. Report message http://www.orafaq.com/forum/t/79809/ to a moderator TNS No Such Protocol adaptor Ora- 12222 [message #221013 is a reply to message #220953] Fri, 23 February 2007 04:02 sauami Messages: 54Registered: October 2005 Location: india Member Dear sir, I am using forms 6i on oracle database 9.2 on oracle apps 11.5.0 i can connect database through toad or pl/sql developer but unable to connect forms and report when i try to connect my forms builder it give the error TNS No Such Protocol adaptor Ora- 12222. print screen is attached. Pls. help me. Thanks, Saurabh Report message to a moderator Re: TNS No Such Protocol adaptor Ora- 12222 [message #221047 is a reply to message #221013] Fri, 23 February 2007 07:55 shahnazurs Messages: 240Registered: June 2005 Location: India Senior Member Hi. I am also facing the same problem, i posted ready but no reply from anybody Thanks, Shahnaz. Report message to a moderator Re: TNS No Such Protocol adaptor Ora- 12222 [message #221081 is a reply to message #221047] Fri, 23 February 2007 12:39 Littlefoot Messages: 20840Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator This is what Oracle says about it; see if it will help.OracleORA-12222: TNS:no support is available for the protocol indicated Cause: The protocol requested in the A
12538 KEY REGISTRY HOME Technote (troubleshooting) Problem(Abstract) Oracle error: ORA-12538: no such 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 no such protocol 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