Download 8.12 Install Win Oracle PDF

Title8.12 Install Win Oracle
File Size3.7 MB
Total Pages428
Table of Contents
                            Chapter 1. Understanding JD Edwards EnterpriseOne
	Understanding This Guide
	Understanding the Installation Process
		Understanding the Deployment Server Installation
		Understanding the Platform Pack Installation
		Understanding the Installation Planner
		Understanding Installation Workbench
		Understanding Data Configuration Workbench
		Understanding the Workstation Installation
	Considering Additional Factors
		Accessing Minimum Technical Requirements
		Using JD Edwards EnterpriseOne Support
		Understanding Documentation Conventions
			Documentation Updates
			Tips
			Fonts and Type Styles
			Hyperlinks
	Working With the Customer Checklist
	Environments Overview
		Understanding Environments
		Planner Environment (JDEPLAN)
			Planner Pathcode
			Planner Database
		Pristine Environment (PS812)
		Deployment Environment (DEP812)
		Development Environment (DV812)
		Prototype Environment (PY812)
		Production Environment (PD812)
		Additional Considerations
			Push Installation
			Cluster Software Options
			Web-Based Options
		Release History
	Language Process Overview
		Language Architecture
			Base Language
			Alternate Language Components
			Language Preference Codes
		Database Character Set and Code Page Considerations
			Unicode
			Code Page Settings
				Oracle Code Page Settings
				Workstations and Deployment Server
		National Language Support
			Single-Byte and Double-Byte Considerations
			Font Considerations
			User Display Preferences
Chapter 2. Before You Begin the Installation
	Verifying Software and Hardware Requirements
	Verifying the Disk Space Requirements
Chapter 3. Working with the Deployment Server
	Installing the Deployment Server
	Downloading and Installing the Latest Software
		Installing the Latest Tools Release and Latest Tools Release Patch to the Deployment Server
		Installing JDBC Drivers for SQL Server 2000
		Installing the Latest Planner Update
	Troubleshooting Deployment Server Installation
Chapter 4. Working with the Platform Pack
	Understanding the Platform Pack
	Configuring the Enterprise Server Prior to Installing the Platform Pack
		Setting Up NLS_LANG Parameter for Oracle
		Enabling Remote Connections for Oracle
		Setting Up and Verifying the Hosts File
	Special Consideration for Oracle 11g on Windows
	Verifying Code Page Settings for Oracle
	Understanding the Platform Pack Installation
	Installing the Platform Pack
		Running the JD Edwards EnterpriseOne Platform Pack Installer
		Custom Mode Feature Selection
		Database Options
		Oracle - Enterprise Server and Database Server (Loaded onto Same Machine Simultaneously) - or Database only
		Oracle - Enterprise Server Only (Different Machine from Database Server)
		Review the Legacy Database Warning Panel
		Concurrent Users
		Review the Summary Information Panel and Complete the Installation
		Verifying the Platform Pack Log File
	Troubleshooting Platform Pack Installation
		Installer Will Not Start or Complete (Invalid vpd.properties)
		Business Data and Control Tables Already Exist
		Business Data and Control Tables Do Not Exist
		Business Data or Control Tables Tablespaces Reported As Existing When They Do Not Exist
		System Database Not Detected
		Foundation Files Do Not Exist
	Rerunning the JD Edwards EnterpriseOne Platform Pack Installer
		Enterprise Server
		Database Server
	Installing the Latest Tools Release and Latest Tools Release Patch to the Enterprise Server
	Working with Database Security
