ADOP Phase=prepare Is Failing Status = 255 Error : PLS-00302: component 'PATCH_CP' must be declared
[STATEMENT] [START 2014/03/23 10:18:49] Checking status of the ADZDPATCH concurrent program
[STATEMENT] Status of ADZDPATCH:
[STATEMENT] This request finished with an error and produced the following completion
message: ORACLE error 6550 in FDPSTP Cause: FDPSTP failed due to
ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored . The SQL
statement being executed at the time o The processing began on
23-MAR-2014 10:18:48 and ended on 23-MAR-2014 10:18:48. You may find more
information on the cause of the error in the request log or the concurrent
manager log.
[STATEMENT] [START 2014/03/23 10:18:57] Unlocking sessions table
[STATEMENT] [END 2014/03/23 10:18:58] Unlocking sessions table
*******FATAL ERROR*******
PROGRAM : (/appgu/gfnhu/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun Mar 23 10:18:54 2014
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:18:54 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
*
ERROR at line 5:
ORA-06550: line 5, column 53:
PLS-00103: Encountered the symbol "PATCH_CP" when expecting one of the
following:
3.1 If the select returns I, do the following:
a. Backup the table: fnd_concurrent_programs.
b. Run the following to update the execution method:
c. Run autoconfig on fs1 and fs2.
OR
3.1 If the select returns Q, run autoconfig on fs1 and fs2.
Source the env file for fs1:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.
Source the env file for fs2:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.
4. Retest the issue by re-running adop phase=prepare.
[STATEMENT] [START 2014/03/23 10:18:49] Checking status of the ADZDPATCH concurrent program
[STATEMENT] Status of ADZDPATCH:
[STATEMENT] This request finished with an error and produced the following completion
message: ORACLE error 6550 in FDPSTP Cause: FDPSTP failed due to
ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored . The SQL
statement being executed at the time o The processing began on
23-MAR-2014 10:18:48 and ended on 23-MAR-2014 10:18:48. You may find more
information on the cause of the error in the request log or the concurrent
manager log.
[STATEMENT] [START 2014/03/23 10:18:57] Unlocking sessions table
[STATEMENT] [END 2014/03/23 10:18:58] Unlocking sessions table
*******FATAL ERROR*******
PROGRAM : (/appgu/gfnhu/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun Mar 23 10:18:54 2014
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:18:54 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
*
ERROR at line 5:
ORA-06550: line 5, column 53:
PLS-00103: Encountered the symbol "PATCH_CP" when expecting one of the
following:
To implement the solution, please execute the following steps:
1. Ensure that one has taken a backup of the environment.
2. Run the following select:
1. Ensure that one has taken a backup of the environment.
2. Run the following select:
select EXECUTION_METHOD_CODE from fnd_concurrent_programs where
CONCURRENT_PROGRAM_NAME='ADZDPATCH';
CONCURRENT_PROGRAM_NAME='ADZDPATCH';
3.1 If the select returns I, do the following:
a. Backup the table: fnd_concurrent_programs.
b. Run the following to update the execution method:
update fnd_concurrent_programs set EXECUTION_METHOD_CODE='Q' where
CONCURRENT_PROGRAM_NAME='ADZDPATCH';
commit;
CONCURRENT_PROGRAM_NAME='ADZDPATCH';
commit;
c. Run autoconfig on fs1 and fs2.
OR
3.1 If the select returns Q, run autoconfig on fs1 and fs2.
Source the env file for fs1:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.
Source the env file for fs2:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.
4. Retest the issue by re-running adop phase=prepare.
No comments:
Post a Comment