1302-opera v2r2-single server install

Opera Hotel Edition

1302-Opera v2.0 release 2 – Single Server Install

Version 2.0

November 18, 2002

OPERA SINGLE SERVER INSTALL

Copyright

2002 MICROS Systems, Inc. All rights reserved. No part of this publication may be reproduced, photocopied, stored on a retrieval system, or transmitted without the express prior written consent of the publisher. MICROS Systems, Inc. retains the right to update or change the contents of this document without prior notice. MICROS Systems, Inc. assumes no responsibility for the contents of this document.

OPERA is a trademark of MICROS Systems, Inc.

On Oracle and the On Oracle logo are trademarks of Oracle Corporation.

Information in this document is subject to change without notice.

MICROS Systems, Inc. makes no warranty of any kind with regard to this material, including but not limited to the implied warranties of marketability and fitness for a particular purpose.

MICROS Systems, Inc. shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material.

Document Number: 1302-OPERA v2.0 release2 – Single Server Install

MICROS Systems, Inc. Fidelio Technologies Inc. 2640 Golden Gate Parkway, Suite 211 Naples, FL 34105 Voice: (239) 643-7999 / Fax: (239) 643-7911

OPERA HOTEL EDITION VERSION 2.0 PAGE 2 2/20/02


Purpose The purpose of this document is to provide Opera Single Server database standards and instructions necessary to perform an Opera Installation for single server production. This version of the document describes the installation of Oracle 8.1.7.2.6 for Windows, Oracle Applications Server and Opera 2.0 Release 2 on the Windows platform. Every reference to these products in the document specifically refers to these versions.

Intended Audience This document is intended for Micros-Fidelio staff charged with installing Opera Single Server, it assumes that the installer has the experience necessary to configure the Windows database server in accordance with these standards. It does not assume any particular knowledge of Oracle or the SQL language but the reader should be familiar with the architecture of an Opera installation.

Requirements

Software

Windows NT Server 4.0 with Service Pack 6a or Windows2000 Service Pack 2 or 3

Opera Single Server CD.

No Oracle products installed.

Disk Layout (NT 4.0/Win2K)

The single server install requires a minimum of one physical hard drive with at least 20Gig of space (two if mirrored). Installation will take place on any physical drive specified (ie. D:\, G:\, H:\, etc…)

Windows Logical Drive

Free Space Required Usage

C: At least 4Gb OS and Program Files

Select Drive letter for Single Server Install (ie. D:\)

At least 20Gb Oracle 8.1.7.2.6, Dev6i Patch 8, Oracle 9iAS, Oracle 9i OEM, Interfaces, and Opera V2 release 2 (Patch 33)

E: Reserved for CD-ROM

Confidential 11/22/2002


Installed Directory Locations NOTE: This example assumes the install was performed on the m:\ drive, and is only an example, the screen shots below show m:\ drive as the example installed drive also. However the install will place your directories under whatever drive letter you specify on the install.

Opera: m:\micros\opera Interfaces: m:\micros\ifc Database: m:\oracle\817 IAS: m:\oracle\ias Dev6I: m:\oracle\dev6I Oracle Enterprise Manager (OEM): m:\oracle\oem Database datafiles: m:\oracle\oradata\opera Backup datafiles location: m:\oracle\oradata\opera\backup Backup script location: m:\oracle\scripts

New Opera Single Server Installation Insert the Single Server installation CD-ROM into the drive, select START / RUN and enter E:\setup, or you can double click on the setup.exe on the CD. The following screen should appear:

Click Next



The next screen allows the user to choose the drive where the software will be installed. The process will populate two paths on the drive \Micros path, where the OPERA software will be installed and \Oracle path, where the Oracle software will be installed.

The screen “Select Destination Location” is used to determine where Oracle will be installed.

To accept the default location click Next.

Otherwise, to change the drive location, click on Browse button and select another drive. By default, the drive letter and folder are set to D:\Micros. To modify the drive, click on the down arrow at the bottom of the screen, and select the new drive letter. Select OK to return to “Select Destination Drive”. Then click Next. This example is installing on the m:\ drive.



Note: You cannot select a mapped drive on the network, the letter selected for the installation must physically be on the server that you are installing Opera Single Server on.

Select OK, to continue and select a physical drive.

Selecting Cancel, is not recommended as it will cancel the entire installation and exit out of the installer.



Opera Single Server is installing.

Insert Disk #2 when prompted, click OK to continue



Opera Single Server Install continues

Opera Services are created at the end of the install.

The services were installed successfully, to continue click OK



The Opera Single Server Install completed successfully, click FINISH

Your installation should now be complete.

Rebooting the server is necessary for the install to complete, click OK



Desktop ICONS

Opera Thin Client

Opera web based connection

Opera QMS

Opera QMS login form

Opera PMS

Opera Property Management System login form

Opera SC

Opera Sales and Catering login form

Oracle Enterprise Manager Console

Oracle Database management utility

Protobase Administrator

Configuration for credit card connection

IFC Install Guide

Documentation in Installing Interfaces

IFC Configuration

Configuration for Interfaces



Interfaces

IFC Startup Forms

Reports Queue Manager

Monitors print jobs in the report queue.

Cold Oracle Backup / Restore Scripts for Opera Single Server THIS BACKUP AND RESTORE METHOD WILL DO A FULL ORACLE COLD BACKUP OF THE OPERA DATABASE; ANY DATA CHANGES AFTER THE LAST SUCCESSFUL BACKUP WILL NOT BE RECOVERED.

