Tuesday, 27 December 2011

Metalink

Workflow mailer troubleshooting useful notes

Note: 831982.1 – 11i/R12 – A guide for troubleshoting Workflow Notification Emails – Inbound and Outbound
Note: 274764.1 – 11i : Oracle Workflow Cartridge Workflow Java Mailer Setup Test
Note: 396314.1 – Oracle Workflow Documentation Resources, Release 12
Note: 453137.1 – Oracle Workflow Best Practices Release 12 and Release 11i
Note: 231286.1 – Configuring the Workflow Java-based Notification Mailer with Oracle Applications 11i
Note: 249957.1 – Example Of Configuring Workflow Java Notification Mailer With Oracle Applications 11.5.x
Note: 564394.1 – How to Troubleshoot when the Workflow Services Go Down
Note: 463354.1 – How to troubleshoot ‘Validation failed’ errors when starting mailer
Note: 753845.1 – How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer Issues
Troubleshooting Oracle Workflow in Applications 11i [ID 262011.1]
Note: 548918.1 – How to start the Workflow Deferred Agent Listener andWorkflow Java Deferred Agent Listener?
Note: 452354.1 – How To Start or Stop The Workflow Mailer Or Defered Agent Listener From The Command Line, Not From OAM
How to Troubleshoot ‘Validation failed’ Errors when Starting the Mailer (Doc ID 463354.1)
Unable To Start Workflow Notification Mailer (Doc ID 418329.1)
How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer Issues (Doc ID 753845.1)
Workflow Mailer Will Not Start Stays In Starting Status (Doc ID 837893.1)
Unable To Connect To The Mail Account. Check The Host, User Name And Password (Doc ID 1123684.1)

April 29, 2011

Useful Metalinks – I

Filed under: Metalink — appsdba11i @ 4:34 pm
RDBMS and E-Business Suite Installation and Configuration
*********************************************************
118218.1 11i. Installing a Digital Cerificate on both the Server and Client.
252217.1 Requirements for Installing Oracle 9iR2 on RHEL3
146469.1 Installation & Configuration of Oracle Login server & Portal3i
146468.1 Installation of Oracle9i Application Server(9iAS)
152775.1 XML gateway installation
165700.1 Multiple Jserv configuration
207159.1 Documentation of 9iAS
210514.1 Express Server WebIV Note numbers
170931.1 Notes on Motif troubleshooting
177610.1 Oracle Forms in Applications FAQ
258021.1 How to monitor the progress of a materialized view refresh (MVIEW)
330250.1 Tips & Tricks To Make Apache Work With Jserv
139684.1 Oracle Applications Current Patchset Comparison Utility – patchsets.sh
236469.1 Using Distributed AD in Applications Release 11.5.
96630.1 Cash Management Overview
233428.1 Sharing the Application Tier File System in Oracle Applications 11i
243880.1 Shared APPL_TOP FAQ
330250.1 Tips & Tricks To Make Apache Work With Jserv
241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
209721.1 How to Change the Port Number on one Machine, When we Use Multiple Collaboration Suite Tiers
177377.1 How to change passwords in Portal (Database and lightweight user passwords)
304748.1 Internal: E-Business Suite 11i with Database FAQ
166213.1 SPFILE internals ** INTERNAL ONLY **
216208.1 Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release

11i Troubleshooting
*******************
186981.1 Oracle Application Server with Oracle E-Business Suite Release 11i

Physical Standby
*****************
Note:180031.1 Creating a Data Guard physical standby
Note:214071.1 Creating a Data Guard physical standby with Data Guard Manager
Note:232649.1 Configuring gap resolution
Note:232240.1 Performing a switchover
Note:227196.1 Performing a failover
Note:187242.1 Applying Patchsets with Physical Standby in Place

Logical Standby
****************
Note:186150.1 Creating a logical standby
Note:214071.1 Creating a logical standby with Data Guard Manager
Note:232240.1 Performing a switchover
Note:227196.1 Performing a failover
Note:233261.1 Tuning Log Apply Services
Note:215020.1 Troubleshooting Logical Standbys
Note:210989.1 Applying Patchsets with Logical Standby in Place
Note:233519.1 Known Issues with Logical Standby

