A user assigned as a member of OracleNetAdmins can create, modify, and delete net service
names and modify Oracle Net attributes of database servers using the Oracle Net Manager. If
you are a directory administrator, you can add users to these groups.
Clients who want to look up information in the directory must meet the following minimum
requirements:
They must be configured to use the directory server.
They must be able to access the Oracle Net entries in the Oracle Context.
They must have anonymous authentication with the directory server.
The clients can use the common names of database servers and net service entries to perform
the lookups, or additional directory location information may be required in the connection string.
Using Easy Connect Naming
As I mentioned earlier in this chapter, starting with Oracle Database 10g, you can use the easy
connect naming method to eliminate the need for service name files in a TCP/IP environment;
in fact, you may not need a tnsnames.ora file at all. Clients can connect to a database server by
specifying the full connection information in their connect strings, in this format as follows with
the SQL*Plus connect command:
connect username/password@[//]host[:port]
[/service_name][/server][/instance_name]
The connection identifier elements are as follows:
Element Description
// Optional. Specify // for a URL.
Host Required. Specify the host name or the IP address.
Port Optional.
Pages:
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804