Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Thursday, November 07, 2013

FUNCTION: ADOP::Phase::executeSQL [ Level 1 ] ERRORMSG: Invalid Credentials

During the Autoconfig on patch filesystem on EBS 12.2,

We were not able to generate the TNS.

The error was not able to create listener.ora at the Patch filesystem. The error was misleading actually.

Once we completed the

adop phase=fs_clone,

we were about to apply the TXK Patches.

At that time, the patch prepare phase fails with error message:

*******FATAL ERROR*******
PROGRAM : (/oracle/CEL122/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Thu Nov  7 16:05:56 2013
FUNCTION: ADOP::Phase::executeSQL [ Level 1 ]
ERRORMSG: Invalid Credentials

adop exiting with status = 1 (Fail)

Cause was described in the metalink:

The cause as per MOS:
Services Summary...
Service "Xxx" has 1 instance(s).
 Instance "XXX", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

In the init.ora service_names=,ebs_patch exist but no local_listener available and listener is not using default port . There for even though following command does not give any errors service is not registering .
alter system set SERVICE_NAMES=',ebs_patch';


FIX:

Fix:

1. Add following line to init.ora:

local_listener = SID_LOCAL
In this SID is database instance name.

e.g

local_listener = XXX_LOCAL


2. Restart database.

3. Retest the issue.

4. Migrate the solution as appropriate to other environment


It just killed the entire day.

Now able to complete the autoconfig on Patch filesystem and can run the patches.


Cheers..

Saturday, September 21, 2013

Oracle E Business Suite 12.2 is available

Great news.. that Oracle Has released its long expected Oracle EBS 12.2 has been released today. As per Steven Chan's blog.

It has been released for Linux 64 Bit.

The features will be:
Hundreds of new features
Includes significant enhancements across the integrated suite of business applications spanning enterprise resource planning, human capital management, and supply chain management.  You can find the complete list here:

Online Patching

Apply EBS patches while users are still entering transactions and using the E-Business Suite.  Online Patching uses the Oracle Database's Edition-Based Redefinition feature and other new technologies to allow the E-Business Suite to be updated while the system is still running. You can learn more about Online Patching via our official documentation and this technical webcast.
WebLogic Server
Uses Oracle WebLogic Server, which replaces the Oracle Containers for Java (OC4J) application server used in EBS 12.0 and 12.1.  You can learn more about how this improves the system administration experience via our official documentation and this technical webcast.
Streamlined installation
  • Option for installing EBS 12.2 on to existing database servers.
  • Capability of installation into existing Real Application Clusters environments.
  • Database deployment on Automatic Storage Management (ASM) and other file systems.


Upgrade Options?

Yes..



Upgrading to EBS 12.2
Is there a direct upgrade path from EBS 11i to 12.2?
Yes, there is a direct upgrade path from EBS 11.5.10.2 to EBS 12.2.  EBS 11.5.10.2 customers do not have to install an intermediary EBS 12 release (such as 12.1.3) before upgrading to EBS 12.2.  EBS 11.5.10.2 customers must have applied the minimum baseline patch requirements for Extended Support as described in Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 (Document 883202.1). Customers on earlier EBS 11i releases (such as 11.5.7) need to be at the 11.5.10.2 level plus the minimum baseline patch requirements for Extended Support before they can upgrade to EBS 12.2.
Is there a direct upgrade path from EBS 12.0 to 12.2?
Yes, there is a direct upgrade path from EBS 12.0.4 and 12.0.6 to EBS 12.2.  EBS 12.0.4 or 12.0.6 customers do not have to install an intermediary EBS 12 release (such as 12.1.3) before upgrading to EBS 12.2.  Customers on earlier EBS 12.0 releases (such as 12.0.3) will need to be at the 12.0.4 or 12.0.6 level before they can upgrade to EBS 12.2.
Is there a direct upgrade path from EBS 12.1 to 12.2?
Yes, there is a direct upgrade path from EBS 12.1.1, 12.1.2, and 12.1.3 to EBS 12.2.


For more details:


§ EBS 12.2 Documentation Library (Oracle Technology Network)




Saturday, August 24, 2013

Integrated SOA Gateway - Part 2

Part -1



Now run the Main patch 8626084/Disk1

$ ./runInstaller -invPtrLoc $IAS_ORACLE_HOME/oraInst.loc





1)      Ensure that all OC4J instances are up and running prior to applying this patch.

2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.

Click the 'OK' button to proceed with the installation.


Figure 2

Figure 3




Figure 4


Figure 5
Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8