Oracle Metalink Notes for Oracle Apps DBAs.

Dear Friends,

Here are the list of Oracle Metalink Notes, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you.

Note: You have to have an account in Oracle Metalink to access notes.

Installation

Note: 452120.1 - How to locate the log files and troubleshoot RapidWiz for R12
Note: 329985.1 - How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higher
Note: 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management
Note: 312731.1 - Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 279956.1 - Oracle E-Business Suite Release 11i with 9i RAC: Installation and Configuration using AutoConfig
Note: 294932.1 - Recommendations to Install Oracle Applications 11i
Note: 403339.1 - Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
Note: 455398.1 - Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i
Note: 402311.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows
Note: 405565.1 - Oracle Applications Release 12 Installation Guidelines

AD Utilities

Note: 178722.1 - How to Generate a Specific Form Through AD utility ADADMIN
Note: 109667.1 - What is AD Administration on APPS 11.0.x ?
Note: 112327.1 - How Does ADADMIN Know Which Forms Files To Regenerate?
Note: 136342.1 - How To Apply a Patch in a Multi-Server Environment
Note: 109666.1 - Release 10.7 to 11.0.3 : What is adpatch ?
Note: 152306.1 - How to Restart Failed AutoInstall Job
Note: 356878.1 - How to relink an Applications Installation of Release 11i and Release 12
Note: 218089.1 - Autoconfig FAQ
Note: 125922.1 - How To Find Oracle Application File Versions

Cloning

Note: 419475.1 - Removing Credentials from a Cloned EBS Production Database
Note: 398619.1 - Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
Note: 230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone
Note: 406982.1 - Cloning Oracle Applications Release 12 with Rapid Clone
Note: 364565.1 - Troubleshooting RapidClone issues with Oracle Applications 11i
Note: 603104.1 - Troubleshooting RapidClone issues with Oracle Applications R12
Note: 435550.1 - R12 Login issue on target after cloning
Note: 559518.1 - Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
Note: 216664.1 - FAQ: Cloning Oracle Applications Release 11i

Patching

Note: 225165.1 - Patching Best Practices and Reducing Downtime
Note: 62418.1 - PATCHING/PATCHSET FREQUENTLY ASKED QUESTIONS
Note: 181665.1 - Release 11i Adpatch Basics
Note: 443761.1 - How to check if a certain Patch was applied to Oracle Applications instance?
Note: 231701.1 - How to Find Patching History (10.7, 11.0, 11i)
Note: 60766.1 - 11.0.x : Patch Installation Frequently Asked Questions
Note: 459156.1 - Oracle Applications Patching FAQ for Release 12
Note: 130608.1 - AdPatch Basics
Note::60766.1 - Patch Installation FAQ (Part 1)

Upgrade

Note: 461709.1 - Oracle E-Business Suite Upgrade Guide - Plan
Note: 293166.1 - Previous Versions of e-Business 11i Upgrade Assistant FAQ
Note: 224875.1 - Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note: 224814.1 - Installation, Patching & Upgrade Current Issues
Note: 225088.1 - Installation, Patching & Upgrade Patches Guide
Note: 225813.1 - Installation, Patching & Upgrade Setup and Usage Guide
Note: 224816.1 - Installation, Patching & Upgrade Troubleshooting Guide
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 362203.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note: 423056.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.2)
Note: 726982.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.3)
Note: 452783.1 - Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
Note: 406652.1 - Upgrading Oracle Applications 11i DB to DB 10gR2 with Physical Standby in Place
Note: 316365.1 - Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions
Note: 418161.1 - Best Practices for Upgrading Oracle E-Business Suite

Printer

Note: 297522.1 - How to investigate printing issues and work towards its resolution ?
Note: 110406.1 - Check Printing Frequently Asked Questions
Note: 264118.1 - Pasta Pasta Printing Setup Test
Note: 200359.1 - Oracle Application Object Library Printer Setup Test
Note: 234606.1 - Oracle Application Object Library Printer Initialization String Setup Test
Note: 1014599.102 - Subject: How to Test Printer Initialization Strings in Unix

Performance

