来源于:
12C ORAAGENT.BIN CONSUMES HIGH MEMORY (文档 ID 1954032.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]Information in this document applies to any platform.
SYMPTOMS
12.1.0.2 oraagent.bin process grows more than 50 GB of res memory
121067 oracle 20 0 55.6g 55g 18m S 2.4 29.2 646:35.09 /u01/app/12.1.0.2/grid/bin/oraagent.bin
121067 oracle 20 0 55.6g 55g 18m S 5.5 29.2 646:35.37 /u01/app/12.1.0.2/grid/bin/oraagent.bin
121067 oracle 20 0 55.6g 55g 18m S 4.4 29.2 646:35.59 /u01/app/12.1.0.2/grid/bin/oraagent.bin
checking the pmap of oraagent,we could see that there are lot of anon pages and taking high private memory
00007fa074000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa07c000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa084000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa08c000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa094000000 65536 rw--- 0000000000000000 000:00000 [ anon ]
00007fa09c000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa0a4000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa0ac000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa0b4000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa0bc000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
00007fa0c4000000 131072 rw--- 0000000000000000 000:00000 [ anon ]
.
00007fff7cf5b000 8 rw--- 0000000000000000 000:00000 [ anon ]
00007fff7cfff000 4 r-x-- 0000000000000000 000:00000 [ anon ]
ffffffffff600000 4 r-x-- 0000000000000000 000:00000 [ anon ]
mapped: 59424832K writeable/private: 59264940K shared: 4K
CAUSE
In the crsd_oraagent_orcldb.trc, there are the following records:
2014-11-24 10:24:11.319051 : USRTHRD:903801152: {2:51113:12058} setResAttrib:attr USR_ORA_DOMAIN clsagfw attribVal clscrs tmpAttrValue
2014-11-24 10:24:11.319082 : USRTHRD:903801152: {2:51113:12058} setResAttrib cmdid 0x0109 checktype 0xffff
2014-11-24 10:24:11.319277 : USRTHRD:903801152: {2:51113:12058} setResAttrib modifyResource attr USR_ORA_DOMAIN value
2014-11-24 10:24:11.319298 : USRTHRD:903801152: {2:51113:12058} setResAttrib clsagfw_modify_attribute attr USR_ORA_DOMAIN value retCode 1
The clsagfw_modify_attribute attr USR_ORA_DOMAIN value failed repeatedly.
The issue has been fixed in Bug 20091753 and unpublished Bug 18590085.
SOLUTION
Apply the fix of Bug.20091753 and 18590085 if the patch is available for your platform and version
or
Workaround
Use the following command to change the value of USR_ORA_DOMAIN of every database resource running in the cluster from NULL to a not NULL doman_name string.
$ srvctl modify database -db db_unique_name -domain domain_name
where domain_name is:
The domain for the database. Must match the DB_DOMAIN initialization parameter.
Setting it will not cause any performance impact to the database.