Re: Net8 problems ORA-12560

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Fri, 30 Nov 2001 19:14:57 +0100
Message-ID: <6jif0uorjr1bkrtc7bcf8djhstpak167iu@4ax.com>

On Fri, 30 Nov 2001 17:22:18 -0000, "David" <david.wynter_at_btclick.com> wrote:

>Hi,
>
>I originally posted this on the Oracle tools newsgroup but realise that it
>is more about Net 8 not being configured properly (at least I think that is
>where the problem lies? ) and that is why thesqlldr and SQLPlus won't work.
>
>I have 8.1.5 and I have read the Net 8 manual. TNSPing works fine, the Net 8
>Assistant tests the connection fine. For this error the troubleshooting
>section of the documentation says run a trace and then look at that. I did
>and the listener trace really gives me nothing that indicates any error.
>
>I am at a loss to know what to do next. I have the client and server on the
>same workstation running W2K Server I use for development. JDBC & SQLPlus
>for windows all work fine.
>
>One thing I don't get is that it has the service names as
>"blah.development.blah.com" when I don't have a blah.com set up in the DNS?
>I don't know enough to understand howw it is supposed to resolve this name.
>The host name I use does appear in the 'Host Name' entry in the Address
>Configuration section of the Net8 assitant and in the DNS command window of
>W2K.
>
>I tried 192.168.0.1 as a localhost address and the string "localhost" to no
>avail. How can it be this difficult?
>
>Any suggestions?
>
>Regards
>
>David
>
>
>

1 the trace should have been a *client* trace. The necessary changes (trace_level_client=16, trace_unique_client=true, trace_directory_client = <whatever you want> ) should be made in sqlnet.ora
2 for any tool you should use the username/password_at_servicename syntax and have tnsnames.ora configured.
If you fail to do so, and don't have ORACLE_SID set, either in the registry or as environment variable, and you have multiple databases, you will get ..... ORA-12560 protocol adapter error 3 the correct way to define localhost
127.0.0.1 localhost
4 In a correctly defined net8 setup the domain part in the service name is a proper dns domain. The syntax for a service name is <servicename>.blah.com =

(address_list = (address =
(protocol=tcp)(host=myhost.blah.com)(port=1521)))
(connect_data=(sid_name=<yoursid>)) # Oracle 7.3 and 8.0
(connect_data=(service_name = <service_name in init.ora>)) # 8i and 9i

5 Requests to resolve 12560 or 12154 without including tnsnames.ora and sqlnet.ora are difficult to resolve. If you really want to have it resolved, include them
6 With several posts per day requesting info on ora-12560, this is becoming a boring issue.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 30 2001 - 12:14:57 CST