How does Policy Server execute Polling to Oracle Database store ?

Document ID:  TEC1094862
Last Modified Date:  08/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Single Sign-On

Releases

  • CA Single Sign-On:Release:12.51 CA SiteMinder
  • CA Single Sign-On:Release:12.52 CA SiteMinder

Components

  • SITEMINDER -POLICY SERVER:SMPLC
Question:

How does Policy Server execute Polling to Oracle Database store ?

Answer:

Policy Server create query to Oracle Data store at 15 seconds interval.

 

*******************************************************************************

1525      93.924436           10.131.xxx.xxx       10.131.xxx.xxx     TNS       164        Request, Data (6), Data

 

0000   ac a0 16 0a 45 00 00 50 56 9b 18 1c 08 00 45 00  ....E..PV.....E.

0010   00 96 29 99 40 00 40 06 78 d7 0a 83 3f 4f 0a 83  ..).@.@.x...?O..

0020   43 9d c0 d5 05 f1 49 fb ac 54 89 2f df 2f 80 18  C.....I..T././..

0030   01 f5 98 7a 00 00 01 01 08 0a 00 10 53 b6 42 86  ...z........S.B.

0040   1e 2c 00 62 00 00 06 00 00 00 00 00 03 5e 00 02  .,.b.........^..

0050   80 21 01 03 01 01 21 01 01 0d 00 00 00 00 04 7f  .!....!.........

0060   ff ff ff 00 00 00 00 00 00 00 00 00 00 00 01 00  ................

0070   00 00 00 00 73 65 6c 65 63 74 20 74 6f 5f 63 68  ....select to_ch

0080   61 72 28 73 79 73 64 61 74 65 29 20 66 72 6f 6d  ar(sysdate) from

0090   20 64 75 61 6c 01 01 00 00 00 00 00 00 01 01 00   dual...........

00a0   00 00 00 00                                      ....

 

*******************************************************************************

Additional Information:

What is the purpose of update query for Policy Store ?

https://support.ca.com/us/knowledge-base-articles.TEC1470324.html

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >