Oracle Warehouse Builder RAC Konfiguration Hamid Habet 06

® Oracle Warehouse Builder RAC Konfiguration Hamid Habet 06. 05. 2008 Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_1

® Standorte in Zentral-Osteuropa ohne Deutschland Schweden Finnland Norwegen Central Eastern Region (ohne Deutschland) Region Nordeuropa UK Region Benelux. Mittelmeer Benelux München, D Cham, CH Wien, A Frankreich Budapest, HUN Spanien Italien Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_2

® Umsatzentwicklung weltweit * Umsatzzuwachs in Prozent $U. S. Milliarden $35. 1 $31. 4 $30. 7 $28. 8 $25. 5 $25. 2 $22. 5 9% -18% -11% $22. 6 1% 13% 9%* 12%* Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_3

® Mitarbeiterentwicklung in Deutschland Mitarbeiterzahlen der Ingram Micro Holding Gmb. H mit den Firmen Ingram Micro Distribution Gmb. H, Ingram Micro Games Gmb. H*, Ingram Micro Components (Europe) Gmb. H *Ingram Micro Games Gmb. H seit 2001 in Ingram Micro Distribution Gmb. H integriert Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_4

® One Stop Shopping Plattform für Wachstumsthemen Ingram Micro bringt Händlerbedarf und Lösungsangebot zusammen Produktangebot Mobility Co nn ec tiv ity Di gi ta l Produktsteuerung Endkundenmarketing Im ag in g y rit cu Se Marktzugang zum Handel 350 Hersteller Aktive Nachfrage er s m ic u s on n r Co ect El Zielgerichtetes Channelmarketing 35. 000 Händler B to B – B to C Bedarfsanalyse Produktbedarf Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_5

® Oracle & Ingram Micro Oracle Value Added Distributor seit 2006 Betreuung von Oracle Resellern und Systemintegratoren und Independet Software Vendors: • • • Training/Schulung Ihrer Vertriebsmitarbeiter Unterstützung in Lizenzierungs-Fragen Vertrieb von Oracle Lizenzen auch bei Endkunden mit Rahmenverträgen Beratung in Technologie-Fragen Projektschutz im Rahmen des Oracle Open Market Models Vermittlung von Oracle Pre. Sales Ressourcen (für Demos, Tests, Tuning, Benchmark u. Prototypes) Bereitstellung von Sales Kits Abwicklung von Oracle Bestellungen Unterstützung bei Marketingaktionen Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_6

® Oracle Warehouse Builder RAC Konfiguration Einführung in OWB 10 g. R 2 RAC Konfiguration Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_7

® Oracle Warehouse Builder RAC Konfiguration Repository Installation auf dem ersten RAC Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_8

® Oracle Warehouse Builder RAC Konfiguration Repository Installation auf dem ersten RAC Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_9

® Oracle Warehouse Builder RAC Konfiguration Repository Installation auf dem ersten RAC Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_10

® Oracle Warehouse Builder RAC Konfiguration Repository Registrierung auf dem zweiten Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_11

® Oracle Warehouse Builder RAC Konfiguration Repository Registrierung auf dem zweiten Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_12

® Oracle Warehouse Builder RAC Konfiguration Repository Registrierung auf dem zweiten Knoten Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_13

® Oracle Warehouse Builder RAC Konfiguration Anpassungen bzw. Nacharbeit 1. rtrepos. properties von Knoten 1 nach Knoten 2 kopieren ($OWB_HOME/owb/bin/admin/rtrepos. properties)) 2. In der OWB-Owner Tabelle WB_RT_SERVICE_NODES muss die IP-Adresse der zweiten RAC-Knoten manuell eingetragen werden insert into WB_RT_SERVICE_NODES (NODE_ID, INSTANCE_NUMBER, HOST, PORT, SERVICE_NAME, ENABLED, RUNTIME_VERSION, SERVER_SIDE_HOME) values ('2', '172. xxx', ‘ 1521', ‘SID_OWB 2', '10. 2. 0. 1. 31', ‘$OWB_HOME') 3. Als user OWB-Owner an die jeweiligen Knoten anmelden und start_service. sql ausführen ($OWB_HOME/owb/rtp/sql/start_service. sql)) 4. Für die OWB Data Collection, den Skript owbcollect. sql auf den Knoten wo der OWB-Repos installiert ausführen Der Skript sollte in SQL*Plus ausgeführt werden Der Skript sollte auch als DBA User ausgeführt werden SQL> connect system/<password> SQL> spool owbcollect. out SQL> @owbcollect. sql SQL> spool off owbcollect. out anschauen Data Collection Script for Oracle Warehouse Builder (Note 340196. 1) Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_14

® Oracle Warehouse Builder RAC Konfiguration Prüfung der RAC-Konfiguration select node_id node, instance_number inst, host, port, service_name service, server_side_home <owb_repository_owner>. wb_rt_service_nodes from OWB RUNTIME REPOSITORIES / CONTROL CENTERS (WB_RTV_SERVICE_NODES) =================================== NODE INST AVAILABLE ENABLED ACTIVE HOST PORT SERVICE_NAME RT_VERSION SERVER_SIDE_HOME ----------------------------------------------------------------------------------------1 1 Y 1 0 172. xxx 1521 SID_OWB 1 10. 2. 0. 3. 0 /oracle/orasoft/owb 2 2 Y 1 1 172. xxx 1521 SID_OWB 2 10. 2. 0. 3. 0 /oracle/orasoft/owb Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_15

® Oracle Warehouse Builder RAC Konfiguration Einführung in Warehouse Builder Browser Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_16

® Oracle Warehouse Builder RAC Konfiguration Control Center Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_17

® Oracle Warehouse Builder RAC Konfiguration Reports (Deployment, Execution, Mgmt and Related Links) Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_18

® Oracle Warehouse Builder RAC Konfiguration Service Node Report Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_19

® Oracle Warehouse Builder RAC Konfiguration Service Node Report Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_20

® hamid. habet@ingrammicro. de Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission. 000000_21