English dropdown-ico

Manual Oracle Audio Technologies 13

35 pages 0.37 mb
Download

Go to site of 35

Summary
  • Oracle Audio Technologies 13 - page 1

    Oracle ® Retail Data Warehouse Database In stallation Guide Release 13.0 April 2008 ...

  • Oracle Audio Technologies 13 - page 2

    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 and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are al ...

  • Oracle Audio Technologies 13 - page 3

    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 Retail Predictive Application Server – Enterprise Engine, Oracle Retail Category Management, Oracle Retail Item Planning, Oracle Retail Merchandise Fi ...

  • Oracle Audio Technologies 13 - page 4

    ...

  • Oracle Audio Technologies 13 - page 5

    v Contents Preface ........................................................................................................................ ..... vii Audience ....................................................................................................................... ........ vii Related Do cuments ....................................... ...

  • Oracle Audio Technologies 13 - page 6

    ...

  • Oracle Audio Technologies 13 - page 7

    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. Audience This Installation Guide i s written for the follow ing audiences:  Database administrators (DBA)  System analy sts and desig ners  Integrators and implementation staff ...

  • Oracle Audio Technologies 13 - page 8

    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. This is a ...

  • Oracle Audio Technologies 13 - page 9

    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 Retail Merchandising System (RMS), Oracle Reta il Invoice Matching (R eIM), Oracle Reta il Merchandise Financial Planning (MFP), and Oracle Retail Pric ...

  • Oracle Audio Technologies 13 - page 10

    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. Oracle Retail strongly sugge sts that before installation or implementation yo u engage yo ur integrator (such as the Oracle Retail ...

  • Oracle Audio Technologies 13 - page 11

    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. Note: These data warehouse server re quirements should only be used as guideline s because th ...

  • Oracle Audio Technologies 13 - page 12

    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. Requirement Version Oracle Business Intelligence Enterprise Edition 10.1.3.3 Or ...

  • Oracle Audio Technologies 13 - page 13

    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. FTP (in binary mode) the tar file, rdw13_db.zip, t o <database_directory&g ...

  • Oracle Audio Technologies 13 - page 14

    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 .profile to correspond with the server file system, RETL in stallation and UNIX environment ...

  • Oracle Audio Technologies 13 - page 15

    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. Note: Become famili ar with the RDW applicat ion in a development e ...

  • Oracle Audio Technologies 13 - page 16

    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 ). 3. ...

  • Oracle Audio Technologies 13 - page 17

    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. Note these as they are used later in the installation. 3. Login to SQL*Plus as SYSD ...

  • Oracle Audio Technologies 13 - page 18

    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. If a table has been dropped an ...

  • Oracle Audio Technologies 13 - page 19

    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.ksh Note: Read the comments on every install script c alled w ...

  • Oracle Audio Technologies 13 - page 20

    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.0/error. 11. Review the error files that were created for time_static_load. Note: Ref ...

  • Oracle Audio Technologies 13 - page 21

    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. 1. If RMS is not being us ...

  • Oracle Audio Technologies 13 - page 22

    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. Note: DAY_IDNT serves as a surrogate key for day of the time. It can represent 454 t ...

  • Oracle Audio Technologies 13 - page 23

    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. Plea se see MetaLink note 559539.1 for ...

  • Oracle Audio Technologies 13 - page 24

    ...

  • Oracle Audio Technologies 13 - page 25

    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.e . RMS, Re IM, etc .) Oracle Database RDW 13.0 Development Environme ...

  • Oracle Audio Technologies 13 - page 26

    ...

  • Oracle Audio Technologies 13 - page 27

    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. <base ...

  • Oracle Audio Technologies 13 - page 28

    ...

  • Oracle Audio Technologies 13 - page 29

    Database Insta llation Guide 21 C Appendix: Orac le 10g Database Creation Scripts ############################################################################### # Oracle 10.2.0.x Parameter file # # NOTES: Before using this script: # 1. Change <datafile_path>, <admin_path>, <utl_file_path>, and <hostname> # values as appropr ...

  • Oracle Audio Technologies 13 - page 30

    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.2.0.1 optimizer_mode = CHOOSE # Oracle Retail ...

  • Oracle Audio Technologies 13 - page 31

    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.dbf&a ...

  • Oracle Audio Technologies 13 - page 32

    Appendix: Oracle 10g Database Creation Sc ripts 24 Oracle Retail Data Warehouse spool off exit ---------------------------------------------------------------------------------- --- --- Script: crdb3.sql --- Execute as: sysdba in 10.1.0.2 databases or higher --- Note: This script installs java and xml components; --- Do not change the order of the ...

  • Oracle Audio Technologies 13 - page 33

    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. --- Modify datafile storage parameters and sizes ...

  • Oracle Audio Technologies 13 - page 34

    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.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M MAXSIZE 2000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AU ...

  • Oracle Audio Technologies 13 - page 35

    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. 1. Oracle Retail Merchandis i ...

Manufacturer Oracle Audio Technologies Category Barcode Reader

Documents that we receive from a manufacturer of a Oracle Audio Technologies 13 can be divided into several groups. They are, among others:
- Oracle Audio Technologies technical drawings
- 13 manuals
- Oracle Audio Technologies product data sheets
- information booklets
- or energy labels Oracle Audio Technologies 13
All of them are important, but the most important information from the point of view of use of the device are in the user manual Oracle Audio Technologies 13.

A group of documents referred to as user manuals is also divided into more specific types, such as: Installation manuals Oracle Audio Technologies 13, service manual, brief instructions and user manuals Oracle Audio Technologies 13. Depending on your needs, you should look for the document you need. In our website you can view the most popular manual of the product Oracle Audio Technologies 13.

Similar manuals

A complete manual for the device Oracle Audio Technologies 13, how should it look like?
A manual, also referred to as a user manual, or simply "instructions" is a technical document designed to assist in the use Oracle Audio Technologies 13 by users. Manuals are usually written by a technical writer, but in a language understandable to all users of Oracle Audio Technologies 13.

A complete Oracle Audio Technologies manual, should contain several basic components. Some of them are less important, such as: cover / title page or copyright page. However, the remaining part should provide us with information that is important from the point of view of the user.

1. Preface and tips on how to use the manual Oracle Audio Technologies 13 - At the beginning of each manual we should find clues about how to use the guidelines. It should include information about the location of the Contents of the Oracle Audio Technologies 13, FAQ or common problems, i.e. places that are most often searched by users in each manual
2. Contents - index of all tips concerning the Oracle Audio Technologies 13, that we can find in the current document
3. Tips how to use the basic functions of the device Oracle Audio Technologies 13 - which should help us in our first steps of using Oracle Audio Technologies 13
4. Troubleshooting - systematic sequence of activities that will help us diagnose and subsequently solve the most important problems with Oracle Audio Technologies 13
5. FAQ - Frequently Asked Questions
6. Contact detailsInformation about where to look for contact to the manufacturer/service of Oracle Audio Technologies 13 in a specific country, if it was not possible to solve the problem on our own.

Do you have a question concerning Oracle Audio Technologies 13?

Use the form below

If you did not solve your problem by using a manual Oracle Audio Technologies 13, ask a question using the form below. If a user had a similar problem with Oracle Audio Technologies 13 it is likely that he will want to share the way to solve it.

Copy the text from the picture

Captcha
New picture

Comments (0)