Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle 12c cluster startup failure what to do

2025-01-15 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

Oracle 12c cluster startup failure how to do, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

The cluster cannot be started (CRS-4535,CRS-4000) because the maintainer modifies the size of / dev/shm in OracleLinux 7 so that it is smaller than the MEMORY_TARGET or SGA_TARGET of the Oracle instance.

[grid@jtp1] $crsctl stat res-t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

Check if there is a problem with the permissions of the asm disk

[root@jtp3 ~] # ls-lrt / dev/asm*

Restart crs

[root@jtp1 bin] #. / crsctl stop crs-f

[root@jtp1 bin] #. / crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

Check the alert.log of crs and find that the disk group cannot be loaded.

[root@jtp1] # tail-f / u01/app/grid/diag/crs/jtp1/crs/trace/alert.log

Locations are on ASM disk groups [CRS], and none of these disk groups are mounted

Continue to view ohasd_orarootagent_root.trc

[root@jtp1 ~] # more / u01/app/grid/diag/crs/jtp1/crs/trace/ohasd_orarootagent_root.trc

Trace file / u01/app/grid/diag/crs/jtp1/crs/trace/ohasd_orarootagent_root.trc

Oracle Database 12c Clusterware Release 12.2.0.1.0-Production Copyright 1996, 2016 Oracle. All rights reserved.

* * TRACE CONTINUED FROM FILE / u01/app/grid/diag/crs/jtp1/crs/trace/ohasd_orarootagent_root_93.trc * *

2018-04-02 18 terminating context 42lav 09.165: CSSCLNT:3554666240: clsssterm: terminating context (0x7f03c0229390)

2018-04-02 18 Credctx deleted 0x7f03c0459470 42lo 09.165: default:3554666240: clsCredDomClose:

2018-04-02 18 at clsgpnp_dbms.c:399 42 Result 09.166: GPNP:3554666240: clsgpnp_dbmsGetItem_profile: [at clsgpnp_dbms.c:399] Result: (0) CLSGPNP_OK (: GPNP00401:) got ASM-Profile.Mode='remote'

2018-04-02 18 initialized context 42V 09.253: CSSCLNT:3554666240: clsssinit: initialized context: (0x7f03c045c2c0) flags 0x115

2018-04-02 18 terminating context 42V 09.253: CSSCLNT:3554666240: clsssterm: terminating context (0x7f03c045c2c0)

2018-04-02 18 42 09.254: CLSNS:3554666240: clsns_SetTraceLevel:trace level set to 1.

2018-04-02 18 at clsgpnp_dbms.c:399 42 Result 09.254: GPNP:3554666240: clsgpnp_dbmsGetItem_profile: [at clsgpnp_dbms.c:399] Result: (0) CLSGPNP_OK. (: GPNP00401:) got ASM-Profile.Mode='remote'

2018-04-02 18 0x7f03c04f0420 42V 09.257: default:3554666240: Inited LSF context: 0x7f03c04f0420

2018-04-02 18 CLSCRED:3554666240 42: 09.260: clsCredCommonInit: Inited singleton credctx.

2018-04-02 18 clsCredDomInitRootDom 42V 09.260: CLSCRED:3554666240: (: CLSCRED0101:) Using user given storage context for repository access.

2018-04-02 18 querying length of attr ASM_DISCOVERY_ADDRESS 42V 09.294: USRTHRD:3554666240: {0:9:3} 8033 Error 4 querying length of attr ASM_DISCOVERY_ADDRESS

2018-04-02 18 querying length of attr ASM_DISCOVERY_ADDRESS 42 Error 09.300: USRTHRD:3554666240: {0:9:3} 8033

2018-04-02 18 clsCredOcrKeyExists 42lav 09.356: CLSCRED:3554666240: (: CLSCRED1079:) clsCredOcrKeyExists: Obj dom: SYSTEM.credentials.domains.root.ASM.Self.5c82286a084bcf37ffa014144074e5dd.root not found

2018-04-02 18 opening dom root in 0x7f03c064c980 42V 09.356: USRTHRD:3554666240: 7755 Error 4 opening dom root in 0x7f03c064c980

Check the alert.log of ASM and find that the / dev/shm size is less than the MEMORY_TARGET size, and gives the minimum value that / dev/shm should be set.

[root@jtp1] # tail-f / u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log

WARNING: ASM does not support ipclw. Switching to skgxp

WARNING: ASM does not support ipclw. Switching to skgxp

WARNING: ASM does not support ipclw. Switching to skgxp

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

* node 0 does not exist. Instance_number = 1

Starting ORACLE instance (normal) (OS id: 9343)

2018-04-02T18:31:00.187055+08:00

CLI notifier numLatches:7 maxDescs:2301

2018-04-02T18:31:00.193961+08:00

WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the / dev/shm file system to be mounted for at least 1140850688 bytes. / dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 1073573888 and used is 167936 bytes. Ensure that the mount point is / dev/shm for this directory.

The size of / dev/shm can be modified by modifying / etc/fstab, and the size of / dev/shm can be changed to 12G

[root@jtp1 bin] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/ol-root 49G 42G 7.9G 85% /

Devtmpfs 12G 28K 12G 1% / dev

Tmpfs 1.0G 164K 1.0G 1% / dev/shm

Tmpfs 1.0G 9.3m 1015m 1% / run

Tmpfs 1.0G 0 1.0G 0% / sys/fs/cgroup

/ dev/sda1 1014M 141M 874M 14% / boot

[root@jtp1 bin] # vi / etc/fstab

#

# / etc/fstab

# Created by anaconda on Sat Mar 18 15:27:13 2017

#

# Accessible filesystems, by reference, are maintained under'/ dev/disk'

# See man pages fstab (5), findfs (8), mount (8) and/or blkid (8) for more info

#

/ dev/mapper/ol-root / xfs defaults 0 0

UUID=ca5854cd-0125-4954-a5c4-1ac42c9a0f70 / boot xfs defaults 0 0

/ dev/mapper/ol-swap swap swap defaults 0 0

Tmpfs / dev/shm tmpfs defaults,size=12G 0 0

Tmpfs / run tmpfs defaults,size=12G 0 0

Tmpfs / sys/fs/cgroup tmpfs defaults,size=12G 0 0

After restarting the cluster, check again that the state of the cluster resources is back to normal.

[grid@jtp1] $crsctl stat res-t

Name Target State Server State details

Local Resources

Ora.ASMNET1LSNR_ASM.lsnr

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.CRS.dg

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.DATA.dg

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.FRA.dg

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.LISTENER.lsnr

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.TEST.dg

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.chad

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.net1.network

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.ons

ONLINE ONLINE jtp1 STABLE

ONLINE ONLINE jtp2 STABLE

Ora.proxy_advm

OFFLINE OFFLINE jtp1 STABLE

OFFLINE OFFLINE jtp2 STABLE

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE jtp1 STABLE

Ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE jtp2 STABLE

Ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE jtp2 STABLE

Ora.MGMTLSNR

1 ONLINE ONLINE jtp2 169.254.237.250 88.8

8.88.2,STABLE

Ora.asm

1 ONLINE ONLINE jtp1 Started,STABLE

2 ONLINE ONLINE jtp2 Started,STABLE

3 OFFLINE OFFLINE STABLE

Ora.cvu

1 ONLINE ONLINE jtp2 STABLE

Ora.jy.db

1 ONLINE OFFLINE STABLE

2 ONLINE OFFLINE STABLE

Ora.jtp1.vip

1 ONLINE ONLINE jtp1 STABLE

Ora.jtp2.vip

1 ONLINE ONLINE jtp2 STABLE

Ora.mgmtdb

1 ONLINE ONLINE jtp2 Open,STABLE

Ora.qosmserver

1 ONLINE ONLINE jtp2 STABLE

Ora.scan1.vip

1 ONLINE ONLINE jtp1 STABLE

Ora.scan2.vip

1 ONLINE ONLINE jtp2 STABLE

Ora.scan3.vip

1 ONLINE ONLINE jtp2 STABLE

To this cluster to return to normal

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report