Oracle Applications - Step by step Approach

Critical Patch Update for January 2012 is now avaliable

noreply@blogger.com (Balaji Srinivasan) — Thu, 19 Jan 2012 04:20:00 +0000

As from the blogs of oracle (Steven Chan)

The Critical Patch Update (CPU) for January 2012 was released on January 17, 2012. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents.

Supported products that are not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.

Also, it is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches, as this is where you can find important pertinent information.

The Critical Patch Update Advisory is available at the following location:

§ Oracle Technology Network

The next four Critical Patch Update release dates are:

§ April 17, 2012

§ July 17, 2012

§ October 16, 2012

§ January 15, 2013

Critical Patch Update	Latest Version/Date
Critical Patch Update - January 2012	Rev 2, 18 January 2012
Critical Patch Update - October 2011	Rev 3, 20 October 2011
Critical Patch Update - July 2011	Rev 7, 15 December 2011
Critical Patch Update - April 2011	Rev 5, 12 May 2011
Critical Patch Update - January 2011	Rev 3, 1 February 2011
Critical Patch Update - October 2010	Rev 1, 12 October 2010
Critical Patch Update - July 2010	Rev 1, 13 July 2010
Critical Patch Update - April 2010	Rev 1, 13 April 2010
Critical Patch Update - January 2010	Rev 2, 4 February 2010
Critical Patch Update - October 2009	Rev 1, 20 October 2009
Critical Patch Update - July 2009	Rev 3, 03 September 2009
Critical Patch Update - April 2009	Rev 4, 03 September 2009
Critical Patch Update - January 2009	Rev 4, 03 September 2009
Critical Patch Update - October 2008	Rev 3, 03 September 2009
Critical Patch Update - July 2008	Rev 3, 05 March 2009
Critical Patch Update - April 2008	Rev 4, 22 May 2008
Critical Patch Update - January 2008	Rev 1, 15 January 2008
Critical Patch Update - October 2007	Rev 1, 16 October 2007
Critical Patch Update - July 2007	Rev 2, 19 July 2007
Critical Patch Update - April 2007	Rev 2, 18 April 2007
Critical Patch Update - January 2007	Rev 2, 05 March 2007
Critical Patch Update - October 2006	Rev 4, 06 March 2006
Critical Patch Update - July 2006	Rev 1, 18 July 2006
Critical Patch Update - April 2006	Rev 1, 18 April 2006
Critical Patch Update - January 2006	Rev 1, 17 January 2006
Critical Patch Update - October 2005	Rev 2, 19 December 2005
Critical Patch Update - July 2005	Rev 1, 12 July 2005
Critical Patch Update - April 2005	Rev 2, 13 April 2005
Critical Patch Update - January 2005	Rev 2, 15 March 2005

The following table includes Critical Patch Updates for Oracle Java SE.

Java SE Critical Patch Update	Latest Version/Date
Java SE Critical Patch Update - October 2011	Rev 1, 18 October 2011
Java SE Critical Patch Update - June 2011	Rev 1, 07 June 2011
Java SE and Java for Business Critical Patch Update - February 2011	Rev 1, 15 February 2011
Java SE and Java for Business Critical Patch Update - October 2010	Rev 1, 12 October 2010
Java SE and Java for Business Critical Patch Update - March 2010	Rev 3, 08 April 2010

Security Alerts

Oracle will issue Security Alerts for vulnerability fixes deemed too critical to wait for distribution in the next Critical Patch Update. The Security Alerts released since 2005 are listed in the following table.Click here for Security Alerts released before 2006. Security Advisories Notifications prior to July 2008 for BEA products are located here. Security Sun Alert notifications prior to April 2010 for Sun products are located here.

Security Alert Number And Description	Latest Version/Date
Alert for CVE-2011-3192	Rev 1, 15 September 2011
Alert for CVE-2010-4476	Rev 1, 08 February 2011
Alert for CVE-2010-0886	Rev 2, 18 May 2010
Alert for CVE-2010-0073	Rev 1, 04 February 2010
Alert for CVE-2008-3257	Rev 3, 05 March 2009

Third Party Bulletin

Oracle has no control over the timing and content of security fixes created by third parties. Consequently, the Third Party Bulletin, rather than Oracle Critical Patch Update Advisories and Security Alerts has been used by Oracle as a mechanism to announce security fixes for third party software distributed with Oracle Sun products for over a year. Starting from January 2012, the Third Party Bulletin will also be used to announce security fixes for third party software that are distributed with non-Sun Oracle products.

The Third Party Patch Map lists all security patches announced for third party software organized by Oracle products. The current list of all Oracle products that use the Third Party Bulletin is as follows:

Hardware Systems
Oracle Glassfish
Oracle Secure Global Desktop
Solaris
Sun Java System Access Manager
Sun Java System Application Server
Sun Ray

Contents from OTN:

Oracle Critical Patch Update Advisory - January 2012

Description

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative but each advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes. Please refer to:

Critical Patch Updates and Security Alerts for information about Oracle Security Advisories.

Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible. This Critical Patch Update contains 78 new security fixes across all product families listed below.

Affected Products and Components

Security vulnerabilities addressed by this Critical Patch Update affect the products listed in the categories below. The product area of the patches for the listed versions is shown in the Patch Availability column corresponding to the specified Products and Versions column. Please click on the link in the Patch Availability column below or in the Patch Availability Table to access the documentation for those patches.

The list of affected product releases and versions that are in Premier Support or Extended Support, under the Oracle Lifetime Support Policy is as follows:

Affected Products and Versions	Patch Availability
Oracle Database 11g Release 2, versions 11.2.0.2, 11.2.0.3	Database
Oracle Database 11g Release 1, version 11.1.0.7	Database
Oracle Database 10g Release 2, versions 10.2.0.3, 10.2.0.4, 10.2.0.5	Database
Oracle Database 10g Release 1, version 10.1.0.5	Database
Oracle Fusion Middleware 11g Release 1, versions 11.1.1.3.0, 11.1.1.4.0, 11.1.1.5.0	Fusion Middleware
Oracle Application Server 10g Release 3, version 10.1.3.5.0	Fusion Middleware
Oracle Outside In Technology, versions 8.3.5, 8.3.7	Fusion Middleware
Oracle WebLogic Server, versions 9.2.4, 10.0.2, 11gR1 (10.3.3, 10.3.4, 10.3.5)	Fusion Middleware
Oracle E-Business Suite Release 12, versions 12.1.2, 12.1.3	E-Business Suite
Oracle E-Business Suite Release 11i, version 11.5.10.2	E-Business Suite
Oracle Transportation Management, versions 5.5, 6.0, 6.1, 6.2	Oracle Supply Chain
Oracle PeopleSoft Enterprise CRM, version 8.9	PeopleSoft
Oracle PeopleSoft Enterprise HCM, versions 8.9, 9.0, 9.1	PeopleSoft
Oracle PeopleSoft Enterprise PeopleTools, version 8.52	PeopleSoft
Oracle JDEdwards, version 8.98	JDEdwards
Oracle Sun Product Suite	Oracle Sun Product Suite
Oracle VM VirtualBox, version 4.1	Oracle Virtualization Product Suite
Oracle Virtual Desktop Infrastructure, version 3.2	Oracle Virtualization Product Suite
Oracle MySQL Server, versions 5.0, 5.1, 5.5	Oracle MySQL Product Suite

Patch Availability Table and Risk Matrices

Products with Cumulative Patches

The Oracle Database, Oracle Fusion Middleware, Oracle Enterprise Manager Base Platform (formerly "Oracle Enterprise Manager Grid Control"), Oracle E-Business Suite Applications, JD Edwards EnterpriseOne, JD Edwards OneWorld Tools, PeopleSoft Enterprise Portal Applications, PeopleSoft Enterprise PeopleTools, Siebel Enterprise, Oracle Industry Applications and Oracle VM patches in the Critical Patch Updates are cumulative; patches for any of these products included in a Critical Patch Update will include all fixes for that product from the previous Critical Patch Updates. For more information about cumulative and non-cumulative patches, check the patch availability documents in the table below for the respective product groups.

Patch Availability Table

For each administered Oracle product, consult the documentation for patch availability information and installation instructions referenced from the following table. For an overview of the Oracle product documentation related to this Critical Patch Update, please refer to the Oracle Critical Patch Update January 2012 Documentation Map, My Oracle Support Note 1368685.1.

