Oracle Utilities Meter Data Management Version 2.2.0 (OUAF ...

[Pages:383]Server Administration Guide

Oracle Utilities Meter Data Management Version 2.2.0 (OUAF 4.3.0.3.0)

E80254-01

December 2016

Server Administration Guide, Oracle Utilities Meter Data Management, Version 2.2.0 (OUAF 4.3.0.3.0)

E80254-01

Copyright ? 2007-2016 Oracle. All rights reserved.

Primary Author: Oracle Utilitie Global Business Unit

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

Oracle, JD Edwards, PeopleSoft and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for:

(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.

Table of Contents

Preface.................................................................................................................................... 2

Introduction ......................................................................................................................................................... 2 Updates to This Documentation ...................................................................................................................... 2 Other Documentation ........................................................................................................................................ 2 Whitepapers ........................................................................................................................................................ 3

Architecture ........................................................................................................................... 5

Roles and Features ............................................................................................................................................ 7 Client......................................................................................................................................................................... 7 Web Application Server ......................................................................................................................................... 7 Business Application Server ................................................................................................................................. 8 Database Server ..................................................................................................................................................... 8

Batch Server

............................................................................................................................................ 9

Concepts ...............................................................................................................................12

Environment ...................................................................................................................................................... 12 Environment Identifier .......................................................................................................................................... 12 Server Roles .......................................................................................................................................................... 12

Administration User Id and Group ................................................................................................................ 13 Native Support vs Embedded Support ......................................................................................................... 14 Directory Structure .......................................................................................................................................... 16 Software Directory Structure ......................................................................................................................... 17

Software (splapp) Directory................................................................................................................................. 19 Tools directory....................................................................................................................................................... 21 Directory Permissions .......................................................................................................................................... 22 Output Structure............................................................................................................................................... 22 Environment Variables .................................................................................................................................... 23 Common Application Logs ............................................................................................................................. 25 Automated Backup of Log files ........................................................................................................................... 26

Batch Concepts

................................................................................................................................. 27

Batch Clustering Concepts .................................................................................................................................. 27

Batch Controls ....................................................................................................................................................... 28

Standard parameters............................................................................................................................................ 28

Additional Key Parameters .................................................................................................................................. 30

Batch Run Tree ..................................................................................................................................................... 31

Timed Jobs ............................................................................................................................................................ 31

Level Of Service .................................................................................................................................................... 32

Explanation of Commit Interval ........................................................................................................................... 32

Explanation of Thread Limit and Thread Number ............................................................................................ 33

Explanation of Restart and Rerun ...................................................................................................................... 34

Submission Methods ............................................................................................................................................ 34

Operations ............................................................................................................................. 37

Command Line Utilities ................................................................................................................................... 37

bedit - Batch Edit

................................................................................................................................... 37

buildJavadocsIndex[.sh] - Builds Appviewer java docs................................................................................... 38 configureEnv ? Setup Environment settings..................................................................................................... 39

createDBStandalone[.sh] - Creates Database Patches .................................................................................. 40 extractCMSourceUNIX[.sh] - Migrate Code Across Upgrades ...................................................................... 40

genappvieweritems ? generate AppViewer ...................................................................................................... 41 initialSetup ? Maintain Configuration Settings .................................................................................................. 42

installSFGroup[.sh] - Install Software Patches ................................................................................................. 45

invokeDBUpdatePatch[.sh] - Regenerates passwords in Installation Options ............................................ 45 iwsdeploy - Inbound Web Services Deployment.............................................................................................. 46

jmxbatchclient[.sh] ? JMX batch command line

................................................................................. 46

ouafDatabasePatch[.sh] - Install Database Patches ....................................................................................... 48

PatchDeployUtility[.sh] - Create and Deploy Patch Rollups ........................................................................... 48 showjavaproc[.sh] - Show java processes ........................................................................................................ 49 splenviron ? Set Environment variables ............................................................................................................ 50

spl ? Start/Stop Environment .............................................................................................................................. 52 starttpw[.sh] - Start Threadpoolworker .............................................................................................................. 53

submitjob[.sh] - Submit Batch Threads

.............................................................................................. 53

threadpoolworker[.sh] - Manage Threadpools

.................................................................................... 57

Attaching to an Environment ......................................................................................................................... 59

Starting an Environment ................................................................................................................................. 60

Starting All Tiers on a Single Server .................................................................................................................. 60

Starting/Stopping at Boot Time (UNIX/Linux) ................................................................................................... 61 Stopping an Environment ............................................................................................................................... 64

Stopping All Tiers on a Single Server ................................................................................................................ 65 Starting and Stopping Using consoles ........................................................................................................ 66

Monitoring .............................................................................................................................67

Monitoring Regimes......................................................................................................................................... 67

Monitoring Client Machines............................................................................................................................ 68

Monitoring The Desktop....................................................................................................................................... 68

Client Debug facility.............................................................................................................................................. 69

Monitoring Web/business Application Server ............................................................................................ 71

JMX Based Monitoring .................................................................................................................................... 71

Web Application Server JMX Reference ........................................................................................................... 73

Business Application Server JMX Reference ................................................................................................... 82

Batch JMX Reference

............................................................................................................................ 85

JMX Security.......................................................................................................................................................... 91

Extending JMX Security....................................................................................................................................... 92

Execution Dump Format ...................................................................................................................................... 92

Service Lists .......................................................................................................................................................... 93

Resetting Statistics ............................................................................................................................................... 94

Database Connection Monitoring.................................................................................................................. 94

Probe Transaction............................................................................................................................................ 95

Configuration ........................................................................................................................96

Configuration Files .......................................................................................................................................... 96 application.xml ? ADF Application configuration .............................................................................................. 96 cistab - Global Configuration Files ..................................................................................................................... 96

coherence-cache-config.xml - Oracle Coherence Configuration

................................................. 97

e0Batch.properties - General Batch Properties

.............................................................................. 97

ejb-jar.xml - Enterprise Java Server Beans Configuration.............................................................................. 98

ENVIRON.INI - Environment Configuration File............................................................................................... 98

hibernate.properties - Database Connectivity Settings ................................................................................... 99

log4j.properties ? Product Logging Configuration .......................................................................................... 100

Server Jar File (ouaf_jar_versions.txt)............................................................................................................. 100

spl.properties ? Product Behaviour Settings................................................................................................... 100

submitbatch.properties - Submitter Configuration

........................................................................ 101

tangosol-coherence-override.xml - Coherence Overrides

.......................................................... 101

threadpoolworker.properties - Threadpool Configuration

........................................................... 101

web.xml ? J2EE Deployment Descriptor ......................................................................................................... 101

weblogic.xml ? Oracle WebLogic Extensions ................................................................................................. 102 weblogic-ejb-jar.xml - WebLogic extensions for Enterprise Java Server Beans ....................................... 104 webservices.xml.resource - Web Services configuration ............................................................................. 105 Web Browser Configuration ......................................................................................................................... 105 Web Application Server Configuration....................................................................................................... 107 Caveat .................................................................................................................................................................. 107 Web Application Server Concepts.................................................................................................................... 107 Web Applications ................................................................................................................................................ 108 Web Application Server Configuration Files ................................................................................................... 108 Quick Reference Guide for Web Application Server Configuration............................................................. 113 User Interface Backward Compatibility Settings ............................................................................................ 113 Web Application Server Deployment Process................................................................................................ 114 Business Application Server Configuration .............................................................................................. 116 Business Application Server Concepts............................................................................................................ 117 Business Application Server Configuration Files ........................................................................................... 117 Business Application Server Configuration Process ..................................................................................... 118 Quick Reference Guide for Business Application Server Configuration..................................................... 120 Business Application Server Deployment Process ........................................................................................ 121 Inbound Web Services Configuration ........................................................................................................ 122 Enabling Inbound Web Services ...................................................................................................................... 122 Inbound Web Services Configuration Files..................................................................................................... 124 Inbound Web Services Concepts ..................................................................................................................... 124 Inbound Web Services Configuration Process............................................................................................... 125 Inbound Web Services Deployment Process ................................................................................................. 127 Quick Reference Guide for Inbound Web Services Configuration .............................................................. 129 Inbound Web Services Deployment Utilities................................................................................................... 129

Batch Server Configuration

.......................................................................................................... 130

Batch Configuration Files................................................................................................................................... 130

General Configuration Process......................................................................................................................... 131

Configuring Batch using bedit ........................................................................................................................... 132

Batch Configuration Guidelines ........................................................................................................................ 139

Oracle Cloud Support .................................................................................................................................... 141

Support for host whitelisting .............................................................................................................................. 141

Domain Template Support................................................................................................................................. 143

Diagnostics Support (WLDF) ............................................................................................................................ 144

ECID Support ...................................................................................................................................................... 145

Global Cache Flush Support ............................................................................................................................. 146

Java Flight Recorder Support ........................................................................................................................... 147

Work Manager Support ...................................................................................................................................... 147

Trust Store Support ............................................................................................................................................ 148

Miscellaneous Operations And Configuration...............................................................149

Enabling Email Logging from Log4j ........................................................................................................... 149 Overriding the default Oracle database connection information .......................................................... 150 Cache Management ....................................................................................................................................... 151

Server Cache....................................................................................................................................................... 151 Client Cache ........................................................................................................................................................ 153 Oracle WebLogic: Expanded or Archive Format ...................................................................................... 154 Implementing Custom Templates ............................................................................................................... 155 Additional templates ........................................................................................................................................... 156

Sending emails at the conclusion of batch processs

............................................................... 160

Oracle WebLogic Configuration Support................................................................................................... 162

Using Configuration Files outside the WAR/EAR file .............................................................................. 162

Oracle RAC Support ...................................................................................................................................... 163

Adding a custom Privacy policy screen .................................................................................................... 164

IBM WebSphere/WebSphere ND Support .................................................................................................. 165

User Exit Include Files................................................................................................................................... 167

Properties File User Exits .................................................................................................................................. 171 Custom JMS configuration........................................................................................................................... 172 Online Transaction Timeouts....................................................................................................................... 174 Setting the Date for testing purposes ........................................................................................................ 175 Secure Transactions...................................................................................................................................... 176 Native Oracle WebLogic Support ................................................................................................................ 177

Manual Re-Deployment Process...................................................................................................................... 178 Oracle WebLogic Console Operations ....................................................................................................... 179

Starting and Stopping from console ................................................................................................................. 179 Monitoring Web Applications using the console............................................................................................. 180

Specifying custom log file names

............................................................................................... 181

Turning off L2 Cache

..................................................................................................................... 182

JDBC Support ................................................................................................................................................. 182

Cancelling Batch Processes Using JMX

.................................................................................... 184

Operations from Oracle Enterprise Manager .................................................................185

Discovering Oracle Utilities targets ............................................................................................................ 185 Discovering Oracle WebLogic Targets....................................................................................................... 186 Oracle Utilities Targets.................................................................................................................................. 187 Monitoring using Oracle Enterprise Manager ........................................................................................... 187

Oracle Scheduler Integration ...........................................................................................189

Introduction ..................................................................................................................................................... 189 Background Materials ................................................................................................................................... 189 Oracle Scheduler Interface Overview ......................................................................................................... 189

Oracle Scheduler Configuration........................................................................................................................ 190 Oracle Scheduler Execution.............................................................................................................................. 191 Oracle Scheduler Interface (OUAF_BATCH) ............................................................................................. 191 Submit_Job - Submit a Job or Thread ............................................................................................................. 192 Restart_Thread - Restart a failed thread/job .................................................................................................. 194 Cancel_Job - Cancel a running Job ................................................................................................................. 195 Set_Option - Set a global or Job option........................................................................................................... 195 Unset_Option - Reset a global or Job option.................................................................................................. 197 Raise_Thread_Error - Raise an error .............................................................................................................. 197 Setting Preferences ............................................................................................................................................ 197 Order Of Preference ........................................................................................................................................... 198 Using soft_parm_map ........................................................................................................................................ 198 Using soft_parm_list ........................................................................................................................................... 199 Building a Schedule ....................................................................................................................................... 199 Recommended tools........................................................................................................................................... 200 Defining Programs .............................................................................................................................................. 201 Defining Job Classes.......................................................................................................................................... 202 Defining Schedules............................................................................................................................................. 203 Defining Remote Destinations and Credentials.............................................................................................. 204 Defining Jobs ....................................................................................................................................................... 206 Defining Chains ................................................................................................................................................... 207 Other Scheduler Objects ................................................................................................................................... 208 Executing Jobs ............................................................................................................................................... 209 Monitoring Oracle Scheduler ....................................................................................................................... 209 Job States ............................................................................................................................................................ 209 Dictionary Views.................................................................................................................................................. 209 Scheduler Notifications ...................................................................................................................................... 209 Cancellation .................................................................................................................................................... 210 Exporting Schedules across environments .............................................................................................. 210

Appendices - Parameters..................................................................................................211

Conventions in this section.......................................................................................................................... 211 ENVIRON.INI .................................................................................................................................................... 211

ADDITIONAL_RUNTIME_CLASSPATH - Additional Classpath ................................................................. 211 ADDITIONAL_STOP_WEBLOGIC - Additional Stop Arguments ................................................................ 212 ADF_HOME - Location of ADF Software ........................................................................................................ 212 ANT_ADDITIONAL_OPT - Additional options for ANT ................................................................................. 213 ANT_HOME - Location of ANT ......................................................................................................................... 213 ANT_OPT_MAX - ANT Maximum Heap Size................................................................................................. 213 ANT_OPT_MIN - ANT Minimum Heap Size ................................................................................................... 213 appViewer - Name of appViewer WAR file ..................................................................................................... 214 BATCHDAEMON - Whether Online Batch Daemon is enabled .................................................................. 214 BATCHEDIT_ENABLED - Whether Batch Edit Facility is Enabled ............................................................. 214 BATCHENABLED - Whether Online Batch Server is Enabled .................................................................... 215 BATCHTHREADS - Number of Online Batch Server Threads .................................................................... 215 BATCH_DBPASS - Batch User Password ..................................................................................................... 215 BATCH_DBUSER - Batch User........................................................................................................................ 215 BATCH_MEMORY_ADDITIONAL_OPT - Threadpool Worker JVM additional options........................... 216 BATCH_MEMORY_OPT_MAX - Threadpool Worker Java Maximum Heap Size.................................... 216 BATCH_MEMORY_OPT_MAXPERMSIZE - Threadpool Worker Java Maximum Perm Size ............... 216 BATCH_MEMORY_OPT_MIN - Threadpool Worker Java Minimum Heap Size ...................................... 217 BATCH_MODE - Default Mode of Batch......................................................................................................... 217 BATCH_ONLINE_LOG_DIR - Online Batch Submission Log Directory .................................................... 217 BATCH_RMI_PORT - RMI Port for Batch....................................................................................................... 217 BSN_APP - Business Server Application Name ............................................................................................ 218 BSN_JMX_RMI_PORT_PERFORMANCE - JMX Port for Business Application Server......................... 218 BSN_JMX_SYSPASS - Password for BAS JMX Monitoring ....................................................................... 218 BSN_JMX_SYSUSER - Default User for BSN JMX Monitoring .................................................................. 219 BSN_NODENAME - IBM WebSphere Node Name....................................................................................... 219 BSN_SVRNAME - IBM WebSphere Server Name........................................................................................ 219 BSN_WASBOOTSTRAPPORT - Bootstrap Port ........................................................................................... 219 BSN_WLHOST - Business App Server Host.................................................................................................. 220 BSN_WLS_SVRNAME - Oracle WebLogic Server Name............................................................................ 220 CERT_IDENT_KS_ALIAS - SSL Certificate Keystore Alias......................................................................... 220 CERT_IDENT_KS_FILE - SSL Keystote File ................................................................................................. 221 CERT_IDENT_KS_PWD - SSL Keystore Password..................................................................................... 221 CERT_IDENT_KS_TYPE - SSL Keystore Type ............................................................................................ 221 CERT_INSTALL_SCRIPT - Install SSL Keystore.......................................................................................... 221 CERT_KS - SSL Keystore Type ....................................................................................................................... 222 CERT_TRUST_KS_ALIAS - SSL Trust Alias ................................................................................................. 222 CERT_TRUST_KS_FILE - SSL Trust Keystore File ..................................................................................... 222 CERT_TRUST_KS_PWD - SSL Trust Keystore Password ......................................................................... 223 CERT_TRUST_KS_TYPE - SSL Trust Keystore Type................................................................................. 223 CLOUD_CUSTOM_WHITE_LIST_PATH - Custom URL Whitelists for Cloud.......................................... 223 CLOUD_RESTRICTIONS_URLS_ENABLE - Enable or Disable URL Restrictions ................................. 223 CLOUD_WHITE_LIST_PATH - URL Whitelists for Cloud ............................................................................ 224 CMPDB - Database Type .................................................................................................................................. 224 CM_INSTALL_SAMPLE - Whether samples are installed ........................................................................... 225 COHERENCE_CLUSTER_ADDRESS - Multicast address for Batch Cluster .......................................... 225 COHERENCE_CLUSTER_MODE - Batch Cluster Mode ............................................................................ 225 COHERENCE_CLUSTER_NAME - Batch Cluster Name ............................................................................ 226 COHERENCE_CLUSTER_PORT - Batch Cluster Port Number................................................................. 226 CONTEXTFACTORY - Context Factory for Mobile Application .................................................................. 226 DBCONNECTION - JDBC Connection string ................................................................................................. 227 DBDRIVER - Database Driver .......................................................................................................................... 227 DBNAME - Database Name.............................................................................................................................. 227 DBPASS - Online Database User Password.................................................................................................. 228 DBPASS_GEOCODE_WLS - GEOCODE Database Password ................................................................. 228

DBPASS_MDS - MDS Database Password ................................................................................................... 228 DBPASS_ORASDPM - DPM Database Password........................................................................................ 229 DBPASS_OSB - OSB Database Password.................................................................................................... 229 DBPASS_SOAINFRA - SOA Database Password........................................................................................ 229 DBPORT - Database Listener Port .................................................................................................................. 230 DBSERVER - Database Server ........................................................................................................................ 230 DBURL_GEOCODE - GEOCODE JDBC URL............................................................................................... 231 DBURL_OSB - OSB JDBC URL ...................................................................................................................... 231 DBURL_SOA - SOA Suite JDBC URL ............................................................................................................ 231 DBUSER - Online Database User.................................................................................................................... 231 DBUSER_GEOCODE - GEOCODE Database User .................................................................................... 232 DBUSER_MDS - SOA MDS Database User .................................................................................................. 232 DBUSER_ORASDPM - DPM Database User ................................................................................................ 232 DBUSER_OSB - OSB Database User ............................................................................................................ 233 DBUSER_SOAINFRA - SOA Database User ................................................................................................ 233 DB_OVERRIDE_CONNECTION - Custom JDBC URL ................................................................................ 234 DESC - Environment Description ..................................................................................................................... 234 DIALECT - Hibernate Dialect ............................................................................................................................ 234 DIRSEP - Directory separator ........................................................................................................................... 235 DOC1BILLSCRIPT - Name Of External Print Script...................................................................................... 235 DOC1SCRIPT - Name Of Generic Print Script .............................................................................................. 235 ENCODING - Whether Encryption Is Enabled ............................................................................................... 236 ENVIRONMENT_ID - Environment Identifier ................................................................................................. 236 FW_VERSION - Oracle Utilities Application Framework version ................................................................ 236 FW_VERSION_NUM - Oracle Utilities Application Framework Version Identifier .................................... 237 GIS - GIS Support............................................................................................................................................... 237 GIS_URL - GIS Service URL ............................................................................................................................ 238 GIS_WLSYSPASS - GIS WebLogic System Password ............................................................................... 238 GIS_WLSYSUSER - GIS WebLogic System User Id.................................................................................... 238 GLOBAL_JVMARGS - Additional JVM Arguments ....................................................................................... 239 help - Name of online help WAR file ................................................................................................................ 239 HEADEND_CD_CB - Headend System URI for SOA Configuration Plan (CD_CB) ................................ 239 HEADEND_MR_CB - Headend System URI for SOA Configuration Plan (MR_CB) ............................... 240 HIBERNATE_JAR_DIR - Location of Hibernate JAR files ........................................................................... 240 HIGHVALUE - Language specific highvalues ................................................................................................ 240 IWS_JDBC_NAME - JNDI Name for the IWS Connection pools ................................................................ 241 IPCSTARTPORT - Starting IPC Port for Scheduler ...................................................................................... 241 IWSWAR - Name of Inbound Web Services WAR ........................................................................................ 241 JAVAENCODING - Java Language Encoding ............................................................................................... 242 JAVA_HOME - Location of Java SDK ............................................................................................................. 242 JAVA_VENDOR - Java Vendor ........................................................................................................................ 242 JAVA_VERSION - JVM Version string ............................................................................................................ 242 JAVA_VERSION_MAIN - Abberviated JVM Version .................................................................................... 243 JDBC_NAME - JNDI Name for the Online JDBC Data Source ................................................................... 243 JNDI_GEOCODE - Geocode Data Source JNDI ........................................................................................... 243 JNDI_OSB - OSB Data Source JNDI............................................................................................................... 244 JVM_ADDITIONAL_OPT - Child JVM additional Options ............................................................................ 244 JVMCOMMAND - Generated Child JVM Command ..................................................................................... 244 JVMMEMORYARG - Child JVM Memory Allocation ..................................................................................... 245 KS_ALIAS - Key Alias ........................................................................................................................................ 245 KS_ALIAS_KEYALG - Key Algorithm .............................................................................................................. 245 KS_ALIAS_KEYSIZE - Keysize........................................................................................................................ 246 KS_HMAC_ALIAS - HMAC Key Alias ............................................................................................................. 246 KS_HMAC_ALIAS_KEYALG - HMAC Key Algorithm ................................................................................... 246 KS_HMAC_ALIAS_KEYSIZE - HMAC Keysize ............................................................................................. 246 KS_KEYSTORE_FILE - Keystore File Name................................................................................................. 247 KS_MODE - Key Padding Mode ...................................................................................................................... 247

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download