Shulou(Shulou.com)06/01 Report--

First, service_name,oracle11g rac scan ip can be used as follows. If you want to use vip, write two addresses, such as the red part.

Click (here) to collapse or open

Sales=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=tcp) (HOST=sales-server) (PORT=1521))

(ADDRESS= (PROTOCOL=tcp) (HOST=sales-server) (PORT=1521))

(CONNECT_DATA=

(SERVICE_NAME=sales.us.acme.com)

Second: if you want to connect to an instance in the cluster, you can use instance_name. Note here that instance_name must appear at the same time as service_name, as shown below:

Click (here) to collapse or open

Sales=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=tcp) (HOST=rac01-vip) (PORT=1521))

(CONNECT_DATA=

(SERVICE_NAME=racdb)

(INSTANCE_NAME=racdb1)

Of course, we can also use another way to connect to an instance, sid, as follows:

Click (here) to collapse or open

Sales=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=tcp) (HOST=sales-server) (PORT=1521))

(CONNECT_DATA=

(SID=sales)

The third easy way: note here, especially in the RAC environment, if we test, please note later, what is needed is service_name, sid and instance_name are invalid

Click (here) to collapse or open

CONNECT username/password@host [: port] [/ service_name]

This method is recommended for simple TCP/IP environments.

In the tnsnames.ora file configuration, aliases (such as sales) must be fixed and must not be preceded by spaces and other things.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.