Product Group	Risk Matrix	Patch Availability and Installation Information
Oracle Database	Oracle Database Risk Matrix	Patch Set Update and Critical Patch Update January 2012 Availability Document, My Oracle Support Note 1374524.1
Oracle Fusion Middleware	Oracle Fusion Middleware Risk Matrix	Patch Set Update and Critical Patch Update January 2012 Availability Document, My Oracle Support Note 1374524.1
Oracle Applications - E-Business Suite	Oracle Applications, E-Business Risk Matrix	Oracle E-Business Suite Critical Patch Update Note for January 2012, My Oracle Support Note 1384016.1
Oracle Applications - Oracle PeopleSoft Enterprise, JDEdwards and Oracle Supply Chain Product Suite	Oracle PeopleSoft Enterprise Risk Matrix, Oracle JDEdwards Risk Matrix, Oracle Supply Chain Products Risk Matrix	Critical Patch Update Knowledge Document for PeopleSoft Enterprise, JDEdwards and Oracle Supply Chain Suite Products, My Oracle Support Note 1388673.1
Oracle Sun Products Suite	Oracle Sun Products Suite Risk Matrix	Critical Patch Update January 2012 Patch Delivery Document for Oracle Sun Products Suite My Oracle Support Note 1390289.1
Oracle Virtualization	Oracle Virtualization Risk Matrix	Critical Patch Update January 2012 Patch Delivery Document for Oracle Sun Products Suite My Oracle Support Note 1390289.1
Oracle MySQL Server	Oracle MySQL Risk Matrix	Critical Patch Update January 2012 Patch Delivery Document for Oracle Sun Products Suite My Oracle Support Note 1390289.1

Risk Matrix Content

Risk matrices list only security vulnerabilities that are newly fixed by the patches associated with this advisory. Risk matrices for previous security fixes can be found in previous Critical Patch Update advisories. An English text version of the risk matrices provided in this document is available here.

Several vulnerabilities addressed in this Critical Patch Update affect multiple products. Each vulnerability is identified by a CVE# which is a unique identifier for a vulnerability. A vulnerability that affects multiple products will appear with the same CVE# in all risk matrices. Italics indicate vulnerabilities in code included from other product areas.

Security vulnerabilities are scored using CVSS version 2.0 (see Oracle CVSS Scoring for an explanation of how Oracle applies CVSS 2.0). Oracle conducts an analysis of each security vulnerability addressed by a Critical Patch Update (CPU). Oracle does not disclose information about the security analysis, but the resulting Risk Matrix and associated documentation provide information about the type of vulnerability, the conditions required to exploit it, and the potential impact of a successful exploit. Oracle provides this information, in part, so that customers may conduct their own risk analysis based on the particulars of their product usage. As a matter of policy, Oracle does not disclose detailed information about an exploit condition or results that can be used to conduct a successful exploit. Oracle will not provide additional information about the specifics of vulnerabilities beyond what is provided in the CPU or Security Alert notification, the Patch Availability Matrix, the readme files, and FAQs. Oracle does not provide advance notification on CPUs or Security Alerts to individual customers. Finally, Oracle does not distribute exploit code or proof of concept code for product vulnerabilities. For more information, see Oracle vulnerability disclosure policies.

The protocol in the risk matrix implies that all its secure variants (if applicable) are affected too. For example, if HTTP is listed as an affected protocol, it implies that HTTPS (if applicable) is also affected.

Workarounds

Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible. Until you apply the CPU fixes, it may be possible to reduce the risk of successful attack by blocking network protocols required by an attack. For attacks that require certain privileges or access to certain packages, removing the privileges or the ability to access the packages from users that do not need the privileges may help reduce the risk of successful attack. Both approaches may break application functionality, so Oracle strongly recommends that customers test changes on non-production systems. Neither approach should be considered a long-term solution as neither corrects the underlying problem.

Skipped Critical Patch Updates

Oracle strongly recommends that customers apply security fixes as soon as possible. For customers that have skipped one or more Critical Patch Updates and are concerned about products that do not have security fixes announced in this CPU, please review previous Critical Patch Update advisories to determine appropriate actions.

Product Dependencies

Oracle products may have dependencies on other Oracle products. Hence security vulnerability fixes announced in this Critical Patch Update may affect one or more dependent Oracle products. For details regarding these dependencies and to apply patches to dependent products, please refer to Patch Set Update and Critical Patch Update January 2012 Availability Document, My Oracle Support Note 1374524.1.

Critical Patch Update Supported Products and Versions

Critical Patch Update patches are provided only for product versions that are covered under the Premier Support or Extended Support phases of the Lifetime Support Policy. We recommend that customers plan product upgrades to ensure that Critical Patch Update patches are available for the versions they are currently running.

Product releases that are not under Premier Support or Extended Support are not tested for the presence of vulnerabilities addressed by this Critical Patch Update. However, it is likely that earlier versions of affected releases are also affected by these vulnerabilities.

Supported Database, Fusion Middleware, Oracle Enterprise Manager Base Platform (formerly "Oracle Enterprise Manager Grid Control") and Collaboration Suite products are patched in accordance with the Software Error Correction Support Policy explained in My Oracle Support Note 209768.1. Please review the Technical Support Policies for further guidelines regarding support policies and phases of support.

Products in Extended Support

Critical Patch Update patches are available to customers who have purchased Extended Support under the Lifetime Support Policy. Customers must have a valid Extended Support service contract to download Critical Patch Update patches for products in the Extended Support Phase.

On Request Model

Oracle proactively creates patches only for platform/version combinations that, based on historical data, customers are likely to download for the next Critical Patch Update. Patches for historically inactive platform/version combinations of the Oracle Database, Oracle Application Server and Enterprise Manager will be created only if requested by customers.

Refer to Patch Set Update and Critical Patch Update January 2012 Availability Document, My Oracle Support Note 1374524.1 for further details regarding the On Request patches.

Credit Statement

The following people or organizations reported security vulnerabilities addressed by this Critical Patch Update to Oracle: an Anonymous Reporter of TippingPoint's Zero Day Initiative; Behrang Fouladi of SensePost Information Security; Clement Lecigne; Dennis Yurichev of McAfee Labs; Gorkem Yakin; InfoWorld; Juan Pablo Perez Etchegoyen of Onapsis; Mateusz "j00ru" Jurczyk; Michael Myngerbayev of McAfee Labs; Michael Oglesby of True Digital Security; Minetoshi Takizawa through JPCERT/CC Vulnerability Handling Team; Robert Maly of Ness Technologies; Rohan Stelling of Stratsec Research; Travis Emmert of Veracode; and Will Dormann of CERT/CC.

Critical Patch Update Schedule

Critical Patch Updates are released on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:

17 April 2012
17 July 2012
16 October 2012
15 January 2013

References

Oracle Critical Patch Updates and Security Alerts main page [ Oracle Technology Network ]
Critical Patch Update - January 2012 Documentation Map [ My Oracle Support Note 1368685.1 ]
Oracle Critical Patch Updates and Security Alerts - Frequently Asked Questions [ CPU FAQ ]
Risk Matrix definitions [ Risk Matrix Definitions ]
Use of Common Vulnerability Scoring System (CVSS) by Oracle [ Oracle CVSS Scoring ]
English text version of the risk matrices [ Oracle Technology Network ]
List of public vulnerabilities fixed in Critical Patch Updates and Security Alerts [ Oracle Technology Network ]
Software Error Correction Support Policy [ My Oracle Support Note 209768.1 ]

Oracle is advising the latest patches to be applied ASAP and workarounds to be considered for the pending issues.

Cheers

txkWfClone.sh Poor performance in R12

noreply@blogger.com (Balaji Srinivasan) — Sat, 19 Nov 2011 07:19:00 +0000

Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profile.

Sometimes, it may end up in error

txkWfClone.sh INSTE8_APPLY -1

it is time out message and could not complete the cloning.

It Runs txkWfClone.sql against apps user in the database.

During cloning, execution of txkWfClone is required only for the first autoconfig run. For subsequent Autoconfig runs, it is not required

To resolve this,

Take the backup of the files described.

1). Move the phase of the script txkWfClone.sh to INSTALL_SETUP phase in $FND_TOP/admin/driver/fndtmpl.drv:

###### Required for OWF ######
fnd admin/template txkWfClone.sql INSTE8 /admin/install/ txkWfClone.sql 600

to

fnd admin/template txkWfClone.sh INSTALL /admin/install/ txkWfClone.sh 600

Changing the autoconfig phase of this script from INST8_SETUP to INSTALL_SETUP will prevent it from unwanted execution, resulting in better performance for future autoconfig runs.

The role of txkWfCLone.sh is to create workflow related references in db tier of target system in the cloning process.

During txkWfClone.sh's execution, the comparison between source system and target system URLs is done. Essentially, in a scenario where we are creating an additional middle tier from an existing middle tier/(s) having one common database tier, it will result in redundant operation of changing/creating workflow references for target middle tier.

For comparison, txkWfClone constructs an url for target system using the context variables as follows:

