How to compile Oracle Apps Forms 11i/R12

How to compile Oracle Apps 11i Forms

============================

Check whether the forms that you want to generate are not in use at the time

you are generating them. If they are in use when you generate the fmx files, 

the forms client session terminates.

1) Login to the Forms server node as applmgr and run

.env file to set the applications environment.

2) Change directory to $AU_TOP/forms/US.

3) Use the “f60gen” command to generate the fmx files for the fmb files.

4) Issue the following command

$ f60gen module=<formname>.fmb userid=apps/<apps_pwd> 

output_file=/forms/US/<formname>.fmx

How to compile Oracle Apps R12 Forms

=============================

1) Log into the forms tier.

2) Set the applications environment

3) Ensure that the $FORMS_PATH includes $AU_TOP/resource and

 $AU_TOP/resource/stub, for example

echo $FORMS_PATH

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource:

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource/stub

4) Compile the form

a)- If you are using forms customizations (CUSTOM.pll) then run

 the command below to compile the form.

frmcmp_batch.sh module=<path to fmb file> userid=APPS/APPS 

output_file=<full path to fmx output file>
module_type=form compile_all=special

For eg:-

frmcmp_batch.sh module=/u01/oracle/TEST/apps/apps_st/appl/au/

12.0.0/forms/US/XXX.fmb userid=APPS/APPS output_file=/u01/

oracle/TEST/apps/apps_st/appl/inv/12.0.0/forms/US/XXX.fmx

 module_type=form compile_all=special

b) If you are NOT using forms customizations, then run the 

command below to compile the form.

frmcmp_batch.sh module=<path to fmb file> userid=APPS/APPS

 output_file=<full path to fmx output file> module_type=form

For example..

frmcmp_batch.sh module=/u01/oracle/TEST/apps/apps_st/

appl/au/12.0.0/forms/US/XXX.fmb userid=APPS/APPS
 output_file=/u01/oracle/TEST/apps/apps_st/appl/inv/

12.0.0/forms/US/XXX.fmx module_type=form

How to compile Oracle Apps

How To Trace a Concurrent Request And Generate TKPROF

Enable Tracing For The Concurrent Manager  Program

Select the Enable Trace Checkbox



Note : Checking the Trace Check box on the Concurrent Program gives an Event 10046
Level 8 trace. So even if the trace is set for Binds and Waits on the Submission form once the
concurrent program is encountered in the trace it will reset to level 8 so no binds
will be present in the trace after that point.

Turn On Tracing

• Responsibility: System Administrator


• Navigate: Profiles > System


• Query Profile Option Concurrent: Allow Debugging


• Set profile to Yes

Run Concurrent Program With Tracing Turned On

• Logon to the Responsibility that runs the Concurrent Program


• In the Submit Request Screen click on Debug Options (B)


• Select the Checkbox for SQL Trace

If the Debug option is greyed out & not updateable set the profile Concurrent: Allow Debugging to Yes

2. Find Trace File Name

Run the following SQL to find out the Raw trace name and location for the concurrent program.  The SQL prompts the user for the request id

prompt
accept request prompt 'Please enter the concurrent request id for the appropriate concurrent program:'
prompt

column traceid format a8
column tracename format a80
column user_concurrent_program_name format a40
column execname format a15
column enable_trace format a12
set lines 80
set pages 22
set head off

SELECT 'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Trace Name:
'||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'Prog. Name: '||prog.user_concurrent_program_name,
'File Name: '||execname.execution_file_name|| execname.subroutine_name ,
'Status : '||decode(phase_code,'R','Running')
||'-'||decode(status_code,'R','Normal'),
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = &request
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
--- and prog.application_id = execname.application_id
and prog.executable_application_id = execname.application_id
and prog.executable_id=execname.executable_id;


To check the timeline of the request :

SELECT request_id, TO_CHAR( request_date, 'DD-MON-YYYY HH24:MI:SS' )
request_date, TO_CHAR( requested_start_date,'DD-MON-YYYY HH24:MI:SS' )
requested_start_date, TO_CHAR( actual_start_date, 'DD-MON-YYYY HH24:MI:SS' )
actual_start_date, TO_CHAR( actual_completion_date, 'DD-MON-YYYY HH24:MI:SS' )
actual_completion_date, TO_CHAR( sysdate, 'DD-MON-YYYY HH24:MI:SS' )
current_date, ROUND( ( NVL( actual_completion_date, sysdate ) - actual_start_date ) * 24, 2 ) duration
FROM fnd_concurrent_requests
WHERE request_id = TO_NUMBER('&p_request_id');

