Install OWB Server

Introduction:

This procedure installs the OWB Server Side components.

Aim:

Install OWB Server.

Requirements:

Oracle is installed and running. A suitable instance is ready for the OWB repositories.

Procedure:

• Log on to Linux as oracle.
• Open Terminal.
• $ mkdir orawb
• $ cd orawb
• Go here (from OTN - link through here to register) to get the software and download it to this directory - it is single file called; 'OWB_10.1.0.4.0_linux_x86.cpio.gz'. (I also burn it on to a CD. You never know when you'll need the install disk and why go through that download twice!)
• Unpack the files:
• $ gunzip OWB_10.1.0.4.0_linux_x86.cpio.gz
• $ cpio -idcmv < OWB_10.1.0.4.0_linux_x86.cpio
  
• These throw messages as they run and the result is a new directory called; Disk1
• $ cd Disk1
• $ ./runInstaller
• There are some requirements checks and on of these failed for me; the swap space was deemed to be too low. I just hit 'y' to continue.
  
• OUI:
• Welcome:
• [Next]
• Specify File Locations:
• Name: wb01
• Path: /u01/app/oracle/10.2.0.1/wb01
• [Next]
• Summary:
• [Install]
• Setup Privileges popup:
• Open Terminal.
• $ su -
• root's Password: *********
• # cd /u01/app/oracle/10.2.0.1/wb01
• # ./root.sh
• ... [/usr/local/bin]: [Enter]
• For the 3 'Overwrite it?' questions, answer 'n'.
• Return to the Setup Privileges popup.
• [OK]
• End of Installation:
• [Exit]
• Exit:
• [Yes]
• Install the Design Repository:
• $ cd /u01/app/oracle/10.2.0.1/wb01/owb/bin/unix
• $ ./reposinst.sh
• OWB Repository Assistant:
• Welcome:
• [Next]
• Server and SYSDBA Information:
• User Name: sys
• Password: *********
• Hostname: lisa
• Port Number: 1521
• Oracle Service Name: whs
• [Next]
• Create or Drop (this is the Design Schema):
• Create a new Warehouse Builder Repository
• [Next]
• New or Existing User:
• Create and install into a new user schema
• [Next]
• User Name and Password (new)
• User Name: wbd
• Password: *********
• Re-enter Password: *********
  
• Tablespace:
• [Next]
• Define Languages:
• [Next]
• Summary:
• [Finish]
• Installation Successful:
• [OK]
  
• Install the Runtime Repository, Runtime Access User and Target Schemas (whs):
• $ cd /u01/app/oracle/10.2.0.1/wb01/owb/bin/unix
• $ ./runtimeinst.sh
• OWB Runtime Assistant:
• Welcome:
• [Next]
• Server and SYSDBA Information:
• User Name: sys
• Password: *********
• Hostname: lisa
• Port Number: 1521
• Oracle Service Name: whs
• [Next]
• Choose Option:
• Runtime Repository
• [Next]
• Create or Drop:
• Create a new Warehouse Builder Runtime Repository
• [Next]
• New or Existing User:
• Create and install into a new user schema
• [Next]
• User Name and Password (new):
• User Name: wbr
• Password: *********
• Re-enter Password: *********
• [Next]
• Warning:
• [OK]
• Tablespace:
• [Next]
• Runtime Access:
• Create a new Runtime Access User
• [Next]
• Runtime Access User (New)
• User Name: wba
• Password: *********
• Re-enter Password: *********
• [Next]
• Name and Address Port:
• Port Number: 4040
• [Next]
• Summary:
• [Finish]
• Installation Successful:
• [Yes]
• Choose Option:
• Target Schema
• [Next]
• Create or Drop:
• Create a new Warehouse Builder Target Schema
• [Next]
• Runtime Repository:
• User Name: wbr
• Password: *********
• [Next]
• New or Existing User:
• Create and install into a new user schema
• [Next]
• User Name and Password:
• User Name: whs
• Password: *********
• Re-enter Password: *********
• [Next]
  
• Warning:
• [OK]
• Tablespace:
• [Next]
• Summary:
• [Finish]
• Installation Successful:
• [OK]
• Go to the OEM Console.
• Expand whs, Security, Users, whs
• Grant the following roles to whs:
• WB_A_WBR
• WB_D_WBR
• WB_R_WBR
• WB_U_WBR
• Create a privilege to allow wbd to use Enterprise Manager:
• Log in to Enterprise Manager whs as sys.
• -Security-
• -Users-
• [wbd]
• [System]
• -Select Any Dictionary- Move this to the Granted: window.
  
• [Apply]
• Change the Global Database Name:
• The default install sets this to [SID].REGRESS..US.ORACLE.COM and DB Link names will have this appended to them resulting in long DB Link names. This can be a problem for OWB, especially when using the debugger.
• For each instance, change the Global Database Name to [SID].[SERVER] (I use the server's alisa short name, e.g. whs.lisa & sta.lisa.
• Open Terminal.
• $ chora [SID]
• $ sqlplus sys as sysdba
• Password: *********
• > SELECT * FROM global_name;
• This returns with the current Global Name.
• > ALTER DATABASE RENAME GLOBAL_NAME TO [SID].[SERVER]
• > SELECT * FROM global_name; to check that the change was made.
  
• Install the Runtime Repository, Runtime Access User and Target Schemas (sta):
• $ cd /u01/app/oracle/10.2.0.1/wb01/owb/bin/unix
• $ ./runtimeinst.sh
• OWB Runtime Assistant:
• Welcome:
• [Next]
• Server and SYSDBA Information:
• User Name: sys
• Password: *********
• Hostname: lisa
• Port Number: 1521
• Oracle Service Name: sta
  
• [Next]
• Choose Option:
• Runtime Repository
• [Next]
• Create or Drop:
• Create a new Warehouse Builder Runtime Repository
• [Next]
• New or Existing User:
• Create and install into a new user schema
• [Next]
• User Name and Password (new):
• User Name: wbr
• Password: *********
• Re-enter Password: *********
• [Next]
• Warning:
• [OK]
• Tablespace:
• [Next]
• Runtime Access:
• Create a new Runtime Access User
• [Next]
• Runtime Access User (New)
• User Name: wba
• Password: *********
• Re-enter Password: *********
• [Next]
• Name and Address Port:
• Port Number: 4040
• [Next]
• Summary:
• [Finish]
• Installation Successful:
• [Yes]
• For each of the schemas; ctl, sta, val & ods:
  
• Choose Option:
• Target Schema
• [Next]
• Create or Drop:
• Create a new Warehouse Builder Target Schema
• [Next]
• Runtime Repository:
• User Name: wbr
• Password: *********
• [Next]
• New or Existing User:
• Create and install into a new user schema
• [Next]
• User Name and Password:
• User Name: as above
  
• Password: *********
• Re-enter Password: *********
• [Next]
  
• Warning:
• [OK]
• Tablespace:
• [Next]
• Summary:
• [Finish]
• Installation Successful:
• [OK]
• This stops the Runtime Installer. Restart it to add the other users.
• Go to the OEM Console.
• Expand sta, Security, Users, added user
  
• Grant the following roles to the user:
• WB_A_WBR
• WB_D_WBR
• WB_R_WBR
• WB_U_WBR

Testing:

This will be extensively tested in later stages.