'%s_webentryurlprotocol%'||'://'||'%s_webhost%'||'.'||'%s_domainname%'||':'||'
%s_active_webport%'||'/pls/'||'%s_dbSid%'

Cheers!!!

11gR2 (11.2.0.3) is certified with Oracle E Business Suite

noreply@blogger.com (Balaji Srinivasan) — Wed, 16 Nov 2011 04:20:00 +0000

Oracle today, announced the version of 11.2.0.3 is certified with Oracle E Business Suite.

It announces minimal requirement for to upgrade this database is:

11i: 11.5.10.2 (ATG.PF.H Rup 6 or Higher)

R12: 12.0.4 or higher (or) 12.1.1 or later.

The patchset 10404530 (5.0 GB) is the third patchset for 11gR2 family.

Oracle E-Business Suite Release 11i

Prerequisites

11.5.10.2 + ATG PF.H RUP 6 and higher

Certified Platforms

Linux x86 (Oracle Linux 4, 5)

Linux x86 (RHEL 4, 5)

Linux x86 (SLES 10)

Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only

Linux x86-64 (RHEL 4, 5) -- Database-tier only

Linux x86-64 (SLES 10--Database-tier only)

Oracle Solaris on SPARC (64-bit) (10)

Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only

Pending Platform Certifications

Microsoft Windows Server (32-bit)

Microsoft Windows Server (64-bit)

HP-UX PA-RISC (64-bit)

HP-UX Itanium

IBM: Linux on System z

IBM AIX on Power Systems

Oracle E-Business Suite Release 12

Prerequisites

Oracle E-Business Suite Release 12.0.4 or later; or,
Oracle E-Business Suite Release 12.1.1 or later

Certified Platforms

Linux x86 (Oracle Linux 4, 5)

Linux x86 (RHEL 4, 5)

Linux x86 (SLES 10)

Linux x86-64 (Oracle Linux 4, 5)

Linux x86-64 (RHEL 4, 5)

Linux x86-64 (SLES 10)

Oracle Solaris on SPARC (64-bit) (10)

Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only

Pending Platform Certifications

Microsoft Windows Server (32-bit)

Microsoft Windows Server (64-bit)

HP-UX PA-RISC (64-bit)

IBM: Linux on System z

IBM AIX on Power Systems

HP-UX Itanium

Database Feature and Option Certifications
The following 11gR2 11.2.0.3 database options and features are supported for use:

Advanced Compression
Active Data Guard
Advanced Security Option (ASO) / Advanced Networking Option (ANO)
Database Vault
Database Partitioning
Data Guard Redo Apply with Physical Standby Databases
Native PL/SQL compilation
Oracle Label Security (OLS)
Real Application Clusters (RAC)
Real Application Testing
Transparent Data Encryption (TDE) Column Encryption
Transparent Data Encryption (TDE) Tablespace Encryption
SecureFiles
Virtual Private Database (VPD)

Oracle 12.1 is certified on Sun Sparc 11 (64 Bit)

noreply@blogger.com (Balaji Srinivasan) — Wed, 16 Nov 2011 04:07:00 +0000

This is indeed a great news, that Oracle E Business Suite 12.1 is certified on Sun Sparc 11 on 15th of Nov according to the Oracle Blog.

Oracle declared, that this OS is the first cloud OS.

Oracle Solaris 11

The First Cloud OS

Brings the reliability, security and scalability of the #1 UNIX OS to the cloud. The best platform for any enterprise application, co-engineered with the Oracle stack for performance and efficiency.

Optimized to run your applications faster—11 world records and counting
Designed-in virtualization with zero-overhead zones, secure live migration
 Data at cloud scale with built-in data services, up to 10x storage savings
Engineered cloud security with wire-speed encryption and delegated admin
Simplified cloud deployments, dramatically faster lifecycle management.

According to the blog from John Abraham,

Oracle E-Business Suite Release 12.1 Certified on Solaris 11

By John Abraham on Nov 15, 2011

Oracle Solaris 11 was announced last week, and I'm pleased to also announce that Oracle E-Business Suite Release 12.1 is now certified on Oracle Solaris on SPARC (64-bit). This new operating system release represents a culmination of years of hard work by our Solaris engineering group. It has a number of new and advanced features including simplified deployment and lifecycle management tools, built-in certified virtualization technologies, support on the latest generation SPARC chips, and more.

New installations of the E-Business Suite R12 on this platform will require version 12.1.1 or higher and the latest Rapid Install startCD version 12.1.1.13. For existing 12.1 installations, we have also certified an "in place" OS upgrade or the use of cloning to a target Solaris 11 system. There are also specific requirements to upgrade technology components such as the Oracle Database and Fusion Middleware. These requirements are noted in the links below.

References

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle Solaris on SPARC (64-bit) (My Oracle Support Document 761568.1)

Oracle Database Installation Guide 11g Release 2 (11.2) for Oracle Solaris

Interoperability Notes Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0) (My Oracle Support Document 1058763.1)

Cloning Oracle Applications Release 12 with Rapid Clone (My Oracle Support Document 406982.1)

Related Articles

It requires Rapid Install version 12.1.1.13. More about Rapid Install Version 12.1.1.13 is as follows..

New Rapid Install StartCD (12.1.1.13) for Oracle E-Business Suite Release 12.1 Now Available

By Max Arderius on Aug 26, 2011

A new Rapid Install startCD (Patch 11072566) for Oracle E-Business Suite Release 12.1 is now available for download in My Oracle Support.

The startCD updates are distributed to customers via My Oracle Support Patch which can be uncompressed on top of any previous 12.1 startCD under the main staging area. This patch replaces any previous startCDs.

What's New in This Update?

This new startCD version 12.1.1.13 includes important fixes for Platform specific issues such as support for AIX 7.1, global inventory registration problems in AIX 6.1 Power 7 Systems and a reoccurring fix for a corrupted datafile included in the 12.1.1 media for Linux 64:

12725526 : RAPID INSTALL SUPPORT FOR AIX 7.1
10312267 : RAPID WIZARD DOES NOT REGISTER THE 11G ORACLE HOME IN ORAINVENTORY (AIX 6.1 POWER7)
11818745 : FIX FOR BUG 8625887 NOT IN STARTCD 12.1.1.11 (LINUX-64 BIT)

This release also contains fixes for the following issues:

9324196 : NEW OCM DOESN'T VALIDATE WHEN USERNAME IS BLANK AND PASSWORD IS FILLED.
9238157 : INCORRECT USER CAUSE ERROR STACK PRINT ON THE SERVER SCREEN
6857060 : RAPIDWIZ FAILS WITH DATABASE INSTALL DRIVER MISSING
5842386 : RAPIDWIZ FAILS TO VALIDATE UNIX USERS WHEN USING CONF FILE

References

Oracle Applications Documentation Resources, Release 12.1 (Note 790942.1)
Oracle E-Business Suite Release 12.1.1: Release Content Documents (Note 561580.1)
Oracle Applications Upgrade Guide Release 11i to 12.1.1

Related Articles

FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker

noreply@blogger.com (Balaji Srinivasan) — Thu, 13 Oct 2011 04:05:00 +0000

This is about the error during application tier cloning.

The message i found was from adconfig.log,

ERRORCODE = 127 ERRORCODE_END
.end std out.
FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker
FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker

Cause:
Since the source system was Oracle Linux 5 update 5 and the destination is Oracle Linux 4 update 8, the executables linked using Linux 5 update 5 libraries are not compatible with the destination system.

Fix:
1. Source the application environment on each application tier.
2. using adadmin, Relink all the executables.
3. Run autoconfig on application tier. (It should complete successfully).
4. Restart the services.

Cheers!!!

Sun JRE1.6.0 update 27 has been certified for E Biz

noreply@blogger.com (Balaji Srinivasan) — Thu, 18 Aug 2011 04:12:00 +0000

Some questions following our last JRE certification indicated that there's still lingering confusion about which JRE releases are safe to use with E-Business Suite environments. To recap: JRE releases 1.6.0_18 through 1.6.0_22 had issues with mismanaging session cookies that affected some users in some circumstances.

The fix for those issues was first included in JRE 1.6.0_23. These fixes will carry forward and continue to be fixed in all future JRE releases. In other words, if you wish to avoid the mismanaged session cookie issue, you should apply any release after JRE 1.6.0_22: for example, JRE 1.6.0_23, 1.6.0_24, 1.6.0_25, and 1.6.0_26.

As of today, you can also apply Sun Java Runtime Environment 1.6.0_27 (a.k.a. JRE 6u27-b07). JRE 1.6.0_27 is certified with E-Business Suite Release 11i and 12.

All JRE releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops from JRE 1.6.0_03 and higher. We test all new JRE releases in parallel with the JRE development process, so all JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team.

