ORACLE数据库问题 ，求助大佬

Question

[oracle@localhost trace]$ sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 30 21:48:52 2020

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

Enter password:
Connected to an idle instance.

SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 6062090
Additional information: 8

oracle@localhost trace]$ tail -f -n 40 /opt/oracle/diag/rdbms/orcl/orcl/alert/log.xml
level='16' host_id='localhost.localdomain' host_addr='::1'
pid='9296'>
Starting ORACLE instance (normal)


msg_id='opistr_real:935:3971575317' type='NOTIFICATION' group='startup'
level='16' host_id='localhost.localdomain' host_addr='::1'
pid='9398'>
Starting ORACLE instance (normal)


msg_id='ksbsrv:2858:3656186066' client_id='' type='WARNING'
group='background_proc' level='16' host_id='localhost.localdomain'
host_addr='::1' module='' pid='8335'>
Process m000 died, see its trace file


msg_id='opistr_real:935:3971575317' type='NOTIFICATION' group='startup'
level='16' host_id='localhost.localdomain' host_addr='::1'
pid='11171'>
Starting ORACLE instance (normal)


msg_id='ksbsrv:2858:3656186066' client_id='' type='WARNING'
group='background_proc' level='16' host_id='localhost.localdomain'
host_addr='::1' module='' pid='8335'>
Process m000 died, see its trace file


msg_id='opistr_real:935:3971575317' type='NOTIFICATION' group='startup'
level='16' host_id='localhost.localdomain' host_addr='::1'
pid='11984'>
Starting ORACLE instance (normal)

[oracle@localhost trace]$ tail -f -n 40 alert_orcl.log
DBRM started with pid=6, OS id=8315
Mon Mar 30 21:16:13 2020
PSP0 started with pid=7, OS id=8317
Mon Mar 30 21:16:13 2020
DIA0 started with pid=8, OS id=8319
Mon Mar 30 21:16:13 2020
MMAN started with pid=9, OS id=8321
Mon Mar 30 21:16:13 2020
DBW0 started with pid=10, OS id=8323
Mon Mar 30 21:16:13 2020
LGWR started with pid=11, OS id=8325
Mon Mar 30 21:16:13 2020
CKPT started with pid=12, OS id=8327
Mon Mar 30 21:16:13 2020
SMON started with pid=13, OS id=8331
Mon Mar 30 21:16:13 2020
RECO started with pid=14, OS id=8333
Mon Mar 30 21:16:13 2020
MMON started with pid=15, OS id=8335
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Mar 30 21:16:13 2020
MMNL started with pid=16, OS id=8337
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Mon Mar 30 21:16:13 2020
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 1564181277
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Mon Mar 30 21:21:09 2020
Starting ORACLE instance (normal)
Mon Mar 30 21:24:56 2020
Starting ORACLE instance (normal)
Mon Mar 30 21:25:29 2020
Starting ORACLE instance (normal)
Mon Mar 30 21:31:17 2020
Process m000 died, see its trace file
Mon Mar 30 21:40:57 2020
Starting ORACLE instance (normal)
Mon Mar 30 21:46:18 2020
Process m000 died, see its trace file

Answer 1

根据提供的信息，ORA-27102错误提示系统内存不足，可能是数据库实例无法正常启动。建议您检查数据库实例的内存限制和分配是否合理，比如使用 ulimit 命令查看系统的限制；检查实例的参数文件（pfile 或 spfile）中的 memory_target 和 memory_max_target 参数设置是否合理，是否超过了系统的实际可用内存。您可以参考 Oracle 官方文档或咨询专业人士，帮助您找到并解决问题。另外，根据日志提示中的 "Process m000 died, see its trace file"，您可以查看对应的跟踪文件，可能有更多有用的信息。