From: Steve McCulloch Newsgroups: comp.databases.oracle.server Subject: Re: Help! ORA-12560 Tns protocol error References: <8jvn2j$ei6$1@nnrp1.deja.com> User-Agent: MT-NewsWatcher/3.0 (PPC) Message-ID: Lines: 42 Date: Sat, 09 Sep 2000 20:26:00 GMT NNTP-Posting-Host: 24.129.140.236 X-Complaints-To: abuse@rr.com X-Trace: typhoon.tampabay.rr.com 968531160 24.129.140.236 (Sat, 09 Sep 2000 16:26:00 EDT) NNTP-Posting-Date: Sat, 09 Sep 2000 16:26:00 EDT Organization: RoadRunner - TampaBay In article <8jvn2j$ei6$1@nnrp1.deja.com>, sjoshi@ingr.com wrote: >Hello All > This error with Oracle is driving me nuts. I can do a tnsping to the >service and lsnctrl says 1 listener configured. However if I go to >server manager, I get an error ORA-12560 TNS protocol adapter error. >I also the checked the sid under \ORACLE\HOME2 and it does have an >entry for ORACLE_SID pointing to the correct instance. > >Any help is greatly appreciated. > >thanks >Sunit > > >Sent via Deja.com http://www.deja.com/ >Before you buy. One possible way this can happen is if your sqlnet.ora file contains a 'names.default_domain' entry that is inconsistant with your service alias name that you are using. For example, if this parameter contains "world" (NAMES.DEFAULT_DOMAIN=WORLD is Oracle's default) then if your connecting to a service using the alias "database" (in your tnanames.ora file), Oracle will add ".world" to the service alias name entered, or to what you default if you used 'set oracle_sid='. It then looks for an entry in tnsnames.ora called "database.world", when it doesn't find it you get the error you described (this happened to me exactly how you decribe it). I think you have two options: 1. Remove the 'names.default_domain' if this is your own private database; or 2. Add the value of 'names.default_domain' to the alias name in your tnsnames.ora file, so it looks something like... database.world = (description = (address_list = etc., etc., etc... Hope I explained this right and it helps. Steve M