You do not need to wait for a certification announcement before applying new JRE releases to your EBS users' desktops. If you wish, your desktop administrators can enable the Java "Automatic updates" option on your end-users' desktops.

What's new in Java 1.6.0_27?

See the 1.6.0_27 Update Release Notes for details about what has changed in this release. This release is available for download from the usual Sun channels and through the 'Java Automatic Update' mechanism.

JRE 1.6.0_27 provides the following fixes and functionality change that may affect Oracle E-Business Suite customers:

The browser window opening behind the Forms window issue is now fixed for Windows Vista and Windows 7 users running IE.
Selecting the "Close Window" Link through Internet Explorer will no longer display a modal window with the prompt, "The webpage you are viewing is trying to close the tab, Do you want to close this tab?".
Due to JRE6u27 now adhering more strictly to the IE browser settings, "File Export" and certain "Form Attachments" will now fail through IE without the correct browser setting for IE6, IE7 & IE8 users.

This JRE release has been certified with both Oracle E-Business Suite Release 11i and 12. We recommend this release for all E-Business Suite users.

IE9 is certified with Oracle E Business Suite

noreply@blogger.com (Balaji Srinivasan) — Tue, 09 Aug 2011 04:57:00 +0000

Internet Explorer 9 Certified with Oracle E-Business Suite

By Steven Chan (Oracle Development) on Aug 08, 2011

Microsoft Internet Explorer 9 is now certified as a desktop client browser for Oracle E-Business Suite Release 11i and 12. The certified desktop operating systems are:

Windows Vista Service Pack 1 (SP1) or Service Pack 2 (SP2)
Windows 7
Windows 7 Service Pack 1 (32-bit or 64-bit)

EBS 12.1 Prerequisites

EBS 12.1.1 or higher
Java Plug-in JRE 1.6.0_03 or higher

EBS 12.0 Prerequisites

Oracle Applications Technology R12.ATG_PF.A.DELTA.6 (patch 7237006) or higher.
Oracle Forms Version 10.1.2.3 or higher.
Java plug-in JRE 1.6.0_03 or higher.

EBS 11i Prerequisites

Oracle Applications patch 10 (11.5.10) plus Maintenance Pack 11.5.10 CU2 or higher
Oracle Applications Technology 11i.ATG_PF.H Rollup 6 (RUP 6) (patch 5903765) or higher.
Oracle Developer 6i patchset 19 (6.0.8.28.x) (see Note 125767.1)
Java plug-in JRE 1.6.0_03 or higher.
MLR patch 8888184 or higher (AIX Users should apply MLR patch 10043867 which replaces 8888184)

for More information.. please visit:

http://blogs.oracle.com/stevenChan/entry/internet_explorer_9_certified_with?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+OracleE-BusinessSuiteTechnology+(Oracle+E-Business+Suite+Technology)

To change ORACLE logo in Forms R12 Instances

noreply@blogger.com (Balaji Srinivasan) — Tue, 09 Aug 2011 04:29:00 +0000

Steps to Change the ORACLE Logo in the Forms of R12 Instances:

The idea here is to replace the logo in frmall.jar. Then reload it.

1. As a Application owner, populate the application environment file

2. cp $ORACLE_HOME/forms/java/frmall.jar $ORACLE_HOME/forms/java/frmall.jar_BAK

3. cp $ORACLE_HOME/forms/java/frmall.jar /tmp

4. cd /tmp

5. jar -xvf frmall.jar

6. rm -rf META-INF/

7. Rename your logo to oracle_logo.gif (Size 125 x 30 )

8. copy your own oracle_logo.gif to oracle/forms/icons/oracle_logo.gif in the /tmp folder.

9. cd /tmp

10. jar -cvf frmall.jar *

11. cp frmall.jar $ORACLE_HOME/forms/java/frmall.jar

12. adadmin (jar regenerate) and use the FORCE option

(selection option 1, regenerate Product JAR file, and

Do you wish to force regeneration of all jar files? [No] ? Yes

Retest the issue by opening the forms.

Cheers...

Trace Level 8 and SQLTXPLAIN

noreply@blogger.com (Balaji Srinivasan) — Fri, 05 Aug 2011 11:36:00 +0000

One of my Service Request needs to be updated with Trace Level 8 and SQLTXPLAIN:

I got the sql which took longer wait event through enabling the trace at the forms level.

Enabling Trace level 8 at backend:

ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';

Session Altered

Run the query.

SQL> ALTER SESSION SET EVENTS '10046 trace name context off';

Session altered.


To obtain the trace file use the following SQL

SET LINESIZE 100
COLUMN trace_file FORMAT A60

SELECT s.sid,
      s.serial#,
      pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||   
      '_ora_' || p.spid || '.trc' AS trace_file
FROM   v$session s,
      v$process p,
      v$parameter pa
WHERE  pa.name = 'user_dump_dest'
AND    s.paddr = p.addr
AND    s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');

This will provide you the trace file location.

SQLTXPLAIN:

Download the file sqlt.zip file from Note 215187.1 and unzip it to an empty local or server directory. This will create the "sqlt" directory and a number of subdirectories.
In the sqlt/install directory run the script "sqcreate.sql"
- Navigate to the sqlt/install directory
- Start SQL*Plus connecting INTERNAL (SYS) as SYSDBA
- Execute script sqcreate.sql and respond to values requested

EXAMPLE:
$ sqlplus / as sysdba
SQL> start sqcreate.sql

During the run, it will ask for the Connect Descriptor like @PROD, give your SID with @symbol.
It will ask for the sqltxplain Tablespace (Provide the tablespace name other than SYSTEM and SYSAUX). Later provide the schema password for the sqltxplain. It will create views and tables related with SQLTXPLAIN.

Create the sql to be analyzed as txt file. (eg. sqltxt.txt)

and move to the directory $ORACLE_HOME/sqlt/run

connect as apps and with apps password.

Run
@sqltxplain sqltxt.txt

It will run for a moment and asks you the password for SQLTXPLAIN schema password. Providing that will enable the script to export the output files to a dmp file and later it will zip them as a single file.

Move the zip file to your local computer and upload to SR.

Now, you will be having the sql with trace level 8 and SQLTXPLAIN.

Cheers!!!

LSNRCTL> set trc_level 16 R12DEV NL-00857: wrong number (0 - 1 needed) of arguments to "trc_level"

noreply@blogger.com (Balaji Srinivasan) — Thu, 28 Jul 2011 06:28:00 +0000

When one of my friend tried to enable the trace for listener.

he got,
LSNRCTL> set trc_level 16 R12DEV
NL-00857: wrong number (0 - 1 needed) of arguments to "trc_level"

The correct syntax is

LSNRCTL> set current_listener R12DEV
Current Listener is R12DEV

LSNRCTL> set trc_level 16
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX)(PORT=1531)))
MIGRATE parameter "trc_level" set to support
The command completed successfully

Hope this helps.

return code = .24.25.26.27.30.31.32.33.34.35.42.43.44.46.47.48.50

noreply@blogger.com (Balaji Srinivasan) — Mon, 04 Jul 2011 09:02:00 +0000

This blog is about the adcfgclone.pl on DB Tier after Migration from Windows to Linux

When I tried to adcfgclone on the same machine for a testing after a detailed adpreclone, i got this message during 2% of adcfgclone.

The error log says make log says:

'/usr/bin/ld: cannot find -ljava'

return code = .24.25.26.27.30.31.32.33.34.35.42.43.44.46.47.48.50

The issue was with $ORACLE_HOME/sysman/lib env_sysman.mk file

Edit the file and find the line JRE_LIB_DIR

It points to the source lib path:

Correct the path. Before you make any changes,

please make a copy of the file.

Then start the adcfgclone.pl dbTier...

It should complete relinking without errors.

During migration, i presented a jdk1.5.

Another issue after completion of relinking.

ouicli INSTE8_APPLY 255

The issue was with jdk 1.5 was not present at the appsutil directory.

Copy the jdk1.5 contents to appsutil directory under $ORACLE_HOME/appsutil/jre

Then rerun the adcfgclone.pl. It should complete normally.

Cheers!!!

`dl_iterate_phdr@GLIBC_2.2.4'

noreply@blogger.com (Balaji Srinivasan) — Tue, 08 Mar 2011 04:42:00 +0000

This post is about the error, i faced during relinking of oracle executable in 9.2.0.5.

During relink, we got the error message as

/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'

Actual Fix from oracle Support

Cause

The issue is caused by the higher gcc version 3.4.6 was used to run adcfgclone.pl.
or some Linux packages were missing.

The Linux/RDBMS document Note 303859.1 Title: Requirements for Installing Oracle 9iR2 on RHEL 4, explains the cause of the error :

/usr/lib/gcc/i386-redhat-linux/3.4.3/libgcc_s.so: undefined reference to
`dl_iterate_phdr@GLIBC_2.2.4'
collect2: ld returned 1 exit status

