对于oracle 网络配置，我们通常通过negmgr或者netca来完成客户端连接到数据库实例。而对于连接到asm实例，同样可以实现从客户端来
对于oracle 网络配置，我们通常通过negmgr或者netca来完成客户端连接到数据库实例。而对于连接到asm实例，同样可以实现从客户端来进行连接。不过oracle并未为我们提供工具来完成配置，，我们可以通过手动配置监听以及客户端tnsnames来实现。本文对此给出描述与示例。
1、服务器端、客户端的环境
#服务器端环境，host信息
oracle@bo2dbp:~> cat /etc/hosts |grep vip
192.168.7.61 bo2dbp-vip.2gotrade.com bo2dbp-vip
192.168.7.62 bo2dbs-vip.2gotrade.com bo2dbs-vip
#操作系统及oracle版本
oracle@bo2dbp:~> cat /etc/issue
welcome to suse linux enterprise server 10 sp3 (x86_64) - kernel \r (\l).
oracle@bo2dbp:~> sqlplus -v
sql*plus: release 10.2.0.3.0 - production
#服务器端环境，集群信息
oracle@bo2dbp:~> ./crs_stat.sh
resource name target state
-------------- ------ -----
ora.gobo4.gobo4a.inst online online on bo2dbp
ora.gobo4.gobo4b.inst online online on bo2dbs
ora.gobo4.db online online on bo2dbp
ora.bo2dbp.asm1.asm online online on bo2dbp
ora.bo2dbp.listener_bo2dbp.lsnr online online on bo2dbp
ora.bo2dbp.gsd online online on bo2dbp
ora.bo2dbp.ons online online on bo2dbp
ora.bo2dbp.vip online online on bo2dbp
ora.bo2dbs.asm2.asm online online on bo2dbs
ora.bo2dbs.listener_bo2dbs.lsnr online online on bo2dbs
ora.bo2dbs.gsd online online on bo2dbs
ora.bo2dbs.ons online online on bo2dbs
ora.bo2dbs.vip online online on bo2dbs
#客户端信息
c:\users\robinson.cheng>systeminfo
host name: pc39
os name: microsoft windows 7 professional
os version: 6.1.7600 n/a build 7600
os manufacturer: microsoft corporation
system type: x64-based pc
c:\users\robinson.cheng>sqlplus -v
sql*plus: release 10.2.0.3.0 - production
2、监听器的状态
oracle@bo2dbs:~> lsnrctl status listener_bo2dbs | grep asm
service +asm has 1 instance(s). #可以看到asm实例处于blocked状态
instance +asm2, status blocked, has 1 handler(s) for this service...
service +asm_xpt has 1 instance(s).
instance +asm2, status blocked, has 1 handler(s) for this service...
3、分配asm sid
#使用下面的asm配置信息来修改监听器配置文件
item node1 node2
------ -------- -----------
hostname bo2dbp bo2dbs
oracle sid gobo4a gobo4b
asm sid +asm1 +asm2
asm global db name (service name) +asm +asm