ADOP Failed At Prepare Stage With Invalid Credential Error ORA-12514


*******FATAL ERROR*******
PROGRAM : (/fh09/UPG1T/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sat Apr 6 20:02:22 2013
FUNCTION: ADOP::Phase::executeSQL [ Level 1 ]
ERRORMSG: Invalid Credentials


adop patch log file has below error:

AutoPatch error:
The following ORACLE error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor




The issue can be reproduced at will with the following steps:
1. adop phase=prepare

To implement the solution, execute the following steps:

1. Add following line to init.ora:

local_listener = _LOCAL

In this SID is database instance name.

e.g 

local_listener = VIS_LOCAL

2. Restart database.

3. Retest the issue.