Re: TNS Resolution

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: <knightjck_work@xxxxxxxxx>
  • Date: Wed, 18 Jan 2006 23:54:50 +0100

I don't have access to the particular box in question
(Data Security has it locked down - it's a development
box, go figure!), so I can't verify the tns entry on
the server.  However, this tns entry allows other
developers to connect to the instance without a
problem.

I will continue to try to verify the tnsnames.ora
entry on the server.  Until then, is there anything
else I can check?

If the listener is not password protected you can set a listener.ora in the OH/TNS_ADMIN on your client(or some other machine with lsnrctl installed), using the same parameters from your thsnames.ora and then run lsnrctl services listener_name to see the correct service name. You could check the sqlnet.ora default domain parameter too.

For example:

LISTENER_CLSDEV =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = ud505)(PORT = 1521))
     )
   )
 )

lsnrctl services LISTENER_CLSDEV

Regards,
Dimitre

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006