Oracle Audio Technologies 12.2 Bedienungsanleitung

Oracle ® Retail Place Installation Guide Release 12.2 Nov ember 2008[...]

Oracle ® Retail Place Installation Guide, Release 12.2 Copyright © 2006, 2008, Oracle. All rights r eserved. Primary Author: An irudha Accanoor The Programs (wh ich include bo th the soft ware and do cumentation) contain proprietar y information; they are pr ovided under a license agreemen t containing r estrictions on use and disclosur e and ar [...]

V alue-Added Res eller (V AR) Language Oracle Retail V AR Application s The following r estrictions and provision s only apply to the programs re ferred to in this sectio n and licensed to you. Y ou acknowledge that the programs may contai n third party softwar e (V AR applications) licensed to Oracle. Depending upon your product and its ve rsion n[...]

[...]

v Contents Preface ............ .............. .............. ................. .............. .............. ................. .............. ............... ................ .............. ix Audience .................... .............. .............. ................. .............. ................. .............. ......... ........ ...........[...]

vi Setting Up the W ebLogic Startup Script ............. .............. .............. ................. .............. .............. ........ 4-4 Setting Up the Maximum Me ssage Size ................ .............. ................. .............. .............. ................. .. 4-5 5 Installing Place Overview of the Installation Proce ss ...[...]

vii Setting Up a Foreign JMS Server on W ebLogic Server ................... .............. .............. ................. ..... 6-6 A Files and Directory Structure Application Director y Structure ............. .............. ................. .............. .............. ................. .............. .... A-1 Modules Deployed On W ebLogic Se[...]

viii[...]

ix Preface This guide enables you to instal l the Oracle Retail Place application, along with the server-side compone nts requir ed for the application. Au d i e n c e This guide is intended for system administrat ors and assumes that you are familiar with the following: ■ Installing and configuring appl ication server software ■ Installing and[...]

x Customer Suppor t ■ https://metalink.oracle.com When contacting Customer Support, please provide: ■ Product version and pr ogram/module name ■ Functional and technical description of the problem (include business impact) ■ Detailed step-by-step instructions to recr eate ■ Ex a ct e rro r m e ss a g e re ce i ve d ■ Screen shots of eac[...]

Overview 1-1 1 Over vie w This chapter provides an overview of Oracle Retail Place and a r oadmap for implementing the application. It contains the following sections: ■ Overview of Place ■ Overview of Oracle C onfiguration Ma nager ■ Roadmap for Implementing Place Overview of Place Oracle ® Retail Place enables retailers to generate and pub[...]

Overview of Place 1-2 Oracle® Retail Place Installation Guide Figure 1–1 T ypical Configuration for Place Client System Tier The Client System tier contains the systems that connect to the Place application using a W eb browser . It includes systems with the following components: ■ Microsoft W indows ■ Microsoft Of fice ■ Microsoft Interne[...]

Overview of Place Overview 1-3 Database Server Tier The Database Server tier contains the systems configur ed with the database management systems (Oracle 10 g Database) along with the necessary database software. The following essential schemas ar e cr eated during the Place installation: ■ AUDIT schema – contains information that helps you be[...]

Roadmap for Implementing Place 1-4 Oracle® Retail Place Installation Guide Roadmap for Implement ing Place This guide explains how you can install and set up the Place application, along with the requir ed and optional software. The instructions in this guide assume knowledge of application servers, databa ses, and application installation, and ar[...]

Planning Y our In stallation 2-1 2 Planning Y our Installation Before installing the Place application, you must first determine the performance and availability go als for your business, and then plan the har dware, network, and s torage requir ements accordingly . This chapter provides some basi c considerations for the implementation. It also in[...]

Suppor ted Config urations 2-2 Oracle® Retail Place Installation Guide Planning f or Optimal Place P erf ormance Consider the following steps to plan and pr epare the product envir onment. 1. Determine the Place metrics r elevant to your bus iness needs. 2. Determine your relevant busine ss policies. The business po licy is a statement of what rul[...]

