workflow rebuild queue Oracle EBS R12.2

How To Rebuild Mailers Queue When it is Inconsistent or Corrupted? (Doc ID 736898.1)



1. Stop application services and Workflow Agent Listeners and Mailers.

2. Find the table space where indexes on corrid for queue tables are created:

sqlplus apps/<apps_pwd>

select distinct tablespace_name
from dba_indexes,dba_queues
where index_name='WF_NOTIFICATION_OUT_N1'
and table_name=queue_table
and name like 'WF%';

3. Rebuild mailer's queue:

sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps123 APPLSYS

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 16:43:06 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

**** wfaqback.sql completed,  executing SQLs from wfntfqup
declare
*
ERROR at line 1:
ORA-20000: Oracle Error = -4020 - ORA-04020: deadlock detected while trying to
lock object APPLSYS.AQ$_WF_NOTIFICATION_OUT_F
ORA-06512: at line 318


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options



Error - ORA-20000: Oracle Error = -4020 - ORA-04020: deadlock detected while trying to lock object APPLSYS.AQ$_WF_NOTIFICATION_OUT_F ORA-06512: at line 318

Soultion- ORA-04020: deadlock detected while trying to lock object APPLSYS.AQ$_WF_CONTROL_F (Doc ID 2496222.1)


[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 16:45:43 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> SHOW parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      PRODERP
SQL> DROP VIEW applsys.AQ$WF_CONTROL;

View dropped.

SQL> DROP VIEW applsys.AQ$_WF_CONTROL_F;

View dropped.

SQL> @$FND_TOP/patch/115/sql/wfctqrec.sql APPLSYS apps123
Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options



SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 16:48:35 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      PRODERP




[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps123 APPLSYS

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 17:49:04 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

**** wfaqback.sql completed,  executing SQLs from wfntfqup
declare
*
ERROR at line 1:
ORA-20000: Oracle Error = -2289 - ORA-02289: sequence does not exist
ORA-06512: at line 318


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Error- ORA-20000: Oracle Error = -2289 - ORA-02289: sequence does not exist
Solution- Restart database


[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps123 APPLSYS

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 17:56:03 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

**** wfaqback.sql completed,  executing SQLs from wfntfqup
declare
*
ERROR at line 1:
ORA-20000: Oracle Error = -24010 - ORA-24010: QUEUE APPLSYS.WF_NOTIFICATION_OUT
does not exist
ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_INV", line 1248
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQ_INV", line 1248
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQ_INV", line 1248
ORA-06512: at line 1
ORA-06512: at line 318


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options



[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL> DROP VIEW applsys.AQ$WF_CONTROL;

View dropped.

SQL> DROP VIEW applsys.AQ$_WF_CONTROL_F;

View dropped.

SQL> @$FND_TOP/patch/115/sql/wfctqrec.sql APPLSYS apps123
Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:04:40 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> @$FND_TOP/patch/115/sql/afwfqgnt.sql APPS apps123 APPLSYS apps123
Connected.
declare
*
ERROR at line 1:
ORA-24010: QUEUE APPLSYS.WF_NOTIFICATION_OUT does not exist
ORA-06512: at line 50


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:30:29 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> exec dbms_aqadm.stop_queue(queue_name => 'APPLSYS.WF_ERROR');

PL/SQL procedure successfully completed.

SQL> exec dbms_aqadm.drop_queue(queue_name => 'APPLSYS.WF_ERROR');

PL/SQL procedure successfully completed


SQL> exec dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_ERROR', force=>true);
BEGIN dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_ERROR', force=>true); END;

*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object APPLSYS.AQ$_WF_ERROR_F
ORA-06512: at "SYS.DBMS_AQADM", line 388
ORA-06512: at line 1


SQL> DROP VIEW applsys.AQ$_WF_CONTROL_F;

View dropped.

SQL> exec dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_ERROR', force=>true);
BEGIN dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_ERROR', force=>true); END;

*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object APPLSYS.AQ$_WF_ERROR_F
ORA-06512: at "SYS.DBMS_AQADM", line 388
ORA-06512: at line 1


SQL> drop view APPLSYS.AQ$_WF_ERROR_F;

View dropped.

SQL> exec dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_ERROR', force=>true);

PL/SQL procedure successfully completed.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ ll $FND_TOP/patch/115/sql/wfevquc2.sql


applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfevquc2.sql APPLSYS apps123 WF_DEFERRED APPS6400

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:38:35 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


PL/SQL procedure successfully completed.

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfbesqsubc.sql APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:39:00 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-24010: QUEUE APPLSYS.WF_ERROR does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7046
ORA-06512: at "SYS.DBMS_AQADM", line 549
ORA-06512: at line 7


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfmqsubc.sql APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:41:25 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$


[applmgr@pansoft sql]$ sqlplus APPS/apps123 @afwfqgnt.sql APPS apps123 APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 18:43:34 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Connected.
declare
*
ERROR at line 1:
ORA-24010: QUEUE APPLSYS.WF_ERROR does not exist
ORA-06512: at line 50


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options



[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfevquc2.sql applsys apps123 WF_ERROR APPS 5 0

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:12:15 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


PL/SQL procedure successfully completed.

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options



OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfbesqsubc.sql APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:12:46 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ sqlplus APPS/apps123 @afwfqgnt.sql APPS apps123 APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:12:56 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Connected.
declare
*
ERROR at line 1:
ORA-24010: QUEUE APPLSYS.WF_NOTIFICATION_OUT does not exist
ORA-06512: at line 50


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfevquc2.sql applsys apps123 WF_OUT APPS 5 36

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:14:05 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


PL/SQL procedure successfully completed.

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:18:41 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> exec dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_NOTIFICATION_OUT',force=>true);
BEGIN dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_NOTIFICATION_OUT',force=>true); END;

*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
APPLSYS.AQ$_WF_NOTIFICATION_OUT_F
ORA-06512: at "SYS.DBMS_AQADM", line 388
ORA-06512: at line 1


SQL> drop view APPLSYS.AQ$_WF_NOTIFICATION_OUT_F
  2  ;

View dropped.

SQL> exec dbms_aqadm.drop_queue_table( queue_table=> 'APPLSYS.WF_NOTIFICATION_OUT',force=>true);

PL/SQL procedure successfully completed.

SQL> begin
 dbms_aqadm.create_queue_table
 (
 queue_table => 'WF_NOTIFICATION_OUT',
 queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE',
 sort_list => 'PRIORITY,ENQ_TIME',
 multiple_consumers => TRUE,
 comment => 'Workflow JMS Topic',
  2    3    4    5    6    7    8    9   compatible => '8.1'
 );
 exception
 when others then
 raise_application_error(-20000, 'Oracle Error Mkr2= '
 ||to_char(sqlcode)||' - '||sqlerrm);
 end;
 /
 10   11   12   13   14   15   16
PL/SQL procedure successfully completed.

SQL>
SQL> begin
 dbms_aqadm.create_queue
 (
 queue_name => 'WF_NOTIFICATION_OUT',
 queue_table => 'WF_NOTIFICATION_OUT',
 max_retries => 5,
 retry_delay => 3600,
 retention_time => 86400,
 comment => 'Workflow JMS Topics'
 );
 exception
 when others then
 raise_application_error(-20000, 'Oracle Error Mkr4= '
  2    3    4    5    6    7    8    9   10   11   12   13   14   ||to_char(sqlcode)||' - '||sqlerrm);
 end;
 / 15   16

PL/SQL procedure successfully completed.

SQL> begin
 dbms_aqadm.start_queue(queue_name => 'WF_NOTIFICATION_OUT');
 exception
 when others then
 raise_application_error(-20000, 'Oracle Error Mkr5= '
 ||to_char(sqlcode)||' - '||sqlerrm);
 end;
 /
  2    3    4    5    6    7    8
PL/SQL procedure successfully completed.

SQL> begin
 dbms_aqadm.start_queue(queue_name => 'AQ$_WF_NOTIFICATION_OUT_E',
 enqueue => FALSE);

 exception
 when others then
 raise_application_error(-20000, 'Oracle Error Mkr9= '
 ||to_char(sqlcode)||' - '||sqlerrm);
 end;
 /  2    3    4    5    6    7    8    9   10

PL/SQL procedure successfully completed.

SQL> declare
 lagent sys.aq$_agent;
 subscriber_exist exception;
 pragma EXCEPTION_INIT(subscriber_exist, -24034);
 begin
 lagent := sys.aq$_agent('WF_NOTIFICATION_OUT',null,0);
  2    3    4    5    6    7   dbms_aqadm.add_subscriber(queue_name =>'APPLSYS.WF_NOTIFICATION_OUT',
 subscriber=>lagent, rule=>'1=1');
 exception
 when subscriber_exist then
 dbms_aqadm.alter_subscriber(queue_name =>'APPLSYS.WF_NOTIFICATION_OUT',
 subscriber=>lagent,
 rule=>'1=1');
 null; -- ignore if we already added this subscriber.
 end;
  8    9   10   11   12   13   14   15   16   /

PL/SQL procedure successfully completed.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ sqlplus APPS/apps123 @afwfqgnt.sql APPS apps123 APPLSYS apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:23:53 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

Connected.

PL/SQL procedure successfully completed.

Connected.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


[applmgr@pansoft sql]$ vi $FND_TOP/patch/115/sql/wfntfqup.sql
[applmgr@pansoft sql]$ vi $FND_TOP/patch/115/sql/wfntfqup.sql

-- backup Oracle Alert messages in wf_notification_out

#@$FND_TOP/sql/wfaqback.sql WF_NOTIFICATION_OUT/APPS:ALR%

[applmgr@pansoft sql]$ sqlplus apps/apps123 @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps123 APPLSYS

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:39:08 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options


PL/SQL procedure successfully completed.

Elapsed: 00:00:00.49

Commit complete.

Elapsed: 00:00:00.00
**** TEMPORARY TABLES / AQs created ****

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.28
**** Messages backed up ****

Commit complete.

Elapsed: 00:00:00.00
**** wfaqback.sql completed,  executing SQLs from wfntfqup

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.53
***  invoking wfaqrenq.sql ******
*** Re-enqueing messages

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.47

Commit complete.

Elapsed: 00:00:00.00
***** Objects related to wf_queue_temp_evt_table and wf_queue_temp_jms_table are dropped *****
***** Re-enqueue OF Alerts completed *****
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ sqlplus applsys/apps123

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 14 19:41:01 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> select name from v$database;

NAME
---------
PRODERP

SQL> CREATE INDEX WF_NOTIFICATION_OUT_N1
ON WF_NOTIFICATION_OUT(CORRID)
STORAGE (INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
TABLESPACE &tbs;   2    3    4
Enter value for tbs: APPS_TS_QUEUES
old   4: TABLESPACE &tbs
new   4: TABLESPACE APPS_TS_QUEUES

Index created.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
[applmgr@pansoft sql]$ cd $ADMIN_SCRIPTS_HOME/
[applmgr@pansoft scripts]$ pwd
/u01/oracle/proderp/fs2/inst/apps/PRODERP_pansoft/admin/scripts
[applmgr@pansoft scripts]$ ./adstrtal.sh

You are running adstrtal.sh version 120.24.12020000.11


Enter the APPS username: apps

Enter the APPS password:
[applmgr@pansoft scripts]$
[applmgr@pansoft scripts]$ ./adstrtal.sh

You are running adstrtal.sh version 120.24.12020000.11


Enter the APPS username: apps

Enter the APPS password:
Enter the WebLogic Server password:

Changing apps password when SSO and DB Vault Enabled

Step 1: Shut down the UAT applications on apps1 & apps2

Step 2: Change the 'apps' password using 'FNDCPASS'

FNDCPASS apps/welcome123 0 Y DBV_ACCTMGR/welcome1 SYSTEM APPLSYS welcome1

applmgr@pansoft01 scripts]$ pwd
/u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/admin/scripts
[applmgr@pansoft01 scripts]$ FNDCPASS apps/welcome123 0 Y DBV_ACCTMGR/welcome1 SYSTEM APPLSYS welcome1
Log filename : L3696582.log


Report filename : O3696582.out

[applmgr@pansoft01 scripts]$ more L3696582.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 08-AUG-2019 09:44:05

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** SYSTEM APPLSYS *****
+----------------------------------------------------------------------------+
Working...

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 08-AUG-2019 09:44:09

+---------------------------------------------------------------------------+
[applmgr@pansoft01 scripts]$


Step 3: Disable Database Vault using dbv_owner

/home/oraprod/DBA/scripts/vault

SQL> select name from v$database;

NAME
---------
UATERP


SQL> @fnddbvstatus.sql DISABLE

PL/SQL procedure successfully completed.


Commit complete.


Step 4:Execute Autoconfig on DB node1 & DB node2 and Apps node1 & Apps node2

DB1:
===

[oraprod@pansoftd01 uaterp1_pansoftd01]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/uaterp1_pansoftd01
[oraprod@pansoftd01 uaterp1_pansoftd01]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/log/uaterp1_pansoftd01/08081005/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oracle/product/12.1.0/dbhome_1
        Classpath                   : :/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/ldapjclnt12.jar

        Using Context file          : /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/uaterp1_pansoftd01.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.


DB2:
=====
[oraprod@pansoftd02 uaterp2_pansoftd02]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/uaterp2_pansoftd02
[oraprod@pansoftd02 uaterp2_pansoftd02]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/log/uaterp2_pansoftd02/08081015/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oracle/product/12.1.0/dbhome_1
        Classpath                   : :/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/ldapjclnt12.jar

        Using Context file          : /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/uaterp2_pansoftd02.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oraprod@pansoftd02 uaterp2_pansoftd02]$

APP1:
======
[applmgr@pansoft01 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/admin/log/08081016/adconfig.log


wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01
        Classpath                   : /u01/oracle/uaterp/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs2/EBSapps/comn/java/classes

        Using Context file          : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/appl/admin/UATERP_pansoft01.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring SHT_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

APP2:
=======
[applmgr@pansoft02 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02/admin/log/08081041/adconfig.log


wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02
        Classpath                   : /u01/oracle/uaterp/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs2/EBSapps/comn/java/classes

        Using Context file          : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02/appl/admin/UATERP_pansoft02.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring SHT_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applmgr@pansoft02 scripts]$


Step 5:Start the admin server from apps1

[applmgr@pansoft01 scripts]$ ./adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.11

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/oracle/uaterp/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[applmgr@pansoft01 scripts]$


Step 6: Change the apps password in Data Sources by login to Weblogic console

Step 7: Test connectivity with sqlplus

APP1:
=====
applmgr@pansoft01 scripts]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 8 10:58:54 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> select name from v$database;

NAME
---------
UATERP

SQL> show user
USER is "APPS"

[applmgr@pansoft02 scripts]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 8 10:59:03 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options

SQL> select name from v$database;

NAME
---------
UATERP

SQL> sho user
USER is "APPS"


Step 9 : Start the applications from APP1 & APP2.

Step 10: Validate the Applications.

Step 11: Validate the SSO

How to change the Concurrent Manager log and output file location in R12

1- By default in R12.1 and R12.2, the Logs and Output are located in $APPLCSF/$APPLLOG and  $APPLCSF/$APPLOUT.

2- Change the value of APPLCSF, APPLLOG and APPLOUT  in the context file to your desired location in context file. Make sure the path you have mentioned is accessible from every application node.

[applmgr@pansoft01 scripts]$ cd $APPLCSF/
[applmgr@pansoft01 conc]$ ls
inbound  log  out  outbound
[applmgr@pansoft01 conc]$ pwd
/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft01/logs/appl/conc
[applmgr@pansoft01 conc]$ cd /u01/oracle/uaterp
[applmgr@pansoft01 uaterp]$

[applmgr@pansoft01 uaterp]$ grep -i s_applcsf $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft01/logs/appl/conc</APPLCSF>
[applmgr@pansoft01 uaterp]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft01/logs/appl/conc</APPLCSF>
         <APPLLOG oa_var="s_appllog">log</APPLLOG>
         <APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@pansoft01 uaterp]$



[applmgr@pansoft02 scripts]$ cd $APPLCSF/
[applmgr@pansoft02 conc]$ pwd
/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft02/logs/appl/conc
[applmgr@pansoft02 conc]$ ls
inbound  log  out  outbound
[applmgr@pansoft02 conc]$ s

[applmgr@pansoft02 conc]$ grep -i s_applcsf $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft02/logs/appl/conc</APPLCSF>
[applmgr@pansoft02 conc]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/fs_ne/inst/UATERP_pansoft02/logs/appl/conc</APPLCSF>
         <APPLLOG oa_var="s_appllog">log</APPLLOG>
         <APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@pansoft02 conc]$



Bakcup of context file on both nodes:


[applmgr@pansoft01 uaterp]$ mkdir conc_logs
[applmgr@pansoft01 uaterp]$ mv conc_logs conc_common
[applmgr@pansoft01 uaterp]$ ll
total 20
-rw-r--r--. 1 applmgr oinstall  878 May 13 09:57 AFPWD_UATERP_741432.log
-rw-r--r--. 1 applmgr oinstall  895 May 13 10:41 AFPWD_UATERP_744093.log
-rw-r--r--. 1 applmgr oinstall  895 May 13 10:48 AFPWD_UATERP_744504.log
drwxr-xr-x. 2 applmgr oinstall    6 May 14 10:57 conc_common
-rw-r--r--. 1 applmgr oinstall 6471 May  6 11:50 EBSapps.env
drwxr-xr-x. 5 applmgr oinstall   66 May  5 10:24 fs1
drwxr-xr-x. 9 applmgr oinstall  133 May  5 08:46 fs1_old2
drwxr-xr-x. 5 applmgr oinstall   49 May  5 10:46 fs2
drwxr-xr-x. 4 applmgr oinstall   33 May  5 10:29 fs_ne
[applmgr@pansoft01 uaterp]$ cd conc_common/
[applmgr@pansoft01 conc_common]$ pwd
/u01/oracle/uaterp/conc_common

[applmgr@pansoft02 admin]$ cd /u01/oracle/uaterp/
[applmgr@pansoft02 uaterp]$ mkdir conc_common
[applmgr@pansoft02 uaterp]$ ll
total 8
drwxr-xr-x. 2 applmgr oinstall    6 May 14 10:58 conc_common
-rw-r--r--. 1 applmgr oinstall 6471 May  6 16:13 EBSapps.env
drwxr-xr-x. 5 applmgr oinstall   49 May  6 15:54 fs1
drwxr-xr-x. 5 applmgr oinstall   49 May  6 16:06 fs2
drwxr-xr-x. 4 applmgr oinstall   33 May  6 15:58 fs_ne
[applmgr@pansoft02 uaterp]$


[applmgr@pansoft01 conc_common]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/conc_common</APPLCSF>
         <APPLLOG oa_var="s_appllog">log</APPLLOG>
         <APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@pansoft01 conc_common]$


[applmgr@pansoft02 conc_common]$ vi $CONTEXT_FILE
[applmgr@pansoft02 conc_common]$ egrep -i 's_applcsf|s_appllog|s_applout' $CONTEXT_FILE
         <APPLCSF oa_var="s_applcsf">/u01/oracle/uaterp/conc_common</APPLCSF>
         <APPLLOG oa_var="s_appllog">log</APPLLOG>
         <APPLOUT oa_var="s_applout">out</APPLOUT>
[applmgr@pansoft02 conc_common]$

[applmgr@pansoft01 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft01/admin/log/05141102/adconfig.log


wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft01
        Classpath                   : /u01/oracle/uaterp/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs1/EBSapps/comn/java/classes

        Using Context file          : /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft01/appl/admin/UATERP_pansoft01.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring SHT_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applmgr@pansoft01 scripts]$


[applmgr@pansoft02 conc_common]$ cd $ADMIN_SCRIPTS_HOME/
[applmgr@pansoft02 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft02/admin/log/05141103/adconfig.log


wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft02
        Classpath                   : /u01/oracle/uaterp/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs1/EBSapps/comn/java/classes

        Using Context file          : /u01/oracle/uaterp/fs1/inst/apps/UATERP_pansoft02/appl/admin/UATERP_pansoft02.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring SHT_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applmgr@pansoft02 scripts]$

BI Discoverer 11g: Unable To Connect To Oracle Applications Database: Invalid Username/Password

[applmgr@pansoft PROD]$ echo $FND_SECURE/
/u01/oracle/PROD/fs1/inst/apps/PROD_pansoft/appl/fnd/12.0.0/secure/
[applmgr@pansoft PROD]$ cd /u01/oracle/PROD/fs1/inst/apps/PROD_pansoft/appl/fnd/12.0.0/secure/
[applmgr@pansoft secure]$ java oracle.apps.fnd.security.AdminAppServer apps/apps123 STATUS DBC=$FND_SECURE/PROD.dbc

Database Server
---------------
DATABASE_ID: PROD
AUTHENTICATION: SECURE

Application Server
------------------
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: 8A8B250D33497B22E0539A67A8C0B20682239503531082300412441641523999

[applmgr@pansoft secure]$ java oracle.apps.fnd.security.AdminAppServer apps/apps123 AUTHENTICATION OFF DBC=$FND_SECURE/PROD.dbc
AUTHENTICATION OFF executed successfully - /u01/oracle/PROD/fs1/inst/apps/PROD_pansoft/appl/fnd/12.0.0/secure/PROD.dbc

[applmgr@pansoft secure]$ java oracle.apps.fnd.security.AdminAppServer apps/apps123 STATUS DBC=$FND_SECURE/PROD.dbc

alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger

R12.2 Adcfgclone.pl Configuring Run File System Error: Failed to enable EBS_LOGON trigger 

Issue

Enter the APPS password : Enter the APPS password : Error while executing /u01/oracle/erpdev/fs2/EBSapps/comn/clone/bin/alter_ebs_logon_trigger.sql

alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger



update context_file

context value == s_update_scan  -====> TRUE(For Rac Only)



Run autoconfig


[oraprod@pansoft ERPDEV_pansoft]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:24:32 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> alter user sys identified by welcome1;

User altered.



SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:29:21 201


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> show parameter service;



NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

service_names                        string      ERPDEV, ebs_patch,ERPDEV_ebs_p

                                                 atch

SQL> alter system set service_names='ERPDEV','ebs_patch' scope=both;



System altered.



SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraprod@pansoft ERPDEV_pansoft]$ lsnrctl reload  ERPDEV



LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-JUL-2019 16:30:33



Copyright (c) 1991, 2014, Oracle.  All rights reserved.



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=panosft.dba.com)(PORT=1541)))

The command completed successfully

[oraprod@pansoft ERPDEV_pansoft]$ lsnrctl status ERPDEV



LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-JUL-2019 16:30:35



Copyright (c) 1991, 2014, Oracle.  All rights reserved.



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=panosft.dba.com)(PORT=1541)))

STATUS of the LISTENER

------------------------

Alias                     ERPDEV

Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date                31-JUL-2019 16:21:10

Uptime                    0 days 0 hr. 9 min. 24 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/ERPDEV_pansoft/listener.ora

Listener Log File         /u01/app/oracle/product/12.1.0/dbhome_1/admin/ERPDEV_pansoft/diag/tnslsnr/pansoft/erpdev/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=panosft.dba.com)(PORT=1541)))

Services Summary...

Service "ERPDEV" has 2 instance(s).

  Instance "ERPDEV", status UNKNOWN, has 1 handler(s) for this service...

  Instance "ERPDEV", status READY, has 1 handler(s) for this service...

Service "ebs_patch" has 1 instance(s).

  Instance "ERPDEV", status READY, has 1 handler(s) for this service...

The command completed successfully

[oraprod@pansoft ERPDEV_pansoft]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:30:37 2019


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> show parameter local_;



NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

_local_communication_costing_enabled boolean     TRUE

local_listener                       string      ERPDEV_LOCAL

SQL>

SQL>

SQL>

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraprod@pansoft ERPDEV_pansoft]$

[oraprod@pansoft ERPDEV_pansoft]$

[oraprod@pansoft ERPDEV_pansoft]$ exit

logout

[root@pansoft ERPDEV_pansoft]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \

> compat-libcap1 \

> compat-libstdc++-33 \

> elfutils-libelf \

> elfutils-libelf-devel \

> gcc \

> gcc-c++ \

> glibc \

> glibc-common \

> glibc-devel \

> glibc-headers \

> ksh \

> libaio \

> libaio-devel \

> libgcc \

> libstdc++ \

> libstdc++-devel \

> make \

> libXext \

> libXtst \

> libX11 \

> libXau \

> libxcb \

> libXi \

> libXp \

> libaio \

> sysstat \

> unixODBC \

> unixODBC-devel \

> openmotif21 \

> xorg-x11-utils \

> libXrender \

> perl \

> gdbm \

> libgomp \

> redhat-lsb \

> util-linux \

> sysstat \

> xorg-x11-libs-compat \

> perl-File-CheckTree

binutils-2.27-34.base.el7(x86_64)

compat-libcap1-1.10-7.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(i686)

