Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 10gr2 rac 建库时候连接asm报错

3 积分	0 好友	0 主题

发消息

10gr2 rac 建库时候连接asm报错

1^#

发表于 2012-2-16 19:54:22 | 查看: 8817| 回复: 11

连接不到asm，报连接本地节点上的asm实例出错。io异常。the network adapter could not establish the connection。
操作系统windows2008 r2，建立数据库的时候不能选择asm存储的时候不能连接。
asm实例正常。

[ 本帖最后由 archer_lf 于 2012-2-16 20:00 编辑 ]

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-2-16 19:55:39

问题描述不清，请阅读提问的智慧

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2012-2-16 20:04:01

”10gr2 rac 建库时候连接asm报错“
连接不到asm，报连接本地节点上的asm实例出错。io异常。the network adapter could not establish the connection。
操作系统windows2008 r2，建立数据库的时候不能选择asm存储的时候不能连接。
asm实例正常。

就这个问题来看至少缺几点描述

1. 10gR2 具体是什么版本？10.2.0.1?10.2.0.4?
2. 建库时候连接asm报错，建库有多种方式手工的还是DBCA?
3. 既然是ASM 链接报错，那么你的ASM配置如何请列出来

回复只看该作者道具举报

archer_lf

4^#

发表于 2012-2-16 20:08:18

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Miscellaneous
###########################################
instance_type=asm

###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive

###########################################
# Pools
###########################################
large_pool_size=12M

###########################################
# Cluster Database
###########################################
cluster_database=true

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\product\10.2.0\admin\+ASM\bdump
core_dump_dest=D:\oracle\product\10.2.0\admin\+ASM\cdump
user_dump_dest=D:\oracle\product\10.2.0\admin\+ASM\udump

asm_diskgroups='DATA','FLASH'
+ASM1.instance_number=1
+ASM2.instance_number=2

10.2.0.4，使用dbca建库

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2012-2-16 20:16:29

action plan:

贴出以下配置文件的内容

$ORACLE_HOME/network/admin/sqlnet.ora
$ORACLE_HOME/network/admin/tnsnames.ora
$ORACLE_HOME/network/admin/listener.ora

lsnrctl status {listener_name}
lsnrvtl services {listener_name}

回复只看该作者道具举报

archer_lf

6^#

发表于 2012-2-16 20:19:28

SQLNET.AUTHENTICATION_SERVICES = (NTS)

LISTENER_OA-ORACLE1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = oa-oracle1-vip)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = oa-oracle1)(PORT = 1521)(IP = FIRST))
)
  )
SID_LIST_LISTENER_OA-ORACLE1 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\product\10.2.0\asm)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = +ASM)
   (SID_NAME = +ASM)
   (ORACLE_HOME = D:\oracle\product\10.2.0\asm)
)
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
   (SID = PLSExtProc)
   (PRESENTATION = RO)
)
  )
ASM =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = oa-oracle1)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NANE = +ASM)
   (UR=A)
)
)

回复只看该作者道具举报

archer_lf

7^#

发表于 2012-2-16 20:20:34

回复 5# 的帖子

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 16-FEB-2012 20:
:48

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_OA-ORACLE1
Version                TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Pro
ction
Start Date             16-FEB-2012 20:18:21
Uptime                   0 days 0 hr. 1 min. 27 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File D:\oracle\product\10.2.0\asm\network\admin\listener.
a
Listener Log File       D:\oracle\product\10.2.0\asm\network\log\listener_oa
racle1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.18.8.14)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.12)(PORT=1521)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm1", 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...
The command completed successfully

回复只看该作者道具举报

