Wednesday, August 24, 2011

Installing OBIEE 10.1.3.4.0 on Oracle XE

  1. Put in the WindowsXP Prof. CD in CDRom.
  2. Goto Control/Panel -> Add/Remove Windows Components -> Select the Internet Information Services(IIS) checkbox, then select Next
  3. Install the j2sdk-1_5_0-beta-windows-i586.exe java executable.
  4. Install the WindowsInstaller-KB893803-v2-x86.exe executable.
  5. Configure the microsoft loop back adapter.
  6. Download and install the 10g OracleXE OracleXEUniv.exe executable.
  7. Execute the setup.exe in the CD: E:\obiee\Server\Oracle_Business_Intelligence folder
  8. Open the command prompt and enter below: sqlplus system/welcome1@XE where welcome1 is given as password.
  9. Tthen enter below to create user SUPPLIER2
  10. create user SUPPLIER2 identified by SUPPLIER2 default tablespace
  11. users;
  12. grant dba to SUPPLIER2;
  13. Unzip D46077GC10__setup_files_win2000.zip to get SUPPLIER2.dmp C:\temp
  14. Then in command prompt cd to C:\temp and run: IMP SUPPLIER2/SUPPLIER2@XE FILE=SUPPLIER2.dmp FULL=Y