Oct 1, 2014

Difference between sqlnet.ora & tnsnames.ora in oracle

tnsnames.ora: > This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.

sqlnet.ora:> The sqlnet.ora file is the profile configuration file. It resides on the client machines and the database server. Profiles are stored and implemented using this file. The database server can be configured with access control parameters in the sqlnet.ora file. These parameters specify whether clients are allowed or denied access based on the protocol.

No comments:

Post a Comment