Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAS(6.4) Analytics page is not able to authenticate in the login after Switch over to DR Database.

Accepted answer
173
Views
6
Comments
Omarkhan
Omarkhan Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Hi,

We have OAS 6.4 version installed on Linux machines with 2 nodes cluster environment for Production instance. For RCU schemas are using Production database while installation and DR database sync in 24hrs delay with Production database (DDL's and data content). While performing the database DNS switch over from Production database(DBA's shutdown the services) to DR database, OAS analytics page is not able to authenticate the login page but able to login console/em (OAS services are up and running). Could you please advise if any solution steps are in place for the same.

Regards,
Omar

Best Answer

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @user_5TZYH - Please let us know if the OAS application is updated with the DR RCU host details or are you using high availability in DB as well to validate the DR activity as soon as Prod RCU DB is shut down. Thanks.

  • Omarkhan
    Omarkhan Rank 2 - Community Beginner

    OAS application is not updated with the DR RCU host details. Can you please let us know how to do that.
    FYI - DR database tns entries are mapped to alias of DNS.

  • Omarkhan
    Omarkhan Rank 2 - Community Beginner

    We are getting below error message.
    "YOU ARE NOT CURRENTLY SIGNED IN TO THE ORACLE ANALYTICS SERVER "

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_5TZYH - Could you please check if the DR database has sufficient tablespace needed. Please refer the below KM article in which I can see similar symptoms. Hope this helps!


    Analytics Login is showing "You Are Not Currently Logged Into Oracle Analytics Server" after RCU Database Failover To Standby Database (Doc ID 2905386.1)

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_5TZYH - Kindly share what helped resolving the issue so that other users going through the community are benefitted as well. Thanks.