You may produce a complete report reference of the request ID using the Note:187504.1 bde_request.sql Process and Session info for one Concurrent Request(11.5)

3. TKPROF Trace File

Once you have obtained the Raw trace file you need to format the file using TKPROF.

$tkprof raw_trace_file.trc output_file explain=apps/apps sort=(exeela,fchela) sys=no

Where:

raw_trace_file.trc: Name of trace file
output_file:        tkprof out file
explain:            This option provides the explain plan for the sql
statements
sort:               This provides the sort criteria in which all sql
statements will be sorted.  This will bring the bad sql at
the top of the outputfile.
sys=no:             Disables sql statements issued by user SYS

How to check whether the port is opened or not from client machine

Status Check of port 8000 from Windows Operating System

Go to Start menu tab.   Then run ‘cmd,’ which will take you to the command prompt.

In the command prompt, you must type the following command and hit Enter:

telnet 123.456.789.86 8000

Oracle Fusion Application Architecture

Oracle Fusion Applications is set of business applications (CRM, HCM, HRMS, Financials..) deployed on Oracle Fusion Middleware  (as middleware) and using Oracle Database as data repository .

1. Oracle Applications is delivered as a Suite (collection of modules), but can be adopted in modules (suset of Suite).

2. Various Modules in Fusion Applications are
a) Oracle Fusion CRM (Customer Relationship Management) - customers, contacts, and resources
b)Oracle Fusion Financials - assets, ledgers, cash cycle, invoices and payments, accounts receivable, collections, and setup of sub-ledger accounting and tax configuration
c) Oracle Fusion HCM (Human Capital Management) - Employee management for an organization
d) Oracle Fusion Procurement  - procurement including requisitions, purchase orders, and supplier negotiations
e) Oracle Fusion PPM (Project Portfolio Management) - projects, budget, forecast, collect costs, bill customers, and report performance.
f) Oracle Fusion SCM (Supply Chain Management) - integrates and automates all key supply chain processes.
g) Oracle Fusion Setup - special product family for Functional Setup and setting up Home Page or Help.
h) Oracle Fusion GRC (Governance, Risk, and Compliance) - automated controls enforcement to enable sustainable risk and compliance management.

3. EAR, JAR, and WAR
a) EAR is enterprise application archive (enterprise application) which contains JAR and WAR files.
b) JAR is Java application Archive which contains Java EE application.
c) WAR is Web application Archive which contains Web Application.

Each product in Fusion Application typically has one-to-one relationship with EAR file, for ex. EarSales.ear is an enterprise application for product Sales.

4. Product Families (CRM, HCM, Financials) mentioned above contains one or more Java EE applications and are deployed on Oracle WebLogic Server.

5. An application can contain multiple products, and a product can also span across multiple  applications.



6.There are two type of components in Fusion Middleware , Java Components(deployed and managed by WebLogic) and System Component (managed by OPMN) and Fusion Applications uses both these components.

For basic concepts in Oracle Fusion Middleware click here

7.  Oracle Fusion Applications consists of following components
a) Oracle Fusion Applications (CRM, HCM, Projects, Financials…)
b) Oracle Fusion Middleware Infrastructure Components for Fusion Applications (Enterprise Scheduler, FMW Extension for Applications, Crawl & Search and Functional Setup Manager)
Note: Enterprise Scheduler is similar to Concurrent Manager in EBS 11i/R12
c) Oracle Fusion Middleware (WebLogic, OHS, WebGate, OWSM, ADF, OBIEE, ODI, ECM, IDAM, IDM, WebCenter, SOA, OWSM..)
d) Database

8. Task of Fusion Applications Administrators
a) Installation and Deployment
b) Management & Availability
c) Debugging/Troubleshooting
d) Cloning
e) Backup & Recovery
f)Patching (Fusion Applications Patch Manager, AutoPatch, AD Controller)

9.Oracle Fusion Applications is currently available for Linux x86-64 from eDelivery edelivery

Implementing AutoConfig Customizations

How to customize AutoConfig in Oracle Apps 11i

