Abnormal Growth Of The DM_ORACLE Pinlog

(Doc ID 1570741.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

Product: BRM 7.5 PS4

When some operations are performed using a script to restart CM and DM_ORACLE, the dm_oracle.pinlog size grows abnormally. For example:
1- Initially the dm_oracle.pinlog had 0 bytes;
2- Performed operations below:
     *changedmoracleto1.sh # script that changes the configuration in the dm_oracle pin.conf to enable the modifications of the BRM data model
     *pin_ctl restart dm_oracle cm
     *pin_deploy replace account.podl
     *changedmoracleto0.sh # script that changes the configuration in the dm_oracle pin.conf to disable the modifications of the BRM data model
     *pin_ctl restart dm_oracle cm
3- In the end the dm_oracle.pinlog had 376M.

Sometimes the log growth is so big (2.1 gb) that dm_oracle only starts after cleaning out the log.

Samples of the dm_oracle.pinlog:
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8339 dm_if_oracle.c(196):3174 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  scoped_system is 0 (Normal System)
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8339 dm_if_oracle.c(196):5047 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_get_passwd[ORA]: password decrypt successful
D Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8340 dm_back.c(31):546 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_crypt_init: pin.conf entry for tag is md5
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8340 dm_if_oracle.c(196):1768 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  prune partitions in search is enabled
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8340 dm_if_oracle.c(196):3174 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  scoped_system is 0 (Normal System)
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8340 dm_if_oracle.c(196):5047 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_get_passwd[ORA]: password decrypt successful
M Sun Aug 4 17:41:27 2013 localhost.localdomain dm:8339 dm_if_oracle.c(196):5213 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_oracle_get_lda: sm_svcname is not configured
M Sun Aug 4 17:41:28 2013 localhost.localdomain dm:8340 dm_if_oracle.c(196):5213 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_oracle_get_lda: sm_svcname is not configured
D Sun Aug 4 17:41:29 2013 localhost.localdomain dm:8338 dm_back.c(31):546 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_crypt_init: pin.conf entry for tag is md5
D Sun Aug 4 17:41:29 2013 localhost.localdomain dm:8341 dm_back.c(31):546 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  dm_crypt_init: pin.conf entry for tag is md5
M Sun Aug 4 17:41:29 2013 localhost.localdomain dm:8341 dm_if_oracle.c(196):1768 1:localhost.localdomain:dm:8267:-2099159184:0:1367317625:0
  prune partitions in search is enabled
...

changedmoracleto1.sh will change the below entries' values to 1, changedmoracleto0.sh will change their values back to 0.
- dm dd_write_enable_fields 1
- dm dd_write_enable_objects 1
- dm dd_write_enable_portal_objects 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms