Hello there,
This post is basically related to my problem with Process Flow deployment.
Could someone please shed some light on the following:
When we create a Process Flow, during this process OWF creates a Database Link. For some reason, this link is not functional unless I remove the part after "." in that defines the "HOST" in the DB Link definition. How do I know it is not functional - I know because following query does not work:
select * from dual@OWB92TRG.US.ORACLE.COM@WB_LK_WF_PKG
Here is the link definition:
----------------
ORIGINAL:
create database link OWB92TRG.US.ORACLE.COM@WB_LK_WF_PKG
connect to RR
identified by "<pwd>"
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(
HOST=CENTENNI-2077E4
.CENTENNIALCOLLEGE.CA)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=OWB92TRG)))'
MODIFIED (it works - above query runs OK):
create database link OWB92TRG.US.ORACLE.COM@WB_LK_WF_PKG
connect to RR
identified by "<pwd>"
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(
HOST=
CENTENNI-2077E4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=OWB92TRG)))'
------------------
My second question is "using what userid/pwd should this link should have been created? Should it use "Runtime Repository Owner" or "OWB Repository Owner" or "Runtime Access User" or "OWF_MGR"?
No matter what userid I use, it works when I run the query but I always get following error when I try to deploy the "Process Flows" in OWB:
---------------
RPE-02085: Failed to test wb_rti_workflow_util.initialize through deployed Workflow Database Link OWB92TRG.US.ORACLE.COM@WB_LK_WF_PKG2. Please check that
"EXECUTE ANY PROCEDURE" privilege is set
and that the OWB Runtime is available.
- ORA-04052: error occurred when looking up remote object RR.WB_RTI_WORKFLOW_UTIL@OWB92TRG.US.ORACLE.COM@WB_LK_WF_PKG2
ORA-12545: Connect failed because target host or object does not exist
------------------
I have already granted the "EXECUTE ANY PROCEDURE" to OWF_MGR. I am not sure, though, what is meant by the
"and that the OWB Runtime is available" part of the error message above.
I have also tried to fix this by running the
"catrpc.sql" script but it did not help either.
I am stuck on this step for past few days. I would highly appreciate help in fixing this problem. Here is the configuration I am using:
o Source database : Oracle 9i (9.2) on my local PC
o Target database : Oracle 9i (9.2) on my local PC
o OWB 9i
o OWF 2.6.2
o OWB and OWF repositories are on the TARGET database
I am able to successfully deploy and run my MAPPINGs.
TIA,
Amer