Create the custom template directory

Create a directory named "custom" at the location where the AutoConfig template file resides.
For example, if you want to customize <FND_TOP>/admin/template/appsweb.cfg, execute the following command as the applmgr user:

mkdir $FND_TOP/admin/template/custom


Copy the AutoConfig template file

Copy the AutoConfig template file to the custom template file.

Execute the following command as the applmgr user:

cp -i <AutoConfig template file> <custom template file>
For example:
cp -i $FND_TOP/admin/template/appsweb.cfg \
$FND_TOP/admin/template/custom/appsweb.cfg

Edit the custom template file

Edit the custom template file with the editor of your choice, such as vi on UNIX or Wordpad on Windows.

Verify your customizations

Execute the adchkcfg utility. When this utility runs, it instantiates any custom template files in place of the corresponding AutoConfig template file. The adchkcfg utility generates a report with information about all files and profile options that will be changed during the next normal execution of AutoConfig. Verify that your customizations would be applied as expected in your next AutoConfig run.

Run AutoConfig

Run AutoConfig. When AutoConfig runs, it instantiates any custom template file in place of the corresponding AutoConfig template file.

Oracle Certification Exam Codes

1z0-001: Introduction to Oracle: SQL and PL/SQL

1z0-007: Introduction to Oracle9i: SQL

1z0-020: Oracle8i: New Features for Administrators

1z0-023: Architecture and Administration

1z0-024: Performance Tuning

1z0-025: Backup and Recovery

1z0-026: Network Administration

1z0-030: Oracle9i: New Features for Administrators

1z0-031: Oracle9i:Database Fundamentals I

1z0-032: Oracle9i:Database Fundamentals II

1z0-033: Oracle9i:Performance Tuning

1z0-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

1z0-036: Managing Oracle 9i on Linux

1z0-040: Oracle Database 10g: New Features for Administrators

1z0-041: Oracle Database 10g: DBA Assessment

1z0-042: Oracle Database 10g: Administration I

1z0-043: Oracle Database 10g: Administration II

1z0-045: Oracle Database 10g: New Features for Oracle8i OCPs

1z0-046: Oracle Datebase 10g: Managing Oracle on Linux for DBAs

1z0-047: Oracle Database SQL Expert

1z0-048: Oracle Database 10g R2: Administering RAC

1z0-050: Oracle Database 11g: New Features for Administrators

1z0-051: Oracle Database: SQL Fundamentals I

1z0-052: Oracle Database 11g: Administration I

1z0-053: Oracle Database 11g: Administration II

1z0-054: Oracle Database 11g: Performance Tuning

1z0-055: Oracle Database 11g: New Features for 9i OCPs

1z0-101: Develop PL/SQL Program Units

1z0-108: Oracle WebLogic Server 10g System Administration

1z0-109: Oracle WebLogic Server 10g Developer

1z0-131: Oracle9i, Build Internet Applications I

1z0-132: Oracle9i, Build Internet Applications II

1z0-140: Oracle9i Forms Developer: New Features

1z0-141: Oracle9i Forms Developer: Build Internet Applications

1z0-144: Oracle Database 11g: Program with PL/SQL

1z0-146: Oracle Database 11g: Advanced PL/SQL

1z0-147: Oracle9i: Program with PL/SQL

1z0-200: Oracle 11i E-Business Essentials

1z0-211: Oracle 11i General Ledger

1z0-212: Oracle Payables 11i Fundamentals

1z0-213: Oracle Receivables 11i Fundamentals

1z0-215: Oracle E-Business Suite R12: General Ledger and Payables Fundamentals

1z0-216: Oracle EBS R12: General Ledger and Receivables Fundamentals

1z0-222: Oracle Purchasing 11i Fundamentals

1z0-223: Oracle Order Management 11i Fundamentals

1z0-225: Oracle EBS R12: Inventory and Purchasing Fundamentals

1z0-226: Oracle EBS R12: Inventory and Order Management Fundamentals

1z0-232: Oracle 11i Systems Administrator

1z0-233: Oracle 11i Install, Patch and Maintain Applications

1z0-235: Oracle 11i Applications DBA:Fundamentals I

1z0-236: 11i Applications DBA Fundamentals II

1z0-238: EBS R12: Install, Patch and Maintain Applications