elfutils-libelf-0.172-2.el7(x86_64)

package elfutils-libelf-devel is not installed

gcc-4.8.5-36.el7_6.2(x86_64)

gcc-c++-4.8.5-36.el7_6.2(x86_64)

glibc-2.17-260.el7_6.5(x86_64)

glibc-2.17-260.el7_6.5(i686)

glibc-common-2.17-260.el7_6.5(x86_64)

glibc-devel-2.17-260.el7_6.5(x86_64)

glibc-devel-2.17-260.el7_6.5(i686)

glibc-headers-2.17-260.el7_6.5(x86_64)

ksh-20120801-139.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

package libaio-devel is not installed

libgcc-4.8.5-36.el7_6.2(x86_64)

libgcc-4.8.5-36.el7_6.2(i686)

libstdc++-4.8.5-36.el7_6.2(x86_64)

libstdc++-4.8.5-36.el7_6.2(i686)

libstdc++-devel-4.8.5-36.el7_6.2(x86_64)

libstdc++-devel-4.8.5-36.el7_6.2(i686)

make-3.82-23.el7(x86_64)

libXext-1.3.3-3.el7(i686)

libXext-1.3.3-3.el7(x86_64)

libXtst-1.2.3-1.el7(x86_64)

libXtst-1.2.3-1.el7(i686)

libX11-1.6.5-2.el7(x86_64)

libX11-1.6.5-2.el7(i686)

libXau-1.0.8-2.1.el7(x86_64)

libXau-1.0.8-2.1.el7(i686)

libxcb-1.13-1.el7(x86_64)

libxcb-1.13-1.el7(i686)

libXi-1.7.9-1.el7(x86_64)

libXi-1.7.9-1.el7(i686)

libXp-1.0.2-2.1.el7(i686)

libXp-1.0.2-2.1.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

sysstat-10.1.5-4.el7(x86_64)

package unixODBC is not installed

package unixODBC-devel is not installed

openmotif21-2.1.30-11.el7(i686)

xorg-x11-utils-7.5-23.el7(x86_64)

libXrender-0.9.10-1.el7(x86_64)

libXrender-0.9.10-1.el7(i686)

perl-5.16.3-294.el7_6(x86_64)

gdbm-1.10-8.el7(x86_64)

gdbm-1.10-8.el7(i686)

libgomp-4.8.5-36.el7_6.2(x86_64)

redhat-lsb-4.1-27.0.1.el7(x86_64)

util-linux-2.23.2-59.el7_6.1(x86_64)

sysstat-10.1.5-4.el7(x86_64)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1(i386)

perl-File-CheckTree-4.42-3.el7(noarch)

[root@pansoft ERPDEV_pansoft]# yum install elfutils*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms                                                                             | 2.1 kB  00:00:00

rhel-7-server-rpms                                                                                       | 2.0 kB  00:00:00

Package elfutils-libs-0.172-2.el7.x86_64 already installed and latest version

Package elfutils-0.172-2.el7.x86_64 already installed and latest version

Package elfutils-default-yama-scope-0.172-2.el7.noarch already installed and latest version

Package elfutils-libelf-0.172-2.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package elfutils-devel.x86_64 0:0.172-2.el7 will be installed

--> Processing Dependency: pkgconfig(liblzma) for package: elfutils-devel-0.172-2.el7.x86_64

---> Package elfutils-libelf-devel.x86_64 0:0.172-2.el7 will be installed

--> Running transaction check

---> Package xz-devel.x86_64 0:5.2.2-1.el7 will be installed

--> Finished Dependency Resolution



Dependencies Resolved



================================================================================================================================

 Package                              Arch                  Version                     Repository                         Size

================================================================================================================================

Installing:

 elfutils-devel                       x86_64                0.172-2.el7                 rhel-7-server-rpms                 87 k

 elfutils-libelf-devel                x86_64                0.172-2.el7                 rhel-7-server-rpms                 39 k

Installing for dependencies:

 xz-devel                             x86_64                5.2.2-1.el7                 rhel-7-server-rpms                 46 k



Transaction Summary

================================================================================================================================

Install  2 Packages (+1 Dependent package)



Total download size: 172 k

Installed size: 496 k

Is this ok [y/d/N]: Y

Downloading packages:

(1/3): elfutils-devel-0.172-2.el7.x86_64.rpm                                                             |  87 kB  00:00:00

(2/3): elfutils-libelf-devel-0.172-2.el7.x86_64.rpm                                                      |  39 kB  00:00:00

(3/3): xz-devel-5.2.2-1.el7.x86_64.rpm                                                                   |  46 kB  00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total                                                                                           775 kB/s | 172 kB  00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : xz-devel-5.2.2-1.el7.x86_64                                                                                  1/3

  Installing : elfutils-libelf-devel-0.172-2.el7.x86_64                                                                     2/3

  Installing : elfutils-devel-0.172-2.el7.x86_64                                                                            3/3

Uploading Package Profile

  Verifying  : elfutils-libelf-devel-0.172-2.el7.x86_64                                                                     1/3

  Verifying  : xz-devel-5.2.2-1.el7.x86_64                                                                                  2/3

  Verifying  : elfutils-devel-0.172-2.el7.x86_64                                                                            3/3



