lms oracle 启动失败,11gr2 的一个节点crs无法启动 asm也起不来

仆儿

于 2021-04-11 05:05:04 发布

阅读量599

点赞数

文章标签： lms oracle 启动失败

Fri Dec 20 09:56:09 2013

NOTE: No asm libraries found in the system

MEMORY_TARGET defaulting to 411041792.

* instance_number obtained from CSS = 2, checking for the existence of node 0...

* node 0 does not exist. instance_number = 2

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Private Interface 'en3' configured from GPnP for use as a private interconnect.

[name='en3', type=1, ip=169.254.121.18, mac=6c-ae-8b-68-49-b3, net=169.254.0.0/16, mask=255.255.0.0, us

e=haip:cluster_interconnect/62]

Public Interface 'en7' configured from GPnP for use as a public interface.

[name='en7', type=1, ip=10.1.84.211, mac=34-40-b5-f5-8e-76, net=10.1.84.0/24, mask=255.255.255.0, use=p

ublic/1]

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/11203/grid/home/dbs/arch

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

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

With the Real Application Clusters and Automatic Storage Management options.

ORACLE_HOME = /oracle/11203/grid/home

System name: AIX

Node name: db2

Release: 1

Version: 6

Machine: 00F8C4F74C00

Using parameter settings in server-side spfile +CRS/db/asmparameterfile/registry.253.834366009

System parameters with non-default values:

large_pool_size = 12M

instance_type = "asm"

remote_login_passwordfile= "EXCLUSIVE"

alert_+ASM2.log (94%) asm_diskgroups = "DATA"

asm_diskgroups = "ARCH"

asm_power_limit = 1

diagnostic_dest = "/oracle/11203/grid/base"

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

169.254.121.18

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

IPC Vendor 1 proto 2

Fri Dec 20 09:56:10 2013

PMON started with pid=2, OS id=3276824

Fri Dec 20 09:56:10 2013

PSP0 started with pid=3, OS id=6291922

Fri Dec 20 09:56:11 2013

VKTM started with pid=4, OS id=4915710 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Fri Dec 20 09:56:11 2013

GEN0 started with pid=5, OS id=6815990

Fri Dec 20 09:56:11 2013

DIAG started with pid=6, OS id=6881334

Fri Dec 20 09:56:11 2013

PING started with pid=7, OS id=2883974

Fri Dec 20 09:56:11 2013

DIA0 started with pid=8, OS id=6750360

Fri Dec 20 09:56:11 2013

LMON started with pid=9, OS id=6947016

Fri Dec 20 09:56:11 2013

LMD0 started with pid=10, OS id=3146022

* System load used for high load check

* New Low - High Load Threshold Range = [221184 - 294912]

Fri Dec 20 09:56:12 2013

LMS0 started with pid=11, OS id=6160764 at elevated priority

Fri Dec 20 09:56:12 2013

LMHB started with pid=12, OS id=5112092

Fri Dec 20 09:56:12 2013

MMAN started with pid=13, OS id=6029684

Fri Dec 20 09:56:12 2013

DBW0 started with pid=14, OS id=3997944

Fri Dec 20 09:56:12 2013

LGWR started with pid=15, OS id=4522434

Fri Dec 20 09:56:12 2013

CKPT started with pid=16, OS id=4850000

Fri Dec 20 09:56:12 2013

SMON started with pid=17, OS id=4063570

alert_+ASM2.log (95%)Fri Dec 20 09:56:12 2013

RBAL started with pid=18, OS id=4915298

Fri Dec 20 09:56:12 2013

GMON started with pid=19, OS id=6684896

Fri Dec 20 09:56:12 2013

MMON started with pid=20, OS id=5767406

Fri Dec 20 09:56:12 2013

MMNL started with pid=21, OS id=5964040

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

Fri Dec 20 09:59:01 2013

PMON (ospid: 3276824): terminating the instance due to error 481

Fri Dec 20 10:00:04 2013

Instance terminated by PMON, pid = 3276824

Fri Dec 20 10:03:32 2013

NOTE: No asm libraries found in the system

MEMORY_TARGET defaulting to 411041792.

* instance_number obtained from CSS = 2, checking for the existence of node 0...

* node 0 does not exist. instance_number = 2

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Fri Dec 20 10:04:42 2013

Private Interface 'en3' configured from GPnP for use as a private interconnect.