1z0-241: PeopleSoft Application Developer I: People Tools & PeopleCode

1z0-311: Oracle Application Server 10g: Administration I

1z0-312: Oracle Application Server 10g:Administration II

1z0-402: Oracle Enterprise Linux: Fundamentals

1z0-403: Enterprise Linux System Administration

1z0-450: Oracle Application Express 3.2: Developing Web Applications

1z0-451: Oracle SOA Foundation Practitioner

1z0-514: Oracle Database 11g Essentials

1z0-515: Data Warehousing 11g Essentials

1z0-516: Oracle EBS R12.1 General Ledger Essentials

1z0-517: Oracle EBS R12.1 Payables Essentials

1z0-518: Oracle EBS R12.1 Receivables Essentials

1z0-519: Oracle EBS R12.1 Inventory Essentials

1z0-520: Oracle EBS R12.1 Purchasing Essentials

1z0-521: Oracle EBS R12.1 Order Management Essentials

1z0-527: Oracle CRM On Demand Essentials

1z0-530: Oracle Enterprise Manager 11g Essentials

1z0-548: Oracle E-Business Suite R12.1 Human Capital Management Essentials Exam

Oracle Apps R12 New Features

Advantage & Disadvantages of Forms Servlet Mode

Simple SSL Configuration (as no separate SSL configuration is required for Forms as

connections are via web/http server)

No port need to open to access forms in firewall.

More secure method of deployment over Internet

Result in more network traffic because of HTTP is more chatty than socket (dedicated)

so not preferred in WAN implementation.

Unified APPL_TOP in Oracle Applications R12

Unified APPL_TOP in Oracle Applications R12 which is different from Separate

APPL_TOP in Oracle Applications 11i.

Unified APPL_TOP make more sense if you are using multi node Oracle Applications R12.

In Oracle Applications 11i , in multi node installation each APPL_TOP have its different
name and files in each APPL_TOP will depend on type of Node (i.e. Forms Node will
have fmx or forms related files where as APPL_TOP belonging to CM only node will
have .rdf or files required to run CM node)

Starting from R12, it will use Unified APPL_TOP which means all files required for all middle tier services are included in all nodes of Multi Node installation (irrespective of services running on that node)

Advantages of Unified APPL_TOP

Cloningof multi node Oracle Application install, only one copy (any one APPL_TOP)

of Application Node files need to copied to target instance.

Cloning of Multi Node to Single Node you don’t have to merge APPL_TOP in R12 as

required in 11i .

Services start/stopIf you are using adstrtall.sh to start services on a node then it will

start services which were configured to start during install on that node (You can still
start a specific service even though it was not suppose to configure/start by calling startup
script of that specific services).
To explain this better, let’s assume you installed multi node R12 instance with Node 1 as
Forms & Web Server where as Node 2 was installed with Concurrent Manager. Now on
Node1 when you use adstrtall.sh script to start services as expected it will start Forms and
Web services but unlike 11i, You can still start Concurrent Manager on Node1 by
running  adcmctl.sh

FND_NODESFrom R12 all nodes will have Y against all services (For multi Node) in

FND_NODES table.

Additional New Feature in R12

Rapid install

Store Base Configuration in Database

No need to copy config.txt

Multiple Domain Support for Database and Middle Tier

Rapid Install supports deploying the database node and the middle tier node into

different domains.

Shared File System Support

Rapid install allows you to select if app servers are using shared APPL_TOP

No hardcode apps password on Unix file system

FNDCPASS Utility New Feature: Enhance Security With Non-Reversible Hash

Password (enhance FND_USER password security)

Improved Forgot password feature

–Retrieve user_name and password

–no workflow inbound process needed

New environment variables e.g. FORMS_TRACE_DIR
FORMS_ environment variables replace FORMS60_
Delivers native runtime executables for Forms (frmweb) (11i: frmwebx)
Forms Trace in addition to Forms Runtime Diagnostics (FRD) record both built-in Formsdata and performance data in a single output (profile: Forms Runtime Parameters)
Reports Only available through Concurrent Manager
Reports Server is not used
Reports executable rwrun is used directly

APPS Password change made easy, no need to change the password in any files as in 11i.

How to change Oracle Applications Products/Schema Password including APPS ?

As most of you might already be aware that you use FNDCPASS utility on Concurrent

Manager Node to change the password.

