Install Oracle Client on the PC

Introduction:

Oracle Client contains a number of applications relevant to Data Warehousing, not least the Java OEM Console.

Aim:

Install and configure Oracle Client on the PC.

Requirements:

Oracle is installed and running on the server.

Procedure:

• Log on to the PC.
• Get the software:
• Go here (OTN - link through here to register), promise - really promise - that you are not a terrorist, and download the following file:
• 10201_client_win32.zip
• Install the software:
• Right-click the file name.
• -Extract All...-
• Welcome to the Compressed (zipped) Folders Extraction Wizard:
• [Next]
• Select a folder to extract files to: Pick a folder.
• [Next]
• Extraction Complete.
• [Finish]
• This has created a normal directory called; '10201_client_win32'. Navigate into this and then burn the entire contents of this directory on to CD.
• Put the CD in the drive. An auto-run window opens:
• -Install/Deinstall Products-
• OUI starts:
• Welcome:
• [Next]
• Select Installation Type:
• Administrator (533MB)
• [Next]
• Specify Home Details:
• Name: OraClient10g
• Path: C:\oracle\product\10.2.0.1.0\OraClient10g
• [Next]
• Product Specific Pre-Requisites:
• [Next]
• Summary:
• [Install]
• The software installs. After a while, the Oracle Net Configuration Assistant is launched (Note: If you can't see this popup, it may be hiding behind the OUI screen).
• Welcome:
• [Next]
• Select Naming Methods:
• The 'Selected Naming Methods' list should contain one entry; 'Local Naming'.
• [Next]
• Service Name:
• Service Name: sta
• [Next]
• Select Protocols:
• Highlight; 'TCP'.
• [Next]
• TCP/IP Protocol:
• Host name: lisa
• [Next]
• Test:
• Yes, perform a test
• [Next]
• Connecting:
• This probably fails with an invalid username/password message because it assumes the default password - which you should have changed by now!.
• [Change Login]
• Change Login popup:
• Enter the system password.
• [OK]
• Message: 'Connecting...Test successful
• [Next]
• Net Service Name:
• Net Service Name: sta
• [Next]
• Another Net Service Name?
• Yes
• [Next]
• Service Name:
• Service Name: whs
  
• [Next]
• Select Protocols:
• Highlight; 'TCP'.
• [Next]
• TCP/IP Protocol:
• Host name: lisa
• [Next]
• Test:
• Yes, perform a test
• [Next]
• Connecting:
• This may fail with an invalid username/password message because it uses the password entered for the sta database.
• [Change Login]
• Change Login popup:
• Enter the system password.
• [OK]
• Message: 'Connecting...Test successful
• [Next]
• Net Service Name:
• Net Service Name: whs
  
• [Next]
• Another Net Service Name?
• No
  
• [Next]
• Net Service Name Configuration Done:
• [Next]
• Naming Methods Configuration Done:
• [Next]
• Done:
• [Finish]
• End of Installation:
• [Exit]
• Exit:
• [Yes]
• Configure Enterprise Manager Console:
• There is now a new Program Group called; 'Oracle - OraClient10g'.
• -Start-
• -All Programs-
• -Oracle - OraClient10g-
• The Enterprise Manager Console starts:
• Popup: Add Databases to Tree:
• Add selected databases from your local tnsnames.ora file
• [OK]
• Main Console window:
• Expand -Databases-
• Both sta and whs are listed.
• Expand; 'STA'
• Database Connect Information:
• Username: sys
• Password: sys's password
• Connect as: SYSDBA
  
• Save as Local Preferred Credentials
• [OK]
• Console stores passwords in encrypted format in a local file. Continue?
• [OK]
• sta's top-level object hierarchy should appear.
• Expand; 'WHS'
• Database Connect Information:
• Username: sys
• Password: sys's password
• Connect as: SYSDBA
  
• Save as Local Preferred Credentials
• [OK]
• Console stores passwords in encrypted format in a local file. Continue?
• [OK]
• whs's top-level object hierarchy should appear.

Testing:

If you can navigate through the object hierarchy for both databases, we are sorted.