Installed:

  elfutils-devel.x86_64 0:0.172-2.el7                         elfutils-libelf-devel.x86_64 0:0.172-2.el7



Dependency Installed:

  xz-devel.x86_64 0:5.2.2-1.el7



Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install libaio-devel

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms                                                                             | 2.1 kB  00:00:00

rhel-7-server-rpms                                                                                       | 2.0 kB  00:00:00

Resolving Dependencies

--> Running transaction check

---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed

--> Finished Dependency Resolution



Dependencies Resolved



================================================================================================================================

 Package                      Arch                   Version                           Repository                          Size

================================================================================================================================

Installing:

 libaio-devel                 x86_64                 0.3.109-13.el7                    rhel-7-server-rpms                  13 k



Transaction Summary

================================================================================================================================

Install  1 Package



Total download size: 13 k

Installed size: 7.8 k

Is this ok [y/d/N]: Y

Downloading packages:

libaio-devel-0.3.109-13.el7.x86_64.rpm                                                                   |  13 kB  00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                                           1/1

Uploading Package Profile

  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                                           1/1



Installed:

  libaio-devel.x86_64 0:0.3.109-13.el7



Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install compat-libstdc*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms                                                                             | 2.1 kB  00:00:00

rhel-7-server-rpms                                                                                       | 2.0 kB  00:00:00

Nothing to do

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install compat*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms                                                                             | 2.1 kB  00:00:00

rhel-7-server-rpms                                                                                       | 2.0 kB  00:00:00

Package compat-db-headers-4.7.25-28.el7.noarch already installed and latest version

Package compat-cheese314-3.14.2-1.el7.x86_64 already installed and latest version

Package compat-libtiff3-3.9.4-11.el7.x86_64 already installed and latest version

Package 1:compat-glibc-headers-2.12-4.el7.x86_64 already installed and latest version

Package compat-db47-4.7.25-28.el7.x86_64 already installed and latest version

Package compat-libical1-1.0.1-2.el7.x86_64 already installed and latest version

Package 1:compat-glibc-2.12-4.el7.x86_64 already installed and latest version

Package compat-libgfortran-41-4.1.2-44.el7.x86_64 already installed and latest version

Package 1:compat-openldap-2.3.43-5.el7.x86_64 already installed and latest version

Package compat-libf2c-34-3.4.6-32.el7.x86_64 already installed and latest version

Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package compat-dapl.x86_64 1:1.2.19-4.el7 will be installed

---> Package compat-exiv2-023.x86_64 0:0.23-2.el7 will be installed

---> Package compat-gcc-44.x86_64 0:4.4.7-8.el7 will be installed

---> Package compat-gcc-44-c++.x86_64 0:4.4.7-8.el7 will be installed

---> Package compat-glade315.x86_64 0:3.15.0-1.el7 will be installed

---> Package compat-gnome-desktop314.x86_64 0:3.14.2-1.el7 will be installed

---> Package compat-grilo02.x86_64 0:0.2.12-1.el7 will be installed

---> Package compat-libcogl-pango12.x86_64 0:1.14.0-3.el7 will be installed

---> Package compat-libcogl12.x86_64 0:1.14.0-3.el7 will be installed

---> Package compat-libcolord1.x86_64 0:1.0.4-1.el7 will be installed

---> Package compat-libgdata13.x86_64 0:0.13.3-1.el7 will be installed

---> Package compat-libgnome-bluetooth11.x86_64 1:3.8.2.1-2.el7 will be installed

---> Package compat-libgnome-desktop3-7.x86_64 0:3.8.4-2.el7 will be installed

---> Package compat-libgweather3.x86_64 0:3.8.2-1.el7 will be installed

---> Package compat-libmediaart0.x86_64 0:0.7.0-1.el7 will be installed

---> Package compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7 will be installed

---> Package compat-libupower-glib1.x86_64 0:0.9.20-1.el7 will be installed

---> Package compat-libxcb.x86_64 0:1.9-1.el7 will be installed

---> Package compat-openmpi16.x86_64 0:1.6.4-10.7.el7 will be installed

--> Processing Dependency: environment-modules for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libpsm_infinipath.so.1()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libosmcomp.so.3()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libhwloc.so.5()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libesmtp.so.6()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

---> Package compat-opensm-libs.x86_64 0:3.3.15-2.el7 will be installed

--> Processing Dependency: libibumad.so.3(IBUMAD_1.0)(64bit) for package: compat-opensm-libs-3.3.15-2.el7.x86_64

--> Processing Dependency: libibumad.so.3()(64bit) for package: compat-opensm-libs-3.3.15-2.el7.x86_64

---> Package compat-poppler022.x86_64 0:0.22.5-4.el7 will be installed

---> Package compat-poppler022-glib.x86_64 0:0.22.5-4.el7 will be installed

---> Package compat-poppler022-qt.x86_64 0:0.22.5-4.el7 will be installed

--> Running transaction check

---> Package environment-modules.x86_64 0:3.2.10-10.el7 will be installed

--> Processing Dependency: libtcl8.5.so()(64bit) for package: environment-modules-3.2.10-10.el7.x86_64

---> Package hwloc-libs.x86_64 0:1.11.8-4.el7 will be installed

---> Package infinipath-psm.x86_64 0:3.3-26_g604758e_open.2.el7 will be installed

---> Package libesmtp.x86_64 0:1.0.6-7.el7 will be installed

---> Package libibumad.x86_64 0:17.2-3.el7 will be installed

---> Package opensm-libs.x86_64 0:3.3.20-3.el7 will be installed

--> Running transaction check

---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed

--> Finished Dependency Resolution



Dependencies Resolved



================================================================================================================================

 Package                                Arch            Version                               Repository                   Size

================================================================================================================================

Installing:

 compat-dapl                            x86_64          1:1.2.19-4.el7                        rhel-7-server-rpms          110 k

 compat-exiv2-023                       x86_64          0.23-2.el7                            rhel-7-server-rpms          681 k

 compat-gcc-44                          x86_64          4.4.7-8.el7                           rhel-7-server-rpms           10 M

 compat-gcc-44-c++                      x86_64          4.4.7-8.el7                           rhel-7-server-rpms          6.3 M

 compat-glade315                        x86_64          3.15.0-1.el7                          rhel-7-server-rpms          243 k

 compat-gnome-desktop314                x86_64          3.14.2-1.el7                          rhel-7-server-rpms          108 k

 compat-grilo02                         x86_64          0.2.12-1.el7                          rhel-7-server-rpms          102 k

 compat-libcogl-pango12                 x86_64          1.14.0-3.el7                          rhel-7-server-rpms           27 k

 compat-libcogl12                       x86_64          1.14.0-3.el7                          rhel-7-server-rpms          282 k

 compat-libcolord1                      x86_64          1.0.4-1.el7                           rhel-7-server-rpms           96 k

 compat-libgdata13                      x86_64          0.13.3-1.el7                          rhel-7-server-rpms          217 k

 compat-libgnome-bluetooth11            x86_64          1:3.8.2.1-2.el7                       rhel-7-server-rpms           63 k

 compat-libgnome-desktop3-7             x86_64          3.8.4-2.el7                           rhel-7-server-rpms           88 k

 compat-libgweather3                    x86_64          3.8.2-1.el7                           rhel-7-server-rpms           57 k

 compat-libmediaart0                    x86_64          0.7.0-1.el7                           rhel-7-server-rpms           33 k

 compat-libpackagekit-glib2-16          x86_64          0.8.9-1.el7                           rhel-7-server-rpms          112 k

 compat-libupower-glib1                 x86_64          0.9.20-1.el7                          rhel-7-server-rpms           33 k

 compat-libxcb                          x86_64          1.9-1.el7                             rhel-7-server-rpms           44 k

 compat-openmpi16                       x86_64          1.6.4-10.7.el7                        rhel-7-server-rpms          2.5 M

 compat-opensm-libs                     x86_64          3.3.15-2.el7                          rhel-7-server-rpms           18 k

 compat-poppler022                      x86_64          0.22.5-4.el7                          rhel-7-server-rpms          722 k

 compat-poppler022-glib                 x86_64          0.22.5-4.el7                          rhel-7-server-rpms           87 k

 compat-poppler022-qt                   x86_64          0.22.5-4.el7                          rhel-7-server-rpms          150 k