FNDCPASS logon 0 Y system/password mode username new_password

WhereMODE is SYSTEM/USER/ORACLE/

ALLORACLE (Introduced with patch 4745998)

Changing APPS Password using FNDCPASS

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

In 11i we need to change the passwords in the below files as it was used and hard coded,
in R12i there is no files where the password is stored, so we need not worry about
changing the passwords in any file, this is due to the security reason,

Only recommended is to run the autoconfig on the Middle Tier after changing the APPS Password.

In 11i files to change after changing Apps Password ?

Once you change apps password you need to change apps password stored in file

wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg

Following Metalink Notes are useful & related to Oracle Applications or Apps Password
–303621.1 How to Change and Which Apps Database Users Passwords Can Be Changed
in a Multi – Node Apps Installation?
–159244.1 How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS
and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in UNIX.
– 437260.1 – How to Change Oracle Applications Release 12 Passwords using Oracle
Applications Schema Password Change Utility (FNDCPASS)

Interesting links of R12 EBS Installation

Release 12.1.x
Operating Systems Install & Upgrade Notes

Note 761569.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX Based Systems (64-bit)'
Note 762891.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for HP-UX Itanium'
Note 762894.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for HP-UX PA-RISC (64-bit)'
Note 761564.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86'
Note 761566.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64'
Note 761568.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Sun Solaris SPARC (64-bit)'
Note 761567.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit)'

Release Notes

Note 798258.1 - 'Oracle Applications Release Notes, Release 12.1.1'
Note 788053.1 - 'Oracle Applications NLS Release Notes, Release 12.1.1'

Release 12.0.x
Operating Systems Install & Upgrade Notes

Note 402310.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)'
Note 416305.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (64-bit)'
Note 402312.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Solaris Operating System (SPARC)'
Note 402311.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows'
Note 402306.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for AIX-Based Systems'
Note 402307.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for HP-UX Itanium'
Note 402308.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for HP-UX PA-RISC'

Note 555895.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for HP-UX PA-RISC'
Note 555893.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for HP-UX Itanium'
Note 555874.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (32-bit)'
Note 555876.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (64-bit)'
Note 555879.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Microsoft Windows'
Note 555873.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for AIX-Based Systems'
Note 555877.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Solaris Operating System (SPARC)'


Known Issues, How-To docs and Environment checks

Note 421409.1 - 'Unbreakable Linux Enviroment check before R12 install'
Note 343917.1 - 'Frequently Asked Questions Oracle E-Business Suite Support on x86-64'
Note 828157.1 - 'Useful Articles for the Oracle E-Business Suite Technology Stack for Technical Consultant / DBA'
Note 452120.1 - 'How to locate the log files and troubleshoot RapidWiz for R12'
Note 743518.1 - 'Starting up AS10g services in an EBusiness Suite Release 12 environment'
Note 733303.1 - 'How to migrate from Cygwin to MKS Toolkit'

Note 752933.1 - 'The Fresh R 12.0.4 installation on Linux RHEL5 (64-bit), Fails During The RDBMS Linking Phase'
Note 565966.1 - 'EBS 12.0.4 Install fails on Solaris While Creating the Database'
Note 579254.1 - 'Installing Rel 12.0.4 Ebuisines Suite autoconfig fails with sqlplus error while loading shared libraries libclntsh.so.10.1 cannot open shared object file No such file or directory'
Note 850264.1 - 'On R 12.1.1 Fresh Installation, POST RAPIDWIZ INSTALL CHECKS FAILS , Rapidwiz Ends With Error Jsp, Virtual Directory And Login Page Does Not Work RW-50016 Error - {0} was not created'
Note 468695.1 - 'Getting RW-50010 and RW-50004 Errors When Installing Oracle Applications Release 12.0 on Linux 64-bit'
Note 452101.1 - 'Fresh R12 Installation Fails with RW-50015'
Note 414414.1 - 'R12 Rapidwiz postinstall step Http, Login page, Virtual directory, JSP, Help page fails'
Note 789431.1 - 'R 12.0.x, Relink via adadmin or adrelink Manually Failed On cat cannot open /xxx/yyyyy/apps/tech_st/10.1.2/lib32/ldflags'
Note 418109.1 - 'Rapidwiz R12 Failed at 66% with error RW-50004 Error code received when running external process.'

