Specify the port or use the default (1521).
service_name Optional. Specify the service name. The default value is the host name of
the database server.
server Optional. Also known as connect_type in OCI, specifies the type of
service handler: dedicated, shared, or pooled.
instance_name Optional. Corresponds to the INSTANCE_NAME initialization parameter.
?–
?–
?–
538 Oracle Database 11g DBA Handbook
For example, you can connect to the LOC service with this syntax:
connect username/password@hq:1521/loc
In order to use easy connect naming, you must have Oracle Net Services 10g (or later) software
installed on your client. You must be using the TCP/IP protocol, and no features requiring a more
advanced connect descriptor are supported.
CAUTION
Oracle Database 11g clients and database no longer support the use
of Oracle Names; however, earlier versions of the client can still
use Oracle Names to resolve naming for an Oracle Database 10g
database.
For URL or JDBC connections, prefix the connect identifier with a double slash (//):
connect username/password@[//][host][:port][/service_name]
Easy connect naming is automatically configured at installation. In your sqlnet.ora file, make
sure EZCONNECT is added to the list of values in the NAME.DIRECTORY_PATH parameter
listing; the default contents of sqlnet.ora for client installations of Oracle Database 11g and later
have these two lines:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.
Pages:
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805