HOME
SEARCH
BLOG
SCRIPTS
CONTACT
SEARCH
SEARCH
Disclaimer:
Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
×
BOOK ORACLE APPLICATIONS DBA FIELD GUIDE
DOWNLOAD
SUMMARY
Items Found:
346
Introduction
CHAPTER 1 Components and Architecture of Oracle Applications
Servicing User Requests—Oracle Applications Components
Client
Web Node
Forms Node
Concurrent Processing Node
Admin Node
Database Node
Oracle Applications Architecture
Fundamental Architecture
Advanced Architecture
Architecture Best Practices
CHAPTER 2 Configuration
The Application Context File
Locating and Creating the Application Context File
Modifying the Application Context File
Creating a Port Numbering Convention
Identifying Nodes with Context Parameters
Using AD Configuration
Executing AD Configuration
Reviewing adconfigsh Log Files
Reviewing adconfigsh Execution Changes
Location of adconfigsh Backup Files
Adding Customizations to the Application Configuration Files
Web Node Configuration
Apache Configuration Files
JServ Configuration Files
Forms Node Configuration
Basic Configuration
Forms Metric Server and Forms Metric Client
Concurrent Processing Node Configuration
Basic Configuration
Configuring the Report Review Agent (FNDFS)
Admin Node Configuration
Application Environment Files
Administering the identityobj File
Administering the Database Connection File
Configuring Generic Service Management
Additional Service Components
TCF Socket
Discoverer Server
Fulfillment Server
Database Node Configuration
Database Initialization File
Reviewing Database Initialization Parameters
Database Network Configuration
Oracle Applications Tablespace Model
Creating Custom Database Objects
Additional Configuration Topics
Configuration Wizards
License Manager
Configuring Password Security
Miscellaneous Configuration
Configuration Best Practices
CHAPTER 3 Monitoring and Troubleshooting
Methods for Monitoring
Database Monitoring and Troubleshooting
Database Log Files
Database Availability
Session Monitoring
Storage Monitoring
Apache Server Monitoring and Troubleshooting
Apache Log Files
Apache Availability
Troubleshooting iAS Configuration
Testing Java Servlet Configuration
Monitoring the JVM Pool
Forms Monitoring and Troubleshooting
Using OAM
Monitoring Forms Dump Files
Concurrent Manager Monitoring
Monitoring Concurrent Manager Log Files
Reviewing Active Concurrent Requests
Monitoring Pending Concurrent Requests
Canceling Active Concurrent Requests
Monitoring Concurrent Request Run Times
vi
Server Monitoring and Troubleshooting
Server Availability
Server CPU Utilization
Server Memory Utilization
Server Filesystem Usage
Network Monitoring
Using ping and tracert for Network Monitoring
Performing a Network Test from the Application
Additional Monitoring and Troubleshooting Topics
Monitoring Profile Changes
Monitoring System Backups
Resolving JInitiator Issues
Monitoring and Troubleshooting Best Practices
CHAPTER 4 Performance Tuning
Performance Tuning Process
Identifying Performance Issues
Developing an Action Plan
Tools for Resolving Performance Issues
Tuning the Database
Tuning the Server
Tuning the Application Tier
User Tuning
Trace Files
Additional Tuning Considerations
Common Performance Issues
Performance Tuning Best Practices
CHAPTER 5 Patching
Applications Patching
Types of Application Patches
Preparing to Patch
Applying Patches
Monitoring and Resolving Patching Problems
Post-Patching Steps
Patching Cleanup
Database Patching
Patching Best Practices
CHAPTER 6 Toolkit
Oracle Applications Utilities and Commands
Application Component Startup and Shutdown Scripts
Changing Application, Oracle, and the APPLSYS/APPS
Passwords
Relinking Application Executables
Regenerating Forms, Libraries, and Menus
Recompiling JSP Pages
Determining Component Versions
Identifying Application File Versions
JInitiator Version
Apache Version and Rollup Patch
Forms and PL/SQL Version
Oracle Applications Framework Version
OJSP Version
JDK Version
Java Class File Versions
Database Version Query
Additional Commands and Usage Tips
General Tips
Using chown
Using chmod
Using kill
Using find
Using df
Using du
Using tar
Finding and Removing Memory Segments and Semaphores
Finding and Removing Print Jobs
Removing Database Sessions
Scheduling Scripts
Using crontab
Scheduling and Monitoring Tools
Preventative Maintenance
Gathering Statistics
Recompiling Invalid Objects
Rotating Log Files
Rebuilding Indexes
Stopping and Restarting the Apache Server
Purging Concurrent Requests
Purging Workflow History
Purging and Archiving Data
Application Instance Clones
Using Rapid Clone
Cloning Cleanup
CHAPTER 7 Resources
Working with Oracle Support
MetaLink Search Techniques
Oracle Support Service Requests
User Communities and Conferences
User Groups
Conferences
Online Resources
Oracle Web Site
Additional Community Resources
Books and Periodicals
Books
Periodicals
Final Thoughts
Introduction
CHAPTER 1 Components and Architecture of Oracle Applications
Servicing User Requests—Oracle Applications Components
Client
Web Node
Forms Node
Concurrent Processing Node
Admin Node
Database Node
Oracle Applications Architecture
Fundamental Architecture
Advanced Architecture
Architecture Best Practices
CHAPTER 2 Configuration
The Application Context File
Locating and Creating the Application Context File
Modifying the Application Context File
Creating a Port Numbering Convention
Identifying Nodes with Context Parameters
Using AD Configuration
Executing AD Configuration
Reviewing adconfigsh Log Files
Reviewing adconfigsh Execution Changes
Location of adconfigsh Backup Files
Adding Customizations to the Application Configuration Files
Web Node Configuration
Apache Configuration Files
JServ Configuration Files
Forms Node Configuration
Basic Configuration
Forms Metric Server and Forms Metric Client
Concurrent Processing Node Configuration
Basic Configuration
Configuring the Report Review Agent (FNDFS)
Admin Node Configuration
Application Environment Files
Administering the identityobj File
Administering the Database Connection File
Configuring Generic Service Management
Additional Service Components
TCF Socket
Discoverer Server
Fulfillment Server
Database Node Configuration
Database Initialization File
Reviewing Database Initialization Parameters
Database Network Configuration
Oracle Applications Tablespace Model
Creating Custom Database Objects
Additional Configuration Topics
Configuration Wizards
License Manager
Configuring Password Security
Miscellaneous Configuration
Configuration Best Practices
CHAPTER 3 Monitoring and Troubleshooting
Methods for Monitoring
Database Monitoring and Troubleshooting
Database Log Files
Database Availability
Session Monitoring
Storage Monitoring
Apache Server Monitoring and Troubleshooting
Apache Log Files
Apache Availability
Troubleshooting iAS Configuration
Testing Java Servlet Configuration
Monitoring the JVM Pool
Forms Monitoring and Troubleshooting
Using OAM
Monitoring Forms Dump Files
Concurrent Manager Monitoring
Monitoring Concurrent Manager Log Files
Reviewing Active Concurrent Requests
Monitoring Pending Concurrent Requests
Canceling Active Concurrent Requests
Monitoring Concurrent Request Run Times
vi
Server Monitoring and Troubleshooting
Server Availability
Server CPU Utilization
Server Memory Utilization
Server Filesystem Usage
Network Monitoring
Using ping and tracert for Network Monitoring
Performing a Network Test from the Application
Additional Monitoring and Troubleshooting Topics
Monitoring Profile Changes
Monitoring System Backups
Resolving JInitiator Issues
Monitoring and Troubleshooting Best Practices
CHAPTER 4 Performance Tuning
Performance Tuning Process
Identifying Performance Issues
Developing an Action Plan
Tools for Resolving Performance Issues
Tuning the Database
Tuning the Server
Tuning the Application Tier
User Tuning
Trace Files
Additional Tuning Considerations
Common Performance Issues
Performance Tuning Best Practices
CHAPTER 5 Patching
Applications Patching
Types of Application Patches
Preparing to Patch
Applying Patches
Monitoring and Resolving Patching Problems
Post-Patching Steps
Patching Cleanup
Database Patching
Patching Best Practices
CHAPTER 6 Toolkit
Oracle Applications Utilities and Commands
Application Component Startup and Shutdown Scripts
Changing Application, Oracle, and the APPLSYS/APPS
Passwords
Relinking Application Executables
Regenerating Forms, Libraries, and Menus
Recompiling JSP Pages
Determining Component Versions
Identifying Application File Versions
JInitiator Version
Apache Version and Rollup Patch
Forms and PL/SQL Version
Oracle Applications Framework Version
OJSP Version
JDK Version
Java Class File Versions
Database Version Query
Additional Commands and Usage Tips
General Tips
Using chown
Using chmod
Using kill
Using find
Using df
Using du
Using tar
Finding and Removing Memory Segments and Semaphores
Finding and Removing Print Jobs
Removing Database Sessions
Scheduling Scripts
Using crontab
Scheduling and Monitoring Tools
Preventative Maintenance
Gathering Statistics
Recompiling Invalid Objects
Rotating Log Files
Rebuilding Indexes
Stopping and Restarting the Apache Server
Purging Concurrent Requests
Purging Workflow History
Purging and Archiving Data
Application Instance Clones
Using Rapid Clone
Cloning Cleanup
CHAPTER 7 Resources
Working with Oracle Support
MetaLink Search Techniques
Oracle Support Service Requests
User Communities and Conferences
User Groups
Conferences
Online Resources
Oracle Web Site
Additional Community Resources
Books and Periodicals
Books
Periodicals
Final Thoughts