Following are the steps to create a new OBIEE instance on an existing obiee instance . This new instance will behave completely independently environment and will be having an enterprise manager and manged sever for its own.
This new instance INSTANCE 2 can have complete customization and will not be impacting the existing INSTANCE 1
RCU Creation : The new instance will need a new BIPLATFORM AND MDS schema and install this using the RCU utilitlity.
- for MS SQL server run the following script before the RCU creation
ALTER database <DATABASENAME>SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE <DATABASENAME> COLLATE LATIN1_GENERAL_CS_AS
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 <DATABASENAME>COLLATE ' + @collate)
END
GO
Configuring the new INSTANCE 2
Navigate to ORACLEBI1\BIN
run CONFIG.BAT
Enter a new domain new which is different from the existing bifoundation_domin
Set the parameters as below
Middle ware home : Current middle ware home
Oracle Home : Current Oracle Home (this will be the shared binaries for both the instances)
Weblogic Server Home : Current weblogic server home
Domain Home : The new domain that was created
Instance Name : Give a new name for the instance (instance_QA, instace_TEST) ETC.
Now the new instance is created and can be used completely Independent from the instance 1
Thanks ,
Sandeep
0 comments:
Post a Comment