gtlions

207 积分	1 好友	4 主题

发消息

双节点中环境客户端只能连接上其中一个

1^#

发表于 2011-10-31 17:28:37 | 查看: 8352| 回复: 8

双节点中环境，在win客户端，配置的连接串只能连接上其中一个
配置如下：
[root@fzwxdb1 ~]# cat /etc/issue
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Kernel \r on an \m

[root@fzwxdb1 ~]# su - oracle
[oracle@fzwxdb1 ~]$ crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora....Y1.inst application ONLINE ONLINE fzwxdb2
ora....Y2.inst application ONLINE ONLINE fzwxdb1
ora.WICITY.db  application ONLINE ONLINE fzwxdb1
ora....SM2.asm application ONLINE ONLINE fzwxdb1
ora....B1.lsnr application ONLINE ONLINE fzwxdb1
ora....db1.gsd application ONLINE ONLINE fzwxdb1
ora....db1.ons application ONLINE ONLINE fzwxdb1
ora....db1.vip application ONLINE ONLINE fzwxdb1
ora....SM1.asm application ONLINE ONLINE fzwxdb2
ora....B2.lsnr application ONLINE ONLINE fzwxdb2
ora....db2.gsd application ONLINE ONLINE fzwxdb2
ora....db2.ons application ONLINE ONLINE fzwxdb2
ora....db2.vip application ONLINE ONLINE fzwxdb2
[oracle@fzwxdb1 ~]$ lsnctl status
-bash: lsnctl: command not found
[oracle@fzwxdb1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 31-OCT-2011 17:26:20

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_FZWXDB1
Version                TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date             01-AUG-2011 21:41:03
Uptime                   90 days 19 hr. 45 min. 16 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /ora/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File       /ora/app/oracle/product/10.2.0/db_1/network/log/listener_fzwxdb1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.46.50.196)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.46.50.195)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  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...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WICITY" has 2 instance(s).
  Instance "WICITY1", status READY, has 1 handler(s) for this service...
  Instance "WICITY2", status READY, has 2 handler(s) for this service...
Service "WICITYXDB" has 2 instance(s).
  Instance "WICITY1", status READY, has 1 handler(s) for this service...
  Instance "WICITY2", status READY, has 1 handler(s) for this service...
Service "WICITY_XPT" has 2 instance(s).
  Instance "WICITY1", status READY, has 1 handler(s) for this service...
  Instance "WICITY2", status READY, has 2 handler(s) for this service...
The command completed successfully
[oracle@fzwxdb1 ~]$

客户端配置：
TNSNAME.ORA:
t1 =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.46.50.196)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = wicity)
)
  )

t2 =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.46.50.198)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = wicity)
)
  )

SQLNET.ORA:

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
# NTS

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

连接测试：
C:\Users\Administrator>sqlplus wicity@t1

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 10月 31 17:23:57 2011

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist

Enter user-name: ^C
C:\Users\Administrator>sqlplus wicity@t2

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 10月 31 17:24:12 2011

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL>

分享0