Centos 7 Oracle数据库12c的内存外安装

Question

我是Oracle数据库安装新手，我试着安装更新版本，但它不起作用，当我获得关于如何安装12c版本的完整文档时，不知何故，内存中出了一个错误。

当我签入这个路径时:/u 01/app/oracle/cfgtoollog/dbca/orcl

[ 2023-04-19 16:37:55.751 GMT ] Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
[ 2023-04-19 16:38:01.236 GMT ] ORA-27102: out of memory

DBCA_PROGRESS : 3%
[ 2023-04-19 16:38:01.238 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:02.301 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:02.305 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:07.537 GMT ] DBCA_PROGRESS : DBCA Operation failed.

当我签入此路径时:/u 01/app/oracle/diag/rdbms/orcl/orcl/trace

2023-04-19T16:38:01.221832+00:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2023-04-19T16:38:01.221951+00:00
 Per process system memlock (soft) limit = 128G
2023-04-19T16:38:01.222002+00:00
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 820M
2023-04-19T16:38:01.222103+00:00
 Available system pagesizes:
  4K 
2023-04-19T16:38:01.222200+00:00
 Supported system pagesize(s):
2023-04-19T16:38:01.222254+00:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2023-04-19T16:38:01.222306+00:00
        4K       Configured          209924            2149   ORA-27102
2023-04-19T16:38:01.222355+00:00

我在安装过程中的当前配置如下：

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

我的当前内存：根@测试等# free -m

              total        used        free      shared  buff/cache   available
Mem:           2048         855         269         496         922         696
Swap:           512         191         320

关闭安装程序并检查我的RAM后

              total        used        free      shared  buff/cache   available
Mem:           2048          76        1120         496         850        1474
Swap:           512          24         487

你能帮我确定我的数据库的正确配置吗？

Answer 1

在安装过程中，您试图分配多少内存/SGA？试着缩小SGA的大小。也许它会有用