ITExperts4u Blog’s

How To License A New Product in Oracle Applications

1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed. License manager can be run 2 ways:

a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration tab -> License Manager

b. run adlicmgr.sh from AD_TOP/bin

Using both methods you can license by Module or by individual Product. Select the check box for the Module/Product to be licensed and Save/Next

2. The Products are now licensed but not ready to be used as none of the Forms/Packages etc would have been compiled and loaded into the Database for these new Products. Use adadmin to generate the files for the new Product/s

a. run adadmin

b. Select Generate Application Files menu

c. Select all of the following Menu options:
- Generate message files
- Generate forms files
- Generate report files
- Generate graphic files
- Generate product JAR files

d. Back to Main Menu

e. Select Compile/Reload Applications Database Entities menu

f. Select all of the following Menu options:
- Compile APPS schema
- Compile menu information
- Compile flexfields

3. Once complete, check that the Forms/JSPs for the new Products licensed now work. The Products are now ready to be configured.

4. Run autoconfig.

I’ve been using PuTTY for years, its easy to use. So far, only one disadvantage I found. It really pain to copy PuTTY settings one by one from one Windows machine to another. Especially when you have a lot of entries saved in there.

Here I’ll write a trick to backup and restore PuTTY settings from one Windows machine to another. This trick tested on Windows XP and Vista.

You’ll need administrator access to both machines as we will be using Windows Registry Editor to backup and restore. Windows Registry Editor is a powerful tools, please be careful with anything you do.

Here we go…

To backup:

* Windows XP:

Click Start Menu >> Run

Windows Vista:

Click Start Menu >> Start Search box

* Type:

regedit

* Hit Enter or Return key, it will open Windows Registry Editor
* Navigate to:

HKEY_CURRENT_USER\Software\SimonTatham

* Right click on “SimonTatham” key >> Export
* Save as putty.reg and put it somewhere.

To restore:

* Copy/transfer putty.reg to another machine which already have PuTTY installed.
* Double click putty.reg file to import the entries to registry

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.

##
## before cleanup
##

13:42:56 APPS@XTPR:host01> r
1 select node_name, node_mode, support_cp,
2 support_web, support_admin, support_forms
3* from FND_NODES

NODE_NAME N S S S S
—————————— – - – - –
HOST01 O Y N Y N
MIDTIER01 O N Y N Y
APPSERVER21 N Y N Y <– bogust host
APPSERVER22 N Y N Y <– bogust host
APPSERVER23 N Y N Y <– bogust host
AUTHENTICATION O N N N N

6 rows selected.

##
## Cleanup
##

13:42:58 APPS@XTPR:host01> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

13:44:12 APPS@XTPR:host01> commit;

Commit complete.

##
## After cleanup
##

13:44:47 APPS@XTPR:host01> r
1 select node_name, node_mode, support_cp,
2 support_web, support_admin, support_forms
3* from FND_NODES

no rows selected

##
## Run AutoConfig
##

## BE tier
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/XTPR_host01.xml appspass=<pass>

## MT tier
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/XTPR_midtier01.xml appspass=<pass>

##
## After AutoConfig runs
##

13:58:15 APPS@XTPR:host01> r
1 select node_name, node_mode, support_cp,
2 support_web, support_admin, support_forms
3* from FND_NODES

NODE_NAME N S S S S
—————————— – - – - –
MIDTIER01 O N Y N Y
AUTHENTICATION O N N N N
HOST01 O Y N Y N

3 rows selected.

Important Note

Be careful not to run this on production, it cleans out all printer
definitions, previsously executed requests logs and outputs. It is okay to run
only on the freshly created environment.

##
## Using oidadmin
##

## startup oidadmin from the infrastructure-host
##

oidadmin

enter hostname: infrastructure-host.domainname.com
enter port: 389

enter username: orcladmin
enter password: <ISA_ADMIN_password_specified_during_install>

On the main screen to check Portal password:

Entry Management
cn=oracle context
cn=Products
=IAS
=IAS Infrastructure Databases
=SID
orclResourceName=PORTAL
orclpasswordattribute: GJx1ywdL (this will vary from install to install)

##
## Using ldapsearch from the command line
##

ldapsearch -h infrastructure-host.domainname.com -p 389 \
-D cn=orcladmin -w <ISA_ADMIN_password_specified_during_install> \
-b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” \
-s sub “orclResourceName=PORTAL” orclpasswordattribute

REFERENCE:
Note:356333.1 Unable access Portal welcome page. Get “Servlet Error”
Note:344804.1 Accessing Portal Returns “Servlet Error” After a New Install of Portal 10.1.2.0.2
Note:198800.1 How to get the Portal schema password of the Infrastructure database

Sun JRE instead of Jinitiator with Forms and Webutil

Running Forms and Webutil with Sun Java 5.0.6 instead of Jinitiator.

And you know what: it’s faster and has more functionality I’ve been told…
First you need the java-file. In this case: jre15006.exe.