You can receive following error at the time of linking the binaries if any of the above packages are missed.

Solution

1)Check the current "gcc" version you are using.

rpm -q glibc
gcc -v

2) Apply the Patch 4198954 and test again.

Workaround:

cd /usr/bin
mv gcc gcc344
mv g++ g++344
ln -s gcc32 gcc
ln -s gcc++32 g++

This solved the problem with workaround itself. I dont need to apply the patch as this server has multiple instances including R12.1.1 and R12.1.3.

Happy helping.. cheers!!!

CPU for January 18, 2011 is out..

noreply@blogger.com (Balaji Srinivasan) — Thu, 20 Jan 2011 07:57:00 +0000

Hi readers..

Oracle just release CPU for 2011. It is advised to apply the patches at the earliest. For further info please visit on the links given below..

Oracle Critical Patch Update Advisory - January 2011

Description

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches. Critical Patch Updates are cumulative, except as noted below, but each advisory describes only the security fixes added since the previous Critical Patch Update. Thus, prior Critical Patch Update Advisories should be reviewed for information regarding earlier accumulated security fixes. Please refer to:

Critical Patch Updates and Security Alerts for information about Oracle Security Advisories.

Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible. This Critical Patch Update contains 66 new security fixes across all product families listed below.

Affected Products and Components

Affected product releases and versions that are in Premier Support or Extended Support, under the Oracle Lifetime Support Policy:

Affected Products and Versions	Patch Availability
Oracle Database 11g Release 2, version 11.2.0.1	Database
Oracle Database 11g Release 1, version 11.1.0.7	Database
Oracle Database 10g Release 2, versions 10.2.0.3, 10.2.0.4, 10.2.0.5	Database
Oracle Database 10g Release 1, version 10.1.0.5	Database
Oracle Audit Vault 10g Release 2, version 10.2.3.2	Database
Oracle Secure Backup 10g Release 3, version 10.3.0.2	Database
Oracle Fusion Middleware, 11g Release 1, versions 11.1.1.2.0, 11.1.1.3.0	Fusion Middleware
Oracle Application Server 10g Release 2, version 10.1.2.3.0	Fusion Middleware
Oracle Beehive, versions 2.0.1.0, 2.0.1.1, 2.0.1.2, 2.0.1.2.1, 2.0.1.3	Fusion Middleware
Oracle BI Publisher, versions 10.1.3.3.2, 10.1.3.4.0, 10.1.3.4.1, 11.1.1.3	Fusion Middleware
Oracle Document Capture, versions 10.1.3.4, 10.1.3.5	Fusion Middleware
Oracle GoldenGate Veridata, version 3.0.0.4	Fusion Middleware
Oracle JRockit versions, R27.6.7 and earlier (JDK/JRE 1.4.2, 5, 6), R28.0.1 and earlier (JDK/JRE 5, 6)	Fusion Middleware
Oracle Outside In Technology, version 8.3.0	Fusion Middleware
Oracle WebLogic Server, versions 7.0.7, 8.1.6, 9.0, 9.1, 9.2.3, 10.0.2, 10.3.2, 10.3.3	Fusion Middleware
Oracle Enterprise Manager Suite Release 10, version 10.2.0.5	Enterprise Manager Suite
Oracle Enterprise Manager Real User Experience Insight, version RUEI 6.0	Enterprise Manager Suite
Oracle E-Business Suite Release 12, versions 12.0.4, 12.0.5, 12.0.6, 12.1.1, 12.1.2, 12.1.3	E-Business Suite
Oracle E-Business Suite Release 11i, version 11.5.10.2	E-Business Suite
Oracle Agile Core, versions 9.3.0.2, 9.3.1	Oracle Supply Chain
Oracle Transportation Manager, versions 5.5, 6.0, 6.1, 6.2	Oracle Supply Chain
Oracle PeopleSoft Enterprise CRM, versions 8.9, 9.0, 9.1	PeopleSoft
Oracle PeopleSoft Enterprise HRMS, versions 8.9, 9.0, 9.1	PeopleSoft
Oracle PeopleSoft Enterprise PeopleTools, versions 8.49, 8.50, 8.51	PeopleSoft
Oracle Argus Safety, versions 5.0, 5.0.1, 5.0.2, 5.0.3	Health Sciences Applications
Oracle InForm Portal, versions 4.5, 4.6, 5.0	Health Sciences Applications
Oracle Sun Product Suite	Oracle Sun Product Suite
Oracle Open Office, version 3.2.1 and StarOffice/StarSuite, versions 7, 8	Oracle Sun Product Suite

Patch Availability Table and Risk Matrices

Products with Cumulative Patches

The Oracle Database, Oracle Fusion Middleware, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite Applications, JD Edwards EnterpriseOne, JD Edwards OneWorld Tools, PeopleSoft Enterprise Portal Applications, PeopleSoft Enterprise PeopleTools, Siebel Enterprise, Oracle Industry Applications and Oracle VM patches in the Critical Patch Updates are cumulative; patches for any of these products included in a Critical Patch Update will include all fixes for that product from the previous Critical Patch Updates.

Patch Availability Table

For each administered Oracle product, consult the documentation for patch availability information and installation instructions referenced from the following table. For an overview of the Oracle product documentation related to this Critical Patch Update, please refer to the Oracle Critical Patch Update January 2011 Documentation Map, My Oracle Support Note 1273550.1.

Product Group	Risk Matrix	Patch Availability and Installation Information
Oracle Database	Oracle Database Risk Matrix	Patch Set Update and Critical Patch Update January 2011 Availability Document, My Oracle Support Note 1263374.1
Oracle Fusion Middleware	Oracle Fusion Middleware Risk Matrix	Patch Set Update and Critical Patch Update January 2011 Availability Document, My Oracle Support Note 1263374.1
Oracle Enterprise Manager	Oracle Enterprise Manager Risk Matrix	Patch Set Update and Critical Patch Update January 2011 Availability Document, My Oracle Support Note 1263374.1
Oracle Applications - E-Business Suite	Oracle Applications, E-Business Risk Matrix	Oracle E-Business Suite Critical Patch Update Note for January 2011, My Oracle Support Note 1271167.1
Oracle Applications - Oracle PeopleSoft Enterprise and Oracle Supply Chain Product Suite	Oracle Applications, PeopleSoft and Oracle Supply Chain Products Risk Matrix	Critical Patch Update Knowledge Document for PeopleSoft Enterprise, JD Edwards EnterpriseOne, Siebel and Oracle Supply Chain Suite Products, My Oracle Support Note 1273607.1
Oracle Health Sciences Applications	Oracle Industry Applications Risk Matrix	Oracle Health Sciences Applications Critical Patch Update January 2011, My Oracle Support Note 1268333.1
Oracle Sun Products Suite	Oracle Sun Products Suite Risk Matrix	Critical Patch Update January 2011 Patch Delivery Document for Oracle Sun Products Suite My Oracle Support Note 1273260.1

Risk Matrix Content

Several vulnerabilities addressed in this Critical Patch Update affect multiple products. A vulnerability that affects multiple products will appear with the same CVE# in all risk matrices. Italics indicate vulnerabilities in code included from other product areas.

Security vulnerabilities are scored using CVSS version 2.0 (see Oracle CVSS Scoring for an explanation of how Oracle applies CVSS 2.0). Oracle conducts an analysis of each security vulnerability addressed by a Critical Patch Update (CPU). Oracle does not disclose information about the security analysis, but the resulting Risk Matrix and associated documentation provide information about the type of vulnerability, the conditions required to exploit it, and the potential result of a successful exploit. Oracle provides this information, in part, so that customers may conduct their own risk analysis based on the particulars of their product usage. As a matter of policy, Oracle does not disclose detailed information about an exploit condition or results that can be used to conduct a successful exploit. Oracle will not provide additional information about the specifics of vulnerabilities beyond what is provided in the CPU or Security Alert notification, the Patch Availability Matrix, the readme files, and FAQs. Oracle does not provide advance notification on CPUs or Security Alerts to individual customers. Finally, Oracle does not distribute exploit code or “proof-of-concept” code for product vulnerabilities. For more information, see Oracle vulnerability disclosure policies.

Workarounds

Skipped Critical Patch Updates

Product Dependencies

Oracle products may have dependencies on other Oracle products. Hence security vulnerability fixes announced in this Critical Patch Update may affect one or more dependent Oracle products. For details regarding these dependencies and to apply patches to dependent products, please refer to Patch Set Update and Critical Patch Update January 2011 Availability Document, My Oracle Support Note 1263374.1.

Unsupported Products and Versions

Critical Patch Update patches are not provided for product versions that are no longer covered under the Premier Support or Extended Support phases of the Lifetime Support Policy.