Suppor ted Configu rations Planning Y our In stallation 2-3 Database Requirements Place requir es the use o f the Oracle database as described in the following table: Application Server Requirements Place requir es the use of the BEA W ebLogic 8.1 Server Service Pack 6. W ebLogic Application Server Place supports the use of the BEA W ebLogic Server[...]

Suppor ted Config urations 2-4 Oracle® Retail Place Installation Guide Client System Requirements The following table lists the suppo rted client system options: T able 2–3 Client System En vironment Software Requirements W indows XP Pro SP2 (with Office XP ) ■ Microsoft Of fice XP ■ Microsoft Inte rnet Explorer 7.0 W indows XP Pro SP2 (with[...]

Setting Up the Database 3-1 3 Setting Up the Database Before you run the Oracle installer to install the application, you must set up the database to include certain ne cessary tablespaces, and a da tabase user account. This chapter describes how you c an set up your database, and the various database components. It contains the following s ections[...]

Creating the Default T ablespaces 3-2 Oracle® Retail Place Installation Guide Creating the Default T ablespaces When you run the Oracle installer , schemas and tables for the application get installed on the database you create. For the schema s and tables to install success fully , the database must include cert ain default tablespaces. Use the O[...]

Creating the Database Links Setting Up the Database 3-3 Creating the Database Links If you plan to instal l the Place application acr oss two database instances, you must create the instances in the following manne r , and then set up the database links between the two instances: ■ Set up the ELM schema (historical data) on a database instance (f[...]

Creating the Database Links 3-4 Oracle® Retail Place Installation Guide[...]

Setting Up the Application Ser v er 4-1 4 Setting Up the Application Server Before installing the Place application, you must set up a domain on the applicatio n server . Based on your business need, you must set up the domain to include one or more ser ver instances, and logically r elated resources and s ervices. This chapter describes how you ca[...]

Setting Up a WebLogic Domain 4-2 Oracle® Retail Place Installation Guide Setting Up a W ebLogic Domain Use the BEA W ebLogic Configuration W izard to cr eate and set up a domain on the W ebLogic Server . This section describes how you can create and set up a domain. It also includes the step s to configure th e managed servers and clus ters on the[...]

Setting Up a WebLogic Domain Setting Up the Application Ser v er 4-3 a. Configure Managed Servers W indow Click Ad d , and then enter appropriate information in the following fields: ■ Name – V alid server name. (String of characters that can include spaces.) ■ Listen address – Listen addr ess for a server instance. ■ Listen port – V al[...]

Setting Up the WebLogic Star tup Scr ipt 4-4 Oracle® Retail Place Installation Guide Setting Up the W ebLogic Startup Script Before you start the W ebLogic server , you mu st edit the startW eblogic.sh and set up the W ebLogic server connection inform at ion, LD_LIB RAR Y_P A TH envir onment variables, and the JA V A_DEBUG_OPTIONS. T o set up the [...]

Setting Up the Maximum Message Size Setting Up the Application Ser v er 4-5 2. After the CLASSP A TH statement, add the following statement to set up the LD_LIBRAR Y_P A TH environment variable: export LD_LIBRARY_ PATH=$<PRODUCT_INS TALL_BASE>/mod ules/Engine/lib/lin ux_ i686:$LD_LIBRARY_P ATH 3. On the last line, update the JA V A_HOME state[...]

Setting Up the Maximum Me ssage Size 4-6 Oracle® Retail Place Installation Guide[...]

Installing Place 5-1 5 Installing Place After you have set up your database and application server , you can install Place using the guidelines pr ovided in this chapter . This chapter contains the following secti ons: ■ Overview of the Installation Process ■ Installing Place ■ Install.properties Parameters Re ference ■ T roubleshooting Ins[...]

Installing Place 5-2 Oracle® Retail Place Installation Guide Installing Place Installing Place consists of the follow ing tasks: ■ Accessing the Installation Softwar e ■ Setting Up Y our Installation Pr operties File ■ Installing Place in the Silent Mode ■ Installing Place Using the Graphical Oracle Installer ■ Installing the Sample Data[...]

Installing Place Installing Place 5-3 Oracle E-Delivery writes a ZIP file to the defaul t location you have selected for downloads. 6. Unpack the ZIP file to a temporary directo ry . In this guide, the director y that contains the installation media is re fer red to as the <PLACE_CD_IMAGE> directory . Now you can set up your Place installatio[...]

Installing Place 5-4 Oracle® Retail Place Installation Guide Return V alue When run in the silent mode (install.sh -s), a trace message appears on the console (the stdout). When run in the Oracle Installer mode (the default), the script displays a graphical user int erface. Output The Place installat ion crea te s the Place dir ectory stru ctur e,[...]

Installing Place Installing Place 5-5 bash install.sh The We l c o m e screen appears. Figure 5–1 Welcome Screen 5. Click Next . The Place Instal lation Destination screen appears. 6. On the Place Installation Destination screen, specify the paths for the following: ■ Destination Directory - path to the Place installation target directory . ■[...]

Installing Place 5-6 Oracle® Retail Place Installation Guide Figure 5–2 Pla ce Installa tion Destination Scree n 7. Click Next . The Place Selections scr een appears. 8. On the Place Selections screen, select the component you want to ins tall, and click Next . Figure 5–3 Place Selections Scre en 9. On the Application Server Se lections screen[...]

Installing Place Installing Place 5-7 Figure 5–4 Appli cation Server Selections Screen 10. On the W ebLogic Applicatio n Server screen, enter the r elevant information (such as host, port, user name, passwor d) to connect to the W ebLogic server set up for the application. Figure 5–5 W ebLogic Application Se rver 11. On the Java Message Server [...]

Installing Place 5-8 Oracle® Retail Place Installation Guide Figure 5–6 Java Message Server Proper ties Screen 12. Click Next . The Data base Selection s screen appears. 13. On the Database Selections scr een, click Oracle , and then click Next . Figure 5–7 Data base Selections Sc reen 14. On the Database Properties scr een, enter the foll owi[...]

Installing Place Installing Place 5-9 ■ Database alias – Enter the da tabase alias, whic h is typically the same name as the database. ■ Ta b l e s – Select one of the following options: –N o C h a n g e – Sel ect this option if you have an existing database schema that you do not want to modify . This enables you to configure data sour[...]

Installing Place 5-10 Oracle® Retail P lace Installatio n Guide Figure 5–9 Sc hema Link Pr operties Screen 16. Review the Selection V erificati on screen, and click Install . Figure 5–10 Selection V erification Screen The Installation Pr ogress scree n appears. If the installation resulted in issues, see T roubleshooting Installation Issues on[...]

Installing Place Installing Place 5-11 Setting Up ADF Libraries For the Online Help to work, you must in voke the ADF libraries in the W ebLogic Server Home dir ectory . Although the ADF libraries are part of the pr oduct installation and they get installed along with the product, you must source the setupadf.sh file in the W ebLogic startup script[...]

Installing Place 5-12 Oracle® Retail P lace Installatio n Guide 2. On the W ebLogic Server Console, under Service Confi gurations , click Servers in the JMS column. The JMS Servers page appears. 3. On the JMS Servers page, cli ck AllocationServer . 4. On the AllocationServer page, click the T arget and Deploy tab. 5. On the T arget and Deploy tab,[...]

Installing Place Installing Place 5-13 Installing the Sample Dataset The Place installation comes along with a sample dataset that can be used during implementation and demonstrations. This dataset contains generic data and is designed to work along with the default produ ct configuration. The data file s, along with the necessary data load scripts[...]

Install.proper ties P arameters Reference 5-14 Oracle® Retail P lace Installatio n Guide Install.pr oper ties P arameter s Reference The install.pr operties file enables you to set up the following parameters before you install Place: ■ In s ta l la t io n T a rg et D ire c to r ie s ■ Command Shell Settings ■ Last Session Pr operties File s[...]

Install.proper ties Parameters Reference Installing Place 5-15 Last Session Proper ties Fi les The Last Session Properties Files settings en able you to specify the location where you want to store the l ast-session.pr opert ies and mi ssing-entries.pr operties files. The following table describe s the Last Session Properties Files settings: Applic[...]

Install.proper ties P arameters Reference 5-16 Oracle® Retail P lace Installatio n Guide Calc Engine User Setting The Calc Engine User setting enables you to specify the passwor d for the Calc Engine default us er account. The following table describes the Calc En gine User setting: W ebLogic Application Server Settings The W ebLogic Application S[...]

Install.proper ties Parameters Reference Installing Place 5-17 Oracle Da tabase Settings The Oracle Database setti ngs enable you to specify the Oracle database parameters for the Place application. The following table d escribes the following database settings: ■ Connection and Authentication Settings ■ Audit Database Properties ■ Place Sche[...]

Install.proper ties P arameters Reference 5-18 Oracle® Retail P lace Installatio n Guide dbms.oracle.alias Use this parame ter to specify the data base alias name. dbms.oracle.user Use this parame ter to spe cify the user name to connect to the database. dbms.oracle.pass Use this parame ter to specify the passwor d to connect to the database. Orac[...]

Install.proper ties Parameters Reference Installing Place 5-19 Au dit Database Proper ties The Audit Database pr operties enable you to specify the connection and authenticati on parameters for the Audit data base. The following table describe s the Audit Database pr operties: T able 5–10 Audit Database Properties P arameter De scription database[...]

Install.proper ties P arameters Reference 5-20 Oracle® Retail P lace Installatio n Guide Place Schema Pr operties The Place Schema pr operties enable you to specify the connection and authentication parameters for the Place schema in the Place database. The following table describes the Place Schema properties: Plan Front End Database Pr operties [...]

Install.proper ties Parameters Reference Installing Place 5-21 ELM Schema Pr operties The ELM Schema properties enable you to specify the connection and authentication parameters for the ELM schema in the Place database. The following table describes the ELM Schema propertie s: database.plandb.oracle.create U se this parameter to indicate that a ne[...]

Install.proper ties P arameters Reference 5-22 Oracle® Retail P lace Installatio n Guide Place-specific Suite Pr operties The Place-specif ic Suite prope rties enable you to specify pr operties that appl y across the product suite. The following table describes the Place-specific Suite pr operties: Cluster Properties The Cluster pr operties enable[...]

Install.proper ties Parameters Reference Installing Place 5-23 MicroStrateg y Pr operties The MicroStrategy Pr operties settings en able you to specify the connection an d authentication parameters for MicroStrategy . It also enables you to specify th e highest hierarchy le vel, in your business, for the merchandi se and location hierarchy . The fo[...]

T roubleshooting Insta llation Issues 5-24 Oracle® Retail P lace Installatio n Guide T r oubleshooting Installation Issues The Oracle Installer simplifies the pr ocess of integrating and configuring multiple applications (for example, your database soft ware, your application server software, and Place). Because of this complexity an d the state o[...]

T roubleshooting Installatio n Issues Installing Place 5-25 Installation Aborts Because of Incompatible Component s When upgrading to the Plan Release 12.2 and Place Release 12.2 on a co-deployed environment, in case the installation does not complete because of the incompatible components, you must run the first pr oduc t upgrade with "-P&quo[...]

T roubleshooting Insta llation Issues 5-26 Oracle® Retail P lace Installatio n Guide[...]

Installing Place Over Plan 6-1 6 Installing Place Over Plan This chapter describes how you can install th e Place application to work along with an existing installation of P lan. It includes th e procedur es you can use to deploy the Place application in the same W e bLogic domain used by Plan. It includes the following s ections: ■ Setting Up t[...]

Setting Up the Place I nstallation 6-2 Oracle® Retail Place Installation Guide database.<schema_n ame>.oracle.upgrade =yes For more information on the installation pr operties file and the Plan installation procedure, see the chapter Installing Plan . Setting Up the Place Installation Before you start installing the Place application, you mu[...]

Configuring Place Installing Place Over Plan 6-3 Configuring Place Once the Place application is installed, you must load the user roles and business rules used between Place and Plan. Y ou must also ru n certain scripts that load seed data for the Place application. This section includes the following tasks you must perform to load the bus iness r[...]

Configuring Place 6-4 Oracle® Retail Place Installation Guide load the seed data. For mor e information on the scripts, see Refer ence to the Data Load Scripts . T o load the seed data: 1. At the SQL pr ompt, run the f ollowing scripts: ■ custom_ir_objects.sq l (Custom script) ■ pl_dd_attributes.sql (Generic script) ■ data_levels_tbl.sql (Cu[...]

Configuring Place Installing Place Over Plan 6-5 Reference to the Data Loa d Scripts The following table describes the scripts (req uired for the data loa d), and li sts their location in the AESample directory: T able 6–1 Data Load Scri pts for Place and Plan Script Name Script Location (Place_InstallDataSetsAESample) Script Description Custom[...]

Upgrading a Co-deploy ed Environment 6-6 Oracle® Retail Place Installation Guide Upgrading a Co-deploy ed En vironment When upgrading to the Plan Release 12.2 and Place Release 12.2 on an existing co-deployed environment, the installation may abort because of the incompatible components. The following example ( Example 6–1 ) displays an e rror m[...]

Setting Up a Foreign JMS Ser ver on WebLogic Server Installing Place Over Plan 6-7 Local JNDI Name: CommonConnectionFa ctory Remote JNDI Name: CommonConnectionFa ctory 7. Configure a new Foreign JMS T opic and point it to the t opic created under the CommonJMS Server d eployed on Pl an. For example, Name: RemoteNotifi cationTopic Local JNDI Name: c[...]

Setting Up a Foreign JMS Ser ver on WebLogic Server 6-8 Oracle® Retail Place Installation Guide[...]

Files and Director y Structure A-1 A Files and Directory Structure This appendix provides a r eferen ce to the dire ctory structur e of a typical Place installation. It includes info rmation on the locations of the various enterprise archive (EAR) modules that get deployed over the W ebLogic server . This appendix includes the following sections: ?[...]

Application Directory Str ucture A-2 Installation Guide |------ integration Contains the configuration fi les for the Integration module. This includes the integration.properties file. |----- testharness |----- translators |----- xsd |----- xsdvalidator |------ SIT Contains the configuration files fo r the System Information T ool (SIT) module. |--[...]

Application Directory Str ucture Files and Director y Structure A-3 |------ Database Contains the sc ripts that help set up the application database. |------ Datasets Contains the scripts and co ntro l files that help set up a sample (AESample) datase t. |----- AESample |----- ControlFiles |------ Install Contains the Place inst aller files and the[...]

Modules Deployed On W ebLogic Ser ver A-4 Installation Guide Modules Deplo yed On W ebLogic Ser ver The following table lists the application modules EARs deployed on the W ebLogi c server: T able A–2 M odules Depl oyed on W ebLogic Ser ver Module Name Description EAR File Name and Locati on allocating4p Place application / modules/Place/allocati[...]

Index-1 Inde x A ADF libraries, 5-11 application server requirem ents, 2-3 application serv er and database settings, 5-15 B brmadmin, 6-3 bulk loader, 6-3 business rule s, 6-3 C CE user setting, 5-16 client system requirem ents, 2-4 command shell settings, 5-14 configure load roles, 6-3 load rules, 6-3 load seed data, 6-3 place over plan, 6-3 conn[...]

Index-2 webLogic application server settings, 5-16 install.prop erties file, 5-3 setup audit, 6-1 L last session prop erties files, 5-15 load business rule s, 6-3 seed data, 6-3 user roles, 6-3 M microstrategy properties, 5-23 N network requirem ents, 2-2 O oracle database settings, 5-17 actual history databa se properties, 5-20 audit database prop[...]