Install OBIEE 11g on Windows by using Microsoft sql server as an database server

-
Download Oracle OBIEE 11G on your PC as per system architecture.

And download RCU(Repository Creation Utility ) from same page where u downloaded OBIEE.


  1. Extract RCU and open rcuHome\BIN location




  2. Run RCU bat file and click next.
  3. Select create repository option and click next.


  4. Select database type as microsft sql server.
  • Unicode support: Yes
  • Server Name: complete server name or ip address or host\server format.
  • Port: 1433
  • Database Name:
    Open SQL server management studio.
    create one new database in sql server(Ex OBIEE) and whle creating database In sql server in owner option give admin user name(ex: sa) and click apply.
And open Quiery window.
Execute below commands.
 ALTER DATABASE obirep COLLATE Latin1_General_CS_AS
ALTER DATABASE obirep SET READ_COMMITTED_SNAPSHOT ON


Navigate in to rcu_home folder
rcuHome\rcu\integration\epm\registry\scripts\sqlserver and open createfr.sql into notepad for editing.


Replace each semicolon terminator and change every instance of Sql_Latin1_General_cp1_CI_AS to be Latin1_General_CS_AS to refelect s pecific UK settings.
  • User Name: sa
  • Password: sql admin password(sa password).



  1. Click "Next". This will start the pre-requisite checks.  
  2. Click next and select Oracle Business intelligence component and AS common schemas. Prefix as DEV


  3. Click next and Enter schema password and make a note of password.


  4. Click next and click create and close the window.


OBIEE instalation:
Put all disk folders(Ie Disk 2 ,3,4) into Disk 1 folder
  1. Open Disk 1 and click on setup.exe
  2. Click Skip Software updates and select simple install


  3. Pr-requisites check has been done.
  4. In middleware home give path to obiee installtion and click next.

  5. Enter the 'Weblogic' Admin credentials.(Remebered password ie: schema password)

  6. Configuring the components. In my case I select all. 
     
  7. Specify the databse connection parameters.
  • Database type: sql server
  • Connect string: servername:1433:databasename
  • Biplatform schema name: DEV_BIPLATFORM
  • Password: schema password.


8) Click next and click install
Installation will take long time.




Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more