rhel/centos 8.5下基于asm存储的oracle 19c安装及异常重启

1、参考https://blog.csdn.net/AllanHwang/article/details/127782317为主体

2、asm磁盘创建参考 https://blog.csdn.net/applmanwx/article/details/120389476，udev配置nvme不生效

3、swapfile一定要大于4GB，2.7GB不够，否则会在link的时候失败

4、DBCA创建的时候报错DBT-05509

解决方法：参考https://forums.oracle.com/ords/apexds/post/dbt-05509-failed-to-connect-to-the-specified-database-labp-2856，LZ是relink后就好了。没走重启大法。 

5、解决ORA-00845: MEMORY_TARGET not supported on this system   https://blog.51cto.com/u_9748604/5572702

6、asm日常启停 https://www.cnblogs.com/slqleozhang/p/17117850.html

 

异常关机启动恢复

[grid@oracle19c-asm:/home/grid]$sqlplus "/as sysasm"

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 6 20:59:42 2024
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit
Disconnected
[grid@oracle19c-asm:/home/grid]$crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@oracle19c-asm:/home/grid]$crsctl start resource ora.cssd
CRS-4995:  The command 'Start  resource' is invalid in crsctl. Use srvctl for this command.
[grid@oracle19c-asm:/home/grid]$crsctl start resource ora.cssd -unsupported
CRS-2672: Attempting to start 'ora.cssd' on 'oracle19c-asm'
CRS-2672: Attempting to start 'ora.diskmon' on 'oracle19c-asm'
CRS-2676: Start of 'ora.diskmon' on 'oracle19c-asm' succeeded
CRS-2676: Start of 'ora.cssd' on 'oracle19c-asm' succeeded
[grid@oracle19c-asm:/home/grid]$crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               OFFLINE OFFLINE      oracle19c-asm            STABLE
ora.LISTENER.lsnr
               ONLINE  INTERMEDIATE oracle19c-asm            Not All Endpoints Re
                                                             gistered,STABLE
ora.asm
               OFFLINE OFFLINE      oracle19c-asm            Instance Shutdown,ST
                                                             ABLE
ora.ons
               OFFLINE OFFLINE      oracle19c-asm            STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oracle19c-asm            STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oracle19c-asm            STABLE
ora.orcl1.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
--------------------------------------------------------------------------------
[grid@oracle19c-asm:/home/grid]$sqlplus "/as sysasm"

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 6 21:02:24 2024
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 1137173320 bytes
Fixed Size            8905544 bytes
Variable Size         1103101952 bytes
ASM Cache           25165824 bytes
ASM diskgroups mounted
SQL>

 

posted @ 2024-01-29 09:49  zhjh256  阅读(173)  评论(0)  编辑  收藏  举报