Example Backup: Tuesday – Last backup Wednesday - No backup performed Thursday – Hardware or database failure causes the database to be unrecoverable and the only option is to perform a database restore. Restore will have to be from the Tuesday backup. After restoring the Opera database the data will be back to what it was on Tuesday at the time of the backup. Thus not including any changes made after the backup. Scripts

There are two provided scripts for the Opera Single Server backup and restore.

Backup file: \oracle\scripts\”backup opera db.bat” Restore file: \oracle\scripts\”restore opera db.bat”



Backup Opera DB.bat script

• AUTOMATIC SHUTDOWN OF THE DATABASE

• AUTOMATIC SHUTDOWN OF THE APPLICATIONS SERVER

• Copies file from \oracle\oradata\opera to \oracle\oradata\opera\backup

NOTE: \oracle\oradata\opera\backup contains all files required to recover the database. After a backup is complete the contents of this folder should be copied to a suitable tape device to ensure data is not lost in the case of a hardware failure.

• Startup Opera database

• Startup Applications server

Restore Opera DB.bat script • AUTOMATIC SHUTDOWN OF THE DATABASE

• AUTOMATIC SHUTDOWN OF THE APPLICATIONS SERVER

• Copies files from \oracle\oradata\opera\backup and overwrites current files in \oracle\oradata\opera

• Startup Opera database

• Startup Applications server



Note: To avoid Opera downtime when performing a backup, third party software will need to be installed such as Veritas BackupExec. For Opera Single Server Install this is not considered in the hardware recommendations so would need to be reviewed to verify the hardware if sufficient.

Referencing Document 1200-Opera V2 NT-Opera Hardware Sizing for Windows[Rev 2].pdf

Reference document 1314-Opera V2R2 NT- BackupExec Configuration.

Initopera.ora NOTE: If there 1G or more of memory modify the following initopera.ora parameters:

shared_pool_size = 131072000

db_block_buffers = 8192

###################################################################### # # INITOPERA.ORA # Oracle initialization file for Opera Single Server database v2.0 release 2 # ###################################################################### ########################################### # Archive ########################################### # Uncommenting the line below will cause automatic archiving if archiving has # been enabled using ALTER DATABASE ARCHIVELOG. #log_archive_start = true #log_archive_dest_1 = "location=d:\oracle\admin\opera\archive" #log_archive_format = %%ORACLE_SID%%T%TS%S.ARC ########################################### # Cache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=8 ########################################### # Cursors and Library Cache ########################################### open_cursors=800 ########################################### # Database Identification ########################################### db_domain="" db_name=Opera instance_name=Opera service_names = opera, opera.world global_names = false



########################################### # Diagnostics and Statistics ########################################### #background_dump_dest=d:\oracle\admin\opera\bdump #user_dump_dest=d:\oracle\admin\opera\udump max_dump_file_size=4096 timed_statistics=TRUE oracle_trace_collection_size=1024000 ########################################### # Distributed, Replication ########################################### open_links=8 open_links_per_instance=8 ########################################### # Events ########################################### EVENT="10235 trace name context forever, level 2" # This event is only for Windows systems on 8.1.7.2.6 ########################################### # File Configuration ########################################### control_files=("d:\oracle\oradata\opera\control01.ctl", "d:\oracle\oradata\opera\control02.ctl") ########################################### # Java ########################################### java_pool_size=40960000 java_max_sessionspace_size=40960000 java_soft_sessionspace_limit=30720000 ########################################### # Job Queues ########################################### job_queue_processes=16 ########################################### # MTS / Shared Server ########################################### #dispatchers="(PROTOCOL=TCP)" #dispatchers="(PROTOCOL=TCP)(DISPATCHERS=1)(MULTIPLEX=ON)" #Sets up the number and type of dispatchers for setting up a shared #large_pool_size=40M #max_dispatchers= 4 #max_shared_servers= 20 #Default #shared_servers= 5 #shared_server_sessions= 200 ########################################### # Miscellaneous ########################################### aq_tm_processes=1 compatible=8.1.7 nls_date_format = DD-MON-RR ########################################### # Optimizer ########################################### optimizer_mode=RULE




########################################### # Optimizer - Cost Based ########################################### #optimizer_mode=cost #parallel_automatic_tuning = true #parallel_adaptive_multi_user = true #parallel_min_servers = 2 #parallel_max_servers = 4 #remote_dependencies_mode = signature ########################################### # PL/SQL ########################################### utl_file_dir = * ########################################### # Processes and Sessions ########################################### processes=512 distributed_transactions = 10 ########################################### # Redo Log and Recovery ########################################### log_checkpoint_interval = 10000 log_checkpoint_timeout=1800 transaction_auditing=false log_buffer=32768 ########################################### # Security and Auditing ########################################### remote_login_passwordfile=EXCLUSIVE os_authent_prefix="" max_enabled_roles=30 ########################################### # SGA Memory ########################################### pre_page_sga=true #lock_sga=true #UNIX ONLY ########################################### # Sort, Hash Joins, Bitmap Indexes ########################################### sort_area_size=2048000 sort_area_retained_size=65536 ########################################### # System Managed Rollback Segments ########################################### rollback_segments=RBS00,RBS01,RBS02,RBS03,RBS04,RBS05,RBS06,RBS07,RBS08,RBS09,RBS10, RBS11, RBS12, RBS13, RBS14,RBS15 ########################################### # Memory for Opera ########################################### shared_pool_reserved_size = 6553600 shared_pool_size = 65536000 db_block_buffers = 2048

1302-opera v2r2-single server install

Documents