Friday, June 24, 2011

Issue : Getting Error while upgrading to 11G

Run Upgrade is failed with below issue.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/kirang/oracle/product/112/dbs/initkirang.ora'
alter system set cursor_sharing=exact
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

During 10.2.0.4 to 11.2.0.1 Upgrade, Database is not starting due to below issue
Automation is erroring out with below infomration:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/kirang/oracle/product/112/dbs/initkirang.ora'
alter system set cursor_sharing=exact
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

Fixed issue by copying the pfile from old Oracle Home. As current ORACLE HOME doesn't have any files in dbs directory

$ ls -ltrd dbs*
drwxr-xr-x 3 orkirang kirang 4096 Jun 24 01:20 dbs_old
drwxr-xr-x 2 orkirang kirang 4096 Jun 24 07:39 dbs

After copying files from old ORACLE_HOME, Restarted automation to upgrade.

Now facing second Issue:-
================
tried to open database manually..

SQL> startup upgrade
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '_kks_use_mutex_pin'
SQL> exit

Checked the importance of this parameter : _kks_use_mutex_pin ?
In Google found this information :
If _kks_use_mutex_pin is set to true the DBA needs to be cautious. First this is an internal Oracle parameter. Do NOT use it unless instructed to do so by Oracle Support. Playing with this parameter may be harmful.

Secondly bug number 5184776 can affect a system using this value. It causes high ‘cursor pin s wait on x’.

solutoin : removed from $ORACLE_HOME/dbs/initKIRANG.ora file and tried starting in Upgrade mode. Its working now.

Now restarted the Automation after shutting down the instance manually...

Summary:
issue with "*._kks_use_mutex_pin=TRUE".

Oracle is not coming up.
Hashed out and tried its working fine now...

learnings:-
-----------
During automation failures, analyse and try to dig down to smaller chunks of issue. In this case, I haved tried starting db manually as automation failing there.
Once this small issue is resolved automatically automation went fine.. :)

Thanks
Kiran Ginni

Thursday, June 23, 2011

Info : Changing Database Name using simple steps.

1. Alter Database backup control file to trace;
2. Above step will create a text control file.
3. Change the Database name there and in init.ora file.
4. create new control file by running script (from backup control file)
5. Startup mount
6.open database resetlogs.
And your database name will be changed

Issue : ORA-00821: Specified value of sga_target 2512M is too small

Issue while starting the Database with SGA_TARGET value after OS Migration is done...

Casue: Due to higher Mainmemory settings incorporated in new machine, older values are having issue. This is one of them.

Detials :
-bash-3.2$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 22 11:17:22 2011

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 2512M is too small, needs to be at least 3808M

Solution: -
===========
Took backup of the pfile
changed the sga_target value to the one recommended. Here we changed it to 4000M and then tried starting the Database
Database got started without any issues.

Issue is resolved....

Ref Note/URL: http://oradbablog.blogspot.com/2007/03/ora-00821-specified-value-of-sgatarget.html

Issue : ORA-12162 "TNS:net service name is incorrectly specified

Issue :
=============
ORA-12162 "TNS:net service name is incorrectly specified

Cause : ORACLE_SID is not properly specified... But the issue is pretty misleading where in we digged a lot for tnsnames.ora file.

Finally after setting it to our SID we successfully logged to sqlplus and able to do our administration tasks...

*********
It suggests that there is a problem with the tnsnames.ora file contents, but in reality the message ORA-12162 "TNS:net service name is incorrectly specified" results from improperly setting your ORACLE_SID value.
************

Saturday, June 11, 2011

Issue with Login screen after HTTP Server Upgrade:

Error details :
Unable to open Main URL: >> getting error: "The requested URL /OA_HTML/AppsLogin was not found on this server."

Status:
Due to some wrong planning we were supposed to start the MT services to perform certain Licensing work. But unfortunately we upgraded HTTP Server as part of R12.1.3 upgrade from 12.0.4.

Normally we will do all the tasks and then start the services to perform post health checks and releasing to the customer.

But in this case we got to start Apache and there we are stuck due to below issue.
Error : "The requested URL /OA_HTML/AppsLogin was not found on this server.".

Upon searching in Metalink found couple of direct hits. Most of them clearly mentioned that "it got resolved once all step till patch 7303030 and post patch step is completed ".

This is there as part of our plan later, but to reach to that point we need to do licensing.

Proactive approach: Planner should have done this licensing part before doing HTTP server.But we are doing Production and this crucial step wasn't taken care of....

Only option we have is to do steps from Note : Note: 1177264.1

1. Login to server
2:- Run adadmin

2a:- Choose the following options