[name='en3', type=1, ip=169.254.121.18, mac=6c-ae-8b-68-49-b3, net=169.254.0.0/16, mask=255.255.0.0, us

e=haip:cluster_interconnect/62]

Public Interface 'en7' configured from GPnP for use as a public interface.

[name='en7', type=1, ip=10.1.84.211, mac=34-40-b5-f5-8e-76, net=10.1.84.0/24, mask=255.255.255.0, use=p

ublic/1]

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/11203/grid/home/dbs/arch

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

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

With the Real Application Clusters and Automatic Storage Management options.

ORACLE_HOME = /oracle/11203/grid/home

System name: AIX

Node name: db2

Release: 1

Version: 6

Machine: 00F8C4F74C00

Using parameter settings in server-side spfile +CRS/db/asmparameterfile/registry.253.834366009

alert_+ASM2.log (96%)System parameters with non-default values:

large_pool_size = 12M

instance_type = "asm"

remote_login_passwordfile= "EXCLUSIVE"

asm_diskgroups = "DATA"

asm_diskgroups = "ARCH"

asm_power_limit = 1

diagnostic_dest = "/oracle/11203/grid/base"

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

169.254.121.18

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

IPC Vendor 1 proto 2

Fri Dec 20 10:04:42 2013

PMON started with pid=2, OS id=3276808

Fri Dec 20 10:04:42 2013

PSP0 started with pid=3, OS id=6815896

Fri Dec 20 10:04:43 2013

VKTM started with pid=4, OS id=7471336 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Fri Dec 20 10:04:43 2013

GEN0 started with pid=5, OS id=7078074

Fri Dec 20 10:04:43 2013

DIAG started with pid=6, OS id=7864444

Fri Dec 20 10:04:43 2013

PING started with pid=7, OS id=7012488

Fri Dec 20 10:04:43 2013

DIA0 started with pid=8, OS id=7536672

Fri Dec 20 10:04:44 2013

LMON started with pid=9, OS id=3146168

Fri Dec 20 10:04:44 2013

LMD0 started with pid=10, OS id=6029782

* System load used for high load check

* New Low - High Load Threshold Range = [221184 - 294912]

Fri Dec 20 10:04:44 2013

LMS0 started with pid=11, OS id=4194812 at elevated priority

Fri Dec 20 10:04:44 2013

LMHB started with pid=12, OS id=4915218

Fri Dec 20 10:04:44 2013

MMAN started with pid=13, OS id=2883846

Fri Dec 20 10:04:44 2013

DBW0 started with pid=14, OS id=4915670

Fri Dec 20 10:04:44 2013

LGWR started with pid=15, OS id=3997700

alert_+ASM2.log (97%)Fri Dec 20 10:04:44 2013

CKPT started with pid=16, OS id=7798796

Fri Dec 20 10:04:44 2013

SMON started with pid=17, OS id=6750554

Fri Dec 20 10:04:44 2013

RBAL started with pid=18, OS id=7209012

Fri Dec 20 10:04:44 2013

GMON started with pid=19, OS id=5964206

Fri Dec 20 10:04:44 2013

MMON started with pid=20, OS id=5112084

Fri Dec 20 10:04:44 2013

MMNL started with pid=21, OS id=6946938

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

Fri Dec 20 10:06:44 2013

PMON (ospid: 3276808): terminating the instance due to error 481

Fri Dec 20 10:06:44 2013

System state dump requested by (instance=2, osid=3276808 (PMON)), summary=[abnormal instance termination]

System State dumped to trace file /oracle/11203/grid/base/diag/asm/+asm/+ASM2/trace/+ASM2_diag_7864444.tr

Fri Dec 20 10:06:44 2013

ORA-1092 : opitsk aborting process

Dumping diagnostic data in directory=[cdmp_20131220100644], requested by (instance=2, osid=3276808 (PMON)

), summary=[abnormal instance termination].

Fri Dec 20 10:06:44 2013

ORA-1092 : opitsk aborting process

Instance terminated by PMON, pid = 3276808

Fri Dec 20 10:06:46 2013

License high water mark = 1

USER (ospid: 7143852): terminating the instance

Instance terminated by USER, pid = 7143852

Fri Dec 20 10:06:51 2013

NOTE: No asm libraries found in the system

MEMORY_TARGET defaulting to 411041792.

* instance_number obtained from CSS = 2, checking for the existence of node 0...

* node 0 does not exist. instance_number = 2

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Private Interface 'en3' configured from GPnP for use as a private interconnect.

