good net8 docs needed or pointers

From: Heidi E. Schmidt <heidi_at_cybercom.net>
Date: Thu, 18 May 2000 11:56:16 -0400 (EDT)
Message-Id: <10501.105973@fatcity.com>

I work in a mixed environment where oracle 7.3.4.4 is on NT and oracle 8.1.5.0.2 is on UNIX

I have been experiencing weird errors.

One example:

	The rdbms target is 8.1.5 on NT
	The net8 client is 8.1.5 on HP-UX 11.0 

On the client in the tnsnames file we use service name instead of sid there is a sqlnet.fdf file (not sqlnet.ora) I made an initial entry that looked like this:

exhange=
  (DESCRIPTION =
(ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.150.71.35)(PORT = 1521))
     )


     (CONNECT_DATA =

       (SERVICE_NAME = exchange)
     )

   )

It would not work with sqlplus, but would work when tnsping'd

Then my co-worker who just took the Oracle 8 Admin class with Oracle mentioned to put in the service_name area exchange.world and change the main alias to exchange.world His instructor said to just "do it" and didn't explain why.

Now, if I execute sqlplus -S user/passwd_at_exchange.world it works just fine.

BUT when I just try sqlplus -S user/passwd_at_exchange it gives me of all things a ORA-12541 (No listener running)

But the remote listner is running.

With Oracle 7.3.4.4.0 I could specify name.world or just name when connecting

Is there some way to trace to understand why it is doign what it is doing? Or some place where the functionality of SERVICE_NAME is defined better?

Even when I went back to play with net assitant to see what it thought it would do...it doesn't sneak in the extra world extension. Received on Thu May 18 2000 - 10:56:16 CDT