R12.2 Apps DBA. Powered by Blogger.

ORA-00904: AD_ZD_ADOP.GET_NODE_TYPE: invalid identifier R12.2

No comments :
Error:
SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('mgoldapp') FROM DUAL
ERROR at line 1:
ORA-00904: "AD_ZD_ADOP"."GET_NODE_TYPE": invalid identifier
Solution
To implement the solution, please execute one of the following steps:
Run manually the following packages delivered by the patch 21351238: 1OFF:- NEED GENERIC API TO GET ALL MASTER NODES
sqlplus apps/apps
SQL>@ADZDADOPS.pls
SQL>@ADZDADOPB.pls
Now, the function ad_zd_adop.get_node_type should exist in your system and you may continue applying the patch.
If you would like to start clean you might want to abort your current adop session and If so, please do the following:
$ adop phase=abort
$ adop phase=cleanup cleanup_mode=full
$ adop phase=fs_clone
Then start a new patching cycle and reapply the patch that was failing because of the missing function.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.