Chapter 5. Working with Installation Planner
	Understanding Installation Planner
		Language Information
		Location Information
		Deployment Server Information
		Enterprise Server Information
		JD Edwards EnterpriseOne HTML Web Server Information
		Data Source Information
		Environment Information
	Working with JD Edwards EnterpriseOne Software Requirements
	Reviewing Installation Planner Processing Options
		Assumptions About Reviewing Installation Planner Processing Options
		Accessing Processing Options
		Choosing Processing Option Values
			Specifying the Prompt Mode
			Specifying the Process Mode
			Specifying the Default Mode
			Verifying Status Change Values Have Not Changed
			Specifying Plan Completion Processes
			Specifying Replication Options
			Specifying Remote Location Package Push Options
	Working with a Typical Installation Plan
		Assumptions About Defining a Typical Installation Plan
		Starting Installation Planner
		Entering a Plan Description
		Entering Location Information
		Entering Deployment Server Information
		Entering Enterprise Server Information
		Entering HTML Web Server Information
		Selecting Default Environments
		Finalizing the Installation Plan
		Concluding the Planner Validation Report
	Creating a Custom Installation Plan
		Understanding a Custom Installation Plan
		Starting Installation Planner
		Entering a Plan Description
		Entering Location Information
		Entering Deployment Server Information
		Entering Enterprise Server Information
		Enter Data Source Information for Server Map
		Entering HTML Web Server Information
		Entering Data Server Information
		Entering Shared Data Source Information
			Specifying (Custom or Default) Shared Data Source Setup Information
				Verifying the Data Source for Data Dictionary
				Verifying the Object Librarian Data Source
				Verifying the System Data Source
		Working with Environment Setup
			Understanding Environment Setup
			Setting Up Environments
				Adding a Custom Environment
				Selecting an Environment
				Specifying Environment Data Load Parameters
				Selecting Languages
			Working with Environment Data Sources
				Understanding Environment Data Sources
				Selecting an Environment Data Source Setup Option
				Setting Up the Data Source for Business Data
				Setting Up the Data Source for Central Objects
				Setting Up the Data Source for Control Tables
				Verifying the Data Dictionary Data Source
				Verifying the Data Source for Versions
		Adding a Remote Location
		Finalizing the Installation Plan
		Concluding the Validation Planner Report
	Deleting Machines from an Installation Plan
Chapter 6. Working With Installation Workbench
	Understanding Workbench Components
		Verifying the Network Share on the Deployment Server
		Loading Data (Demo Data and Production Data)
		Creating the Job Queue
	Working with Unattended Workbench Mode
		Selecting Attended or Unattended Workbench Mode
		Setting a Task Break in Unattended Workbench Mode
	Starting Installation Workbench
	Working With Initial Tasks Workbench
		Changing the Status of Initial Tasks Workbench
	Configuring Your Locations
	Configuring Your Data Sources
	Configuring Your Environments
	Using Machine Workbench
	Using the Package Workbench
	Using Remote Location Workbench
		Configuring Remote Locations
	Finishing Installation Workbench
	Updating Oracle Database Statistics
Chapter 7. Working With Data Configuration Workbench
	Understanding Data Configuration Workbench
		Data Configuration Process
		Components and Tables that are Updated by Data Configuration Workbench
	Adding a Data Configuration Plan
	Running a Data Configuration Plan
	Troubleshooting Data Configuration Workbench Installation
Chapter 8. Working With the Enterprise Server
	Verifying the Release 8.12 Enterprise Server Installation Using PORTTEST
	Starting Network Services on the Enterprise Server
	Stopping Network Services on the Enterprise Server
	Working with OCM Generation
		Understanding OCM Mappings
		Understanding Data Source Setup
		Understanding OCM Creation
			Understanding Database Data Sources
			Understanding Logic Data Sources
		Understanding OCM Customization
			Understanding Data Classes
			Creating a New Data Class
			Modifying the Data Source Template
			Associating Table Data Classes
	Setting Up a Printer on the Enterprise Server
		Adding a New Printer
		Defining a Default Printer
Chapter 9. Installing the Workstations for Developers and System Administrators
	Understanding Workstation Installation
	Preparing for Workstation Installation
	Understanding Workstation Installation
		Understanding Workstation Installation Methods
			Working with Interactive Mode
				Creating a Desktop Shortcut
				Using a Shared Drive
			Working with Silent Mode
			Working with Push Mode
		Understanding Third-Party Products
	Understanding User Profiles and Languages
	Working with the Workstation JDE.INI on the Deployment Server
		Understanding the Workstation JDE.INI on the Deployment Server
		Modifying the Workstation JDE.INI on the Deployment Server
Chapter 10. Understanding Media Object Queues
	Modifying Media Object Queues
	Specifying the Help Location
Chapter 11.  Performing Post Installation Tasks
	Understanding Post Installation Tasks
	Setting Up Microsoft Windows Security on Release 8.12 Directories
		Setting Security on the Files within the Client Directory
		Setting Security on the Pathcode Directory
		Setting Security on the Database Directory
		Setting Security on the Data Dictionary Directory
		Setting Security on the Helps Directory
		Setting Security on the Media Object Directory
		Setting Security on the Planner Directory
		Setting Security on the Print Queue Directory
		Setting Security on the System Directory
	Using the Adobe SVG Viewer on Web Clients
	Understanding Task Word Search Tables
		Building Task Word Search Tables
	Setting Up Solution Explorer
		Setting Up Solution Explorer HTML Documentation Path
		Setting Up the Home Page for Solution Explorer
	Configuring JD Edwards EnterpriseOne for Use with Vertex Quantum Tax Applications
		Adding Vertex Quantum Directory Information to the Microsoft Windows Server Path
		Configuring the Release 8.12 Database Connections for Vertex Quantum Tax Applications
		Mapping Objects to the Enterprise Server
		Understanding the Autopilot Scripting Tool
			Configuring Autopilot for the Oracle Database
		Testing the Vertex Quantum Connection from Release 8.12
	Enabling CRM Functionality
		Enabling CRM on the CRM Mobile Client
		Enabling CRM on the Enterprise Server
