[20180208]ezconnect语法.txt
--昨天看书Oracle Database11g DBA Handbook.pdf,Using Easy Connect Naming P561.发现如下内容:
connect username/password@[//]host[:port][/service_name][/server][/instance_name]
Element Description
// Optional. Specify // for a URL.
Host Required. Specify the host name or the IP address.
Port Optional. 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.
For URL or JDBC connections, prefix the connect identifier with a double slash (//):
connect username/password@[//][host][:port][/service_name]
--//如果通过ezconnect连接数据库特定实例,可以这样:
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis:dedicated/fyhis1
SYSTEM@192.168.aa.bb:1521/fyhis:dedicated/fyhis1> select INSTANCE_NUMBER,INSTANCE_NAME from v$instance ;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
1 fyhis1
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis:dedicated/fyhis2
SYSTEM@192.168.aa.bb:1521/fyhis:dedicated/fyhis2> select INSTANCE_NUMBER,INSTANCE_NAME from v$instance ;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
2 fyhis2
--//这样可以连接不同实例.这样写也可以:
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis:/fyhis1
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis:/fyhis2
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis/fyhis1
sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis/fyhis2
--//注文档有误,应该是这样,server前使用:.
connect username/password@[//]host[:port][/service_name][:server][/instance_name]
R:\>sqlplus system/xxxxxxxxxxxx@192.168.aa.bb:1521/fyhis/dedicated/fyhis2
SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 8 08:59:26 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor
