服务器端完成配置后,现在客户端可以通过不同的网络服务名配置来访问这个数据库,下面是一个配置示范:
EYGLE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = eygle)
)
)
JULIA=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = julia)
)
)
通过这两个服务名,都可以顺利的访问到数据库:
[oracle@jumper admin]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Feb 16 16:54:48 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect eygle/eygle@eygle
Connected.
SQL> show parameter service_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string eygle,julia
SQL> connect eygle/eygle@julia
Connected.
SQL> show parameter service_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string eygle,Julia
通过服务名,Oracle可以将客户端和服务器彻底隔离开来,对于客户端来说,它不用关心数据库的名字、实例名到底是什么,它只需要知道数据库对外提供的服务名就行了,这个名字可能和实例名相同,也可能并不相同。