Chapter 12. Working With Signon Security
	Setting Up Signon Security
	Setting up Security Overrides for Package Build
	Enabling Server-Side Signon Security
	Enabling Client-Side Signon Security
	Setting Up JD Edwards EnterpriseOne Single Sign-on
Chapter 13.  Building and Testing Packages
	Understanding Packages
	Installing Application Fixes
	Updating the System Path
	Reviewing Pre-Package Build Issues
		Verifying Available Space in DBMS
		Verifying Specific UBEs are Mapped Locally
		Verifying the OCM Mapping
		Deleting the BUSOBJ Directories
		Verifying the F9631 Table
		Verifying the Server-Side Settings
		Configuring the Enterprise Server for Simultaneous Builds
		Adding a Security Override for Running Package Build
			Adding a System User for the Central Objects Data Source Owner
			Adding an Override for an EnterpriseOne User Running Package Build
	Reviewing Troubleshooting Tips
		User Tips
		Deployment Tips
	Building an Alternate Language Package
		Package Build Considerations
		Package Deployment Considerations
Chapter 14. Installation Utilities
	Revalidating Software Protection Codes
		Revalidating the Deployment Server
		Revalidating Workstations
	Granting Disk and Registry Access for Microsoft Windows Workstations
		Granting Non-Privileged Access to Disk for Microsoft Windows
		Granting Access to the Software Installation Directory
		Granting Nonprivileged Access to the Microsoft Windows Registry
Chapter 15. Troubleshooting
	Using the PORTTEST Checklist
	Resolving Data Errors
	Planner Update Special Instructions
		Special Instructions for All
		Special Instructions for OCX Registration
	Orphan Users
Chapter 16. Creating a Remote Installation Plan
	Understanding Remote Installation Plans
	Starting Installation Planner
	Entering Information in Installation Planner
	Entering Plan Location Information
	Specifying a Deployment Server
		Entering Deployment Server Information
		Concluding Deployment Server Setup
	Specifying an Enterprise Server
		Entering Enterprise Server Information
		Entering Enterprise Server Data Source Information
			Specifying Custom or Default Data Source Information
			Entering the Oracle Connect String
			Verifying Custom Server Map Source Information
			Adding Another Enterprise Server
	Entering HTML Web Server Information
	Entering Data Server Information
	Entering Shared Data Source Information
		Specifying (Custom or Default) Shared Data Source Setup Information
		Verifying the Data Dictionary Data Source
		Verifying the Object Librarian Data Source
		Verifying the System Data Source
	Setting Up Environments
		Environments
		Adding a Custom Environment
		Selecting an Environment
	Replicating Information to Remote Locations
	Setting Up Data Sources for Environment
		Beginning the Data Source Setup for Environment
		Setting up the Data Source for Business Data
		Verifying the Data Source for Control Tables
		Select Another Environment
	Concluding the Remote Installation Plan Setup
	Finalizing the Installation Plan
	Concluding the Validation Planner Report
Chapter 17. Adding a Server to an Existing Configuration
	Assumptions about Adding a Server to an Existing Installation Plan
	Starting Installation Planner
	Entering a Plan Description
	Entering a Plan Location
	Selecting Additional Server Types
	Entering Deployment Server Information
	Specifying an Enterprise Server
		Entering Enterprise Server Information
		Entering Enterprise Server Data Source Information
			Specifying Custom or Default Data Source Information
			Entering the Oracle Connect String
			Verifying Custom Server Map Data Source Information
			Adding another Enterprise Server
	Entering HTML Web Server Information
	Entering Data Server Information
	Entering Shared Data Source Information
		Specifying (Custom or Default) Shared Data Source Setup information
		Verifying the Data Dictionary Data Source
		Verifying the Object Librarian Data Source
		Verifying the System Data Source
	Setting Up Environments
		Adding a Custom Environment
		Selecting an Environment
		Specifying Environment Data Load Parameters
		Selecting Languages
	Setting Up Environment Data Sources
		Selecting an Environment Data Source Setup Option
		Setting Up the Data Source for Business Data
		Setting Up the Data Source for Central Objects
		Setting Up the Data Source for Control Tables
		Verifying the Data Source for Versions
	Finalizing the Installation Plan
	Concluding the Validation Planner Report
	Configuring Additional Servers