[name='en3', type=1, ip=169.254.121.18, mac=6c-ae-8b-68-49-b3, net=169.254.0.0/16, mask=255.255.0.0, us

e=haip:cluster_interconnect/62]

Public Interface 'en7' configured from GPnP for use as a public interface.

alert_+ASM2.log (98%) [name='en7', type=1, ip=10.1.84.211, mac=34-40-b5-f5-8e-76, net=10.1.84.0/24, mask=255.255.255.0, use=p

ublic/1]

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/11203/grid/home/dbs/arch

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

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

With the Real Application Clusters and Automatic Storage Management options.

ORACLE_HOME = /oracle/11203/grid/home

System name: AIX

Node name: db2

Release: 1

Version: 6

Machine: 00F8C4F74C00

Using parameter settings in server-side spfile +CRS/db/asmparameterfile/registry.253.834366009

System parameters with non-default values:

large_pool_size = 12M

instance_type = "asm"

remote_login_passwordfile= "EXCLUSIVE"

asm_diskgroups = "DATA"

asm_diskgroups = "ARCH"

asm_power_limit = 1

diagnostic_dest = "/oracle/11203/grid/base"

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

169.254.121.18

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

IPC Vendor 1 proto 2

Fri Dec 20 10:06:52 2013

PMON started with pid=2, OS id=7471120

Fri Dec 20 10:06:52 2013

PSP0 started with pid=3, OS id=5964252

Fri Dec 20 10:07:51 2013

VKTM started with pid=4, OS id=7798910 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Fri Dec 20 10:07:51 2013

GEN0 started with pid=5, OS id=6750266

Fri Dec 20 10:07:51 2013

DIAG started with pid=6, OS id=3997790

Fri Dec 20 10:07:51 2013

PING started with pid=7, OS id=4915676

Fri Dec 20 10:07:51 2013

alert_+ASM2.log (99%)DIA0 started with pid=8, OS id=3276806

Fri Dec 20 10:07:51 2013

LMON started with pid=9, OS id=8323084

Fri Dec 20 10:07:51 2013

LMD0 started with pid=10, OS id=7405940

* System load used for high load check

* New Low - High Load Threshold Range = [221184 - 294912]

Fri Dec 20 10:07:51 2013

LMS0 started with pid=11, OS id=7864378 at elevated priority

Fri Dec 20 10:07:51 2013

LMHB started with pid=12, OS id=7667934

Fri Dec 20 10:07:51 2013

MMAN started with pid=13, OS id=7340182

Fri Dec 20 10:07:51 2013

DBW0 started with pid=14, OS id=6947000

Fri Dec 20 10:07:51 2013

LGWR started with pid=15, OS id=6815932

Fri Dec 20 10:07:51 2013

CKPT started with pid=16, OS id=4915238

Fri Dec 20 10:07:51 2013

SMON started with pid=17, OS id=8257788

Fri Dec 20 10:07:51 2013

RBAL started with pid=18, OS id=3146078

Fri Dec 20 10:07:51 2013

GMON started with pid=19, OS id=6684870

Fri Dec 20 10:07:51 2013

MMON started with pid=20, OS id=6029722

Fri Dec 20 10:07:51 2013

MMNL started with pid=21, OS id=6160808

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

Fri Dec 20 10:09:51 2013

PMON (ospid: 7471120): terminating the instance due to error 481

Fri Dec 20 10:09:51 2013

System state dump requested by (instance=2, osid=7471120 (PMON)), summary=[abnormal instance termination]

System State dumped to trace file /oracle/11203/grid/base/diag/asm/+asm/+ASM2/trace/+ASM2_diag_3997790.tr

Fri Dec 20 10:09:51 2013

ORA-1092 : opitsk aborting process

Dumping diagnostic data in directory=[cdmp_20131220100951], requested by (instance=2, osid=7471120 (PMON)

), summary=[abnormal instance termination].

Fri Dec 20 10:11:17 2013

Instance terminated by PMON, pid = 7471120

alert_+ASM2.log: END[root@db2:/oracle/11203/grid/base/diag/asm/+asm/+ASM2/trace]#

仆儿

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
lms oracle 启动失败,11gr2 的一个节点crs无法启动 asm也起不来

Fri Dec 20 09:56:09 2013NOTE: No asm libraries found in the systemMEMORY_TARGET defaulting to 411041792.* instance_number obtained from CSS = 2, checking for the existence of node 0...* node 0 does no...
复制链接

扫一扫