Dataguard General Information
*****************************
Note:205637.1 Configuring Transparent Application Failover with Data Guard
Note:233509.1 Data Guard Frequently Asked Questions
Note:225633.1 Using SSH with 9i Data Guard
Note:233425.1 Top Data Guard Bugs
Note:219344.1 Usage, Benefits and Limitations of Standby RedoLogs
Note:201669.1 Setup and maintenance of Data Guard Broker using DGMGRL
Note:203326.1 Data Guard 9i Log Transportation on RAC
Note:239100.1 Data Guard Protection Modes Explained

Dataguard Configuration Best Practices
**************************************
Note:240874.1 Primary Site and Network Configuration Best Practices
Note:240875.1 9i Media Recovery Best Practices

Frequently Asked Questions
**************************
68993.1 Concurrent Managers on NT
1013526.102 Changing and Resetting Release 11 Applications Passwords
130608.1 ADPATCH BASICS
74924.1 ADI (Applications Desktop Integrator) Installation
61552.1 DIAGNOSING DATABASE HANGING ISSUES
114226.1 How to Set Up Apache and JSERV w/ Oracle XSQL, JSP, and Developer
146469.1 Installing and Configuring Oracle Login Server and Oracle Portal 3i with Oracle Applications 11i
146468.1 Installing Oracle9i Application Server 1.0.2.2.2 with Oracle Applications 11i
62463.1 Detailed Guide on How the Intelligent Agent Works
104452.1 Troubleshooting (Concurrent Manager Unix specific)
122662.1 How to change the hostname or domainname of your portal
231286.1 Configuring the Oracle Workflow 2.6 Java-based Notification Mailer with Oracle Applications 11i
230688.1 Basic ApacheJServ Troubleshooting with IsItWorking.class
204015.1 Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle8i EE
158818.1 Migrating the Workflow Mailer to the APPLMGR Account
185431.1 Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
177089.1 OAM11i Standalone Mode Setup and Configuration
172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i
166021.1 Oracle Applications Manager 11i – Pre-requisite Patches
166115.1 Oracle Applications Manager 11i integrated with Oracle Applications 11i
165041.1 Generic Service Management Functionality
204090.1 Generic Service Management Configuration using Applications Context Files
139863.1 Configuring and Troubleshooting the Self Service Framework with Oracle Applications (latest version)
187735.1 Workflow FAQ – All Versions
166830.1 Setting up Real Application Cluster (RAC) environment on Linux – Single node
158868.1 Step by Step, Oracle 9iAS Installation Process
123243.1 Scheduling Web Reports Via Oracle Reports Server CGI
165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i

RMAN and Backup & Restore
**************************
60545.1 How to Extract Controlfiles, Datafiles, and Archived Logs from RMAN Backupsets

