TNS Resolution 2006-01-18 - By Radoulov, Dimitre
> 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
--
http://www.freelists.org/webpage/oracle-l
|
|
