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

Oracle OAS 5.9 Configuration fails at "Sync mid tier database"

Received Response
94
Views
3
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Apr 26, 2024 8:08AM in Oracle Analytics Cloud and Server

Hi Gurus,

Installed and configured FMW 12.2.1.4.0, then installed OAS 5.9 on top of FMW, ran and created RCU schemas (on MS SQL Server database), finally started configuring OAS, then encountered the error "Config Action failed, Configure BI failed with Execution of sync_midtier_db.sh failed with exit value 1.

Please share any inputs on this if you came across...

Thanks in advance.

Answers

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    This is no longer an issue, specifying connection string in [database name]:port:[host name] resolved the issue, Note: this issue happens when RCU ran on MS SQL server databases only.

  • lrohrer
    lrohrer Rank 1 - Community Starter

    You might also need to run config.cmd with admin privs.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    @lrohrer this is a 3-year old thread which was abandoned. Please don't resurrect zombie threads.