Showing posts with label 12C Upgrade Issues. Show all posts
Showing posts with label 12C Upgrade Issues. Show all posts

Wednesday, April 3, 2019

WF_WS_JMS_OUT_R , WF_WS_SAMPLE_R , WF_JAVA_DEFERRED_R invalids after Database upgrade from 11g to 12c

Dear Folks,

We have observed few invalids related to workflow after DB upgrade to 12c from 11G.


OWNER           OBJECT_NAME                    CREATED   OBJECT_TYPE                    LAST_DDL_ STATUS
--------------- ------------------------------ --------- ------------------------------ --------- -------
APPLSYS         WF_WS_JMS_OUT_R                09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_WS_SAMPLE_R                 09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_IN_R                    09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_OUT_R                   09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JAVA_DEFERRED_R             09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_WS_JMS_IN_R                 09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_JMS_OUT_R               09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JAVA_ERROR_R                09-NOV-13 RULE SET                       03-APR-19 INVALID

Solution
======

As per ML 337294.1 we executed below procedure for each object listed above.

declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_WS_JMS_OUT_R';
lagent := sys.aq$_agent('WF_WS_JMS_OUT_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;


declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_WS_SAMPLE_R';
lagent := sys.aq$_agent('WF_WS_SAMPLE_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;


declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JMS_IN_R';
lagent := sys.aq$_agent('WF_JMS_IN_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;

declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JMS_OUT_R';
lagent := sys.aq$_agent('WF_JMS_OUT_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;


declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED_R';
lagent := sys.aq$_agent('WF_JAVA_DEFERRED_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;


declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_WS_JMS_IN_R';
lagent := sys.aq$_agent('WF_WS_JMS_IN_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;



declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JMS_JMS_OUT_R';
lagent := sys.aq$_agent('WF_JMS_JMS_OUT_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;


declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_JAVA_ERROR_R';
lagent := sys.aq$_agent('WF_JAVA_ERROR_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;

Then compile invalid objects. Issue solves.

Thanks.
Sreeharsha

Saturday, February 2, 2019

Start_processes: failed to open STDOUT (1) , catconExec: catconInit has not been run datapatch error

Hi,

We experienced issue with  datapatch run and it had failed with below error.


start_processes: failed to open STDOUT (1)

Installing patches...
catconExec: catconInit has not been run
catconWrapUp: catconInit has not been runPatch installation complete.  Total patches installed: 2

Cause

====

It happens when we have multiple database instances running on a single machine and those OS users don't have privileges on each other's files (sqlpatch files) and as a result datapatch fails while trying to open catcon log files. 



Solution
====

Delete files under: /tmp/sqlpatch_* and re-run datapatch for the affected database.


Datapatch error "CATCONINIT FAILED" when applying patch in a multi-DB environment (Doc ID 1935401.1)


Thanks.

Sreeharsha