Maclean Liu(刘相兵

8^#

发表于 2012-2-16 20:25:42

RAC环境请在所有的节点上都收集一下一上信息

回复只看该作者道具举报

Maclean Liu(刘相兵

9^#

发表于 2012-2-16 20:40:23

ODM Data:

ASM Access From DBCA or OEM Fails With "IO Exception: The Network Adapter Could Not Establish a Connection" [ID 604155.1]
Applies to:
Oracle Net Services - Version: 10.2.0.1.0 to 10.2.0.4.0
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.
Symptoms
Normal RAC configuration with ASM enabled.
Sometimes, when changes
are made to the listener.ora file (manually or with a Nettool), then
neither OEM nor DBCA are able to connect to the ASM instances.
Also, just installing RAC and configuring ASM this can occur.
The error thrown by DBCA is:
"Error when connecting to ASM instance on local node:
IO exception: The Network Adapter could not establish a connection."
.
Changes
Changes made to the listener.ora file, such as the inclusion of control parameters such as:
ADMIN_RESTRICTIONS_<listener_name> = ON
LOGGING_<listener_name> = ON
Cause
1. One cause is if the listener(s) is stopped or not listening on the
correct TCP hostname. If this is the situation, then the DBCA or OEM
tools will not locate the +ASM instance(s).
2. Another common
cause is if the listener is only configured for TCP address
communication and has no IPC address. Then there may be a problem with
an "internal" tool such as lsnrctl and DBCA communicating with the +ASM
instance(s).
Under certain conditions, these tools may require the
IPC Protocol to be set in the listener for correct communication to the
+ASM instances. Reason is, there seem to be some unknown factors and
conditions that combine with TCP use which can cause mis-communication
with some tools to find the ASM instances.
Solution
Check to make certain that:
a) the listeners related to the RAC cluster are all up and running;
b)
the listeners are listening on correct and valid VIP hostnames (make
certain that the local HOSTS file does not specify that the VIP hostname
is linked in any way to the localhost IP address of 127.0.0.1);
c)
when 'lsnrctl services' is issued on each listener, that they show the
+ASM instances in the services summary (the status of "Blocked" is
normal);
d) at least one IPC address entry is included in the
listener.ora file for all RAC listeners that may be used to access the
ASM instances. The IPC key can be anything at all as it will only be
used by DBCA access for ASM. If External Procedures will be run on the
nodes, then this will be required anyway.

复制代码

回复只看该作者道具举报

Maclean Liu(刘相兵

10^#

发表于 2012-2-16 20:43:07

d) at least one IPC address entry is included in the
listener.ora file for all RAC listeners that may be used to access the
ASM instances. The IPC key can be anything at all as it will only be
used by DBCA access for ASM. If External Procedures will be run on the
nodes, then this will be required anyway.

即 DBCA需要ipc key 以便访问 ASM

而lz的环境中

listener.ora

LISTENER_OA-ORACLE1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = oa-oracle1-vip)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = oa-oracle1)(PORT = 1521)(IP = FIRST))
)
  )
SID_LIST_LISTENER_OA-ORACLE1 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\product\10.2.0\asm)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = +ASM)
   (SID_NAME = +ASM)
   (ORACLE_HOME = D:\oracle\product\10.2.0\asm)
)
  )

lsnrctl status

LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 16-FEB-2012 20:
:48

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_OA-ORACLE1
Version                TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Pro
ction
Start Date             16-FEB-2012 20:18:21
Uptime                   0 days 0 hr. 1 min. 27 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File D:\oracle\product\10.2.0\asm\network\admin\listener.
a
Listener Log File       D:\oracle\product\10.2.0\asm\network\log\listener_oa
racle1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.18.8.14)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.12)(PORT=1521)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm1", 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...
The command completed successfully

均不存在ipc 的 DESCRIPTION

正确的 lsnrctl 输出

[grid@vrh2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-FEB-2012 23:37:45

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             16-FEB-2012 21:20:41
Uptime                   0 days 2 hr. 17 min. 4 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /g01/11.2.0/grid/network/admin/listener.ora
Listener Log File       /g01/orabase/diag/tnslsnr/vrh2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.163)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.164)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "VPROD" has 1 instance(s).
  Instance "VPROD2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

[grid@vrh2 admin]$ lsnrctl service

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-FEB-2012 23:40:59

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
   "DEDICATED" established:0 refused:0 state:ready
      LOCAL SERVER
Service "VPROD" has 1 instance(s).
  Instance "VPROD2", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
   "DEDICATED" established:0 refused:0 state:ready
      LOCAL SERVER
The command completed successfully

回复只看该作者道具举报

Maclean Liu(刘相兵

11^#

发表于 2012-2-16 20:47:02

补充原始问题的截图

回复只看该作者道具举报

qiangshaofan

12^#

发表于 2012-2-16 20:51:37

版主很给力啊

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册