测试环境内存不够用,调整参数存在问题,导致DB无法启动,重新创建好的spfile,修改rac指定的实例位置。
测试环境内存不够用,减少SGA内存大小 SQL>alter system set sga_max_size=600m scope=spfile sid='*'; $ srvctl stop database -d orcl $ srvctl start database -d orcl PRCR-1079 : Failed to start resource ora.orcl.db CRS-5017: The resource action "ora.orcl.db start" encountered the following error: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u03/app/oracle/product/19.0.0/db_1/dbs/initorcl1.ora' . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/d1/crs/trace/crsd_oraagent_oracle.trc". 2020-04-16 19:15:14.302 :CLSDYNAM:3349079808: [ora.orcl.db]{2:15568:806} [check] ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Additional information: 4376 Additional information: -892012805 Process ID: 0 Session ID: 0 Serial number: 0 $ srvctl config database -d orcl Spfile: +DATA/ORCL/PARAMETERFILE/spfile.277.1036700589 SQL>create pfile='/tmp/pfile.ora' from spfile='+DATA/ORCL/PARAMETERFILE/spfile.277.1036700589'; *.sga_max_size=629145600 #*.sga_target=1130m SQL>create spfile='+DATA/ORCL/PARAMETERFILE/spfile.ora' from pfile='/tmp/pfile.ora'; ASMCMD> ls -l Type Redund Striped Time Sys Name PARAMETERFILE UNPROT COARSE APR 16 19:00:00 N spfile.ora => +DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.277.1037908227 $ srvctl modify database -d orcl -spfile '+DATA/ORCL/PARAMETERFILE/spfile.ora' $ srvctl config database -d orcl |grep spfile Spfile: +DATA/ORCL/PARAMETERFILE/spfile.ora