10gR2 Setup Installation, ASM,CRS, RAC , Troubleshooting
********************************************************
471165.1 Additional steps to install 10gR2 RAC on IBM zSeries Based Linux (SLES10)
407086.1 USING CLONING IN CRS/RAC WINDOWS ENVIRONMENTS TO ADD A NODE
414163.1 10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA Failures)
467753.1 Veritas clusterware 5.0 not recognized by Oracle due to the fact that Veritas
467176.1 RAC: Installing RDBMS Oracle Home Hangs The Oui
466975.1 Step to remove node from Cluster when the node crashes due to OS or H/w
330358.1 CRS 10g R2 Diagnostic Collection Guide
401132.1 How to install Oracle Clusterware with shared storage on block devices
392207.1 CSSD Startup fails with NSerr (12532,12560) transport:(502,0,0) during Install
333166.1 CSSD Startup Fails with NSerr (12546,12560) transport:(516,0,0) During install
330929.1 CRS Stack Fails to Start After Reboot ORA-29702 CRS-0184
463255.1 Enable trace for gsd issues on 10gR2 RAC
338924.1 CLUVFY Fails With Error: Could not find a suitable set of interfaces for VIPs
462616.1 Reconfiguring the CSS disktimeout of 10gR2 Clusterware for Proper LUN Failover
461884.1 How To Disable Fatal Mode Oprocd On HP-UX Itanium 10gR2
404474.1 Status of Certification of Oracle Clusterware with HACMP 5.3 & 5.4
329530.1 Using Redhat Global File System (GFS) as shared storage for RAC
458324.1 Increased ‘Log File Sync’ waits in 10gR2
341214.1 How To clean up after a Failed (or successful) Oracle Clusterware Installation
454638.1 srvctl command failed – An unexpected exception has been detected in native
276434.1 Modifying the VIP or VIP Hostname of a 10g Oracle Clusterware Node
383123.1 PRKP-1001 CRS-215 srvctl Can not Start 2nd Instance
358620.1 How To Recreate Voting And OCR Disk In 10gR1/2 RAC
200346.1 RAC: Frequently Asked Questions
220970.1 RAC: Frequently Asked Questions
269320.1 Removing a Node from a 10g RAC Cluster
430266.1 How to install 10gR2 and 9iR2 on the same node with different UDLM requirement
283684.1 How to Change Interconnect/Public Interface IP Subnet in a 10g Cluster
391790.1 Unable To Connect To Cluster Manager Ora-29701
294430.1 CSS Timeout Computation in RAC 10g (10g Release 1 and 10g Release 2)
316583.1 VIPCA FAILS COMPLAINING THAT INTERFACE IS NOT PUBLIC
416868.1 CDMP DIRECTORIES AND TRW FILES ON RAC
414177.1 Executing root.sh errors with “Failed To Upg Oracle Cluster Registry Config
390483.1 DRM – Dynamic Resource management
390880.1 OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack
309542.1 How to start/stop the 10g CRS ClusterWare
396643.1 CVU HAS INCORRECT ORA_CRS_HOME VARIABLE AFTER APPLYING CRS BUNDLE II
387205.1 The 10.1.0.4 DB Cannot Start With 10.2.0.2.0 CRS And ASM
270512.1 Adding a Node to a 10g RAC Cluster
395156.1 Startup (mount) of 2nd RAC instance fails with ORA-00600 [kccsbck_first]
363777.1 How to Completely Remove a Service so that its Service_id Can Be Reused
391112.1 Database Resource Manager Spins Lmon To 100% Of Cpu
365530.1 Permissions not set correctly after 10gR2 installation
357808.1 Diagnosability for CRS / EVM / RACG
284752.1 10g RAC: Steps To Increase CSS Misscount, Reboottime and Disktimeout
332180.1 ASMCMD – ASM command line utility
371434.1 Using Openfiler iSCSI with an Oracle database
338047.1 cluvfy ERROR: Unable to retrieve database release version
183408.1 Raw Devices and Cluster Filesystems With Real Application Clusters
367564.1 Server Reboots When Rolling Upgrading CRS(10gr1 -> 10gr2)
358545.1 Root.sh is failing with CORE dumps, during CRS installation
343092.1 How to setup Linux md devices for CRS and ASM
295871.1 How to verify if CRS install is Valid
331934.1 RAC Single Instance (ASM) startup fails with ORA-27300/ORA-27301/ORA-27302
341974.1 10gR2 RAC Scheduling and Process Prioritization
341971.1 10gR2 RAC GES Statistics
341969.1 10gR2 RAC OS Best Practices
341965.1 10gR2 RAC Reference
341963.1 10gR2 RAC Best Practices
313540.1 Manually running cvu to verify stages during a CRS/RAC installation
331168.1 Oracle Clusterware consolidated logging in 10gR2
339710.1 Abnormal Program Termination When Installing 10gR2 on RHAS 4.0
339383.1 CSSD FAILURE DOES NOT REBOOT THE NODE
337937.1 Step By Step – 10gR2 RAC with ASM install on Linux(x86) – Demo
280209.1 10g RAC Performance Best Practices