Oracle DB Upgrade from 9.2.0.6 to 10.2.0.2

Patching before Upgrading Database from 9.2.0.6 to 10.2.0.2

Step-1

Apply Developer 6i Patchset version 19.

Step-2 

Apply TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH p9535311_11i_LINUX.zip

Generate appsutil.zip and ftp to RDBMS OH.

unzip and run autoconfig

Features & Enhancements

Step-3

Apply AD.I.7 Patch p7429271_11i_LINUX.zip from AD.I.2

Step-4

Apply Patch p5989593_11i_LINUX.zip

Step-5

Apply Patch p3218526_11i_GENERIC.zip

Step-6

Apply Patch p4206794_11i_GENERIC.zip

Step-7

Apply Patch p3854951_11i_LINUX.zip

Step-7a

Apply Patch p5194357_11i_GENERIC.zip

Step-8

Patch 11i.ATG_PF.H.delta.5: 11i.ATG_PF.H.RUP p6241631_11i_LINUX.zip

select count(*) from dba_objects where status like 'INVALID';

Will take 4-5Hrs

Meanwhile we can install Oracle 10g and patch it.

Unzip 10201_database_linux32.zip and install

unzip Companion Cd 10201_companion_linux32.zip and install

Apply patch for 10.2.0.3 unzip p5337014_10203_LINUX.zip and install

Step-9

Apply Patch 4653225 - 11.5.10 INTEROP PATCH FOR 10GR2

Step-10

Apply additional patches for Invalid Objects.

i.p4619025_11i_GENERIC.zip

ii.p5194357_11i_GENERIC.zip

Step-11

After Applying Patches run adadmin and select recreate grants and synonyms

and complie apps schema.

Suceesfully Completed Pre Upgradation Patching Process

Upgradation

-------------

Step-1 

Install Oracle 10g

Install Companion CD

Apply 10.2.0.3 patch Set

Step-2

Configuration

Create nls/data/9idata directory 

perl $ORACLE_HOME/nls/data/old/cr9idata.pl 

Check whether files exist in $ORACLE_HOME/nls/data/9idata else copy the files

cd $ORACLE_HOME/nls/data/9idata

if not then issue below commands 

