Oracle Analytics Cloud and Server

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

OBIEE 11.1.1.9.X INSTALLATION ISSUE

Received Response
43
Views
6
Comments
User_MSQS7
User_MSQS7 Rank 6 - Analytics Lead

Dear Experts,

I started installation OBIEE RCU with ms sql server db, facing below issue

=======================================================================================================

ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed

oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Failed - Check prerequisites requirement for selected component:MDS

------------------------------------------------------------------------------

Component     : MDS

Error         : Repository creation check failed.

Cause         : Database: 'xxxxx' is not configured correctly.

Action        : Alter database to turn on the READ_COMMITTED_SNAPSHOT option.

                Ensure you have DBA priviliges. Also the DBA should not have

                multiple logins on this database - else it will result in a

                lock error.

Command       : ALTER database xxxxx SET READ_COMMITTED_SNAPSHOT ON

-------------------------------------------------------------------------------

-------------------------------------------------------------------------------

Component     : MDS

Error         : Repository creation check failed.

Cause         : Database: 'xxxxx' is not configured correctly.

Action        : Alter database to apply the correct collate to the database.

                Ensure you have DBA priviliges. Also, the DBA should not have

                multiple logins on this database - else it will result in a

                lock error.

Command       : DECLARE @collate   sysname

                SELECT @collate = convert(sysname, serverproperty('COLLATION'))

                IF ( charindex(N'_CI', @collate) > 0 )

                BEGIN

                  select @collate = replace(@collate, N'_CI', N'_CS')

                  exec ('ALTER database $(DATABASE_NAME) COLLATE ' + @collate)

                END

                GO

-------------------------------------------------------------------------------

    at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76)

    at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)

    at java.lang.Thread.run(Thread.java:745)

==============================================================================================

as per the oracle document based on above issue I fired below query's but its taking huge amount of time ?

ALTER DATABASE mds SET READ_COMMITTED_SNAPSHOT ON

ALTER DATABASE mds COLLATE SQL_Latin1_General_CP1_CS_AS

Please suggest me best solution for it

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    This would indicate ("taking a lot of time") exactly what it says here:

    Action        : Alter database to turn on the READ_COMMITTED_SNAPSHOT option.

                    Ensure you have DBA priviliges. Also the DBA should not have

                    multiple logins on this database - else it will result in a

                    lock error.

    Ensure that there are no other active DBA logins to the database before you execute this command.

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Dear Joel,

    Thanks for the update. After start the installation this is the step i have seen error app crashed, but when click the check online for a solution error gone out installation goes fine further step but finally its got struck it took almost 20 hours time please find the below screen shot.

    pastedImage_1.png

    pastedImage_2.png

    I have seen some documents they mentioned software only install but in production  we should install Enterprise only install, is it fine if go with software only install instead of Enterprise install ?

    • Install Java 1.7.
    • Install WebLogic Server 10.3.6.
    • Patch WebLogic Server with Patch 16844206.
    • Perform a software-only install of OBIEE 11.1.1.9.0.
    • Configure OBIEE.
  • Joel
    Joel Rank 8 - Analytics Strategist

    What version of Windows is this?

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    windows server 2012 r2

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Can I get any update on above query?

  • Joel
    Joel Rank 8 - Analytics Strategist

    As I mentioned previously, can you additionally ask your DBAs to ensure that there are no other sessions running on the DB when you execute those commands.