adop phase=prepare fails with: Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
cause
----
The local_listener not set properly in the init.ora parameter file.
solution
---------
Check if the local_listener is set incorrectly by using:
At the DB server:
sqlplus / as sysdba
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string cal456:1521
In this scenario ERPDEV is the SID used in this Environment
If the local listener value returned is incorrect, change it to the correct value in the init.ora parameter file.
SQL> alter system set local_listener='ERPDEV_LOCAL' scope=both;
System altered.
then Execute the "adop phase=prepare" again in application tier and confirm the error no longer occurs.
Screenshot
--------------