1. Generate Applications Files menu
4. Generate product JAR files
Do you wish to force regeneration of all jar files? [YES] ?

3:- Shutdown the E-business suite middle tier services

4:- Run the ojspCompile.pl

Run Autoconfig on MT & DB.
bring up application and retest issue

FInally after performing issue got resolved...

Summary:- In case we need to start MT Services to see login page in the middle of R12.1.3 Upgrade like HTTP server upgrade is done follow note : 1177264.1 as mentioned above.

Thanks
KIran.

Issue with OCM 10.3.2.0 installation on 10G forms OH.

Details : This installation is already configured for OCM. Please remove existing configuration first.

Procedure of Installation where we faced the issue.

1) Uninstalled / removed older directories.
2) Reinstallation (Here where issue is hit).

Detailed instructions :
------------------
Uninstall 10.2.7 and later versions of OCM

sh $ORACLE_HOME/ccr/bin/emCCR stop
rm -rf $ORACLE_HOME/ccr
rm -rf $ORACLE_HOME/ccr_stage

Installation steps:
unzip -d $ORACLE_HOME p5567658_1032_Linux-x86-64.zip
cd $ORACLE_HOME/ccr/bin
./emocmrsp

CSI = Customer CSI number
Country Code = Customer Country Code
Metalink ID = metalink ID.
Proxy host and proxy port = xxxxxx

Run the setup command

cd $ORACLE_HOME/ccr/bin
./setupCCR -R ocm.rsp ===> This script failed.....

This installation is already configured for OCM. Please remove existing configuration first.

Research:-
------------
Searched in metalink and finally got some information in one of the Oracle doc:
"http://download.oracle.com/docs/cd/E12482_01/doc.103/e16215/release_notes.htm"

Some of its information extracted here...
=============
4.1.2 Installation Considered Configured After Abnormal Termination of setupCCR or configCCR Commands

An abnormal termination such as a Control C during the invocation of setupCCR or reconfiguration using configCCR may result in subsequent attempts returning the message:

This installation is already configured for OCM. Please remove existing configuration first.

To manually reset the environment, remove the config and state directories located under the $ORACLE_HOME/ccr/hosts/ directory. If ORACLE_CONFIG_HOME is set, remove the config and state directories in the $ORACLE_CONFIG_HOME/ccr directory.

If this is a fresh installation, delete the ccr directory and unzip the Oracle Configuration Manager distribution into the ORACLE_HOME and issue the setupCCR command again.
==============

AFter reading and implementing issue got resolved.

Removed "ccr" directory from "$ORACLE_CONFIG_HOME"... This was not documented in our doc.
Once this is removed and restarted all the steps from beginning like "Uninstalling and reinstallation."

Issue got resolved. Able to install properly this time..

thanks
Kiran Ginni

Thursday, June 2, 2011

Info : Release 12.2 Overview

Infomration Sharing from one of my Colleague who Mailed this information to our Team. Thanks to SatyaKrishna.....

Upcoming new E-Business Suite of Applications Release 12.2 and the next generation Fusion Applications.

Release 12.1.3 is the terminal (final) release for 12.1. Premier Support for Release 12.1.3 will end May 31, 2014

Release 12.2 has a completely new technology stack based on WebLogic components. The old web tier, Apache and OC4J, will be replaced by WebLogic. This will be a major technology change and learning challenge for Applications DBAs - even those with years of experience managing and maintaining the E-Business Suite. Release 12.2 is expected to be out very soon which, as we all know, could be anywhere from six months to over a year away :-) .

And, finally, the Fusion Applications will be GA (generally available) in the next two months according to Steve Miranda, Senior Vice President of Oracle Applications Development. The Fusion Applications for this release will consist of the Financials, Procurement and Project Portfolio Management pillars and will not include the other four Fusion Applications pillars. Please see http://www.oracle.com/us/products/consulting/018716.htm for more details on the Fusion Application Pillars.

Release 12.2 is the first release of the E-Business Suite running with WebLogic components and is probably not something a stable customer would uptake especially as the first release.

Release 12.2 Overview

The technology stack for Oracle E-Business Suite Release 12.2 takes advantage of the latest Oracle and third-party technologies for the database, application tiers, and Java.

Oracle E-Business Suite Release 12.2 is certified with the latest Oracle Enterprise Edition 11g Release 2 (11.2) database release. On the application middle tier, Oracle E-Business Suite Release 12.2 is certified with Oracle Fusion Middleware 11g Release 1 (11.1.1.4), as well as Java SE Development Kit (JDK) 6.0. On the client, Oracle E-Business Suite Release 12.2 uses Version 6.0 of the Java Plug-in.

