What is the easy connect naming method?
August 21st, 2006 By Eddie Awad
Starting with Oracle 10gR1, you can use the easy connect naming method to connect to an Oracle database.
Advantages:
- Eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments.
- No naming or directory system is required.
- Provides out-of-the-box TCP/IP connectivity to databases.
- Easy connect naming is automatically configured at client installation.
You can connect to a database server using easy connect naming if the following conditions are met:
- Oracle Database 10g Net Services software installed on the client.
- Oracle TCP/IP protocol support on both the client and database server.
- No features requiring a more advanced connect descriptor are required.
How to use:
CONNECT username/password@[//]host[:port][/service_name]
- The host specifies the host name or IP address of the database server computer.
- The port is optional and specifies the listening port. The default is 1521.
Examples:
- CONNECT hr/hr@localhost/xe
- CONNECT scott/tiger@10.10.1.101/ORCL