当前是这样的设置
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 32G
sga_target big integer 18G
SQL> show parameter mem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 12G
SQL> 这种情况应该是自动共享内存模式，这种情况下可以设置db_cache_size、shared_pool_size吗？
我设置后就无法启动数据库
SQL>
SQL> alter system set sga_target=32G scope=spfile;
System altered
SQL>
SQL> alter system set db_cache_size=18G scope=spfile;
System altered
SQL> alter system set shared_pool_size=12G scope=spfile;
System altered
SQL> alter system set pga_aggregate_target=3G scope=spfile;
System altered
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORA-03113: 通信通道的文件结尾
SQL> select instance_name from v$instance;
ERROR:
ORA-03114: 未连接到 ORACLE
求助各位大哥解答一下
回答了上一个问题才看到这个，看来上个问题找到解决办法了。。
看上个问题应该是Windows服务器吧，估计是虚拟内存不够，调整下虚拟内存试试参考
https://blog.csdn.net/weixin_46133643/article/details/125042903
评论
有用 1
你这属于ASMM模式了，automatic SGA memory management. In ASMM mode, you needn't setup db_cache_size,shared_pool_size,java_pool_szie and large_pool_size, etc. all these size are set by the server automatically.
评论 有用 0启动时的日志
Thu Apr 20 19:49:15 2023
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Thu Apr 20 19:49:15 2023
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 40
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Thu Apr 20 19:49:22 2023
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Apr 20 19:49:23 2023
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 141236
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Apr 20 19:49:26 2023
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Apr 20 19:49:26 2023
Stopping background process VKTM
Thu Apr 20 19:49:31 2023
Instance shutdown complete
Thu Apr 20 19:50:28 2023
Adjusting the default value of parameter parallel_max_servers
from 1280 to 470 due to the value of parameter processes (500)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 32
Number of processor cores in the system is 32
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Error: Failed to allocate SGA granule addr 00000004E4000000 size 67108864
mode 131073 locality 0
Errors in file d:\oracle\diag\rdbms\eas\eas\trace\eas_ora_5432.trc:
ORA-27102: out of memory
OSD-00026: 附加错误信息
O/S-Error: (OS 1455) 页面文件太小，无法完成操作。
Error: Failed to allocate SGA granule addr 00000004E0000000 size 67108864
mode 131073 locality 0
Errors in file d:\oracle\diag\rdbms\eas\eas\trace\eas_ora_5432.trc:
ORA-27102: out of memory
OSD-00026: 附加错误信息
O/S-Error: (OS 1455) 页面文件太小，无法完成操作。
Error: Failed to allocate SGA granule addr 00000004DC000000 size 67108864
mode 131073 locality 0
Errors in file d:\oracle\diag\rdbms\eas\eas\trace\eas_ora_5432.trc:
ORA-27102: out of memory
OSD-00026: 附加错误信息
O/S-Error: (OS 1455) 页面文件太小，无法完成操作。
Error: Failed to allocate SGA granule addr 00000004D8000000 size 67108864
mode 131073 locality 0
Errors in file d:\oracle\diag\rdbms\eas\eas\trace\eas_ora_5432.trc:
ORA-27102: out of memory
OSD-00026: 附加错误信息
O/S-Error: (OS 1455) 页面文件太小，无法完成操作。
评论 有用 0
墨值悬赏