We recommend that customers upgrade to a supported version of Oracle products in order to obtain patches. Unsupported products, releases and versions are not tested for the presence of vulnerabilities addressed by this Critical Patch Update. However, it is likely that earlier versions of affected releases are also affected by these vulnerabilities.

Products in Extended Support

Supported Database, Fusion Middleware, EM Grid Control and Collaboration Suite products are patched in accordance with the Software Error Correction Support Policy explained in My Oracle Support Note 209768.1. Please review the Technical Support Policies for further guidelines regarding support policies and phases of support.

On Request Model

Refer to Patch Set Update and Critical Patch Update January 2011 Availability Document, My Oracle Support Note 1263374.1 for further details regarding the On Request patches.

Credit Statement

The following people or organizations reported security vulnerabilities addressed by this Critical Patch Update to Oracle: Alexander Kornbrust of Red Database Security; Alexandr Polyakov of Digital Security; Alexey Sintsov of Digital Security Research Group; Andrea Micalizzi aka rgod, working with TippingPoint's Zero Day Initiative; Andrey Labunets of Digital Security Research Group; Cris Neckar of Neohapsis, Inc.; Daniel Fahlgren; Esteban Martinez Fayo of Application Security, Inc.; Evdokimov Dmitriy of Digital Security Research Group; Karan Saberwal; Laszlo Toth; Maksymilian Arciemowicz of SecurityReason; Martin Rakhmanov of Application Security, Inc.; Matt Parcell of Accuvant; Monarch2020 of TippingPoint's Zero Day Initiative; Monarch2020 of unsecurityresearch.com; Robert Clugston of Accuvant; Roberto Suggi Liverani of Security-Assessment.com; Rodrigo Rubira Branco (BSDaemon) via TippingPoint's Zero Day Initiative; and Sumit Siddharth from 7safe.

Security-In-Depth Contributors

Oracle provides recognition to people that have contributed to our Security-In-Depth program (see FAQ). People are recognized for Security-In-Depth contributions if they provide information, observations or suggestions pertaining to security vulnerability issues that result in significant modification of Oracle code or documentation in future releases, but are not of such a critical nature that they are distributed in Critical Patch Updates.

For this Critical Patch Update, Oracle recognizes Abdul-Aziz Hariri of TippingPoint's Zero Day Initiative; Alexander Kornbrust of Red Database Security; and David Litchfield formerly of NGS Software for contributions to Oracle's Security-In-Depth program.

Critical Patch Update Schedule

Critical Patch Updates are released on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:

19 April 2011
19 July 2011
18 October 2011
17 January 2012

References

Oracle Critical Patch Updates and Security Alerts main page [ Oracle Technology Network ]
Critical Patch Update - January 2011 Documentation Map [ My Oracle Support Note 1273550.1 ]
Oracle Critical Patch Updates and Security Alerts - Frequently Asked Questions [ CPU FAQ ]
Risk Matrix definitions [ Risk Matrix Definitions ]
Use of Common Vulnerability Scoring System (CVSS) by Oracle [ Oracle CVSS Scoring ]
English text version of the risk matrices [ Oracle Technology Network ]
List of public vulnerabilities fixed in Critical Patch Updates and Security Alerts [ Oracle Technology Network ]
Software Error Correction Support Policy [ My Oracle Support Note 209768.1 ]

Login page error: 404 - The url /OA_HTML/AppsLogin not found

noreply@blogger.com (Balaji Srinivasan) — Tue, 18 Jan 2011 06:53:00 +0000

This blog speaks about the Login Page Issue on R12.1.1 instance.

Suddenly the login page was throwing an error - 404 /OA_HTML/AppsLogin was not found on the server

The access_log shows no errors. error.log from $LOG_HOME/ora/10.1.3/Apache shows

[Tue Jan 18 11:27:51 2011] [error] [client 123.238.255.152] [ecid: 1295330271:127.0.0.1:10897:0:2,0] File does not exist: /oracle/CLON/inst/apps/CLON_obaserver/portal/OA_HTML/AppsLogin
[Tue Jan 18 11:27:54 2011] [error] [client 123.238.255.152] [ecid: 1295330274:127.0.0.1:10897:0:3,0] File does not exist: /oracle/CLON/inst/apps/CLON_obaserver/portal/OA_HTML/AppsLogin
[Tue Jan 18 11:30:10 2011] [error] [client 123.238.255.152] [ecid: 1295330410:127.0.0.1:10899:0:2,0] File does not exist: /oracle/CLON/inst/apps/CLON_obaserver/portal/OA_HTML/AppsLogin

I recreated the jar files using adadmin

and compiled the jsp using

cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 20 -log /tmp/ojspc_error2.log

Nothing worked out.

Fix:
This problem occurred because wsrp_service.wsdl was owned by root but the services were being started by applmgr.

Ensure that the file
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl

it shows it is owned by root. Somebody started the services of Apps as root user.

Changed the owner of the file to Apps Owner.

Restarted the service.

Everything works fine.

Cheers...!!!

Mismanaged Session Cookie JRE 1.6.0 Update 23

noreply@blogger.com (Balaji Srinivasan) — Thu, 09 Dec 2010 04:40:00 +0000

This is great News from oracle, that the new Version of JRE 1.6.0 Update 23 is being certified to use with Oracle EBS.

Those who are all working with JRE for forms, update as soon as possible. (11i and R12)
As seen in

http://blogs.oracle.com/stevanChan

Mismanaged Session Cookie Issue Fixed for EBS in JRE 1.6.0_23

By Steven Chan on December 7, 2010 11:14 PM

At last: some good news for those of you affected by the mismanaged session cookie issue in E-Business Suite environments. This issue is resolved by the latest Sun Java Runtime Environment 1.6.0_23 (a.k.a. JRE 6u23, internal version 1.6.0_23-b05).

See the 1.6.0_23 Update Release Notes for details about what has changed in this release. This release is available for download from the usual Sun channels and through the 'Java Automatic Update' mechanism.

This JRE release has been certified with both Oracle E-Business Suite Release 11i and 12. We recommend this release for all E-Business Suite users.

References

Recommended Browsers for Oracle Applications 11i (Metalink Note 285218.1)
Upgrading Sun JRE (Native Plug-in) with Oracle Applications 11i for Windows Clients (Metalink Note 290807.1)
Recommended Browsers for Oracle Applications 12 (MetaLink Note 389422.1)
Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)

Related Articles

Apex 4.0.2 Configured with Oracle EBS 12.1.2

noreply@blogger.com (Balaji Srinivasan) — Wed, 01 Dec 2010 09:35:00 +0000

This post is about the integration of Oracle Application Express 4.0.2 with Oracle EBS 12.1.2 with oracle Application server 10.1.3.1 in the middle.

Operating System: Redhat - Linux 4 update 5
Database : 10.2.0.4
Application Server 10g: 10.1.3.1.0

Oracle E Business Suite: 12.1.2 with 11g Database (11.1.0.7)

The steps to be done:

1. Install oracle Database (Installed 10.2.0.1 and upgraded to 10.2.0.4)

Oracle Database to be installed with enterprise option.

Oracle Database upgraded to 10.2.0.4.
Detailed Upgrade steps can be obtained from (http://balajiabhi.blogspot.com/2009/02/install-soa-and-bpel-part-1.html) or click here

2. Install and configure Oracle SOA Suite 10g (10.1.3.1)
Installation and configuration Steps are detailed here

3. Oracle Application Express 4.0.2 can be obtained here (download)

4. Unzip the Apex402.zip into a location in the server.

5. Login to the EBS Database owner and connect as sys user.
[oracle@fserver apex]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 1 13:17:13 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace APEX402 datafile '/oracle2/db/apps_st/data/apex402.dbf' size 1G autoextend on;

Tablespace Created.

After creating the tablespace, exit from the sqlplus window, navigate to the folder where we unzipped the Apex402 Zip file.

from that location, again connect as sys user

SQL> @apexins.sql apex402 apex402 temp /i/

here apex402 is the tablespace
apex402 is the datafile,
temp is temporary tablespace by default
/i/ is the location of the image files. (simply specify /i/ at this time)

Once the process started, keep watching the logfile for the errors. Log file will be created at the base location of apex source files (Unzipped location)

...Adjust Oracle APEX Application owner to install owner

13 rows updated.

Commit complete.

...Adjust Application Express (APEX) version

FLOW_VERSION
--------------------------------------------------------------------------------
4.0.2.00.06

1 row selected.

12 rows updated.

1 row updated.

Commit complete.

User altered.

User altered.

PL/SQL procedure successfully completed.

-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------

PL/SQL procedure successfully completed.

-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------
-- Copying preferences to new schema. -------
Upgrade completed successfully no errors encountered.
-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:01:14.28

Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the APEX_040000 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

JOB_QUEUE_PROCESSES: 2

Performing Application Express component validation - please wait...

Completing registration process. 13:35:57
Validating installation. 13:35:57
...Database user "SYS", database schema "APEX_040000", user# "587" 13:35:57

Once you see this message, the Apex installation to the Oracle EBS database is completed.

unlock the APEX_PUBLIC_USER account.
Change the password using @apxchpwd.sql from apex directory.

6. Navigate to the Application server installed directory.

Copy the image files:

Copy the image files from the Apex Base directory to someother directory in the Application server installed directory.

In my case it is APPLICATION_SERVER_BASE/images

7. Move to Apache/modplsql/conf directory and edit the dads.conf file.

Add the entry like this:
Alias /i/ "/home/oraappload/product/10.1.3.1/OracleAS_2/images/"
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex_R12>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString fserver.fdomain:1550:VIS1212 [Hostname:DBListenerPort:SID]
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword welcome [Password chosen by running apxchpwd.sql]
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all
</Location>

Bounce the opmn using

Application_server_base/opmn/bin/./opmnctl stopall

and

Application_server_base/opmn/bin/./opmnctl startall

Login to the Apex using the URL from Application server:

http://localhost:port/pls/apex_r12/apex_admin

this will bring the Apex login screen, login with the username admin and password as specified during the apex install

then create the workspaces as requested from the admin page.

If You are getting ADMIN/ADMIN_PASSWORD as "Invalid Login Credential Error", then
run

connect as sys user at the EBS Database and execute this procedure:
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);

wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'xxx@xxxdomain.com',
p_web_password => 'admin2') ;

end;

Cheers.....

Previous Posts of Application Express from my blog (Complete List)

Apex Installation and configuration:

Apex 3.1 Installation with Oracle Databases:

Apex with Oracle EBS 11i

Apex 3.2 with Oracle EBS 12.0.6

Cheers..

Flashback - 10g or Later

noreply@blogger.com (Balaji Srinivasan) — Fri, 19 Nov 2010 09:56:00 +0000

Today i need to post on flashback feature on oracle database (10g or later)

Version: 10.2.0.1

One of my friend needed step by step configuration of Flashback. Here we go..

Pre-Requisites:
1. Database should be on archivelog mode

Startup the database with mount option:
(Simple Example of the procedure)

connect as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 19 14:40:28 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 603979776 bytes
Fixed Size 1220796 bytes
Variable Size 184553284 bytes
Database Buffers 411041792 bytes
Redo Buffers 7163904 bytes
Database mounted.

Enable the Flashback:

SQL> alter database flashback on;

Database altered.

SQL> alter system set DB_FLASHBACK_RETENTION_TARGET=4320;

System altered.

SQL> alter system set DB_FLASHBACK_RETENTION_TARGET=4320;

System altered.

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=1G;

System altered.

SQL> alter database open;

Now connect as a normal user who has default tablespace as someone other than SYSTEM

SQL> conn balaji/balaji
connected

SQL> create table test (id number(2), name varchar(30));

Table created.

SQL> insert into table test values (3, 'INDIA');
1 row inserted

SQL> insert into table test values(4,'SRILANKA');
1 row inserted

SQL> select * from test;

ID NAME
---------- --------------------
3 INDIA
4 SRILANKA

SQL> select tablespace_name from dba_segments where segment_name like 'TEST';

TABLESPACE_NAME
------------------------------
USERS

Note the user balaji has the default tablespace as USERS.

Drop the table test:

SQL> drop table test;

Table dropped.

SQL> select * from test;
ERROR at line 1:
ORA-00942: table or view does not exist

Using Flashback to get the table from recycle bin:

SQL> flashback table "TEST" to before drop;

Flashback complete.

SQL> select * from test;

ID NAME
---------- --------------------
3 INDIA
4 SRILANKA

SQL>

Points to remember:
Flashback option will not work for SYSTEM tablespace objects.

You will receive:
SQL> flashback table "TEST" to before drop;
flashback table "TEST" to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN

This is not about SYS objects, this is about SYSTEM tablespace... I can create a sys.table (logged as sys) on USER tablespace and then recover it through flashback.

Recycle functionality is available only for non-system locally-managed tablespaces.

Hope it helps... Cheers!!!

ORA-25153: Temporary Tablespace is Empty has been detected

noreply@blogger.com (Balaji Srinivasan) — Mon, 08 Nov 2010 08:14:00 +0000

The Following Error was detected while doing Cloning of DB Tier.

The actual Fact was:
The server was heavily loaded, so the control file creation terminated unsuccessfully. So manually created the control file and opened the database.

After this, I began run adconfig.sh

$cd $ORACLE_HOME/appsutil/bin
$ ./adconfig.sh
[oracle@prod bin]$ ./adconfig.sh
Enter the full path to the Context file: /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml
Enter the APPS user password:
The log file for this session is located at: /oracle/PROD/db/tech_st/11.1.0/appsutil/log/UPGRDE_prod/11081336/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/11.1.0
Classpath : :/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/o jdbc5.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/oracle/PROD/db/tech_st/11.1.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

Using Context file : /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...ERROR: InD bCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_ fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespac e is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm _util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java: 249)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchroni zer.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(File SysDBCtxMerge.java:678)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(Fi leSysDBCtxMerge.java:222)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:16 88)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
FAILED

So after creating the controlfile, i did not created a tempfile.

So,
sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 8 13:45:51 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$tempfile;

no rows selected

SQL> alter tablespace TEMP1 add tempfile '/oracle/PROD/db/apps_st/data/TEMP01.dbf' size 500M autoextend on;

Tablespace altered.

SQL> select * from v$tempfile;

FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE# STATUS
---------- ---------------- ------------------ ---------- ---------- -------
ENABLED BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
1 5.9652E+12 08-NOV-10 284 1 ONLINE
READ WRITE 524288000 64000 524288000 8192
/oracle/PROD/db/apps_st/data/TEMP01.dbf

After this, again run adconfig.sh on DB Tier

[oracle@prod bin]$ ./adconfig.sh
Enter the full path to the Context file: /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml
Enter the APPS user password:
The log file for this session is located at: /oracle/PROD/db/tech_st/11.1.0/appsutil/log/UPGRDE_prod/11081348/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/11.1.0
Classpath : :/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/ojdbc5.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/oracle/PROD/db/tech_st/11.1.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

Using Context file : /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.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 db111
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oracle@prod bin]$

Cheers... Hope this helps...

adbldxml.pl DB tier errors out: FOLLOWING ERROR OCCURED : 3 >= 3

noreply@blogger.com (Balaji Srinivasan) — Thu, 07 Oct 2010 05:14:00 +0000

The critical error i faced during the upgrade database to 10.2.0.4 from 9.2.0.5 in oracle Applications 11.5.10.2

Error during adbldxml.pl on Database Tier

FOLLOWING ERROR OCCURED :

3 >= 3

StackTrace:
java.lang.ArrayIndexOutOfBoundsException: 3 >= 3
at java.util.Vector.setElementAt(Vector.java:505)
at oracle.apps.ad.context.GenerateContext.setJRETOP(GenerateContext.java:7471)
at oracle.apps.ad.context.GenerateContext.InstantiateRestForDB(GenerateContext.java:3045)
at oracle.apps.ad.context.GenerateContext.main(GenerateContext.java:8138)

Cause for this issue:

GenerateContext.java Release reported in the logfile is 115.87
Latest version of GenerateContext.java is 115.103

You need to apply the patch 4709948 in the apps Tier using the tnsnames.ora and listener.ora just we created during the upgrade process in latest RDBMS_ORACLE_HOME (10.2.0.4)

once applied the patch, synchronize the DB Tier with Apps Tier using admkappsutil.pl from $AD_TOP/bin

Run adbldxml.pl from db Tier now. The error should not appear now.

ERROR: Context Value Management Failed. Terminate

noreply@blogger.com (Balaji Srinivasan) — Sun, 26 Sep 2010 16:41:00 +0000

Today, i need to blog out my experience with newly cloned system from production in a new server.

Version Apps: 11.5.10.2
Database: 10.2.0.4

OS: HP-UX 11.11

The issue is when we try to run autoconfig on the the Apps Tier, adconfig.sh errors out with message

Exception in thread "main" java.lang.NoClassDefFoundError: java/sql/Savepoint
...

etc.,

The log file shows:

ERROR: Context Value management Failed.
Terminate

The logfile for this session is located at:
/clone/CLONE/prodappl/admin/CLONE_erp3/log/09121702/adconfig.log

So, I searched the CLASSPATH, it points to Java 1.3.

I installed java 1.5 and recloned the server on the same location using adcfgclone.pl and update the java_path as /opt/java1.5

