martes, 29 de abril de 2014

Resolver problema al instalar obiee 11g con sqlserver 2005


Para resolver este error:

2014-04-29 15:09:40.800 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Fallo: Comprobar requisitos para el componente seleccionado:MDS
Consulte el log de RCU en C:\ofm_rcu_win_11.1.1.7.0_32_disk1_1of1\rcuHome\rcu\log\logdir.2014-04-29_15-03\rcu.log para obtener más información.
------------------------------------------------------------------------------
Component     : MDS
Error         : Repository creation check failed.
Cause         : Database: 'BI' 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 BI SET READ_COMMITTED_SNAPSHOT ON
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Component     : MDS
Error         : Repository creation check failed.
Cause         : Database: 'BI' 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:662)

2014-04-29 15:17:56.203 NOTIFICATION rcu: oracle.sysman.assistants.common.wizard.WizardExt::doCancel: User Canceled the operation
2014-04-29 15:17:56.204 NOTIFICATION rcu: oracle.sysman.assistants.common.wizard.WizardExt::doCancel: User cleanup the tablespaces: false



Se requiere ejecutar los siguientes comandos:

ALTER database NombreBD SET READ_COMMITTED_SNAPSHOT ON;
ALTER database NombreBD SET ALLOW_COMMITTED_SNAPSHOT ON;

ALTER DATABASE NombreBD SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Go
ALTER DATABASE NombreBD COLLATE Latin1_General_CS_AS
Go
ALTER DATABASE NombreBD SET MULTI_USER
Go


No hay comentarios:

Publicar un comentario