Adop Failed At Prepare Stage With Invalid Credential 12.2

adop give below error at prepare stage when trying to apply patch with phase=prepare optin

*******FATAL ERROR*******
PROGRAM : (/test/app01/appl/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
Procedure to Solve the Problem

There may be multiple reasons for this error, Following are known causes:
1) ebs_patch service is not registered in listener due to local_listener parameter set .
2.local_listener is not define in init.ora.

Solution:
1. Add following line to init.ora:

local_listener = SID_LOCAL
In this SID is database instance name.

e.g

local_listener = test_LOCAL
SQL> alter system set service_names='test','ebs_patch','test_patch' scope=memory;

System altered.


2. Restart database.

3. Retest the issue.

Comments

Post a Comment

Popular posts from this blog

Steps to run Autoconfig for patch File system 12.2

1.       To run Autoconfig from the patch file system you must disable trigger ebs_login prior to running autoconfig. SQL> show user; USER is "SYSTEM" SQL> alter trigger ebs_logon disable; Trigger altered. 2.       Now run autoconfig with the patch env sourced [appltest@test001]$ echo $FILE_EDITION [appltest@test001]$patch [appltest@test001]$ adautocfg.sh Make sure Autoconfig completes ok      3. Enable the login trigger “alter trigger ebs_logon enable”                  SQL> conn system/Oracle4u                  Connected.                SQL> SQL> alter trigger ebs_logon enable;                 Trigger altered.
Read more

ADOP fs_clone failing with ERROR: Managed Server's are not in sync between file system context and DB context

 adop fs_clone failing with below error. +++++++++++++++++++++++++ configProperty id = Server11 Count for NodeIterator nextNode = 3 ERROR: Managed Server's are not in sync between file system context and DB context ERROR: Update Moveplan Fail START: Inside exitClone.... Updating status INCOMPLETE for ApplywlsTechStack START: Updating status INCOMPLETE for action ApplywlsTechStack END: Updated status INCOMPLETE for action ApplywlsTechStack SOLUTION Please follow the solution in  Doc ID 2232990.1  and advise accordingly To resolve the issue test the following steps in a development instance and then migrate accordingly: 1. Unlock the configuration in the weblogic console via the following steps: A. Open a browser and enter the weblogic console URL eg: https ://localhost:port/console as the administrator. B. Navigate to the weblogic server administration Applications Configuration console. C. Unlock the weblogic server configuration by clicking 'Release Configuration' option.
Read more

txkCfgUtlfileDir.pl -mode=getUtlFileDir as per Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1) errors with ERRORMSG: Invalid APPS database user credentials

 txkCfgUtlfileDir.pl -mode=getUtlFileDir as per Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1) errors with ERRORMSG: Invalid APPS database user credentials validate_apps_password.log Pattern found... ================ EXIT STATUS: 1 Invalid APPS database user credentials. Solution Check  lsnrctl status <listener_name>,check files under $TNS_ADMIN,check environment,Check if case sensitive login is enabled and if enabled,disable it
Read more