Now, it completed the clone process and started the service.

I rerun the autoconfig.sh, it completed normally.

So if you have error like

/sql/SavePoint, you need Java1.4 and above. Because Java 1.3 is not relased with Savepoint.

Cheers...

Issue with Oracle DB Upgrade 9.2.0.5 to 10.2.0.4 (Apps DB)

noreply@blogger.com (Balaji Srinivasan) — Thu, 19 Aug 2010 13:30:00 +0000

This blog is about error "insufficient Privileges" while connecting as sys as sysdba

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

When logging into the new ORACLE_HOME (to be upgraded)

I received this error. (ORA-01031)

OS: HP-UX 11.11 64 bit
OS_GROUP other than DBA My groups is USERS

Reason: in rdbms/lib config.c is hard-coded the group as "dba"

Solution:
1. Navigate to new ORACLE_HOME/rdbms/lib
2. Look for config.c
3. Backup config.o as config.o_bk
4. Backup config.c as config.c_bk
5. Open config.c
Change the lines as

Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */

#define SS_DBA_GRP "dba"
#define SS_OPER_GRP "dba"

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};

Changed Section
Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */

#define SS_DBA_GRP "users"
#define SS_OPER_GRP "users"

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};

6. run
make -f ins_rdbms.mk config.0 ioracle

once finished,

try to login as sysdba

it should work.

Cheers!!!!

Critical patch Update for July 2010

noreply@blogger.com (Balaji Srinivasan) — Thu, 15 Jul 2010 11:38:00 +0000

Oracle Announced Critical patch update for July 2010

visit

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2010.html

for more details.

The affected products includes:

Oracle Database 11g Release 2, version 11.2.0.1	[ Database ]
• Oracle Database 11g Release 1, version 11.1.0.7	[ Database ]
• Oracle Database 10g Release 2, versions 10.2.0.3, 10.2.0.4	[ Database ]
• Oracle Database 10g, version 10.1.0.5	[ Database ]
• Oracle Database 9i Release 2, versions 9.2.0.8, 9.2.0.8DV	[ Database ]
• Oracle TimesTen In-Memory Database, versions 7.0.6.0, 11.2.1.4.1	[ Database ]
• Oracle Secure Backup version 10.3.0.1	[ Database ]
• Oracle Application Server, 10gR2, version 10.1.2.3.0	[ Fusion Middleware ]
• Oracle Identity Management 10g, version 10.1.4.0.1	[ Fusion Middleware ]
• Oracle WebLogic Server 11gR1 releases (10.3.1, 10.3.2 and 10.3.3)	[ Fusion Middleware ]
• Oracle WebLogic Server 10gR3 release (10.3.0)	[ Fusion Middleware ]
• Oracle WebLogic Server 10.0 through MP2	[ Fusion Middleware ]
• Oracle WebLogic Server 9.0, 9.1, 9.2 through MP3	[ Fusion Middleware ]
• Oracle WebLogic Server 8.1 through SP6	[ Fusion Middleware ]
• Oracle WebLogic Server 7.0 through SP7	[ Fusion Middleware ]
• Oracle JRockit R28.0.0 and earlier (JDK/JRE 5 and 6)	[ Fusion Middleware ]
• Oracle JRockit R27.6.6 and earlier (JDK/JRE 1.4.2, 5 and 6)	[ Fusion Middleware ]
• Oracle Business Process Management, versions 5.7.3, 6.0.5, 10.3.1, 10.3.2	[ Fusion Middleware ]
• Oracle Enterprise Manager Grid Control 10g Release 5, version 10.2.0.5	[ Enterprise Manager ]
• Oracle Enterprise Manager Grid Control 10g Release 1, version 10.1.0.6	[ Enterprise Manager ]
• Oracle E-Business Suite Release 12, versions 12.0.4, 12.0.5, 12.0.6, 12.1.1 and 12.1.2	[ E-Business Suite ]
• Oracle E-Business Suite Release 11i, versions 11.5.10, 11.5.10.2	[ E-Business Suite ]
• Oracle Transportation Manager, Versions: 5.5.05.07, 5.5.06.00, 6.0.03	[ Oracle Transportation Management ]
• PeopleSoft Enterprise Campus Solutions, version 9.0	[ PeopleSoft ]
• PeopleSoft Enterprise CRM, versions 9.0 and 9.1	[ PeopleSoft ]
• PeopleSoft Enterprise FSCM, versions 8.9, 9.0 and 9.1	[ PeopleSoft ]
• PeopleSoft Enterprise HCM, versions 8.9, 9.0 and 9.1	[ PeopleSoft ]
• PeopleSoft Enterprise PeopleTools, versions 8.49 and 8.50	[ PeopleSoft ]
• Oracle Sun Product Suite	[ Oracle Sun Product Suite ]

Oracle recommends to apply the latest CPU at the earliest.

11g SOA Suite - Fusion Middleware Installation Step by Step - 4

noreply@blogger.com (Balaji Srinivasan) — Tue, 13 Jul 2010 12:40:00 +0000

Step: 4
Installation of oracle Application server 11g (SOA Suite)
Visit my earlier posts for configuration of Database, RCU and Weblogic Server

Points to consider,

Please ensure that you have database parameters
processes as 500 or more
and
open_cursors as 500 or more.

From the Location where the SOA unzipped files, issue runInstaller.sh

Welcome Screen

Give the jdk location (java should be present at the bin location of the path) 1.6 or above

Validation Checks

Specify the location where to install the Middleware. The Weblogic should be present in that middleware location.
Selected Components summary

Starting of the installation process:

Installation Finished

Summary about the installation:

Configuration of soa and bam applications

from the location WEBLOGICHOME/Oracle_SOA1/common/bin/config.sh
Select the Extend domain option

Select the Domain where your AdminServer is located:
in my case it is base_domain1

Select the components you need to fuse with existing domain

provide the details of JDBC driver details which you created during weblogic administration

If you forget the password you created during RCU, you can change it now for all the schema

Deploy the selected components

Finished Fusing the components to AdminServer Domain.
Now start the weblogic server from

WEBLOGICHOME/user_projects/domains/base_domain1/bin

startWebLogic.sh
startManagedWebLogic.sh soa_server1 (to Start SOA Components)
startManagedWebLogic.sh bam_server1 (to start BAM components)

during the initiation, the start modules will ask for the username and password for admin of weblogic,

please provide as weblogic and password you defined during the installation of Weblogic.

next blog will discuss about component deployment using weblogic.

Important URLs

To access Middleware Fusion 11g
http://genius.chainsys.com:7001

to Access Enterprise Manager 11g
http://genius.chainsys.com:7001/em

To access Applications console
http://genius.chainsys.com:7001/console

Cheers...

11g SOA Suite - Fusion Middleware Installation Step by Step - 3

noreply@blogger.com (Balaji Srinivasan) — Tue, 13 Jul 2010 11:28:00 +0000

Step 2 (Creation of repository into the Database is in my previous post ( http://balajiabhi.blogspot.com/2010/07/11g-soa-suite-fusion-middleware_13.html )

Step: 3
Weblogic

The Weblogic zip file is unzipped in a location.

Invoke the installer using the command

$

jre160_05/bin/java -mx256m -cp installer.jar com.bea.plateng.wizard.WizardController -mode=gui

jre160_05 will be present in the same unzipped location.

Specify the location where to install Weblogic server 10.3.3

Select the components for Installation

Use the quick start to configure AdminServer:
or later you can install it using

WEBLOGICHOME/Middleware/utils/quickstart $ ./quickstart.sh

Create a new Weblogic Domain

Select default

Give the domain Name

Start the weblogic server using the command from
WEBLOGICHOME/user_projects/domains/base_domain/bin/startWebLogic.sh

http://genius.chainsys.com:7001/console is the deployment application screen for /console (Administrative console)

From the main screen click on the JDBC data Sources
add the current database and provide the details for connection and test connect.

Installation and Configuration 11gSOA will be continued in the next post

11g SOA Suite - Fusion Middleware Installation Step by Step - 2

noreply@blogger.com (Balaji Srinivasan) — Tue, 13 Jul 2010 11:10:00 +0000

Step:2
Installation of repository Creation Utility (RCU) for creating SOA repository in the datbase. For Installation of 11gR2 Database please follow my previous blog entry (http://balajiabhi.blogspot.com/2010/07/11g-soa-suite-fusion-middleware.html)

From the RCU unzipped home, (rcuHome/bin)

run ./rcu

Define the Database properties

Select the components for creation:

pre-requisite Check for all the components selected

You can define only one password for all the schema to be created. Or you can define each schema with each password. I have created only one password for all the schema.

Installaer will notify the tablespaces to be created.

at the end, the Installaer will notify the status message after creation of repository into the database.

Continued in the next post