nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 11.1.1.9.X INSTALLATION ISSUE

User_MSQS7

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

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

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

Find more posts tagged with

Accepted answers

All comments

Joel Acha

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

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.

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 Acha

What version of Windows is this?

User_MSQS7

windows server 2012 r2

User_MSQS7

Can I get any update on above query?

Joel Acha

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.