淘先锋技术网

首页 1 2 3 4 5 6 7

oracle2节点asm日志,oracle 11g的第二个节点的ASM事例在aix上起不来?

在aix上配置asm环境,发现asm只能在第一个节点(test123)上起来, 但其alert日志也同样有错,

ORA-27506: IPC error connecting to a port

ORA-27300: OS system dependent operation:sendmsg failed with status: 68

ORA-27301: OS failure message: Can't assign requested address

ORA-27302: failure occurred at: sskgxpsnd1

但事例还是能起来的. 为了排错, 没mount上任何asm磁盘.

环境

Nodes :  test123,test124

Os version: AIX6.1 (实际上aix5.3上同样有此问题)

Oracle    : 11gr1

timezone= BEIST-8

test123# crs_stat -t

ora....SM1.asm application    ONLINE    ONLINE    test123

ora....23.lsnr application    ONLINE    ONLINE    test123

ora....123.gsd application    ONLINE    ONLINE    test123

ora....123.ons application    ONLINE    ONLINE    test123

ora....123.vip application    ONLINE    ONLINE    test123

ora....SM2.asm application    ONLINE    OFFLINE

ora....24.lsnr application    ONLINE    ONLINE    test124

ora....124.gsd application    ONLINE    ONLINE    test124

ora....124.ons application    ONLINE    ONLINE    test124

ora....124.vip application    ONLINE    ONLINE    test124

test124 上的asm alert日志:

Interface type 1 en6 192.168.2.0 configured from OCR for use as a cluster interconnect

WARNING 192.168.2.0 could not be translated to a network address error 1

Interface type 1 en7 192.168.3.0 configured from OCR for use as a cluster interconnect

Interface type 1 en4 10.182.0.0 configured from OCR for use as  a public interface

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/11g/dbs/arch

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 11.1.0.6.0.

Using parameter settings in server-side pfile /opt/oracle/11g/dbs/init+ASM2.ora

System parameters with non-default values:

large_pool_size          = 12M

instance_type            = "asm"

cluster_database         = TRUE

instance_number          = 2

asm_diskgroups           = ""

diagnostic_dest          = "/opt/oracle"

Cluster communication is configured to use the following interface(s) for this instance

192.168.3.124

cluster interconnect IPC version:Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

Oracle instance running with ODM: Veritas 6.0 ODM Library, Version 1.1

Tue Mar 10 12:48:49 2009

PMON started with pid=2, OS id=954400

Tue Mar 10 12:48:49 2009

VKTM started with pid=3, OS id=860250 at elevated priority

VKTM running at (20)ms precision

Tue Mar 10 12:48:49 2009

DIAG started with pid=4, OS id=921706

Tue Mar 10 12:48:49 2009

PING started with pid=5, OS id=839702

Tue Mar 10 12:48:49 2009

PSP0 started with pid=6, OS id=831568

Tue Mar 10 12:48:49 2009

DSKM started with pid=7, OS id=770214

Tue Mar 10 12:48:49 2009

DIA0 started with pid=8, OS id=557134

Tue Mar 10 12:48:49 2009

LMON started with pid=7, OS id=512238

Tue Mar 10 12:48:49 2009

LMD0 started with pid=9, OS id=897058

Tue Mar 10 12:48:49 2009

LMS0 started with pid=10, OS id=491712 at elevated priority

Tue Mar 10 12:48:49 2009

MMAN started with pid=11, OS id=450798

Tue Mar 10 12:48:49 2009

DBW0 started with pid=12, OS id=389146

Tue Mar 10 12:48:49 2009

LGWR started with pid=13, OS id=335906

Tue Mar 10 12:48:49 2009

CKPT started with pid=14, OS id=843790

Tue Mar 10 12:48:49 2009

SMON started with pid=15, OS id=323642

Tue Mar 10 12:48:50 2009

RBAL started with pid=16, OS id=479306

Tue Mar 10 12:48:50 2009

GMON started with pid=17, OS id=339974

lmon registered with NM - instance id 2 (internal mem no 1)

Tue Mar 10 12:57:10 2009

Error: KGXGN polling error (15)

Errors in file /opt/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_lmon_512238.trc:

ORA-29702: error occurred in Cluster Group Service operation

LMON (ospid: 512238): terminating the instance due to error 29702

Tue Mar 10 12:57:11 2009

ORA-1092 : opitsk aborting process

Tue Mar 10 12:57:11 2009

System state dump is made for local instance

Errors in file /opt/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_diag_921706.trc:

ORA-29702: error occurred in Cluster Group Service operation

Trace dumping is performing id=[cdmp_20090310125710]

Instance terminated by LMON, pid = 512238

root@test124 # cat /opt/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_diag_921706.trc

Trace file /opt/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_diag_921706.trc

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

ORACLE_HOME = /opt/oracle/11g

System name:    AIX

Node name:      test124

Release:        1

Version:        6

Machine:        000DD3D0D600

Instance name: +ASM2

Redo thread mounted by this instance: 0

Oracle process number: 4

Unix process pid: 921706, image: oracle@test124 (DIAG)

*** 2009-03-10 12:48:49.688

*** SESSION ID

c58e339c7046a1ffce9c5508745874fa.gif112.1) 2009-03-10 12:48:49.688

*** CLIENT ID

c58e339c7046a1ffce9c5508745874fa.gif) 2009-03-10 12:48:49.688

*** SERVICE NAME

c58e339c7046a1ffce9c5508745874fa.gif) 2009-03-10 12:48:49.688

*** MODULE NAME

c58e339c7046a1ffce9c5508745874fa.gif) 2009-03-10 12:48:49.688

*** ACTION NAME

c58e339c7046a1ffce9c5508745874fa.gif) 2009-03-10 12:48:49.688

Node id: 1

List of nodes: 0, 1,

*** 2009-03-10 12:48:49.690

Reconfiguration starts [incarn=0]

*** 2009-03-10 12:48:49.690

I'm the voting node

Group reconfiguration cleanup

*** 2009-03-10 12:57:10.691

Performing diagnostic data dump for this instance

*** 2009-03-10 12:57:11.962

Error 29702 encountered during system state dump

*** 2009-03-10 12:57:11.962

----- Error Stack Dump -----

ORA-29702: error occurred in Cluster Group Service operation

*** 2009-03-10 12:57:11.962

Trace dumping is performing id=[cdmp_20090310125710]....

*** 2009-03-10 12:57:12.276

Trace dumping is done

[本帖最后由 wangyl1977_cu 于 2009-3-10 16:45 编辑]