Configure the client to connect to the ASM instance

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. To connect to the ASM instance, you can also

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. To connect to the ASM instance, you can also

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. You can also connect to the ASM instance from a client. However, Oracle does not provide a tool for us to complete the configuration. We can manually configure the listener and the client tnsnames. This section describes and provides examples.

1. server and client Environments
# Server environment and host information
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

# Operating system and Oracle version
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

# Server environment and cluster information
Oracle @ bo2dbp: ~> ./Crs_stat.sh
Resource name Target State
-------------------------
Ora. GOBO4.GOBO4A. inst ONLINE on bo2dbp
Ora. GOBO4.GOBO4B. inst ONLINE on bo2dbs
Ora. GOBO4.db ONLINE on bo2dbp
Ora. bo2dbp. ASM1.asm ONLINE on bo2dbp
Ora. bo2dbp. LISTENER_BO2DBP.lsnr ONLINE on bo2dbp
Ora. bo2dbp. gsd ONLINE on bo2dbp
Ora. bo2dbp. ons ONLINE on bo2dbp
Ora. bo2dbp. vip ONLINE on bo2dbp
Ora. bo2dbs. ASM2.asm ONLINE on bo2dbs
Ora. bo2dbs. LISTENER_BO2DBS.lsnr ONLINE on bo2dbs
Ora. bo2dbs. gsd ONLINE on bo2dbs
Ora. bo2dbs. ons ONLINE on bo2dbs
Ora. bo2dbs. vip ONLINE on bo2dbs

# Client information
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. Listener status
Oracle @ bo2dbs: ~> Lsnrctl status LISTENER_BO2DBS | grep ASM
Service "+ ASM" has 1 instance (s). # You can see that the ASM instance is in the BLOCKED status.
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. Allocate the ASM SID
# Use the following ASM configuration information to modify the Listener Configuration File
Item Node1 Node2
-------------------------
Hostname bo2dbp bo2dbs
Oracle SID GOBO4A GOBO4B
Asm sid + ASM1 + ASM2
ASM Global DB Name (service name) + ASM