Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obiee 11g migration : weblogic user unable to login into Analytics

2671324May 23 2014 — edited May 23 2014

hello

we have just migrate  obiee 11g successfully from one server to another server.

but now after migration we are not able to login into analytics page with weblogic user.

this user weblogic is able to login to Console and EM but not in analytics page.

All other user can log into console , EM and Analytics page.

so far ,

we have tried trobleshooting with following links,

1.

2. also tried with deleting weblogic user and again created weblogic user.

   but no luck.

Note : i have noticed when we migrated users and roles from one server to another , then weblogic user was working fine , even could login to Analytics page.

         But as soon as we migrated and deployed RPD, only since then we are facing this issue.

does any one have idea on this.

TIA

This post has been answered by SunilSharma on May 23 2014
Jump to Answer

Comments

user9540031

The documentation for the OPTIMIZER_ADAPTIVE_STATISTICS parameter (remark: modifiable in a PDB) states:
OPTIMIZER_ADAPTIVE_STATISTICS does not control the creation of SQL plan directives. SQL plan directives will be created even if this parameter is false, but they will not be used to refine SQL execution plans with dynamic sampling.
Therefore, if the AUTO_STAT_EXTENSIONS statistics preference is set to ON, it would be normal that statistics extensions be created.
Related blog articles by Frank Pachot and Christian Antognini:
https://blog.dbi-services.com/matching-sql-plan-directives-and-queries-using-it/
https://blog.dbi-services.com/dba_sql_plan_directive-last_used/
https://antognini.ch/2017/11/spd-state-does-not-change-if-adaptive-statistics-are-disabled/
Remarks:
Sadly, the +metrics format option (so far undocumented) seems to work only in dbms_xplan.display; it does nothing apparently in calls to dbms_xplan.display_cursor—I didn't try, but I wouldn't expect it to do anything in calls to dbms_xplan.display_awr either.
Christian Antognini's post includes a test script; I ran it on a 19.5 test DB, which behaved exactly as described.

1 - 1
Locked Post
New comments cannot be posted to this locked post.