如题,oracle19c,windows 64bit下,trace文件目录产生大量的TRACE文件,文件中,包含
RDMAV_FORK_SAFE,RDMAV_HUGEPAGES_SAFE
具体文件内容如下:
*** 2021-03-01T19:41:34.218246+08:00
Required IPC RDMAV_FORK_SAFE environment not set
Required IPC RDMAV_HUGEPAGES_SAFE environment not set
Trace file D:\ORACLE\diag\rdbms\orclwin\orcl\trace\orcl_ora_15304.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
Build label: RDBMS_19.9.0.0.0DBRU_WINDOWS.X64_200930.1
Windows NT Version V6.2
ORACLE_HOME = D:\oracle\product\19.9.0\db_1
Node name : HISSERVER
CPU : 32 - type 866432 physical cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:7544M/49151M, Ph+PgF:56645M/100351M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 0
Windows thread id: 15304, image:
*** 2021-03-01T19:41:34.218246+08:00
Required IPC RDMAV_FORK_SAFE environment not set
Required IPC RDMAV_HUGEPAGES_SAFE environment not set
这个是19C的一个BUG,见Doc ID 2602978.1,
解决办法:
set Windows Environment Variables RDMAV_FORK_SAFE and RDMAV_HUGEPAGES_SAFE as "0" to prevent the trace outputs
将Windows环境变量RDMAV_FORK_SAFE和RDMAV_HUGEPAGES_SAFE设置为“0”以阻止跟踪输出
附:
Frequent Trace File Outputs Concerning RDMAV_FORK_SAFE Environment Variable On Windows Oracle 19c (Doc ID 2602978.1)
--APPLIES TO:
Oracle Database - Standard Edition - Version 19.3.0.0.0 and later
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Microsoft Windows x64 (64-bit)
--SYMPTOMS
Trace files containing following warnings are frequently generated in Windows platform.
Required IPC RDMAV_FORK_SAFE environment not set
Required IPC RDMAV_HUGEPAGES_SAFE environment not set
--CHANGES
CAUSE
The RDMAV environment variables are not relevant on Windows platform, but Oracle 19c checks it and prints warnings when not set.
This is being invstigated in unpublished Bug 30284751
and the conclusion will be updated on this document once the
investigation completes.
--SOLUTION
As a workaround, set Windows Environment Variables
RDMAV_FORK_SAFE and RDMAV_HUGEPAGES_SAFE as "0" to prevent the trace
outputs.
中文翻译:
关于Windows Oracle 19c上RDMAV_FORK_SAFE环境变量的频繁跟踪文件输出(文档ID 2602978.1)
--适用于:
Oracle数据库-标准版-19.3.0.0.0及更高版本
Oracle数据库-企业版-19.3.0.0.0及更高版本
Microsoft Windows x64(64位)
--症状
在Windows平台中经常生成包含以下警告的跟踪文件。
未设置所需的IPC RDMAV_FORK_SAFE环境
未设置所需的IPC RDMAV_HUGEPAGES_SAFE环境
--更改
原因
RDMAV环境变量在Windows平台上不相关,但Oracle 19c会对其进行检查,并在未设置时打印警告。
这是未发布的Bug 30284751中的invstigated
--解决方案
作为一种解决方法,请设置Windows环境变量
RDMAV_FORK_SAFE和RDMAV_HUGEPAGES_SSAFE为“0”以防止跟踪输出。
注意,设置环境变量后,需要重启机器生效。
Tag: Oracle错误 Oracle19c