Benutzeranleitung / Produktwartung 13 des Produzenten Oracle Audio Technologies
Zur Seite of 35
Oracle ® Retail Data Warehouse Database In stallation Guide Release 13.0 April 2008.
Oracle ® Retail Data Warehouse Database Installation Guide, Release 13.0 Copyright © 2008, Oracle . All rights reserved. Primary Author: Paul Kehler The Programs (which include both the softwa re an.
Value-Added Reseller (VAR) Langu age (i) the software component known as ACUMATE developed and licensed by Lucent Technologies Inc. of Murray Hill, New Jersey, to Oracle and im bedded in the Oracle Re.
.
v Contents Preface ........................................................................................................................ ..... vii Audience ............................................................................................
.
vii Preface Oracle Retail Inst allation Guide s contain the re quirements and p rocedures that are necessary for the retailer to in stall Oracle Ret ail produ cts.
viii Conventions Navigate: This is a navigat e statement. It tells yo u how to get to the start of the procedure and ends with a screen shot of the start ing point and the statement “the W indow Name window opens.” Note: This is a note. It is us ed to call out information t hat is important, but not necessarily part of the procedure.
Database Insta llation Guide 1 1 Preinstallation T asks This release o f RDW incorporates option al in terfaces with these Oracle Retail products which can be sources for th e data warehouse: Oracle R.
Preinstallation Tasks 2 Oracle Retail Data Warehouse Implementation Capacity Planning There is significant com plexity involved in the dep loyment of Oracle Retai l applications, and capacity planning is site specific.
Check Database Server Software Requirements Database Insta llation Guide 3 Overall database size for the RDW. A capacity plan should be done for the database server and DASD require ments in general to asse ss how large the environment will need to be.
Preinstallation Tasks 4 Oracle Retail Data Warehouse Other Software Requirements for the Data Warehouse Please refer to the RDW 13.0 Middle Tier Installation Guide for the full installation instructions of the Oracle B usiness Intelligence Enterprise Edition components.
Alter Directory Ownership and Privileges Database Insta llation Guide 5 2. Create RDW database directory structure: Log in to the database server as UNIX user rdwdba. This user owns the datab ase directory structure. Extract the files from the downloaded zip file.
Preinstallation Tasks 6 Oracle Retail Data Warehouse Copy Profiles for RDW User 1. Login to UNIX as t he rdw13dev user and change d irectories to <base_directory>/rdw13 .0/sample_profiles. 2. Copy the profile to the home directory of rdw13dev. Edit the .
Database Insta llation Guide 7 2 Installation T asks It is assumed that Oracle 10 g release 2, w ith appropria te patches, has alre ady been installed. If not, refer to “Check Database Server Software Re quirements” in Chapter 1, “Preinstallation Tas ks” before proceedin g.
Installation Tasks 8 Oracle Retail Data Warehouse Create the RDW Database and Tablespaces Create the Database as Follows 1. Login to the RDW database server as the rdwdba user. 2. Create the Oracle recommended OFA d irectory structure for the database (d atafile directories, adump, bdump, cdump, arch , cr eate, exp, pfile, udump, utl_file_dir ).
Load RDW Database Database Insta llation Guide 9 Load RDW Database Create RDW Schema Owners 1. As the rdwdba user, ch ange director ies to INSTALL_DIR/rdw 13/utility. 2. Review the crusers.sql file for the name s and passwords of the rdw users that w ill be created.
Installation Tasks 10 Oracle Retail Data Warehouse SP2-0734: unknown command beginning "no rows se..." - rest of line ignored. Note: These scripts ar e also used f or maintenance. If you need to drop or add a tab le in the database, run these scripts again to give the appropri ate pr ivileges t o your users.
Data Population Database Insta llation Guide 11 Populate Datamart Default Data 1. As the rdw13dev user, change directories to <base_di rectory>/rdw13.0/install. This directory contains the code for all de f ault data instal lation scripts. 2. At the UNIX prompt, enter: default_load.
Installation Tasks 12 Oracle Retail Data Warehouse 8. On the UNIX server, cChange directorie s to <base_d irectory>/rdw13.0/log. 9. Review the log file that w as created or modified. 10. On the UNIX server, change directories to <base_directory >/rdw13.
Data Population Database Insta llation Guide 13 Create Time in RDW If more time data is needed, modi fy the pa rameters below for the new time period and run the module again. To minimize the load time for adding additi onal time, ent er only the first year to be added as the response for the first year prompt in number 5.
Installation Tasks 14 Oracle Retail Data Warehouse the error files that were created for g_time_l oad and g_time_trnsfrm_l oad if 454 time with Gregorian calendar is used. 13. Refer to the RDW Operations Guide for more in formation on the log files and error files.
Install Oracle Configuration Manager Database Insta llation Guide 15 Install Oracle Configuration Manager This Oracle Retail prod uct has been instr umented for configuration discovery and collection by Oracle Confi guration Manager (OCM). It is recommended that yo u take advantage of OCM in your environment.
.
Database Insta llation Guide 17 A Appendix: De velopment Database Schema Implementation The following figure shows the so urce system and RDW deve lopment schemas that are referred to in this in stallation guide. Source Databas e (Dimension Data , Fact Data, etc) Source Server (i.
.
Database Insta llation Guide 19 B Appendix: RD W Code T ree The following table describes the contents of each o f the RDW code tree directories created during the RDW installation. Path Directory Description <base_directory> dbasql This directory contains all SQL scripts necessary to maintain the permissions fo r the database users.
.
Database Insta llation Guide 21 C Appendix: Orac le 10g Database Creation Scripts ############################################################################### # Oracle 10.
Appendix: Oracle 10g Database Creation Sc ripts 22 Oracle Retail Data Warehouse nls_sort = BINARY # Should be explicitly set to ensure all sessions get the same order nls_territory = AMERICA # Default open_cursors = 900 # Oracle Retail required (minimum=900); default is 50 optimizer_features_enable = 10.
Install Oracle Configuration Manager Database Insta llation Guide 23 GROUP 3 ('<datafile_path>/redo3a.log') SIZE 1000M DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '<datafile_path>/temp01.dbf' SIZE 5000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M UNDO TABLESPACE undo_ts DATAFILE '<datafile_path>/undo_ts01.
Appendix: Oracle 10g Database Creation Sc ripts 24 Oracle Retail Data Warehouse spool off exit ---------------------------------------------------------------------------------- --- --- Script: crdb3.
Database Insta llation Guide 25 D Appendix: T ablespace Creation Scripts ------------------------------------------------------------------------- ------------ --- Script: create_rdw_tablespaces.sql --- Execute as: sysdba --- Note: Before running this script: --- Modify <datafile_path> values.
Appendix: Tablespace Creation Sc ripts 26 Oracle Retail Data Warehouse AUTOEXTEND ON NEXT 100M MAXSIZE 2000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; CREATE TABLESPACE user_data DATAFILE '<datafile_path>/user_data01.
Database Insta llation Guide 27 E Appendix: Installation Or der This section provides a gu ideline as to the or der in which the Orac le Retail applic ations should be instal led. If a retail er has chosen to use some, but not all, of the applications the order is still valid l ess the applications not being installed.
Ein wichtiger Punkt beim Kauf des Geräts Oracle Audio Technologies 13 (oder sogar vor seinem Kauf) ist das durchlesen seiner Bedienungsanleitung. Dies sollten wir wegen ein paar einfacher Gründe machen:
Wenn Sie Oracle Audio Technologies 13 noch nicht gekauft haben, ist jetzt ein guter Moment, um sich mit den grundliegenden Daten des Produkts bekannt zu machen. Schauen Sie zuerst die ersten Seiten der Anleitung durch, die Sie oben finden. Dort finden Sie die wichtigsten technischen Daten für Oracle Audio Technologies 13 - auf diese Weise prüfen Sie, ob das Gerät Ihren Wünschen entspricht. Wenn Sie tiefer in die Benutzeranleitung von Oracle Audio Technologies 13 reinschauen, lernen Sie alle zugänglichen Produktfunktionen kennen, sowie erhalten Informationen über die Nutzung. Die Informationen, die Sie über Oracle Audio Technologies 13 erhalten, werden Ihnen bestimmt bei der Kaufentscheidung helfen.
Wenn Sie aber schon Oracle Audio Technologies 13 besitzen, und noch keine Gelegenheit dazu hatten, die Bedienungsanleitung zu lesen, sollten Sie es aufgrund der oben beschriebenen Gründe machen. Sie erfahren dann, ob Sie die zugänglichen Funktionen richtig genutzt haben, aber auch, ob Sie keine Fehler begangen haben, die den Nutzungszeitraum von Oracle Audio Technologies 13 verkürzen könnten.
Jedoch ist die eine der wichtigsten Rollen, die eine Bedienungsanleitung für den Nutzer spielt, die Hilfe bei der Lösung von Problemen mit Oracle Audio Technologies 13. Sie finden dort fast immer Troubleshooting, also die am häufigsten auftauchenden Störungen und Mängel bei Oracle Audio Technologies 13 gemeinsam mit Hinweisen bezüglich der Arten ihrer Lösung. Sogar wenn es Ihnen nicht gelingen sollte das Problem alleine zu bewältigen, die Anleitung zeigt Ihnen die weitere Vorgehensweise – den Kontakt zur Kundenberatung oder dem naheliegenden Service.
