The host is sales-server, the port is 80, and the service name is sales.Įasy Connect string with host, service name, and server. Square brackets are required around IPv6 host names.Įasy Connect string with IPv6 host address. The IPv6 address of the host is 2001:0db8:0:0::200C:417A, the port is 80, and the service name is sales. The host name is sales-server and the service name is sales. The host name is sales-server, and the port is 3456.Įasy Connect string with host and service name. Table 8-2 Examples of Easy Connect Naming Naming Option The instance name can be obtained from the INSTANCE_NAME parameter in the initialization parameter file. Identify the database instance to access. Note: In Oracle Call Interface documentation, server is referred to as connect_type. If server is not specified in the Easy Connect syntax, then the type of server is chosen by the listener (shared server if configured, otherwise a dedicated server is used). The values for the server parameter are dedicated, shared, and pooled. This parameter instructs the listener to connect the client to a specific type of service handler. If DEFAULT_SERVICE_ listener_name is not configured for the listener and a service name is not explicitly specified by the user as part of the Easy Connect syntax, then the listener returns an error. Otherwise, the listener connects to the database specified by the DEFAULT_SERVICE_ listener_name parameter in the listener.ora file. If a user specifies a service name, then the listener connects the user to that specific database. Specify the service name of the database. IPv6 addresses or host names that resolve to IPv6 addresses must be enclosed in square brackets, as in and. You may use an IPv4 or IPv6 address as a value. The host name is domain-qualified if the local operating system configuration specifies a domain. SQL> CONNECT CONNECT Specify the host name or IP address of the database host computer. For example, the following connect strings are semantically equivalent: The connect identifier can preceded by a double-slash ( //). The connect identifier must be preceded by a double-slash ( //). Use // to specify a URL or JDBC connection. Table 8-1 Connect Identifier for Easy Connection Naming Method Syntax Element Table 8-1 lists the Easy Connect syntax elements and descriptions for each. If the Oracle Database server installation was performed in Typical mode, then the default service name used by the Oracle instance is the database name, and the following Easy Connect syntax can be used to connect to that instance: (ADDRESS=(PROTOCOL=tcp)(HOST= host)(PORT= port))
The connect identifier converts to the following connect descriptor: It extends the functionality of the host naming method by enabling clients to connect to a database server with an optional port and service name in addition to the host name of the database:ĬONNECT host This naming method provides out-of-the-box TCP/IP connectivity to databases.
In fact, no naming or directory system is required when using this method. The Easy Connect naming method eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments. Understanding the Easy Connect Naming Method
0 kommentar(er)
