通过分析是因为sga_target参数设置不合理导致asm无法正常启动 GI无法正常启动 grid@zwq-rpt1:~$crsctl status resource -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors. grid@zwq-rpt1:~$crsctl status resource -t -init --- NAME...
SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...
SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...
SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...