CLONING
*********
216664.1 FAQ: Cloning Oracle Applications Release 11i
230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
135792.1 Cloning Oracle Applications Release 11i

Discoverer
************
139516.1 Discoverer 4i with Oracle Applications 11i
257798.1 Discoverer 10g (9.0.4) with Oracle Applications 11i
139516.1 Installation of Discoverer 4i

AutoConfig
************
165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
218089.1 Autoconfig FAQ

Real Application Clusters(RAC)
*******************************
181503.1 Real Application Clusters Whitepapers (OTN)
280209.1 10g RAC Performance Best Practices (INTERNAL ONLY)
302806.1 IBM General Parallel File System (GPFS) and Oracle RAC on AIX 5L and IBM eServer pSeries
270512.1 Adding a Node to a 10g RAC Cluster
137288.1 Manual Database Creation in Oracle9i (Single Instance and RAC)
292776.1 10g RAC Lessons Learned
280216.1 10g RAC Reference (INTERNAL ONLY)
269320.1 Removing a Node from a 10g RAC Cluster
226561.1 9iRAC Tuning Best Practices (INTERNAL ONLY)
220178.1 Installing and setting up ocfs on Linux – Basic Guide
208375.1 How To Convert A Single Instance Database To RAC In A Cluster File System Configuration
255359.1 Automatic Storage Management (ASM) and Oracle Cluster File System (OCFS) in Oracle10g
341963.1 10gR2 RAC Best Practices (INTERNAL ONLY)
273015.1 Migrating to RAC using Data Guard
329530.1 Using Redhat Global File System (GFS) as shared storage for RAC
270901.1 How to Dynamically Add a New Node to an Existing 9.2.0 RAC Cluster
203326.1 Data Guard 9i Log Transportation on RAC
169539.1 A Short Description of HA Options Available in 9i
160120.1 Oracle Real Application Clusters on Sun Cluster v3
226569.1 9iRAC Most Common Performance Problem Areas (INTERNAL ONLY)
251578.1 Step-By-Step Upgrade of Oracle Cluster File System (OCFS v1) on Linux
247135.1 How to Implement Load Balancing With RAC Configured System Using JDBC
139436.1 Understanding 9i Real Application Clusters Cache Fusion
285358.1 Creating a Logical Standby from a RAC Primary Using a Hot Backup
222288.1 9i Rel 2 RAC Running on IBM’s General Parallel File System
226567.1 9iRAC Related Init.ora Parameters (INTERNAL ONLY)
210889.1 RAC Installation with a NetApp Filer in Red Hat Linux Environment
341965.1 10gR2 RAC Reference (INTERNAL ONLY)
341969.1 10gR2 RAC OS Best Practices (INTERNAL ONLY)
226566.1 9iRAC Related Latches (INTERNAL ONLY)
220970.1 RAC: Frequently Asked Questions
268202.1 Dynamic node addition in a Linux cluster
285455.1 HOW TO MAKE AN EXCLUSIVE INSTANCE AVAILABLE ON MULTIPLE CLUSTER NODES.
332257.1 Using Oracle Clusterware with Vendor Clusterware FAQ
245079.1 Steps to clone a 11i RAC environment to a non-RAC environment
235158.1 How To Enable/Disbale Archive Log Mode on Oracle9i Real Application Cluster
210022.1 How To Add A New Instance To The Existing Two Nodes RAC Database Manually
317516.1 Adding and Deleting a Cluster Node on 10gR2 / Linux
271685.1 How to Run Autoconfig for RAC Environment on Apps Tier Only
278816.1 How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment
334459.1 How to change hostname in RAC environment
250378.1 Migrating Applications 11i to use Oracle9i RAC (Real Application Clusters).
295998.1 How to solve corruptions on OCFS file system
345081.1 How to Rename a RAC Database in a 10g Real Application Clusters Environment
312051.1 How To Remove Ocfs From Linux Box.

PORTAL
*******
228516.1 How to copy (export/import) Portal database schemas of IAS 9.0.2 to another database
330391.1 How to copy (export/import) Portal database schemas of IAS 10.1.2 to another database