1. Installation

The Release 12.2 installation process has been significantly enhanced compared to prior releases. These enhancements include the provision of application tier node services, the use of native Oracle Database and Oracle Fusion Middleware installation tools to install and configure these technology stack components, and support for integrating Oracle E-Business Suite with existing Oracle Database 11g Release 2 and Oracle Fusion Middleware 11g Release 1 homes.

2. Online Patching

One of the key features of Release 12.2 is the switch to online patching (OLP). This utilizes the Oracle Database 11g Release 11.2.0.2 feature of edition-based redefinition to reduce significantly the downtime traditionally needed for patching and related maintenance activities.

An edition is a private environment in which you can redefine database objects. With online patching, patches are applied to a separate edition while users are working with the original edition. Subsequently, the system is cutover to make the patch edition the new production edition. After the upgrade to Release 12.2, all future patches and maintenance packs can be applied online, requiring only a short cutover period to make the new functionality active.

3. Cloning

Release 12.2 simplifies and enhances the cloning process, for example when scaling systems up by increasing the number of nodes. Also, support is now provided for cloning the Fusion Middleware components of Oracle E-Business Suite.

4. Application Tier

A key change to the Oracle E-Business Suite technology stack is the adoption of the Oracle WebLogic Server component of Oracle Fusion Middleware, in association with the Oracle HTTP Server component. Corresponding changes have been made to the various application tier services. A further difference is that the application tier file system is now always shared.

5. External Integrations

Release 12.2 includes enhancements to support integration with Oracle WebCenter and Oracle BPEL Process Manager using the new application tier.

Additionally, Oracle Application Framework now integrates with AutoVue Document Print Services. For more information, see section

6. Diagnostics for Secure Configuration

Release 12.2 enhances the tests that are provided to help ensure an Oracle E-Business Suite system is secured appropriately. Successful execution of these tests verifies that various accounts, profiles, parameters and configuration settings are set up in accordance with Oracle’s best practices recommendations for security.

7. Character Date International Calendar Support Enhancements

International calendar support in dates of type character is improved in Release 12.2. International calendar support in the character date routines FND_DATE and APP_DATE packages is enabled.

8. Serbian and Albanian Language Support

The Serbian and Albanian languages are supported across the Oracle E-Business Suite in Release 12.2.

9. Forms UI Export Functionality Enhancements

The Oracle Forms UI Export feature is enhanced to include Comma-Separated-Value (CSV) file format support and improved Unicode character set support capabilities.

10. Oracle Diagnostics Internationalization Enhancements

The Oracle Diagnostics product has been improved in several areas affecting internationalization capabilities, including string conversion to byte streams, end-user-visible strings, and the parsing of date strings.

Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 13

11. Internationalization Library Display Support

This feature provides the ability to identify which version of internationalization library is being used at a site. With this enhancement, it is no longer necessary to check the version of each file individually. This feature is especially useful for Oracle Support.

12. Oracle Workflow E-mail Character Encoding Configuration

A workflow administrator can now optionally specify the character encoding to use for each language in workflow notifications. This feature lets you override the character encoding specified by the notification recipient’s NLS preferences as well as the database character encoding, if another character encoding is required to display the notification content correctly. Use the Administration tab in the Oracle Workflow administrator Web pages to configure your character encoding specifications.

13. Native Oracle Database 11g Release 2 Caching for Profiles

Profile caching now uses the native Oracle Database 11g Release 2 PL/SQL Function Result Cache feature for improved performance in fetching profile option values.

14. Uptake of AUTO Sampling Statistics Gathering Feature in Oracle Database 11g

Oracle E-Business Suite on Oracle Database 11g uses its improved DBMS_STATS.AUTO_SAMPLE_SIZE feature by default in the FND_STATS package for gathering statistics in query optimization

15. Oracle Applications Manager and Oracle Enterprise Manager Integration

This enhancement extends the Oracle Enterprise Manager 11g Fusion Middleware Control console to discover Oracle E-Business Suite instances and to include a navigation link to the Oracle Applications Manager. Oracle Applications Manager itself is updated to work with Fusion Middleware Control

16. Change Base Language Script

Oracle E-Business Suite includes single-language tables that must be updated when changing an existing Installed language to be the Base language of the application system. The Change Base Language script, adchgbase.pl, is a new utility being delivered in RUP2 that will update these tables and corresponding seed data to the new base language. This utility is not required when installing a new language as the Base language.

Use Oracle License Manager to change an existing Installed language to be the Base language. Run the Perl script adchgbase.pl; this script will generate a patch driver, u_ChangeBase.drv, based on seed data in your environment. Apply the driver to your application system using Autopatch. Review log files for any issues.