Chapter 18. Creating a Language-Only Installation Plan
	Understanding Language-Only Installation Plans
	Reviewing Requirements for a Language Installation
	Installing Languages on the Deployment Server
	Running Installation Planner
		Accessing Installation Planner
		Entering Information into Installation Planner
		Selecting Custom or Default Parameters
		Selecting an Environment
	Selecting a Language
	Running Installation Workbench
	Verifying Enterprise Server Requirements
	Verifying Workstation Requirements
	Completing the Language Installation
	Building and Deploying Alternate Language Packages
Chapter 19. Understanding JD Edwards EnterpriseOne Directory Structures
	Deployment Server Directory Structure
	Language Directory Structure
	Enterprise Server Directory Structure
	Workstation General Directory Structure
Chapter 20. Understanding Data Source Charts
	Business Data
	Central Objects
	Control Tables
	Data Dictionary
	Logic
	Object Librarian
	Language
	Local
	Server Map
	System
	Versions
Chapter 21. Major Technical Tables
Chapter 22. Working with Reports
	Installation Planner Validation Report (R9840B)
		Setting Processing Options
		How to Read the Report
	Environment Database Creation Report (R98403)
		Setting Processing Options
			Version XJDE0001 for Installations and Upgrades
			Version XJDE0004 for Updates
			Version XJDE0024 for Running Pristine Data
			How to Read the Report
			Errors and How to Resolve Them
	Index Recreation (R9698713)
	Pathcode Copy (R9800942)
Chapter 23. Uninstalling the Software
	Understanding the Uninstallation Process
	Uninstalling the Software from the Workstations
	Uninstalling the Deployment Server
	Dropping Oracle Tablespaces and Indexes
	Removing Database Users for Oracle
	Uninstalling the Platform Pack
Appendix A: Using Instcat.sql to Support MSDE ODBC
	Running the instcat.sql SQL Script
                        
Document Text Contents
Page 215

Chapter 11. Performing Post Installation Tasks
This section contains these tasks:

• Understanding Post Installation Tasks

• Setting Up Microsoft Windows Security on Release 8.12 Directories

• Using the Adobe SVG Viewer on Web Clients

• Understanding Task Word Search Tables

• Setting Up Solution Explorer

• Configuring JD Edwards EnterpriseOne for Use with Vertex Quantum Tax Applications

• Enabling CRM Functionality

Understanding Post Installation Tasks
You must modify specific applications after finishing the installation process. You should perform special in-
structions as described in the Application Special Instructions Guide located on Customer Connection.

Copyright © 2008, Oracle. All rights reserved. GA.Rev8 1/7/2008 203

Page 427

Appendix A: Using Instcat.sql to Support MSDE ODBC
You must run the instcat.sql SQL script against the master MicroSoft Database Engine (MSDE) database
on your Deployment Server.

The instcat.sql SQL script runs stored procedures against your MSDE database instance in order to bring
them to the most current level.

Refer to the detailed procedures provided by Microsoft on their web site. Reference the following Knowledge
Base article:

• How to Run INSTCAT.SQL

Using the following navigation at the Microsoft web site:

MSDN Home > MSDN Library > Enterprise Development > Windows Server System > Microsoft SQL
Server > Microsoft SQL Server 2000 > ODBC > Configuring the SQL Server ODBC Driver (ODBC)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_6_odbcht_9ylw.asp

Running the instcat.sql SQL Script
The instcat.sql SQL script is supplied by your installation of the latest version of SQL Server or Microsoft
Data Access Component (MDAC). The Microsoft articles referenced above provide the operational theory and
requirements for running the instcat.sql SQL script.

Caution

As recommend by Microsoft, you must not have any open connections to the MSDE database when run-
ning the instcat.sql SQL script. You should sign off from EnterpriseOne and close SQL Server
Enterprise Manager.

Use this command line to call the instcat.sql SQL script.

ISQL -Usa -Psa_password -Sserver_name -ilocation\Instcat.sql

where –U specifies the UsereID, and
where –P specifies the corresponding password, and
where -S specifies the Server name of the SQL server, and
where -i specifies the full path to the instcat.sql file, and
optionally where –E specifies the integrated logic to the SQL Server database.

Note

The server name switch (-S) may also include the instance name.

For example, Server_name\instance_name.

Copyright © 2008, Oracle. All rights reserved. GA.Rev8 1/7/2008 415

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_6_odbcht_9ylw.asp

Similer Documents