UPGRADES
*********
125767.1 Upgrading Devloper6i with Oracle Applications 11i
216550.1 RDBMS upgrade to 9.2.0
161779.1 Upgradation of HTTP Server
212005.1 Upgrade Oracle Applications to 11.5.8
139863.1 Self Servie Framework Upgrade
112867.1 Express Server & OFA upgrade
124606.1 Jinitiator upgrade
130091.1 JDK upgrade to 1.3
130091.1 Upgrading Oracle Applications 11i to use JDK 1.3
144069.1 Upgrading to Workflow 2.6 with Oracle Applications 11i
159657.1 Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9i

EXPORT / IMPORT
***************
Note 230627.1 – 9i Export/Import Process for Oracle Applications Release 11i
Note 331221.1 – 10g Export/Import Process for Oracle Applications Release 11i
Note 362205.1 – 10g Release 2 Export/Import Process for Oracle Applications Release 11i
Note 277650.1 – How to Use Export and Import when Transferring Data Across Platforms or Acros…
Note 243304.1 – 10g: Transportable Tablespaces Across Different Platforms
Note 341733.1 – Export/Import DataPump Parameters INCLUDE and EXCLUDE – How to Load and Unload..

Thursday, 22 December 2011

Try to Start the DB/APPS without ENV File:

 STEP 1: Try to Start the DB/apps without ENV File:

[oracle@dev140 10.2.0]$  export ORACLE_SID=PROD
[oracle@dev140 10.2.0]$ export ORACLE_HOME=/oracle/PROD/db/tech_st/10.2.0/
[oracle@dev140 10.2.0]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@dev140 10.2.0]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin:/ oracle/PROD/db/tech_st/10.2.0//bin
[oracle@dev140 10.2.0]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Dec 20 14:57:22 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1271540 bytes
Variable Size             427821324 bytes
Database Buffers          633339904 bytes
Redo Buffers               11309056 bytes
Database mounted.
Database opened.
SQL>

Step 2: Creating LISTENER / NET SERVICE NAME

Creating Listner using NETCA.
[oracle@dev140 bin]$ pwd
/oracle/PROD/db/tech_st/10.2.0/bin
[oracle@dev140 bin]$
[oracle@dev140 bin]$ ./netca

Step:3 creating context file and Inst_top



oracle@dev140 bin]$ pwd
/oracle/PROD/apps/apps_st/comn/clone/bin
[oracle@dev140 bin]$


set the CLASSPATH  using Following Command.

[oracle@dev140 bin]$ ls
adaddnode.pl  adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl
[oracle@dev140 bin]$ export CLASSPATH=/oracle/PROD/apps/apps_st/comn/java/classes
[oracle@dev140 bin]$ ./adclonectx.pl

CREATING CONTEXT FILE IN APPS TIER USING FOLLOWING COMMAND

[oracle@dev140 bin]$ ./adclonectx.pl retrieve

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/RetrieveContext_12201730.log

Database Host [dev140]:

Database Host Domain [chainsys.com]:

Database Port [1521]:

Database SID:PROD

APPS Schema Name [APPS]:

APPS Schema Password:apps

The following context files are available:

[1] PROD_dev140 (APPL_TOP Context)
[2] PROD_dev140 (Database Context)

Select the context to retrieve [1]:1

Destination file path [/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml]:/oracle/PROD_dev140.xml---------------------------------->inew context  file created and stored in this path.
Retrieved context file to /oracle/PROD_dev140.xml

Log file location: /oracle/PROD/apps/apps_st/comn/clone/bin/RetrieveContext_12201730.log
[oracle@dev140 bin]$

CREATING INST_TOP

[oracle@dev140 bin]$ ./adclonectx.pl contextfile=/oracle/PROD_dev140.xml

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext  -e /oracle/PROD_dev140.xml
Enter the APPS password : apps

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [dev140] :

