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
FUNCTION: ADOP::Phase::executeSQL [ Level 1 ] ERRORMSG: Invalid Credentials
Subscribe to:
Post Comments (Atom)
Let us be Friends...
Popular Posts
-
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...
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
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 ...
-
This blog is about Configuring the Apex PDF printing with Apache FOP. You need to download the OC4J from here You move the downloaded file t...
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
MWA configuration in Oracle Applications Consider these points 1. Check if Enabled Telnet on the server If no.. please do the following step...
-
Today, when about to start fusion applications using faststartstop utility, We encountered a problem like: [TRACE:16] [] [WLC] [oracle...
-
Oracle E-Business Suite 12 Certified on Oracle Linux 6 (x86-64) Oracle E-Bus...
-
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...
-
FND_USER table stores the details of all the end users. If we give this query: select user_name,to_char(last_logon_date,'DD-MON-YYYY HH...
No comments:
Post a Comment