Installing for dependencies:

 environment-modules                    x86_64          3.2.10-10.el7                         rhel-7-server-rpms          107 k

 hwloc-libs                             x86_64          1.11.8-4.el7                          rhel-7-server-rpms          1.6 M

 infinipath-psm                         x86_64          3.3-26_g604758e_open.2.el7            rhel-7-server-rpms          186 k

 libesmtp                               x86_64          1.0.6-7.el7                           rhel-7-server-rpms           63 k

 libibumad                              x86_64          17.2-3.el7                            rhel-7-server-rpms           23 k

 opensm-libs                            x86_64          3.3.20-3.el7                          rhel-7-server-rpms           66 k

 tcl                                    x86_64          1:8.5.13-8.el7                        rhel-7-server-rpms          1.9 M



Transaction Summary

================================================================================================================================

Install  23 Packages (+7 Dependent packages)



Total download size: 26 M

Installed size: 71 M

Is this ok [y/d/N]: Y

Downloading packages:

(1/30): compat-exiv2-023-0.23-2.el7.x86_64.rpm                                                           | 681 kB  00:00:00

(2/30): compat-dapl-1.2.19-4.el7.x86_64.rpm                                                              | 110 kB  00:00:00

(3/30): compat-gcc-44-4.4.7-8.el7.x86_64.rpm                                                             |  10 MB  00:00:00

(4/30): compat-gcc-44-c++-4.4.7-8.el7.x86_64.rpm                                                         | 6.3 MB  00:00:00

(5/30): compat-glade315-3.15.0-1.el7.x86_64.rpm                                                          | 243 kB  00:00:00

(6/30): compat-gnome-desktop314-3.14.2-1.el7.x86_64.rpm                                                  | 108 kB  00:00:00

(7/30): compat-grilo02-0.2.12-1.el7.x86_64.rpm                                                           | 102 kB  00:00:00

(8/30): compat-libcogl-pango12-1.14.0-3.el7.x86_64.rpm                                                   |  27 kB  00:00:00

(9/30): compat-libcogl12-1.14.0-3.el7.x86_64.rpm                                                         | 282 kB  00:00:00

(10/30): compat-libcolord1-1.0.4-1.el7.x86_64.rpm                                                        |  96 kB  00:00:00

(11/30): compat-libgdata13-0.13.3-1.el7.x86_64.rpm                                                       | 217 kB  00:00:00

(12/30): compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64.rpm                                            |  63 kB  00:00:00

(13/30): compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64.rpm                                               |  88 kB  00:00:00

(14/30): compat-libgweather3-3.8.2-1.el7.x86_64.rpm                                                      |  57 kB  00:00:00

(15/30): compat-libmediaart0-0.7.0-1.el7.x86_64.rpm                                                      |  33 kB  00:00:00

(16/30): compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64.rpm                                            | 112 kB  00:00:00

(17/30): compat-libxcb-1.9-1.el7.x86_64.rpm                                                              |  44 kB  00:00:00

(18/30): compat-libupower-glib1-0.9.20-1.el7.x86_64.rpm                                                  |  33 kB  00:00:00

(19/30): compat-opensm-libs-3.3.15-2.el7.x86_64.rpm                                                      |  18 kB  00:00:00

(20/30): compat-openmpi16-1.6.4-10.7.el7.x86_64.rpm                                                      | 2.5 MB  00:00:00

(21/30): compat-poppler022-0.22.5-4.el7.x86_64.rpm                                                       | 722 kB  00:00:00

(22/30): compat-poppler022-glib-0.22.5-4.el7.x86_64.rpm                                                  |  87 kB  00:00:00

(23/30): compat-poppler022-qt-0.22.5-4.el7.x86_64.rpm                                                    | 150 kB  00:00:00

(24/30): environment-modules-3.2.10-10.el7.x86_64.rpm                                                    | 107 kB  00:00:00

(25/30): hwloc-libs-1.11.8-4.el7.x86_64.rpm                                                              | 1.6 MB  00:00:00

(26/30): infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64.rpm                                            | 186 kB  00:00:00

(27/30): libesmtp-1.0.6-7.el7.x86_64.rpm                                                                 |  63 kB  00:00:00

(28/30): libibumad-17.2-3.el7.x86_64.rpm                                                                 |  23 kB  00:00:00

(29/30): opensm-libs-3.3.20-3.el7.x86_64.rpm                                                             |  66 kB  00:00:00

(30/30): tcl-8.5.13-8.el7.x86_64.rpm                                                                     | 1.9 MB  00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total                                                                                            24 MB/s |  26 MB  00:00:01

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : compat-poppler022-0.22.5-4.el7.x86_64                                                                       1/30

  Installing : libibumad-17.2-3.el7.x86_64                                                                                 2/30

  Installing : opensm-libs-3.3.20-3.el7.x86_64                                                                             3/30

  Installing : hwloc-libs-1.11.8-4.el7.x86_64                                                                              4/30

  Installing : infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64                                                            5/30

  Installing : compat-libcogl12-1.14.0-3.el7.x86_64                                                                        6/30

  Installing : libesmtp-1.0.6-7.el7.x86_64                                                                                 7/30

  Installing : 1:tcl-8.5.13-8.el7.x86_64                                                                                   8/30

  Installing : environment-modules-3.2.10-10.el7.x86_64                                                                    9/30

  Installing : compat-openmpi16-1.6.4-10.7.el7.x86_64                                                                     10/30

  Installing : compat-libcogl-pango12-1.14.0-3.el7.x86_64                                                                 11/30

  Installing : compat-opensm-libs-3.3.15-2.el7.x86_64                                                                     12/30

  Installing : compat-poppler022-glib-0.22.5-4.el7.x86_64                                                                 13/30

  Installing : compat-poppler022-qt-0.22.5-4.el7.x86_64                                                                   14/30

  Installing : compat-exiv2-023-0.23-2.el7.x86_64                                                                         15/30

  Installing : 1:compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64                                                         16/30

  Installing : 1:compat-dapl-1.2.19-4.el7.x86_64                                                                          17/30

  Installing : compat-libmediaart0-0.7.0-1.el7.x86_64                                                                     18/30

  Installing : compat-libgweather3-3.8.2-1.el7.x86_64                                                                     19/30

  Installing : compat-libupower-glib1-0.9.20-1.el7.x86_64                                                                 20/30

  Installing : compat-libxcb-1.9-1.el7.x86_64                                                                             21/30

  Installing : compat-grilo02-0.2.12-1.el7.x86_64                                                                         22/30

  Installing : compat-gnome-desktop314-3.14.2-1.el7.x86_64                                                                23/30

  Installing : compat-glade315-3.15.0-1.el7.x86_64                                                                        24/30

  Installing : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64                                                           25/30

  Installing : compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64                                                              26/30

  Installing : compat-libcolord1-1.0.4-1.el7.x86_64                                                                       27/30

  Installing : compat-libgdata13-0.13.3-1.el7.x86_64                                                                      28/30

  Installing : compat-gcc-44-4.4.7-8.el7.x86_64                                                                           29/30

  Installing : compat-gcc-44-c++-4.4.7-8.el7.x86_64                                                                       30/30