17. Change Base Language Script

18. Oracle WebLogic Server 11g with Oracle SOA Suite 11g Integration

Oracle E-Business Suite Integrated SOA Gateway now uses Oracle SOA Suite 11g running on Oracle WebLogic Server 11g to provide greater capabilities and best-in-class SOA infrastructure for Oracle E-Business Suite. In this integration, Oracle SOA Suite provides the most current SOA technology such as Web services standards support, protocols, and binding, while Oracle E-Business Suite Integrated SOA Gateway provides the integration content, such as the integration interfaces, security model, and guidelines for best practices.

• Service Provider – In this release, Oracle E-Business Suite Integrated SOA Gateway continues to generate and deploy Oracle E-Business Suite Web services into Oracle SOA Suite. However, at run time the SOAP requests and responses from Web service clients and consumers will be executed by Oracle SOA Suite.

• Service Invocation Framework - Previously, the Service Invocation Framework (SIF) was based on the Web Services Invocation Framework (WSIF) provided in Oracle Application Server 10g. In Release 12.2, SIF instead leverages the Java API for XML-based Web Services (JAX-WS) dispatcher from Oracle WebLogic Server 11g.

• Service Monitor – The component known as SOA Monitor in earlier releases is now called the Service Monitor and is based on Oracle Enterprise Manager 11g. The Service Monitor fetches data and statistics for each instance of a Web service request and response from the underlying Oracle SOA Suite infrastructure to let you monitor Oracle E-Business Suite Web services. You can use the Service Monitor user interface in Oracle E-Business Suite to view

Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Secure Enterprise Search 37

the runtime SOAP request and response data received and sent from Oracle SOA Suite.

19. Asynchronous Web Service Support

Oracle E-Business Suite Integrated SOA Gateway now supports asynchronous request/response Web services. Unlike synchronous Web services, which return a response from the Provider immediately, asynchronous Web services may require a significant amount of time to process a request. However, the client that invoked the Oracle E-Business Suite Web service can continue with other processing in the meantime rather than wait for the response. Later, when the Web service request processing completes, Oracle E-Business Suite Integrated SOA Gateway sends the response back to the client that sent the request. The Service Provider in Oracle E-Business Suite Integrated SOA Gateway provides the infrastructure to support these asynchronous Web service transactions.

Additionally, the Oracle Integration Repository user interface now lets you specify interaction pattern options for a service before generating the service. You can choose synchronous interaction, asynchronous interaction, or both.

20. Advanced Scheduling Options

When submitting a report, you can now choose a simple schedule such as, as soon as possible, a specific date and time, or recurring intervals; or you can choose a more advanced schedule such as specific days of the week or specific dates in a month. You can also choose a previously saved schedule.

21. E-mail Character Encoding Configuration

Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle XML Gateway 51

22. Deferring Worklist Response Processing

To increase performance, a workflow administrator can optionally configure Oracle Workflow to defer the processing of notification responses submitted through the worklist. In this case, control is returned to a user immediately after the user submits a response, while the subsequent activities in the workflow are executed at a later time. You can choose to defer notification response processing for all item types or only for specified item types. Use the Administration tab in the Oracle Workflow administrator Web pages to configure the item types for which you want to defer response processing.

23. Workflow RAC Affinity

To increase scalability and performance on Oracle Real Application Clusters (RAC) databases, Oracle Workflow now supports RAC affinity for some high-volume batch processing item types. As part of the RAC configuration, the workflow runtime tables are partitioned based on a fixed number of RAC instance IDs. Then, when a RAC-enabled workflow process is launched in a particular RAC instance, the Workflow Engine and background engine concurrent requests set a VPD policy that allows them to access and manipulate workflow runtime records only from that specific instance ID. This policy helps to avoid contention by confining each engine request to processing workflows specific to a given RAC instance ID.

Oracle Workflow supports RAC affinity only for certain item types whose processes are either launched and completed in one online session, or deferred once and completed later by a background engine. Use the FND lookup type WF_RAC_ENABLED_TYPES to specify which of the supported item types you want to execute using RAC affinity.

And so on .....

Good luck!!

Thanks,
Srisatyakrishna

Issue: 9062727 [11i.HR_PF.K.delta.5] having issue with "patch file is older".

While applying :9062727 (language: ALL): - 11i.HR_PF.K.delta.5 faced below error.

Checked the "u9062727us.lgi" file from $APPL_TOP/admin//log