Note: 390137.1 - FAQ for Collections Performance
Note: 216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
Note: 169935.1 - Troubleshooting Oracle Applications Performance Issues
Note: 171647.1 - Tracing Oracle Applications using Event 10046
Note: 153507.1 - Oracle Applications and StatsPack
Note: 356501.1 - How to Setup Pasta Quickly and Effectively
Note: 333504.1 - How To Print Concurrent Requests in PDF Format
Note: 356972.1 - 11i How to troubleshoot issues with printers

Others

Note: 189367.1 - Best Practices for Securing the E-Business Suite
Note: 403537.1 - Best Practices For Securing Oracle E-Business Suite Release 12
Note: 454616.1 - Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2
Note: 394692.1 - Oracle Applications Documentation Resources, Release 12
Note: 370274.1 - New Features in Oracle Application 11i
Note: 130183.1 - How to Get Log Files from Various Programs for Oracle Applications
Note: 285267.1 - Oracle E-Business Suite 11i and Database FAQ
Note: 453137.1 - Oracle Workflow Best Practices Release 12 and Release 11i
Note: 398942.1 - FNDCPASS Utility New Feature ALLORACLE
Note: 187735.1 - Workflow FAQ - All Versions

Oracle Applications 11i/12 Online Documentation

http://www.oracle.com/technology/documentation/applications.html

Note: Above are only the few important notes, there are bunch of notes on many other issues and topics in the metalink. I would suggest one to refer the metalink for more note ids.

Leave your comments if you feel these Oracle Metalink Notes help you in solving your Application issues.

Regards,
Sabdar Syed,
http://sabdarsyed.blogspot.com/

Wikipedia on OCP, Oracle DBA and Oracle Apps DBA

Hi Friends,

I do get mails from newbie asking that what is OCP, Oracle DBA, and Oracle Apps DBA, and their responsibilities?. The Wikipedia has good information on these questions. Please follow the links given below.

Database administrator
http://en.wikipedia.org/wiki/Database_administrator

Oracle Apps DBA
http://en.wikipedia.org/wiki/Oracle_Apps_DBA

Oracle Certification Program
http://en.wikipedia.org/wiki/Oracle_Certification_Program

Regards,
Sabdar Syed,
http://sabdarsyed.blogspot.com/

I have passed the 1Z0-233 exam "Oracle 11i Install, Patch and Maintain Applications"

Dear Friends,

I have taken an Oracle 11i Applications exam (1Z0-233 - Oracle 11i Install, Patch and Maintain Applications) yesterday, and passed that exam.

I would like to share my preparation for and experience with that exam.

Pre-requisite for 1Z0-233 exam is that one should have earned Oracle9i and 10g Database Administrator Certified Professionals can achieve an upgrade to the Oracle 11i Applications Database Administrator Certified Professional credential through passing the exam Oracle 11i Install, Patch and Maintain Applications - 1Z0-233.

Please visit the following URL for more information.
http://www.oracle.com/global/us/education//certification/appsdba.html

Please note if you are pursuing the Oracle 11i Applications DBA OCP certification based on your prior Oracle 9i DBA or Oracle DBA 10g OCP certification, it is not necessary to submit a Hands On Course Requirement Form or Waiver.

Note: Please register for all your exams with the same Prometric ID. Using multiple ID's can cause delay in your certification and the database will recognize you as two different candidates.

Preparation: I have gone through all the ILT (Instructor Led Training) materials of the course “11i Install, Patch, and Maintain Oracle Applications” which my friend has done this course from Oracle University. These guides have helped me greatly in passing this exam, as all of the questions came from these materials topics.

Questions came from the following topics.

• APPS Schema
• Shared APPL_TOP
• AutoConfig
• Validation and Compilation of APPS Schema
• Desktop Tier
• Worker status flow, Worker log file locations.
• Rapid Clone/Install
• Server process scripts of Database and Applications.
• Patching i.e AutoPatch (Got many questions from this topic)
• Applications Top Level directories – APPL_TOP, ORA_TOP,COMMN_TOP,DATA_TOP
• Applications Context File
• Single Node and Multi Node installation
• AdAdmin – Recreate grants and synonyms for APPS schema.
• Oracle APPS tablespace model
• Syntaxes of adpatch, admrgpch etc
• Apps Tier components
• Others i.e. Error messages, log files of the utilities, definitions etc.