Uploading Package Profile

  Verifying  : 1:tcl-8.5.13-8.el7.x86_64                                                                                   1/30

  Verifying  : compat-gcc-44-c++-4.4.7-8.el7.x86_64                                                                        2/30

  Verifying  : compat-libgdata13-0.13.3-1.el7.x86_64                                                                       3/30

  Verifying  : compat-gcc-44-4.4.7-8.el7.x86_64                                                                            4/30

  Verifying  : libibumad-17.2-3.el7.x86_64                                                                                 5/30

  Verifying  : compat-libcolord1-1.0.4-1.el7.x86_64                                                                        6/30

  Verifying  : libesmtp-1.0.6-7.el7.x86_64                                                                                 7/30

  Verifying  : compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64                                                               8/30

  Verifying  : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64                                                            9/30

  Verifying  : compat-glade315-3.15.0-1.el7.x86_64                                                                        10/30

  Verifying  : compat-libcogl-pango12-1.14.0-3.el7.x86_64                                                                 11/30

  Verifying  : compat-libcogl12-1.14.0-3.el7.x86_64                                                                       12/30

  Verifying  : compat-gnome-desktop314-3.14.2-1.el7.x86_64                                                                13/30

  Verifying  : compat-opensm-libs-3.3.15-2.el7.x86_64                                                                     14/30

  Verifying  : compat-grilo02-0.2.12-1.el7.x86_64                                                                         15/30

  Verifying  : compat-libxcb-1.9-1.el7.x86_64                                                                             16/30

  Verifying  : compat-openmpi16-1.6.4-10.7.el7.x86_64                                                                     17/30

  Verifying  : compat-libupower-glib1-0.9.20-1.el7.x86_64                                                                 18/30

  Verifying  : compat-libgweather3-3.8.2-1.el7.x86_64                                                                     19/30

  Verifying  : infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64                                                           20/30

  Verifying  : compat-poppler022-0.22.5-4.el7.x86_64                                                                      21/30

  Verifying  : environment-modules-3.2.10-10.el7.x86_64                                                                   22/30

  Verifying  : opensm-libs-3.3.20-3.el7.x86_64                                                                            23/30

  Verifying  : compat-poppler022-glib-0.22.5-4.el7.x86_64                                                                 24/30

  Verifying  : compat-libmediaart0-0.7.0-1.el7.x86_64                                                                     25/30

  Verifying  : hwloc-libs-1.11.8-4.el7.x86_64                                                                             26/30

  Verifying  : 1:compat-dapl-1.2.19-4.el7.x86_64                                                                          27/30

  Verifying  : 1:compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64                                                         28/30

  Verifying  : compat-poppler022-qt-0.22.5-4.el7.x86_64                                                                   29/30

  Verifying  : compat-exiv2-023-0.23-2.el7.x86_64                                                                         30/30



Installed:

  compat-dapl.x86_64 1:1.2.19-4.el7                             compat-exiv2-023.x86_64 0:0.23-2.el7

  compat-gcc-44.x86_64 0:4.4.7-8.el7                            compat-gcc-44-c++.x86_64 0:4.4.7-8.el7

  compat-glade315.x86_64 0:3.15.0-1.el7                         compat-gnome-desktop314.x86_64 0:3.14.2-1.el7

  compat-grilo02.x86_64 0:0.2.12-1.el7                          compat-libcogl-pango12.x86_64 0:1.14.0-3.el7

  compat-libcogl12.x86_64 0:1.14.0-3.el7                        compat-libcolord1.x86_64 0:1.0.4-1.el7

  compat-libgdata13.x86_64 0:0.13.3-1.el7                       compat-libgnome-bluetooth11.x86_64 1:3.8.2.1-2.el7

  compat-libgnome-desktop3-7.x86_64 0:3.8.4-2.el7               compat-libgweather3.x86_64 0:3.8.2-1.el7

  compat-libmediaart0.x86_64 0:0.7.0-1.el7                      compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7

  compat-libupower-glib1.x86_64 0:0.9.20-1.el7                  compat-libxcb.x86_64 0:1.9-1.el7

  compat-openmpi16.x86_64 0:1.6.4-10.7.el7                      compat-opensm-libs.x86_64 0:3.3.15-2.el7

  compat-poppler022.x86_64 0:0.22.5-4.el7                       compat-poppler022-glib.x86_64 0:0.22.5-4.el7

  compat-poppler022-qt.x86_64 0:0.22.5-4.el7



Dependency Installed:

  environment-modules.x86_64 0:3.2.10-10.el7                              hwloc-libs.x86_64 0:1.11.8-4.el7

  infinipath-psm.x86_64 0:3.3-26_g604758e_open.2.el7                      libesmtp.x86_64 0:1.0.6-7.el7

  libibumad.x86_64 0:17.2-3.el7                                           opensm-libs.x86_64 0:3.3.20-3.el7

  tcl.x86_64 1:8.5.13-8.el7



Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install glibc*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms                                                                             | 2.1 kB  00:00:00

rhel-7-server-rpms                                                                                       | 2.0 kB  00:00:00

Resolving Dependencies

--> Running transaction check

---> Package glibc.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-common.x86_64 0:2.17-260.el7_6.5 will be updated

--> Processing Dependency: glibc-common = 2.17-260.el7_6.5 for package: glibc-2.17-260.el7_6.5.i686

---> Package glibc-common.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-devel.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc-devel.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-headers.x86_64 0:2.17-260.el7_6.5 will be updated

--> Processing Dependency: glibc-headers = 2.17-260.el7_6.5 for package: glibc-devel-2.17-260.el7_6.5.i686

---> Package glibc-headers.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-utils.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc-utils.x86_64 0:2.17-260.el7_6.6 will be an update

--> Running transaction check

---> Package glibc.i686 0:2.17-260.el7_6.5 will be updated

---> Package glibc.i686 0:2.17-260.el7_6.6 will be an update

---> Package glibc-devel.i686 0:2.17-260.el7_6.5 will be updated

---> Package glibc-devel.i686 0:2.17-260.el7_6.6 will be an update

--> Finished Dependency Resolution



Dependencies Resolved



================================================================================================================================

 Package                       Arch                   Version                          Repository                          Size

================================================================================================================================

Updating:

 glibc                         x86_64                 2.17-260.el7_6.6                 rhel-7-server-rpms                 3.6 M

 glibc-common                  x86_64                 2.17-260.el7_6.6                 rhel-7-server-rpms                  11 M

 glibc-devel                   x86_64                 2.17-260.el7_6.6                 rhel-7-server-rpms                 1.1 M

 glibc-headers                 x86_64                 2.17-260.el7_6.6                 rhel-7-server-rpms                 684 k

 glibc-utils                   x86_64                 2.17-260.el7_6.6                 rhel-7-server-rpms                 222 k

Updating for dependencies:

 glibc                         i686                   2.17-260.el7_6.6                 rhel-7-server-rpms                 4.3 M

 glibc-devel                   i686                   2.17-260.el7_6.6                 rhel-7-server-rpms                 1.1 M



Transaction Summary

================================================================================================================================

Upgrade  5 Packages (+2 Dependent packages)



Total download size: 22 M

Is this ok [y/d/N]: Y

Downloading packages:

No Presto metadata available for rhel-7-server-rpms

(1/7): glibc-2.17-260.el7_6.6.i686.rpm                                                                   | 4.3 MB  00:00:00

