Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11.1.1.9.X INSTALLATION ISSUE

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
-
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.
0 -
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.
0 -
What version of Windows is this?
0 -
windows server 2012 r2
0 -
Can I get any update on above query?
0 -
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.
0