h18153753151 2019-12-05 10:48 采纳率: 0%
浏览 506

oracle自动关闭服务,然后手动stratup启动,又能正常使用!

Thu Dec 05 09:37:05 2019
System state dump requested by (instance=1, osid=44223 (DBW0)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_44215_20191205093705.trc
Instance terminated by DBW0, pid = 44223
Thu Dec 05 09:47:25 2019
Adjusting the default value of parameter parallel_max_servers
from 320 to 120 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 64 KB

Total Shared Global Region in Large Pages = 0 KB (0%)

Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB

RECOMMENDATION:
Total System Global Area size is 9634 MB. For optimal performance,
prior to the next instance restart:

  1. Increase the number of unused large pages by at least 4817 (page size 2048 KB, total size 9634 MB) system wide to get 100% of the System Global Area allocated with large pages
  2. Large pages are automatically locked into physical memory. Increase the per process memlock (soft) limit to at least 9642 MB to lock 100% System Global Area's large pages into physical memory ******************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 CELL communication is configured to use 0 interface(s): CELL IP affinity details: NUMA status: non-NUMA system cellaffinity.ora status: N/A CELL communication will use 1 IP group(s): Grp 0: Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =27 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1 System name: Linux Node name: easdatabase Release: 2.6.32-642.el6.x86_64 Version: #1 SMP Tue May 10 17:27:01 UTC 2016 Machine: x86_64 Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora System parameters with non-default values: processes = 150 sga_target = 9632M control_files = "/oracle/app/oracle/oradata/orcl/control01.ctl" control_files = "/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl" db_block_size = 8192 compatible = "11.2.0.4.0" log_archive_dest_1 = "location=/mnt1/archivelog" db_recovery_file_dest = "/oracle/app/oracle/fast_recovery_area" db_recovery_file_dest_size= 35G undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "/oracle/app/oracle/admin/orcl/adump" audit_trail = "DB" db_name = "orcl" open_cursors = 300 _b_tree_bitmap_plans = FALSE _no_or_expansion = TRUE optimizer_index_cost_adj = 50 optimizer_index_caching = 90 pga_aggregate_target = 3210M diagnostic_dest = "/oracle/app/oracle" Thu Dec 05 09:47:26 2019 PMON started with pid=2, OS id=47601 Thu Dec 05 09:47:26 2019 PSP0 started with pid=3, OS id=47603 Thu Dec 05 09:47:28 2019 VKTM started with pid=4, OS id=47607 at elevated priority VKTM running at (1)millisec precision with DBRM quantum (100)ms Thu Dec 05 09:47:28 2019 GEN0 started with pid=5, OS id=47611 Thu Dec 05 09:47:28 2019 DIAG started with pid=6, OS id=47613 Thu Dec 05 09:47:28 2019 DBRM started with pid=7, OS id=47615 Thu Dec 05 09:47:28 2019 DIA0 started with pid=8, OS id=47617 Thu Dec 05 09:47:28 2019 MMAN started with pid=9, OS id=47619 Thu Dec 05 09:47:28 2019 DBW0 started with pid=10, OS id=47621 Thu Dec 05 09:47:28 2019 LGWR started with pid=11, OS id=47623 Thu Dec 05 09:47:28 2019 CKPT started with pid=12, OS id=47625 Thu Dec 05 09:47:28 2019 SMON started with pid=13, OS id=47627 Thu Dec 05 09:47:28 2019 RECO started with pid=14, OS id=47629 Thu Dec 05 09:47:28 2019 MMON started with pid=15, OS id=47631 Thu Dec 05 09:47:28 2019 MMNL started with pid=16, OS id=47634 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = /oracle/app/oracle Thu Dec 05 09:47:28 2019 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 1553952944 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Thu Dec 05 09:47:33 2019 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 7 processes Started redo scan Completed redo scan read 10546 KB redo, 1690 data blocks need recovery Started redo application at Thread 1: logseq 47164, block 39943 Recovery of Online Redo Log: Thread 1 Group 3 Seq 47164 Reading mem 0 Mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log Recovery of Online Redo Log: Thread 1 Group 2 Seq 47165 Reading mem 0 Mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log Completed redo application of 5.86MB Completed crash recovery at Thread 1: logseq 47165, block 4932, scn 500814159 1690 data blocks read, 1688 data blocks written, 10546 redo k-bytes read Thu Dec 05 09:47:40 2019 LGWR: STARTING ARCH PROCESSES Thu Dec 05 09:47:40 2019 ARC0 started with pid=27, OS id=47696 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Thu Dec 05 09:47:41 2019 ARC1 started with pid=28, OS id=47711 Thu Dec 05 09:47:41 2019 ARC2 started with pid=30, OS id=47713 Thu Dec 05 09:47:41 2019 ARC3 started with pid=29, OS id=47715 ARC1: Archival started ARC2: Archival started ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC2: Becoming the heartbeat ARCH Thread 1 advanced to log sequence 47166 (thread open) Thread 1 opened at log sequence 47166 Current log# 1 seq# 47166 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Dec 05 09:47:41 2019 SMON: enabling cache recovery Archived Log entry 44784 added for thread 1 sequence 47165 ID 0x58d8a86f dest 1: [47655] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:1111127512 end:1111127762 diff:250 (2 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Database Characterset is AL32UTF8 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Thu Dec 05 09:47:43 2019 Starting background process QMNC Thu Dec 05 09:47:43 2019 QMNC started with pid=31, OS id=47739 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Thu Dec 05 09:47:44 2019 db_recovery_file_dest_size of 35840 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Completed: ALTER DATABASE OPEN Thu Dec 05 09:47:45 2019 Starting background process CJQ0 Thu Dec 05 09:47:45 2019 CJQ0 started with pid=32, OS id=47753 Thu Dec 05 09:48:03 2019 Starting background process SMCO Thu Dec 05 09:48:03 2019 SMCO started with pid=47, OS id=47850
  • 写回答

1条回答 默认 最新

  • 憧憬blog 2023-03-15 04:31
    关注

    根据您提供的信息,您的Oracle实例在运行过程中异常终止,并且自动关闭服务。然后你手动启动了服务,它又正常工作了。警告信息中提到了一些性能优化建议。

    这种情况可能是由于许多原因引起的,例如由于系统故障或配置错误导致的问题。为了确定问题的根本原因,您可能需要查看跟踪日志和其他相关日志,以及检查配置设置和系统资源使用情况。

    为避免类似问题未来重现,并且以提高性能和可靠性,建议您执行以下操作:

    • 适当地分配和配置系统资源和内存。
    • 定期检查和维护数据库和操作系统。
    • 监控数据库性能并调整参数设置。
    • 当出现故障时查看相关日志和跟踪文件,并根据需要采取适当的措施。

    除此之外,我无法给出更具体的回答。如果您需要更多帮助,请提供更多详细信息。

    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 MATLAB动图问题
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名