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..
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.
You are encouraged to leave a comment.
Thursday, November 07, 2013
Subscribe to:
Posts (Atom)
Let us be Friends...
Popular Posts
-
In a default configuration of Oracle Applications the user validating and sign on is done at the database level. For this purpose the FND_US...
-
1. Installation of the Demantra Base Application or Patches Create a C:/Tmp folder on the machine where the setup.exe will be executed pri...
-
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 ...
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
This was a biggest issue we were facing at the point of implementation. We were getting the reports designed in Developer and all are displa...
-
Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profil...
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
Primary Node: Host name: genius.chainsys.com IP : 192.168.2.236 File locations: apps - /oracle/D1/apps (SHARED) db - /oracle/PROD/db inst - ...
-
For Installation of the OBIEE please follow my previous post http://balajiabhi.blogspot.com/2009/07/installation-and-configuration-of-obiee....
-
Today, I need to blog out my experience with Apex integration with R12 E Business Suite!!! How I did: as follows. As you know how to install...