ORDS 403 not able to login using chrome and firefox

ORDS:-

Issue:-

The request cannot be processed because this resource does not support Cross Origin Sharing requests, or the request Origin is not authorized to access this resource. If ords is being reverse proxied ensure the front end server is propagating the host name, for mod_proxy ensure ProxyPreserveHost is set to On



Solution :-


1) Add below parameter in defaults.xml file and restart all services.

<entry key="security.httpsHeaderCheck">X-Forwarded-Proto: https</entry>

2) In case if your using  OHS  then restart OHS services.

oracle 19c Installation Fails with error libclntsh.so

While installation  19c oracle home we are facing below issue.

Issue:- 

1) libclntsh.so: file format not recognized; treating as linker script.

2) unzip issue cannot find LINUX.X64_193000_db_home.zip

Solution:-

[root@ebs143 dbhome_1]# chmod -R 644 LINUX.X64_193000_db_home.zip 

[root@ebs143 dbhome_1]# ll

total 2988000

-rw-r--r-- 1 root root 3059705302 Apr  7 22:21 LINUX.X64_193000_db_home.zip

[root@ebs143 dbhome_1]# chown -R oracle:dba LINUX.X64_193000_db_home.zip 

[root@ebs143 dbhome_1]# yum install zip

Loaded plugins: langpacks, ulninfo

Package zip-3.0-11.el7.x86_64 already installed and latest version

Nothing to do

[root@ebs143 dbhome_1]# yum install unzip 

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package unzip.x86_64 0:6.0-19.el7 will be installed

       Protected multilib versions: unzip-6.0-19.el7.x86_64 != unzip-5.40-1.i386

[root@ebs143 dbhome_1]# yum remove unzip

root@ebs143 dbhome_1]# yum install unzip 

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package unzip.x86_64 0:6.0-19.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

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

 Package         Arch             Version                 Repository              Size

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

Installing:

 unzip           x86_64           6.0-19.el7              InstallMedia           169 k

Transaction Summary

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

Install  1 Package

Total download size: 169 k

Installed size: 365 k

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

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : unzip-6.0-19.el7.x86_64                                             1/1 

  Verifying  : unzip-6.0-19.el7.x86_64                                             1/1 

Installed:

  unzip.x86_64 0:6.0-19.el7                                                            

Complete!

[root@ebs143 dbhome_1]# 

Complete the installation.

OBIEE 12c: Exceeded configured maximum number of allowed input records

How to Fix Error Exceeded Co Maximum number of allowed I Records


Error:-

Solution :-


1) Go to the Instance Config file and take a backup copy of it .
2) Locate the cube section in the file, if it doesn't exist you might need to add.
3) Include the following set of code between the server instance tag.

Take a backup and modify [Domain-Home]/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

<Table>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload>
<DefaultRowsDisplayedInDownloadCSV>1000000</DefaultRowsDisplayedInDownloadCSV>
<MaxCells>20000000</MaxCells>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>200000</MaxVisibleRows>
<MaxVisibleSections>200000</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Table>

<Pivot>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
<MaxCells>20000000</MaxCells>
<MaxVisibleColumns>20000</MaxVisibleColumns>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>200000</MaxVisibleRows>
<MaxVisibleSections>200000</MaxVisibleSections>
</Pivot>

To export large quantities of rows to MS Excel, increase the InputStreamLimitInKB parameter and changed the ReadRequestBeforeProcessing value to false in $DOMAIN_HOME/config/fmwconfig/biconfig/OBIJH/config.xml file, as recommended by Oracle in Doc ID 1595671.1 

<XMLP> 

<InputStreamLimitInKB>0</InputStreamLimitInKB> 

<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing> 

</XMLP

<MessageProcessor> 

<!-- How much time worker thread should wait for a message before returning socket to the "idle" pool. Initial messages in the idle pool are handled using Java NIO Channels. --> 

<SocketTimeout>1200000</SocketTimeout> 

</MessageProcessor> 

In the obijh.properties file located in $ORACLE_HOME/bi/modules/oracle.bi.cam.obijh/env/ increase the memory reserved for JavaHost requests to 16GB 

MEM_ARGS=-Xmx16384M 

Edit the bridgeconfig.properties file, which is the configuration file for the Presentation Services Plug-In located in $DOMAIN_HOME/config/fmwconfig/biconfig/, adding the following parameters to increase the socket timeout and connection pool maximum connections 

# Number of seconds to wait for a response from sawserver 

# Default value is 360 seconds 

oracle.bi.presentation.sawconnect.ConnectionPool.SocketReadTimeoutSec = 3600 

# Maximum number of connections in pool. Default is a function of number of processors. 

# Default value is 128 

oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections = 512 

Restart OBIEE and validate the issue. 

4) If your using load balancer then perform below action plan

Take a backup of the existing configuration files mod_wl_ohs.conf. 

Increase the below parameter of <Location /analytics> and <Location /analytics-ws> to 