(2/7): glibc-2.17-260.el7_6.6.x86_64.rpm                                                                 | 3.6 MB  00:00:00

(3/7): glibc-devel-2.17-260.el7_6.6.i686.rpm                                                             | 1.1 MB  00:00:00

(4/7): glibc-common-2.17-260.el7_6.6.x86_64.rpm                                                          |  11 MB  00:00:00

(5/7): glibc-devel-2.17-260.el7_6.6.x86_64.rpm                                                           | 1.1 MB  00:00:00

(6/7): glibc-headers-2.17-260.el7_6.6.x86_64.rpm                                                         | 684 kB  00:00:00

(7/7): glibc-utils-2.17-260.el7_6.6.x86_64.rpm                                                           | 222 kB  00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total                                                                                            50 MB/s |  22 MB  00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Updating   : glibc-common-2.17-260.el7_6.6.x86_64                                                                        1/14

  Updating   : glibc-2.17-260.el7_6.6.x86_64                                                                               2/14

  Updating   : glibc-headers-2.17-260.el7_6.6.x86_64                                                                       3/14

  Updating   : glibc-2.17-260.el7_6.6.i686                                                                                 4/14

  Updating   : glibc-devel-2.17-260.el7_6.6.i686                                                                           5/14

  Updating   : glibc-devel-2.17-260.el7_6.6.x86_64                                                                         6/14

  Updating   : glibc-utils-2.17-260.el7_6.6.x86_64                                                                         7/14

  Cleanup    : glibc-devel-2.17-260.el7_6.5                                                                                8/14

  Cleanup    : glibc-devel-2.17-260.el7_6.5                                                                                9/14

  Cleanup    : glibc-2.17-260.el7_6.5                                                                                     10/14

  Cleanup    : glibc-headers-2.17-260.el7_6.5.x86_64                                                                      11/14

  Cleanup    : glibc-utils-2.17-260.el7_6.5.x86_64                                                                        12/14

  Cleanup    : glibc-common-2.17-260.el7_6.5.x86_64                                                                       13/14

  Cleanup    : glibc-2.17-260.el7_6.5                                                                                     14/14

Uploading Package Profile

  Verifying  : glibc-utils-2.17-260.el7_6.6.x86_64                                                                         1/14

  Verifying  : glibc-devel-2.17-260.el7_6.6.i686                                                                           2/14

  Verifying  : glibc-2.17-260.el7_6.6.x86_64                                                                               3/14

  Verifying  : glibc-devel-2.17-260.el7_6.6.x86_64                                                                         4/14

  Verifying  : glibc-headers-2.17-260.el7_6.6.x86_64                                                                       5/14

  Verifying  : glibc-2.17-260.el7_6.6.i686                                                                                 6/14

  Verifying  : glibc-common-2.17-260.el7_6.6.x86_64                                                                        7/14

  Verifying  : glibc-devel-2.17-260.el7_6.5.i686                                                                           8/14

  Verifying  : glibc-2.17-260.el7_6.5.i686                                                                                 9/14

  Verifying  : glibc-utils-2.17-260.el7_6.5.x86_64                                                                        10/14

  Verifying  : glibc-devel-2.17-260.el7_6.5.x86_64                                                                        11/14

  Verifying  : glibc-headers-2.17-260.el7_6.5.x86_64                                                                      12/14

  Verifying  : glibc-common-2.17-260.el7_6.5.x86_64                                                                       13/14

  Verifying  : glibc-2.17-260.el7_6.5.x86_64                                                                              14/14



Updated:

  glibc.x86_64 0:2.17-260.el7_6.6            glibc-common.x86_64 0:2.17-260.el7_6.6    glibc-devel.x86_64 0:2.17-260.el7_6.6

  glibc-headers.x86_64 0:2.17-260.el7_6.6    glibc-utils.x86_64 0:2.17-260.el7_6.6



Dependency Updated:

  glibc.i686 0:2.17-260.el7_6.6                               glibc-devel.i686 0:2.17-260.el7_6.6



Complete!



[root@pansoft ERPDEV_pansoft]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \

> compat-libcap1 \

> compat-libstdc++-33 \

> elfutils-libelf \

> elfutils-libelf-devel \

> gcc \

> gcc-c++ \

> glibc \

> glibc-common \

> glibc-devel \

> glibc-headers \

> ksh \

> libaio \

> libaio-devel \

> libgcc \

> libstdc++ \

> libstdc++-devel \

> make \

> libXext \

> libXtst \

> libX11 \

> libXau \

> libxcb \

> libXi \

> libXp \

> libaio \

> sysstat \

> unixODBC \

> unixODBC-devel \

> openmotif21 \

> xorg-x11-utils \

> libXrender \

> perl \

> gdbm \

> libgomp \

> redhat-lsb \

> util-linux \

> sysstat \

> xorg-x11-libs-compat \

> perl-File-CheckTree

binutils-2.27-34.base.el7(x86_64)

compat-libcap1-1.10-7.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(i686)

elfutils-libelf-0.172-2.el7(x86_64)

elfutils-libelf-devel-0.172-2.el7(x86_64)

gcc-4.8.5-36.el7_6.2(x86_64)

gcc-c++-4.8.5-36.el7_6.2(x86_64)

glibc-2.17-260.el7_6.6(x86_64)

glibc-2.17-260.el7_6.6(i686)

glibc-common-2.17-260.el7_6.6(x86_64)

glibc-devel-2.17-260.el7_6.6(i686)

glibc-devel-2.17-260.el7_6.6(x86_64)

glibc-headers-2.17-260.el7_6.6(x86_64)

ksh-20120801-139.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

libaio-devel-0.3.109-13.el7(x86_64)

libgcc-4.8.5-36.el7_6.2(x86_64)

libgcc-4.8.5-36.el7_6.2(i686)

libstdc++-4.8.5-36.el7_6.2(x86_64)

libstdc++-4.8.5-36.el7_6.2(i686)

libstdc++-devel-4.8.5-36.el7_6.2(x86_64)

libstdc++-devel-4.8.5-36.el7_6.2(i686)

make-3.82-23.el7(x86_64)

libXext-1.3.3-3.el7(i686)

libXext-1.3.3-3.el7(x86_64)

libXtst-1.2.3-1.el7(x86_64)

libXtst-1.2.3-1.el7(i686)

libX11-1.6.5-2.el7(x86_64)

libX11-1.6.5-2.el7(i686)

libXau-1.0.8-2.1.el7(x86_64)

libXau-1.0.8-2.1.el7(i686)

libxcb-1.13-1.el7(x86_64)

libxcb-1.13-1.el7(i686)

libXi-1.7.9-1.el7(x86_64)

libXi-1.7.9-1.el7(i686)

libXp-1.0.2-2.1.el7(i686)

libXp-1.0.2-2.1.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

sysstat-10.1.5-4.el7(x86_64)

package unixODBC is not installed

package unixODBC-devel is not installed

openmotif21-2.1.30-11.el7(i686)

xorg-x11-utils-7.5-23.el7(x86_64)

libXrender-0.9.10-1.el7(x86_64)

libXrender-0.9.10-1.el7(i686)

perl-5.16.3-294.el7_6(x86_64)

gdbm-1.10-8.el7(x86_64)

gdbm-1.10-8.el7(i686)

libgomp-4.8.5-36.el7_6.2(x86_64)

redhat-lsb-4.1-27.0.1.el7(x86_64)

util-linux-2.23.2-59.el7_6.1(x86_64)

sysstat-10.1.5-4.el7(x86_64)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1(i386)

perl-File-CheckTree-4.42-3.el7(noarch)