It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:

        -If cloning a context on source system for a remote system.
        -If cloning a context on a machine where the ports are taken and
         you do not want to shutdown the services at this point.
        -If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ? : y----> IF WE GIVE YES INST_TOP WILL BE CREATED

Target System Database SID : PROD

Target System Database Server Node [dev140] :

Target System Base Directory : /oracle/PROD

Target System Tools ORACLE_HOME Directory [/oracle/PROD/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/oracle/PROD/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/oracle/PROD/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/oracle/PROD/apps/apps_st/comn] :

Target System Instance Home Directory [/oracle/PROD/inst] :

Username for the Applications File System Owner [oracle] :

Group for the Applications File System Owner [dba] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [dev140:0.0] (y/n) ? : n

Target System Display [dev140:0.0] :

Target System Port Pool [0-99] : 0

Checking the port pool 0
done: Port Pool 0 is free
Report file located at /oracle/PROD/inst/apps/PROD_dev140/admin/out/portpool.lst
Complete port information available at /oracle/PROD/inst/apps/PROD_dev140/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /oracle/PROD/db/tech_st/10.2.0/appsutil/outbound/PROD_dev140
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /oracle/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log
contextfile=/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml
Check Clone Context logfile /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log for details.
[oracle@dev140 bin]$ pwd
/oracle/PROD/apps/apps_st/comn/clone/bin
[oracle@dev140 bin]$

RUN ADCONFIG TO CREATING   .ENV FILE.