$ cp $ORACLE_HOME/nls/data/*.nlb .

$ cp $ORACLE_HOME/nls/data/old/*.nlb .

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

Step-3

Install 10g Listener

i.stop 9i listener

ii.run netca from Oracle 10g home and create new listener.

iii.copy cp /d01/oracle/VIS/db/tech_st/10.2.0/rdbms/admin/utlu102i.sql /tmp/

iv. in 9i run this script to generate a report.

Note: at this time 10g listener and 9i database is up and running.

*************************************************************************************

SQL> @utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility 12-13-2010 13:48:09.

**********************************************************************

Database:

**********************************************************************

--> name: VIS

--> version: 9.2.0.6.0

--> compatible: 9.2.0

--> blocksize: 8192.

**********************************************************************

Logfiles: [make adjustments in the current environment]

**********************************************************************

--> The existing log files are adequate. No changes are required.

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 8056 MB

--> APPS_UNDOTS1 tablespace is adequate for the upgrade.

.... minimum required size: 469 MB

--> TEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

--> APPS_TS_QUEUES tablespace is adequate for the upgrade.

.... minimum required size: 567 MB

--> APPS_TS_TX_DATA tablespace is adequate for the upgrade.

.... minimum required size: 10457 MB

--> ODM tablespace is adequate for the upgrade.

.... minimum required size: 15 MB

--> OLAP tablespace is adequate for the upgrade.

.... minimum required size: 32 MB.

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

WARNING: --> "streams_pool_size" is not currently defined and needs a value of

at least 50331648

WARNING: --> "large_pool_size" needs to be increased to at least 8388608

WARNING: --> "session_max_open_files" needs to be increased to at least 20.

**********************************************************************

Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No renamed parameters found. No changes are required.

**********************************************************************

Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

--> "optimizer_max_permutations"

--> "row_locking"

--> "undo_suppress_errors"

--> "max_enabled_roles"

--> "enqueue_resources"

--> "sql_trace".

**********************************************************************

Components: [The following database components will be upgraded or installed]

**********************************************************************

--> Oracle Catalog Views [upgrade] VALID

--> Oracle Packages and Types [upgrade] VALID

--> JServer JAVA Virtual Machine [upgrade] VALID

...The 'JServer JAVA Virtual Machine' JAccelerator (NCOMP)

...is required to be installed from the 10g Companion CD.

--> Oracle XDK for Java [upgrade] VALID

--> Oracle Java Packages [upgrade] VALID

--> Oracle Text [upgrade] VALID

--> Oracle XML Database [install]

--> Real Application Clusters [upgrade] INVALID

--> Oracle Data Mining [upgrade] VALID

--> OLAP Analytic Workspace [upgrade] UPGRADED

--> OLAP Catalog [upgrade] VALID

--> Oracle OLAP API [upgrade] UPGRADED

--> Oracle interMedia [upgrade] VALID

...The 'Oracle interMedia Image Accelerator' is

...required to be installed from the 10g Companion CD.

--> Spatial [upgrade] VALID.

**********************************************************************

Miscellaneous Warnings

**********************************************************************

WARNING: --> Passwords exist in some database links.

.... Passwords will be encrypted during the upgrade.

.... Downgrade of database links with passwords is not supported.

WARNING: --> Deprecated CONNECT role granted to some user/roles.

.... CONNECT role after upgrade has only CREATE SESSION privilege.

WARNING: --> Database contains stale optimizer statistics.

.... Refer to the 10g Upgrade Guide for instructions to update

.... statistics prior to upgrading the database.

.... Component Schemas with stale statistics:

.... SYS

.... ODM

.... OLAPSYS

.... MDSYS.

**********************************************************************

SYSAUX Tablespace:

[Create tablespace in the Oracle Database 10.2 environment]

**********************************************************************

--> New "SYSAUX" tablespace

.... minimum required size for database upgrade: 500 MB.

PL/SQL procedure successfully completed.

**************************************************************************************

Step-4

--------

Copy the existing initTEST.ora(9i) to $ORACLE_HOME/dbs/initTEST.ora(10g)

Modify initTEST.ora for the below parameters

user_dump_dest =

/

background_dump_dest =

core_dump_dest =

utl_file_dir =

/VIS_linux1,/usr/tmp

# Make the below changes in initTEST.ora

#optimizer_max_permutations

#row_locking

#undo_suppress_errors

#max_enabled_roles

#enqueue_resources

#sql_trace

streams_pool_size=50331648

large_pool_size = 8388608

session_max_open_files=20

optimizer_features_enable=10.2.0.3

compatible=10.2.0

Step-5

Copy the 9i environment file and modify it

Step-6

Copy the 9i network folder to 10g to get tnsnames.ora and

listener.ora

Step-7

# Shutdown all the middle tier process on application tier, if they are started

# Shutdown the 9i listener and 9i database.

# Please do take a backup of database before running manual update or dbua

# At this point in time all the services are down only 10 listener is up

SQL> startup upgrade

cd $ORACLE_HOME

. ./VIS_linux1.env

Create sysaux tablespace

CREATE TABLESPACE sysaux DATAFILE '/d01/oracle/devdbdata/sysaux01.dbf'

SIZE 1000M REUSE

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO

ONLINE; 

cd $ORACLE_HOME/rdbms/admin

startup upgrade

SPOOL upgrade.log

@catupgrd.sql

SPOOL OFF

SHUTDOWN IMMEDIATE

STARTUP

@utlrp.sql

Oracle Database 10.2 Upgrade Status Utility 12-13-2010 15:55:38.

Component Status Version HH:MM:SS

Oracle Database Server VALID 10.2.0.3.0 00:30:11

JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:03:17

Oracle XDK VALID 10.2.0.3.0 00:06:51

Oracle Database Java Packages VALID 10.2.0.3.0 00:00:17

Oracle Text VALID 10.2.0.3.0 00:00:42

Oracle XML Database VALID 10.2.0.3.0 00:00:54

Oracle Real Application Clusters INVALID 10.2.0.3.0 00:00:01

Oracle Data Mining VALID 10.2.0.3.0 00:00:14

OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:24

OLAP Catalog VALID 10.2.0.3.0 00:00:49

Oracle OLAP API VALID 10.2.0.3.0 00:00:24

Oracle interMedia VALID 10.2.0.3.0 00:04:07

Spatial VALID 10.2.0.3.0 00:02:42 

Step-8

--------

Post Upgrade Steps:

Some more fixes

i) Fix Korean lexers

a. Connect to sqlplus as sysdba

b. execute $ORACLE_HOME/ctx/sample/script/drkorean.sql

ii) Run adgrants.sql

a. Connect to sqlplus as sysdba

b. Execute @$APPL_TOP/admin/adgrants.sql APPLSYS

iii) Grant create procedure privilege on CTXSYS

a. Connect to sqlplus with apps

b. Execute @$AD_TOP/patch/115/sql/adctxprv manager CTXSYS

manager is the SYSTEM password

Added few steps

i) Gather Statistics for SYS schema

a. sqlplus “/as sysdba”

b. shutdown immediate

c. startup restrict

d. @/oracle/tst10appl/admin/adstats.sql

e. shutdown

f. startup

ii) Recreate grants and synonym for apps

a. Log in to server with applmgr user

b. Execute adadmin

c. Choose -> Maintain Applications Database Entities menu

d. Choose -> Re-create grants and synonyms for APPS schema

d) On the application tier run the below command to generate

appsutil.zip file.

perl /d01/oracle/singlenode/testappl/ad/11.5.0/bin/admkappsutil.pl

Copy the appsutil.zip file generated on application tier to the

database tier inside 10g Oracle Home.

su - oracleupd

cd $ORACLE_HOME

cp /d01/oracle/singlenode/testappl/admin/out/appsutil.zip .

unzip appsutil.zip

f) Next step is to create a context file on database tier. Run the

below commands with appropriate values. This will generate context file

on database tier.

cd $ORACLE_HOME/appsutil/bin

perl adbldxml.pl tier=db appsuser=apps appspasswd=apps

On the application tier run the below command to generate

appsutil.zip file.

perl /d01/oracle/singlenode/testappl/ad/11.5.0/bin/admkappsutil.pl

Copy the appsutil.zip file generated on application tier to the

database tier inside 10g Oracle Home.

su - oracleupd

cd $ORACLE_HOME

cp /d01/oracle/singlenode/testappl/admin/out/appsutil.zip .

unzip appsutil.zip

Next step is to create a context file on database tier. Run the

below commands with appropriate values. This will generate context file

on database tier.

cd $ORACLE_HOME/appsutil/bin

perl adbldxml.pl tier=db appsuser=apps appspasswd=apps

Once the context file is created on db tier, run autoconfig.

cd $ORACLE_HOME/appsutil/bin

./adconfig.sh

contextfile=/d01/oracle/singlenode/testdb/10.2.0/appsutil/TEST_linux1.xml appspass=apps

AutoConfig completed successfully.

The log file for this session is located at:

/d01/oracle/singlenode/testdb/10.2.0/appsutil/log/TEST_linux1/12130604/adconfig.log

Simple Clone Process in 11i/R12

In normal cloning process, we do archive the Source node then copy the archived files to the Target node then extract the archived files back.

If you want to speed up this process, you can follow this one:

Example: Ine One step, we have to copy the ORACLE_HOME form Source Node (Prod) to Target Node (Test).

On the Target node create the ORACLE_HOME directory if it does not exist:

$ mkdir -p /u01/app/oracle/product/10.2.0./

On the Source node:

$ cd $ORACLE_HOME

$ tar cf - * | ssh TEST '(cd /u01/app/oracle/product/10.2.0./; tar xf - )'

on the Target node, you can check files are copying and extracting by giving:

$ cd /u01/app/oracle/product/10.2.0./db

$ ls -ltr

total 240

drwxr-x--- 3 oracle dba 4096 Oct 25 20:38 jre

drwxr-x--- 7 oracle dba 4096 Oct 25 20:38 javavm

drwxr-x--- 3 oracle dba 4096 Oct 25 20:38 has

drwxr-x--- 3 oracle dba 4096 Oct 25 20:38 diagnostics

drwxr-x--- 3 oracle dba 4096 Oct 25 20:38 demo

drwxr-x--- 6 oracle dba 4096 Oct 25 20:38 crs

drwxr-x--- 4 oracle dba 4096 Oct 25 20:38 clone

drwxr-x--- 7 oracle dba 4096 Oct 25 20:38 assistants

drwxr-x--- 4 oracle dba 4096 Oct 25 20:49 jdbc