WLSocketTimeoutSecs 3600 

Restart OHS server and validate the issue. 

If still having the issue, increase the timeout from Oracle Load balancer "hostname". 

Contact your network team and troubleshoot network trace while running the report. This could help to understand the network breaking. 

Timeout parameter value of listener for obiee load balancer to 1800 seconds.

Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P

Error:

OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.


Solution:

[obiee@pan OBIS]$ pwd
/OBIEE/middleware/oracle/user_projects/domains/bi12/config/fmwconfig/biconfig/OBIS
[obiee@opera OBIS]$ ls -ltr
total 28
-rw-r----- 1 obiee dba 22401 Dec 26 11:06 NQSConfig.INI
-rw-r----- 1 obiee dba  1500 Dec 26 18:49 logconfig.xml
[obiee@pan OBIS]$ cp -rf NQSConfig.INI NQSConfig-org.INI
[obiee@pan OBIS]$ ls -ltr
total 52

Add below parameter.

[obiee@pan OBIS]$ ls
logconfig.xml  NQSConfig.INI  NQSConfig-org.INI
[obiee@opera OBIS]$ grep  EVALUATE_SUPPORT_LEVEL NQSConfig.INI
# EVALUATE_SUPPORT_LEVEL:
EVALUATE_SUPPORT_LEVEL = 2;
[obiee@pan OBIS]$

Restart BI services.

ORA-04063: Package Body APPS.FND_PROFILE Has Errors

Error:-


Cause: afpodbinit failed due to ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped package body "APPS.ICX_SEC"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ICX_SEC"
ORA-06512: at "APPS.FND_PROFILE", l.


The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.


Solution:-

SQL> alter package apps.ICX_SEC compile;

Package altered.

SQL> alter package apps.ICX_SEC compile body;

Package body altered.

SQL> show  error
No errors.
SQL> alter package apps.FND_PROFILE compile;

Package altered.

SQL> show error
No errors.
SQL> alter package apps.FND_PROFILE compile body;

Package body altered.

SQL> show error
No errors.
SQL> exit


Run Autoconfig at application.

You are not currently signed in to the Oracle BI Server

Error:-

You are not currently signed in to the Oracle BI Server

If you have already signed in, your connection might have timed out, or a communications or server error may have occurred.

To sign in again, click here. If the problem persists, please contact the site's administrator

Raised Oracle SR but Oracle was failed to Solve the ISSUE using below document.

OBIEE 12c : EBS / OBIEE 12c Integration Missing Steps (Doc ID 2141505.1) OBIEE 12c: Integrating OBIEE 12c with Oracle E-Business Suite (EBS) Security (Doc ID 2174747.1)

Solution:-

1) Execute the EBS security(RPD)  query against the EBS database and check the result.
2) Do not include ROLES and USER is same target variable.it will give same error.
3) check the parameters in two files authenticationschemas.xml and instanceconfig.xml. as per oracle doc id 2174747.1.
4) Found issue in  RPD need to correct the initialization using below parameters.

•   Get Oracle EBS Security Context
  
  Query=

SELECT
  FND_GLOBAL.RESP_ID,
  FND_GLOBAL.RESP_APPL_ID,
  FND_GLOBAL.SECURITY_GROUP_ID,
  FND_GLOBAL.RESP_NAME,
  FND_GLOBAL.USER_ID,
  FND_GLOBAL.EMPLOYEE_ID,
  FND_GLOBAL.USER_NAME
FROM DUAL

Required for authentication = checked box –YES

•  Get OBIEE User Group Persmissions

Query=

SELECT RESPONSIBILITY_NAME

FROM FND_RESPONSIBILITY_TL

WHERE RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'

Variable target  =GROUP

Execution precedence = ORACLE EBS Security Context

Required for authentication = checked box –YES

•  EBS Security Context – ROLES – Row wise

Query=

SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_TL WHERE
RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'
Variable target = ROLES
 Execution precedence = ORACLE EBS Security Context 

       Required for authentication = checked box –YES

Finally Issue resolved.

Create View ORA-01031: insufficient privileges

*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges



Solution :

[oracle@~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 5 14:54:07 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> grant CREATE ANY VIEW to XXALU;

Grant succeeded.


SQL> alter user XXALU enable editions;

User altered.


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
[oracle@~]$

View "XXTAM"."JOBS" created.

R12.2: Cloning Failed While Running adcfgclone appstier dualfs With sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Error:-

TXK Script Name: txkChkFormsLaunchMethod.pl
Enter the APPS user password:
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
ERRORCODE = 1 ERRORCODE_END
.end std out.
stty: standard input: Inappropriate ioctl for device
stty: standard input: Inappropriate ioctl for device
/u01/oracle/pansoft/fs2/EBSapps/10.1.2/bin/sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION:  [ Level 1 ]
ERRORMSG: *******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.




FIX:- (RHEL -7)

yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install zlib-devel.i686 -y

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]$