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..