Will not apply adf01.drv: Patch file is older.
Patch : /autofs/upgrade/ebso/linux/115X_PATCHES/9062727_US/ad/admin/driver/adf01.drv, v115.0
On-Site: /kirang/applmgr/11510/ad/11.5.0/admin/driver/adf01.drv, v115.23

Will not apply adf02.drv: Patch file is older.
Patch : /autofs/upgrade/ebso/linux/115X_PATCHES/9062727_US/ad/admin/driver/adf02.drv, v115.0
On-Site: /kirang/applmgr/11510/ad/11.5.0/admin/driver/adf02.drv, v115.6

"u9062727us.lgi" [readonly] 151613L, 7566857C
Copying file /autofs/upgrade/ebso/linux/115X_PATCHES/9062727_US/ssp/patch/115/sql/sspwsmat.pkh
Creating backup directory
/autofs/upgrade/ebso/linux/115X_PATCHES/9062727_US/backup/kirang/kirang/ssp/reports/US.
-----

First tried to review the versions from Instance to that of patch directory. No unique/specific hints related to this issue in Metalink.

Started working in other angle...
AFter analysing this file found that there are thousands of lines which have "Patch file is older".
Means there is something seriously wrong in the Patch directory.

Workaround tried:-
-------------------
Scrapped the existing Patch directory.
Downloaded Fresh copy of Patch: 9062727 & unzipped it.
Reapplied the patch and this time patch applied successfully..

Summary:- Patch corrupted earlier. But the error is deviating, where in issue is not exacly related to versions.

How to Login when You Forgot ROOT Password in LINUX

Forgotten Password

Help! I forgot my root password. How do I log in now?

You can log in using single-user mode and create a new root password.

To enter single-user mode, reboot your computer. If you use the default boot loader, GRUB, you can enter single user mode by performing the following:

At the boot loader menu, use the arrow keys to highlight the installation you want to edit and type [A] to enter into append mode.
You are presented with a prompt that looks similar to the following:
grub append> ro root=LABEL=/
Press the Spacebar once to add a blank space, then add the word single to tell GRUB to boot into single-user Linux mode. The result should look like the following:
ro root=LABEL=/ single
Press [Enter] and GRUB will boot single-user Linux mode. After it finishes loading, you will be presented with a shell prompt similar to the following:
sh-2.05b#
You can now change the root password by typing
passwd root
You will be asked to re-type the password for verification. Once you are finished, the password will be changed. You can then reboot by typing reboot at the prompt; then you can log in to root as you normally would.

Cloud Computing & Oracle Consulting...

Oracle Consulting for Cloud Computing

Oracle Consulting services for Cloud Computing is for organizations looking to build a Private or Public Cloud environment.
Complementing various cloud products from Oracle, cloud services provided by Oracle On Demand Cloud Services and via partners such as Amazon Web Services (AWS), the Oracle Consulting approach to the deployment of Cloud environments is based on a pragmatic, experience based Cloud Services Framework.
The Framework has five phases to accelerate your journey to Cloud Computing. Experts from Oracle Consulting will first work with you to define your Cloud Roadmap and then together we will accelerate the Standardization, Consolidation, Automation and Optimization of your IT environment.

*********
Benifits :
*********
Each phase of the Oracle Consulting Cloud Services Framework results in tangible benefits, such as improved agility, increased efficiency and reduced costs.
By defining a Roadmap you can publish an agreed strategy for the cloud solution and for future phases of the framework. The Roadmap is defined in terms of the architecture and services that will be offered from the Cloud platform.

By Standardizing on a common architecture you can reduce RISK and increase AGILITY. Reducing the number of disparate vendors and maximizing the use of a common architecture across your business will result in a less complex landscape and it being easier to manage and faster to deploy new applications.

By Consolidating to a shared platform and shared infrastructure you can reduce COST and RISK. Consolidation will lead to improved utilization of available resources and in turn enable you to do more with your existing IT estate.

By Automating you can improve AGILITY and SPEED and benefit from further COST reductions. Environments are provisioned and deployed in a shorter timeframe, for example by deploying self-service and auto-scaling capabilities to the Cloud environment.

By Optimizing you begin to see the FULL benefit of Cloud Computing. The previous phases of Standardisation, Consolidation and Automation will enable your IT policies and processes to be streamlined. During Optimization you may additionally adopt metering or charge back capability.

Completion of all phases of the Framework will result in a more agile IT estate, with an architecture built on a standard and consolidated platform that enables applications to be provisioned quicker and that can rapidly adjust to changes in business requirements.
The Framework we use is not a rigid approach; instead its flexibility allows us together to create a unique roadmap, based on experience and leading practice, that maximizes your technology assets and delivers the greatest return on IT investment.