Note: I would suggest them those who are willing to appear for this exam that read and go through the Instructor Guides on this exam course provided my Oracle Corp/University/Authorized Center. These materials would stand handy for passing this exam.

Update: Read my other post on "The books, guides, and materials used for my OCA/OCP/OCE Exam Preparation."

http://sabdarsyed.blogspot.com/2008/08/books-guides-and-materials-used-for-my.html

Happy reading!!!

Regards,
Sabdar Syed,
http://sabdarsyed.blogspot.com/

Oracle Applications Schema Password Change Utility - (FNDCPASS)

Changing passwords periodically helps ensure database security. Oracle Applications provides a command line utility, FNDCPASS, to set Oracle Applications schema passwords. In addition to changing the schema password in the database, this utility changes the password registered in Oracle Applications tables (FND Tables). This utility can also change Applications End User passwords.

FNDCPASS changes

• Oracle Applications Database System Users (APPS, APPLSYS)
• Oracle Applications Product Schema Passwords (GL, AR, AP, etc,)
• Oracle Applications End User Account Passwords (SYSADMIN, OPERATIONS etc)

Note: the utility, FNDCPASS, cannot be used for changing the database SYSTEM and SYS users. Only users that are registered in FND meta data tables need to be changed using FNDCPASS. Normally, the APPS database user password and APPLSYS password need to be the same. When changing the APPLSYS password using FNDCPASS, the APPS password is also changed.

Syntax of FNDCPASS command:

FNDCPASS logon 0 Y system/password mode username new_password

Where logon is username/password[@connect]
System/password is password of the system account of that database
Mode is SYSTEM/USER/ORACLE
Username is the username where you want to change its password
new_password is the new password in unencrypted format

Example:

$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

$ FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1

$ FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME

Note: The FNDCPASS has a new mode, "ALLORACLE", in which all Oracle Application schema passwords can be changed in one call. Apply the patch (Patch No# 4745998) to have this option, if not available currently with your Apps.

Syntax:

FNDCPASS 0 Y ALLORACLE

Example:

$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

To change APPS/APPLSYS password, we need to give mode as SYSTEM
To change product schema passwords, i.e., GL, AP, AR, etc., we need to give mode as ORACLE
To change end user passwords, i.e., SYSADMIN, OPERATIONS etc., we need give mode as USER

Note: Till 11.5.9 there is bug in FNDCPASS, which allows FNDCPASS to change APPS&APPLSYS passwords. Doing so will corrupt the data in FND meta data tables and cause to the application unusable. Because of that it is recommend taking backup of the tables FND_USER and FND_ORACLE_USERID before changing the passwords.

After changing the APPS/APPLSYS or APPLSYSPUB user, following extra manual steps needs to be done.

If you changed the APPS (and APPLSYS) password, update the password in these files:

• iAS_TOP/Apache/modplsql/cfg/wdbsvr.app
• ORACLE_HOME/reports60/server/CGIcmd.dat

If you changed the APPLSYSPUB password, update the password in these files:

• FND_TOP/resource/appsweb.cfg
• OA_HTML/bin/appsweb.cfg
• FND_TOP/secure/HOSTNAME_DBNAME.dbc

Note: I would you suggest you to first try changing the passwords using FNDCPASS on your test Apps Instances, once you are done with this without any errors or issues then you can move this to production, and also request you to search in metalink for more information about FNDCPASS utility and it's usage.

Happy Reading !

With Best Regards,
Sabdar Syed,
http://sabdarsyed.blogspot.com

Free Oracle Applications Vision Demo Instances

Dear Friends,

I have found two Free Oracle Applications Vision Demo Instances so far.

http://www.appshosting.com/login/

http://www.solutionbeacon.com/tools_r11ivision.htm

All you need to do is, register an account in these above sites and start using Oracle Apps Demo instances.

Happy reading!!!

Regards,
Sabdar Syed.

Installing Oracle Applications 11i 11.5.10.2 on SUSE Linux Enterprise Server 9 SP1

Dear Friends,

Today I have come accross a good link for "Installing Oracle Apps 11i on SLES 9". Below is an URL.

http://www.novell.com/coolsolutions/feature/16009.html

I hope that this link may help you in installing Oracle Application on Linux.

Happy reading !!!!

Regards,
Sabdar Syed