Re: Names Server and Tnsnames.ora co-existing

I don't have any example files, but all you need is to define properly the parameter NAMES.DIRECTORY_PATH in the clients' SQLNET.ORA files. In your case, it sounds that it should be defined to (tnsnames, onames) or (onames, tnsnames). For performance reason, put first the method that you expect will be the most used. If the same service name exists for both methods (try to avoid this), the one defined for the first method will be used. Don't forget to setup onames.ora also (use the Net Manager or NAMESCTL utility, it's much easier than doing it manually). By the way, the names server method might not be around for long, so you might want to think of migrating to an LDAP server ("Internet Directory").

HTH Daniel

debor19071_at_aol.com (Deborah Dawicki) wrote in message news:<6d1cc40f.0304181541.450b959d_at_posting.google.com>...
> We have a case where we are using tnsnames locally and don't plan to
> go to names server and we would like to connect to a configuration in
> another location of our company where they are using names server..
> How does one config for both? Can you send an example tnsnames.org and
> sqlnet.ora where both are used? to debor19071_at_aol.com?
>
> Thanks alot!
Received on Tue Apr 22 2003 - 00:28:06 CEST