[oracle@dev140 bin]$ pwd
/oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin
[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./adconfig.pl contextfile=/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml
Enter the APPS user password:

The log file for this session is located at: /oracle/PROD/inst/apps/PROD_dev140/admin/log/12201824/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /oracle/PROD/inst/apps/PROD_dev140
        Classpath                   : /oracle/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/oracle/PROD/apps/apps_st/comn/java/classes

        Using Context file          : /oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[oracle@dev140 bin]$





Step 3: Creating Appsutil using admkappsutil.
Source the new APPS .ENV file
[oracle@dev140 bin]$ pwd
/oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin
[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./admkappsutil.pl

OUTPUT OF THIS SCRIPT
Starting the generation of appsutil.zip
Log file located at /oracle/PROD/inst/apps/PROD_dev140/admin/log/MakeAppsUtil_12201842.log
output located at /oracle/PROD/inst/apps/PROD_dev140/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
[oracle@dev140 bin]$


MOVE THE APPSUTIL ZIP FILE TO RDBMS HOME LOCATION USING FOLLOWING COMMAND
 [oracle@dev140 bin]$cp -pr /oracle/PROD/inst/apps/PROD_dev140/admin/out/appsutil.zip /oracle/PROD/db/tech_st/10.2.0/


UNZIP THIS FILE IN RDBMS HOME LOCATION

[oracle@dev140 10.2.0]$ unzip -o appsutil.zip



STEP :4 NO JRE FILE IN APPSUTIL RDBMS HOME.SO  COPYING FROM THE COMMONTOP JRE DIR .USING THE FOLLOWING STEP.

[oracle@dev140 clone]$ pwd
/oracle/PROD/apps/apps_st/comn/clone

[oracle@dev140 clone]$ cp -pr jre /oracle/PROD/db/tech_st/10.2.0/appsutil    
                                                 OR  THIS COMMAND
[oracle@dev140 clone]$ cp -vR jre /oracle/PROD/db/tech_st/10.2.0/appsutil

STEP:5

CREATING CONTEXT FILE IN DBTIER USING FOLLOWING STEPS

SET YOUR OWN PROFILE
[oracle@dev140 10.2.0]$ . profile

[oracle@dev140 10.2.0]$ pwd
/oracle/PROD/db/tech_st/10.2.0
[oracle@dev140 10.2.0]$ cd appsutil/bin/
[oracle@dev140 bin]$ ./adbldxml.pl
OUTPUT:
Starting context file generation for db tier..
Using JVM from /oracle/PROD/db/tech_st/10.2.0/appsutil/jre/bin/java to execute java programs..
APPS Password: apps

The log file for this adbldxml session is located at:
/oracle/PROD/db/tech_st/10.2.0/appsutil/log/adbldxml_12201900.log
AC-00013: Error: File: /oracle/PROD/db/tech_st/10.2.0/network/admin/listener.ora is not a valid file as database SID could not be found for connect string: PROD

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: dev140

Enter Port of Database server: 1521

Enter SID of Database server: PROD

The context file has been created at:
/oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.xml
[oracle@dev140 bin]$

CREATING  .ENV FILE BY USING ADCONFIG.PL

[oracle@dev140 bin]$ pwd
/oracle/PROD/db/tech_st/10.2.0/bin
[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./adconfig.pl contextfile=/oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.xml

OUTPUT:

Enter the APPS user password:

The log file for this session is located at: /oracle/PROD/db/tech_st/10.2.0/appsutil/log/PROD_dev140/12201906/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /oracle/PROD/db/tech_st/10.2.0
        Classpath                   : :/oracle/PROD/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/PROD/db/tech_st/10.2.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/10.2.0/appsutil/java:/oracle/PROD/db/tech_st/10.2.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/10.2.0/jlib/ldapjclnt10.jar

        Using Context file          : /oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oracle@dev140 bin]$ pwd
/oracle/PROD/db/tech_st/10.2.0/appsutil/bin
[oracle@dev140 bin]$


SET THE APPS ENV FILE AND START THE APPLICATION


Thursday, 15 December 2011

adpatch failed

adpatch failed

The steps mentioned below is one of the time saving technique.Adpatch is running and fails on one of the workers.  To fix this worker and continue with the patch installation, a new patch needs to be applied.Considering that only 1 adpatch session can run on an instance at any given time(yes, if you cant believe then try it once  ), how can a patch be applied when adpatch is already running?


Using the adctrl utility, shutdown the workers.

a. adctrl

b. Select option 3 “Tell worker to shutdown/quit”

2.  Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema

a. sqlplus applsys/<password>

b. create table fnd_Install_processes_back as select * from fnd_Install_processes;

c. The 2 tables should have the same number of records.

select count(*) from fnd_Install_processes_back;

select count(*) from fnd_Install_processes;

3.  Backup the AD_DEFERRED_JOBS table.

a. sqlplus applsys/<password>

b. create table AD_DEFERRED_JOBS_back

as select * from AD_DEFERRED_JOBS;

c. The 2 tables should have the same number of records.

select count(*) from AD_DEFERRED_JOBS_back;

select count(*) from AD_DEFERRED_JOBS;

4.  Backup the .rf9 files located in $APPL_TOP/admin/<SID>/restart directory.

At this point, the adpatch session should have ended and the cursor should

be back at the Unix prompt.

a. cd $APPL_TOP/admin/<SID>

b. mv restart restart_back

c. mkdir restart

6.  Drop the FND_INSTALL_PROCESSES table and the AD_DEFFERED_JOBS table.

a. sqlplus applsys/<password>

b. drop table FND_INSTALL_PROCESSES;

c. drop table AD_DEFERRED_JOBS;

8.  Apply the new patch.

9.  Restore the .rf9 files located in $APPL_TOP/admin/<SID>/restart_back

directory.

a. cd $APPL_TOP/admin/<SID>

b. mv restart restart_<patchnumber>

c. mv restart_back restart

10. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS

schema.

a. sqlplus applsys/<password>

b. create table fnd_Install_processes

as select * from fnd_Install_processes_back;

c. The 2 tables should have the same number of records.

select count(*) from fnd_Install_processes;

select count(*) from fnd_Install_processes_back;

11. Restore the AD_DEFERRED_JOBS table.

a. sqlplus applsys/<password>

b. create table AD_DEFERRED_JOBS

as select * from AD_DEFERRED_JOBS_back;

c. The 2 tables should have the same number of records.

select count(*) from AD_DEFERRED_JOBS_back;

select count(*) from AD_DEFERRED_JOBS;

12. Re-create synonyms

a. sqlplus apps/apps

b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;

c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;

13. Start adpatch, it will resume where it stopped previously.