Initially I found it hard to find on the site of Sun – didn’t even know the name of the file I was looking for…
Found it at http://www.muangyacctv.com/download/JAVA but if you keep searching the Sun-website, you will find it here:

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProduct
Detail-Start?ProductRef=jre-1.5.0_06-oth-JPR@CDS-CDS_Developer

Then: where shall I put the file? The application server expects the file in /forms/jinitiator.
In forms.conf this is defined as:
AliasMatch ^/forms/jinitiator/(..*) “/software/oracle/middle/jinit/$1?

Next thing is the configuration in formsweb.cfg (at the end of this post is the configuration what worked for me,
but first some explanation, quoted from some notes):

# baseHTMLjinitiator
# Suppose the old [webutil] configuration in formsweb.cfg contains:
baseHTMLjinitiator=webutiljini.htm
# Change this in [sunwebutil] to:
baseHTMLjinitiator=webutiljpi.htm

# IE : Used to enable the browser’s default JRE
IE=native

# jpi_classid
# This parameter value is used by Microsoft Internet Explorer to determine if the desired plug-in is installed.
# The value is recorded in the Windows Registry during the JRE/JPI or Jinitiator installation.
# When the browser sees this ID number it looks in the Registry to determine if it exists.
# If the ID is not found, the browser assumes that the needed plug-in has not been installed.
# The exact value will differ depending on the JRE or Jinitiator version selected for use.
# The only exception is the Sun “dynamic

Solution for mount problems facing on AIX?
Facing Errors like below?

Have you ever tried mounting a shared folder existing on Solaris or Linux machine to a AIX machine ? While doing so most of us will see the below kind of error. So to solve this problem the solution is this post.

bash-3.00# mount pmgxs2v1:/dbarchive /dbarchive
mount: 1831-008 giving up on:
pmgxs2v1:/dbarchive
vmount: Operation not permitted.

Solution:
bash-3.00# nfso -o nfs_use_reserved_ports=1
Setting nfs_use_reserved_ports to 1
bash-3.00# mount -n pmgxs2v1 /dbarchive /dbarchive
bash-3.00# cd /dbarchive/
bash-3.00# ls
apache builds java oracle os stax unzipper
browsers instance lost+found oracle-bundles staf stax-tnpm

Explanation:
Solaris by default requires any NFS mount to use a so called reserved port below 1024 and AIX 4.3 or above does by default use ports above 1024.
We can use the nfso command to restrict AIX to the reserved port range as follows:
nfso -o nfs_use_reserved_ports=1

You can have multiple instances on the same machine, each with their own data files, either sharing the ORACLE_HOME or each with different ORACLE_HOME. ORACLE_HOME and ORACLE_SID are the key environment variables used by Oracle to identify an instance. In addition $ORACLE_HOME/bin must be in your PATH environment variable.

To check the value of these environment variables:

$ env |grep ORACLE
ORACLE_SID=pdb10i1
ORACLE_BASE=/u01/app
ORACLE_HOME=/u01/app/oracle/product/10.2.0

The “oraenv

Sequence to be followed for Starting and Stopping Oracle Application Server:-
The following steps hold true if the Mid and Infra tiers are on the same machine or on different machines, the sequence remains the same.

Steps to Stop Application Server:-
1) First Stop Middle Tier
Set MIDTIER_HOME to your middle tier home location
a) Goto $MIDTIER_HOME/bin/emctl stop iasconsole
b) $MIDTIER_HOME/opmn/bin/opmnctl stopall
2) Once the Mid Tier services are stopped, now stop Infra-Tier Services.
Set INFRATIER_HOME to your infra home location
a) $INFRATIER_HOME/bin/emctl stop iasconsole
b) $INFRATIER_HOME/opmn/bin/opmnctl stopall
3) Login to database
a) $INFRATIER_HOME/bin/ sqlplus / as sysdba
b)Issue the command ” shut immediate” to shut down the database
c) $INFRATIER_HOME/bin lsnrctl stop
d) $INFRATIER_HOME/bin/emctl stop dbconsole

Steps to Start Application Server:-

Follow the Above Steps in reverse order:-
1) First Start Infra Tier
Set Infratier_home to your Infra tier home locaiton
a)$INFRATIER_HOME/bin/lsnrctl start
b)$INFRATIER_HOME/bin/ sqlplus / as sysdba
c) Once logged in Issue the command ” startup” to startup the database
d) $INFRATIER_HOME/bin/emctl start dbconsole

2) Now issue the following commands,
a) $INFRATIER_HOME/opmn/bin/opmnctl startall
b) $INFRATIER_HOME/bin/emctl start iasconsole

3) Once the Infra tier is up now start the Mid Tier
Set MIDTIER_HOME to your mid home location
a) INFRATIER_HOME/opmn/bin/opmnctl startall
b) INFRATIER_HOME/bin/emctl start iasconsole