Installing Oracle Enterprise Command Center Framework, Release 12.2.8

Oracle Database version: 12.2.0.2

Oracle EBS version : 12.2.8

Oracle Enterprise Command Center Framework: 6.0

Oracle WebLogic Server: 12.2.1.4

1.1 Download the quick install package from My Oracle Support (https://support.oracle.com) by downloading Patch 31818720.

Unzip the patch using root user.

unzip p31818720_R12_GENERIC.zip

chmod +x *.bsx

Then, from within the $ECC_BASE directory, execute the .bsx files using the following command:

for f in *.bsx; do sh $f; done

1.2 Apply prerequisites patch in EBS 12.2.8

30628681->R12.AD.C.DELTA.12

30735865->R12.TXK.C.DELTA.12

31904550->Critical TXK Patches

31818610->R12.FIN_PF.C

31818592->R12.SCM_PF.C

31818605->R12.PRC_PF.C

31885457->Online Help Patch Financials (fin_pf)

31885375->Online Help Patch Supply Chain Management (scm_pf)

31885440->Online Help Patch Procurement (prc_pf)

1.3 Configure the Oracle Enterprise Command Center Framework Installation

Navigate to the $ECC_BASE/Oracle/quickInstall/ directory and open the EccConfig.properties file with a text editor. Enter the values for the following properties and then save the file.

ECC_BASE – The root directory where you extracted the .bsx files. This property is set to the value /u02 by default.

ECC_CONFIG_LOC – You can optionally set this property to the location of a custom ecc-config.properties file. Oracle Enterprise Command Center Framework will then use the properties file in this location instead of the standard ecc-config.properties file created in the $ECC_BASE/Oracle/quickInstall/env/ecc directory.

ECC_LOG_DIR – The directory where the Oracle Enterprise Command Center Framework administration application log files should be generated. For cluster setup, this directory must be shared between all nodes. All nodes must have full (read/write) access to this shared directory.

EBS_MIDDLETIER_HOST_FQDN – The fully qualified domain name (FQDN) for the Oracle E-Business Suite application tier. If the Oracle E-Business Suite instance uses a proxy or load balancer, use the FQDN for the web entry point instead.

EBS_MIDDLETIER_PORT – The Oracle E-Business Suite application tier port. If the Oracle E-Business Suite instance uses a proxy or load balancer, use the port for the web entry point instead. If you plan to enable TLS for communication between Oracle E-Business Suite and the Oracle Enterprise Command Center Framework installation, then you should use port 4443 here. See Enabling TLS for Oracle Enterprise Command Center Framework, Release 12.2, My Oracle Support Knowledge Document 2496445.1.

EBS_MIDDLETIER_PROTOCOL – The Oracle E-Business Suite application tier protocol, either http or https. If the Oracle E-Business Suite instance uses a proxy or load balancer, use the protocol for the web entry point instead. If you plan to enable TLS for communication between Oracle E-Business Suite and the Oracle Enterprise Command Center Framework installation, then you must set the protocol to https here.

EBS_MIDDLETIER_INTERNAL_HOSTS – The host name of the Oracle E-Business Suite instances. If there is more than one Oracle E-Business Suite instance behind a load balancer, specify all the Oracle E-Business Suite host names separated by a comma.

EBS_DB_URL – The URL for the Oracle E-Business Suite database.

EBS_DB_USERNAME – The user name for the Oracle E-Business Suite database user, usually apps.

ECC_HOST_PROTOCOL – The protocol for the Oracle Enterprise Command Center Framework installation , either http or https. If you plan to enable TLS for communication between Oracle E-Business Suite and the Oracle Enterprise Command Center Framework installation, then you must set the protocol to https here. See Enabling TLS for Oracle Enterprise Command Center Framework, Release 12.2, My Oracle Support Knowledge Document 2496445.1.

ECC_HOST_NAME – The fully qualified domain name for the Oracle Enterprise Command Center Framework installation.

EBS_ECC_USER – The Oracle E-Business Suite user name (FND user) with which Oracle Enterprise Command Center Framework connects to Oracle E-Business Suite using the JNDI configuration.

ECC_DB_URL – The connection URL for the Oracle Enterprise Command Center Framework database. It is recommended that you use the Oracle E-Business Suite database for Oracle Enterprise Command Center Framework as well.

After you modify the $ECC_BASE/Oracle/quickInstall/EccConfig.properties file, you must run the $ECC_BASE/Oracle/quickInstall/createEnvFile.sh script to update the environment file before proceeding. Use the following commands to run this script:

cd $ECC_BASE/Oracle/quickInstall

./createEnvFile.sh

Run the envSetup.sh script using the following command

./envSetup.sh

1.4 Set Up the Oracle Enterprise Command Center Framework Environment and Integrate with Oracle E-Business Suite

Run the $ECC_BASE/Oracle/quickInstall/envSetup.sh script. When prompted, select the option to run. Run the following options in the order shown:

Enter the database system password:

Enter the password for ECC DB user ECC (Passwords must be at least 8 characters long):

Confirm the password for user ECC :

Creating ECC…

ECC user created successfully

Creating ECC schema…

ECC schema created successfully

Launcher log file is /tmp/OraInstall2021-06-05_06-28-51AM/launcher2021-06-05_06-28-51AM.log.

Extracting the installer . . . . . . Done

Checking if CPU speed is above 300 MHz. Actual 1996.246 MHz Passed

Checking swap space: must be greater than 512 MB. Actual 8191 MB Passed

Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)

Checking temp space: must be greater than 300 MB. Actual 196411 MB Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2021-06-05_06-28-51AM

Log: /tmp/OraInstall2021-06-05_06-28-51AM/install2021-06-05_06-28-51AM.log

Reading response file..

Skipping Software Updates

Starting check : CertifiedVersions

Expected result: One of oracle-6, oracle-7, redhat-7, redhat-6, SuSE-11, SuSE-12, SuSE-15

Actual Result: oracle-7.6

Check complete. The overall result of this check is: Passed

CertifiedVersions Check: Success.

Starting check : CheckJDKVersion

Expected result: 1.8.0_191

Actual Result: 1.8.0_281

Check complete. The overall result of this check is: Passed

CheckJDKVersion Check: Success.

Validations are enabled for this session.

Verifying data

Copying Files

Percent Complete : 10

Percent Complete : 20

Percent Complete : 30

Percent Complete : 40

Percent Complete : 50

Percent Complete : 60

Percent Complete : 70

Percent Complete : 80

Percent Complete : 90

Percent Complete : 100

The installation of Oracle Fusion Middleware 12c WebLogic Server and Coherence 12.2.1.4.0 completed successfully.

Logs successfully copied to /u02/Oracle/software/oraInventory/logs.

Enter the password for ECC DB user ECC :

Enter the password for ECC admin user weblogic (Passwords must be at least 8 characters long):

Confirm the password for ECC admin user weblogic :

Creating ECC Domain …

Configuring the wallet

<< read template from “/u02/Oracle/software/weblogic/templates/ecc_domain_template.jar”

>> succeed: read template from “/u02/Oracle/software/weblogic/templates/ecc_domain_template.jar”

<< set config option JavaHome to “/u02/Oracle/software/java/jdk”

>> succeed: set config option JavaHome to “/u02/Oracle/software/java/jdk”

<< set config option ServerStartMode to “prod”

>> succeed: set config option ServerStartMode to “prod”

<< find Security “ecc_domain” as obj0

<< find Security “ecc_domain” as obj1

<< find Security “ecc_domain” as obj2

<< find Security!User “ecc_domain!weblogic” as obj3

>> succeed: find Security!User “ecc_domain!weblogic” as obj3

<< find User “weblogic” as obj4

>> succeed: find User “weblogic” as obj4

<< set obj4 attribute Password to “********”

>> succeed: set obj4 attribute Password to “********”

<< set obj4 attribute IsDefaultAdmin to “true”

>> succeed: set obj4 attribute IsDefaultAdmin to “true”

>> validateConfig “KeyStorePasswords”

>> succeed: validateConfig “KeyStorePasswords”

<< write Domain to “/u02/Oracle/Middleware/user_projects/domains/ecc_domain”

…………………………………………..

>> succeed: write Domain to “/u02/Oracle/Middleware/user_projects/domains/ecc_domain”

<< close template

>> succeed: close template

ECC Domain is created…

ECC Log directory is: /u02/Oracle/quickInstall/logs/ecc

Updating ECC Domain with the Config properties location /u02/Oracle/quickInstall/env/ecc/ecc-config.properties

ecc.log.path update in /u02/Oracle/quickInstall/env/ecc/ecc-config.properties successful

zkHost.url update in /ecc-config.properties successful

push.staging.dir update in /u02/Oracle/quickInstall/env/ecc/ecc-config.properties successful

ecc.languages update in /ecc-config.properties successful

ecc.base_language update in /ecc-config.properties successful

dataset.analyzer.default update in /ecc-config.properties successful

dataset.analyzer.override.solr.datasets update in /ecc-config.properties successful

dataset.analyzer.override.olt.datasets update in /ecc-config.properties successful

cluster.jpa.manager update in /ecc-config.properties successful

rmi.url update in /ecc-config.properties successful

Starting ECC high availability configuation script.

Configuring ECC in single mode.

zookeeper numbers 1

updating dataset.num.replicas=1

dataset.num.replicas update in /ecc-config.properties successful

eccConfigLocation jvm property configured for eccManaged Server

Configuring WLS servers ports …

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

PATH=/u02/Oracle/Middleware/wlserver/server/bin:/u02/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.10.5.0.0/apache-ant-1.10.5/bin:/u02/Oracle/software/java/jdk/jre/bin:/u02/Oracle/software/java/jdk/bin:/u02/Oracle/software/java/jdk/bin:/u02/insta_client:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/applmgr/.local/bin:/home/applmgr/bin:/u02/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Exiting WebLogic Scripting Tool.

WLS ports configured successfully for ECC

Configuring WLS servers SSL ports …

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Exiting WebLogic Scripting Tool.

WLS SSL ports configured successfully for ECC

Updating ECC Domain for Heap space…

Done updating ECC Domain for Heap space…

applyWLSPatch.sh:06/05/21 06:40:13 GMT:info : Taking backup of ORACLE_HOME /u02/Oracle/Middleware

applyWLSPatch.sh:06/05/21 06:40:16 GMT:info : Extracting opatch latest

Archive: /u02/Oracle/software/weblogic/opatch.zip

creating: /u02/Oracle/quickInstall/patch/6880880/

inflating: /u02/Oracle/quickInstall/patch/6880880/README.txt

inflating: /u02/Oracle/quickInstall/patch/6880880/opatch_generic.jar

Patching component oracle.wls.security.core, 12.2.1.4.0…

Patch 32253037 successfully applied.

Log file location: /u02/Oracle/Middleware/cfgtoollogs/opatch/opatch2021-06-05_06-41-30AM_1.log

OPatch succeeded.

applyWLSPatch.sh:06/05/21 06:42:34 GMT:info : Successfully applied WLS CPU Patch

applyWLSPatch.sh:06/05/21 06:42:34 GMT:info : Cleaning up the Middleware backup /u02/Oracle/Middleware-1622875213 taken as part of the WLS Patching

Copying the ojdbc8.jar to support 19c database

Starting ECC Domain Admin Server …

Started the ECC Admin Server successfully

Creating JNDI for ECC schema…

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connectiong to t3://localhost:7775 to create JNDI for url:jdbc:oracle:thin:@apps.example.com:1521:ebsdb

Connecting to t3://localhost:7775 with userid weblogic …

Successfully connected to Admin Server “AdminServer” that belongs to domain “ecc_domain”.

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

Location changed to edit tree.

This is a writable tree with DomainMBean as the root.

To make changes you will need to start an edit session via startEdit().

For more help, use help(‘edit’).

Starting an edit session …

Started edit session, be sure to save and activate your changes once you are done.

No stack trace available.

eccdb does not exist

Saving all your changes …

Saved all your changes successfully.

Activating all your changes, this may take a while …

The edit lock associated with this edit session is released once the activation is completed.

Activation completed

eccdb created Successfully

Disconnected from weblogic server: AdminServer

JNDI setup successfully for ECC data source

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 4: l_conn_name VARCHAR2(30) := ‘&&4’;

new 4: l_conn_name VARCHAR2(30) := ‘ebsdb’;

Enter value for 5: old 5: l_conn_string VARCHAR2(300) :=’&&5′;

new 5: l_conn_string VARCHAR2(300) :=’apps.example.com:1521/ebsdb’;

Starting creating connections with parameters : connection Name :ebsdb

Connection String : apps.example.com:1521/ebsdb

port pos = 16

sid pos = 21

port pos = 16

sid pos = 21

l_hostname = apps.example.com

l_port = 1521

l_service_name = ebsdb

l_conn_name = ebsdb

created connection with parameters : connection Name :ebsdb Connection String :

apps.example.com:1521/ebsdb

PL/SQL procedure successfully completed.

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

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 4: l_conn_name VARCHAR2(30) := ‘&&4’;

new 4: l_conn_name VARCHAR2(30) := ‘eccdb’;

Enter value for 5: old 5: l_conn_string VARCHAR2(300) :=’&&5′;

new 5: l_conn_string VARCHAR2(300) :=’jdbc:oracle:thin:@apps.example.com:1521:ebsdb’;

Starting creating connections with parameters : connection Name :eccdb

Connection String : jdbc:oracle:thin:@apps.example.com:1521:ebsdb

port pos = 4

sid pos = -1

port pos = 4

sid pos = -1

l_hostname = jdbc

l_port =

l_service_name = jdbc:oracle:thin:@apps.example.com:1521:ebsdb

l_conn_name = eccdb

created connection with parameters : connection Name :eccdb Connection String :

jdbc:oracle:thin:@apps.example.com:1521:ebsdb

PL/SQL procedure successfully completed.

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

SQL*Plus: Release 12.2.0.1.0 Production in Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 8: l_conn_name VARCHAR2(30) := ‘&&4’;

new 8: l_conn_name VARCHAR2(30) := ‘ebsdb’;

Enter value for 5: old 9: l_system_name VARCHAR2(100) := ‘&&5’;

new 9: l_system_name VARCHAR2(100) := ‘EBS’;

Enter value for 6: old 10: l_conn_string VARCHAR2(300) :=’&&6′;

new 10: l_conn_string VARCHAR2(300) :=’http://apps.example.com:7776′;

Creating Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

Creating Source System with System Name = EBS already exists . Deleting and

creating again

Creating Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

protcol = http:

protcol = http

protoppos = 8

port_pos = 24

l_hostname =apps.example.com

l_port =7776

Created Source System with Parameters :

Created Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

PL/SQL procedure successfully completed.

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

Configured the ECC domain successfully.ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Starting zookeeper … STARTED

Zookeeper started. Starting Managed Server

Starting the eccManaged …

Started the eccManaged successfully

ECC WEB ENTRY URL:http://apps.example.com:7776/ecc ECC Application File:/u02/Oracle/quickInstall/applications/activity_audit_ecc.zip Importing file /u02/Oracle/quickInstall/applications/activity_audit_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210605064438.log”}]

Configured the ECC domain successfully.

Proceed with Integration? confirm(y) otherwise(n):

Enter the password for ECC DB user ECC :

Enter the password for ECC admin user weblogic :

Updating EBS Security Manager

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 07:18:33 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER=’&4′ where SYSTEM_NAME=’EBS’

new 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER=’oracle.ecc.security.extensions.EbsEccSecurityManager’ where SYSTEM_NAME=’EBS’

1 row updated.

Commit complete.

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

Done

Restarting the ECC managed server

Stopping ECC Managed Server …

Stopping Weblogic Server…

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connecting to t3://localhost:7775 with userid weblogic …

Successfully connected to Admin Server “AdminServer” that belongs to domain “ecc_domain”.

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

Shutting down the server eccManaged with force=false while connected to AdminServer …

……

Exiting WebLogic Scripting Tool.

Done

Stopping Derby Server…

Derby server stopped.

ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Stopping zookeeper … STOPPED

ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Starting zookeeper … STARTED

Zookeeper started. Starting Managed Server

Starting the eccManaged …

Enter the password for ECC DB user ECC :

Enter the password for ECC admin user weblogic (Passwords must be at least 8 characters long):

Confirm the password for ECC admin user weblogic :

Creating ECC Domain …

Configuring the wallet

<< read template from “/u02/Oracle/software/weblogic/templates/ecc_domain_template.jar”

>> succeed: read template from “/u02/Oracle/software/weblogic/templates/ecc_domain_template.jar”

<< set config option JavaHome to “/u02/Oracle/software/java/jdk”

>> succeed: set config option JavaHome to “/u02/Oracle/software/java/jdk”

<< set config option ServerStartMode to “prod”

>> succeed: set config option ServerStartMode to “prod”

<< find Security “ecc_domain” as obj0

<< find Security “ecc_domain” as obj1

<< find Security “ecc_domain” as obj2

<< find Security!User “ecc_domain!weblogic” as obj3

>> succeed: find Security!User “ecc_domain!weblogic” as obj3

<< find User “weblogic” as obj4

>> succeed: find User “weblogic” as obj4

<< set obj4 attribute Password to “********”

>> succeed: set obj4 attribute Password to “********”

<< set obj4 attribute IsDefaultAdmin to “true”

>> succeed: set obj4 attribute IsDefaultAdmin to “true”

>> validateConfig “KeyStorePasswords”

>> succeed: validateConfig “KeyStorePasswords”

<< write Domain to “/u02/Oracle/Middleware/user_projects/domains/ecc_domain”

…………………………………………..

>> succeed: write Domain to “/u02/Oracle/Middleware/user_projects/domains/ecc_domain”

<< close template

>> succeed: close template

ECC Domain is created…

ECC Log directory is: /u02/Oracle/quickInstall/logs/ecc

Updating ECC Domain with the Config properties location /u02/Oracle/quickInstall/env/ecc/ecc-config.properties

ecc.log.path update in /u02/Oracle/quickInstall/env/ecc/ecc-config.properties successful

zkHost.url update in /ecc-config.properties successful

push.staging.dir update in /u02/Oracle/quickInstall/env/ecc/ecc-config.properties successful

ecc.languages update in /ecc-config.properties successful

ecc.base_language update in /ecc-config.properties successful

dataset.analyzer.default update in /ecc-config.properties successful

dataset.analyzer.override.solr.datasets update in /ecc-config.properties successful

dataset.analyzer.override.olt.datasets update in /ecc-config.properties successful

cluster.jpa.manager update in /ecc-config.properties successful

rmi.url update in /ecc-config.properties successful

Starting ECC high availability configuation script.

Configuring ECC in single mode.

zookeeper numbers 1

updating dataset.num.replicas=1

dataset.num.replicas update in /ecc-config.properties successful

eccConfigLocation jvm property configured for eccManaged Server

Configuring WLS servers ports …

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Exiting WebLogic Scripting Tool.

WLS ports configured successfully for ECC

Configuring WLS servers SSL ports …

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Exiting WebLogic Scripting Tool.

WLS SSL ports configured successfully for ECC

Updating ECC Domain for Heap space…

Done updating ECC Domain for Heap space…

applyWLSPatch.sh:06/05/21 06:40:13 GMT:info : Taking backup of ORACLE_HOME /u02/Oracle/Middleware

applyWLSPatch.sh:06/05/21 06:40:16 GMT:info : Extracting opatch latest

Archive: /u02/Oracle/software/weblogic/opatch.zip

creating: /u02/Oracle/quickInstall/patch/6880880/

inflating: /u02/Oracle/quickInstall/patch/6880880/README.txt

inflating: /u02/Oracle/quickInstall/patch/6880880/opatch_generic.jar

Patching component oracle.wls.security.core, 12.2.1.4.0…

Patch 32253037 successfully applied.

Log file location: /u02/Oracle/Middleware/cfgtoollogs/opatch/opatch2021-06-05_06-41-30AM_1.log

OPatch succeeded.

applyWLSPatch.sh:06/05/21 06:42:34 GMT:info : Successfully applied WLS CPU Patch

applyWLSPatch.sh:06/05/21 06:42:34 GMT:info : Cleaning up the Middleware backup /u02/Oracle/Middleware-1622875213 taken as part of the WLS Patching

Copying the ojdbc8.jar to support 19c database

Starting ECC Domain Admin Server …

Started the ECC Admin Server successfully

Creating JNDI for ECC schema…

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connectiong to t3://localhost:7775 to create JNDI for url:jdbc:oracle:thin:@apps.example.com:1521:ebsdb

Connecting to t3://localhost:7775 with userid weblogic …

Successfully connected to Admin Server “AdminServer” that belongs to domain “ecc_domain”.

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

Location changed to edit tree.

This is a writable tree with DomainMBean as the root.

To make changes you will need to start an edit session via startEdit().

For more help, use help(‘edit’).

Starting an edit session …

Started edit session, be sure to save and activate your changes once you are done.

No stack trace available.

eccdb does not exist

Saving all your changes …

Saved all your changes successfully.

Activating all your changes, this may take a while …

The edit lock associated with this edit session is released once the activation is completed.

Activation completed

eccdb created Successfully

Disconnected from weblogic server: AdminServer

JNDI setup successfully for ECC data source

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 4: l_conn_name VARCHAR2(30) := ‘&&4’;

new 4: l_conn_name VARCHAR2(30) := ‘ebsdb’;

Enter value for 5: old 5: l_conn_string VARCHAR2(300) :=’&&5′;

new 5: l_conn_string VARCHAR2(300) :=’apps.example.com:1521/ebsdb’;

Starting creating connections with parameters : connection Name :ebsdb

Connection String : apps.example.com:1521/ebsdb

port pos = 16

sid pos = 21

port pos = 16

sid pos = 21

l_hostname = apps.example.com

l_port = 1521

l_service_name = ebsdb

l_conn_name = ebsdb

created connection with parameters : connection Name :ebsdb Connection String :

apps.example.com:1521/ebsdb

PL/SQL procedure successfully completed.

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

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 4: l_conn_name VARCHAR2(30) := ‘&&4’;

new 4: l_conn_name VARCHAR2(30) := ‘eccdb’;

Enter value for 5: old 5: l_conn_string VARCHAR2(300) :=’&&5′;

new 5: l_conn_string VARCHAR2(300) :=’jdbc:oracle:thin:@apps.example.com:1521:ebsdb’;

Starting creating connections with parameters : connection Name :eccdb

Connection String : jdbc:oracle:thin:@apps.example.com:1521:ebsdb

port pos = 4

sid pos = -1

port pos = 4

sid pos = -1

l_hostname = jdbc

l_port =

l_service_name = jdbc:oracle:thin:@apps.example.com:1521:ebsdb

l_conn_name = eccdb

created connection with parameters : connection Name :eccdb Connection String :

jdbc:oracle:thin:@apps.example.com:1521:ebsdb

PL/SQL procedure successfully completed.

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

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 06:43:29 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 8: l_conn_name VARCHAR2(30) := ‘&&4’;

new 8: l_conn_name VARCHAR2(30) := ‘ebsdb’;

Enter value for 5: old 9: l_system_name VARCHAR2(100) := ‘&&5’;

new 9: l_system_name VARCHAR2(100) := ‘EBS’;

Enter value for 6: old 10: l_conn_string VARCHAR2(300) :=’&&6′;

new 10: l_conn_string VARCHAR2(300) :=’http://apps.example.com:7776′;

Creating Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

Creating Source System with System Name = EBS already exists . Deleting and

creating again

Creating Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

protcol = http:

protcol = http

protoppos = 8

port_pos = 24

l_hostname =apps.example.com

l_port =7776

Created Source System with Parameters :

Created Source System with Parameters : Connection String =

http://apps.example.com:7776 Connection Name = ebsdb System Name = EBS

PL/SQL procedure successfully completed.

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

Configured the ECC domain successfully.ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Starting zookeeper … STARTED

Zookeeper started. Starting Managed Server

Starting the eccManaged …

Started the eccManaged successfully

Configured the ECC domain successfully.

Creating JNDI ….

Enter the ECC Domain weblogic password:

Enter the EBS Schema apps password:

Checking connection.dbc file availability…

DBC file /u02/Oracle/quickInstall/connection.dbc available

Verify if the Node is registered in the EBS database…

Node name APPS.EXAMPLE.COM

EBS_ECC_USER ECC_USER

DB URL apps.example.com:1521/ebsdb

Node is registerd in EBS

ECC node APPS.EXAMPLE.COM mode is correct

Check if the FND USER ECC_USER exists

User ECC_USER already exists in FND_USER. Validating user

Enter password:

User ECC_USER successfully validated

Creating JNDI for ECC to access EBS DB…

CLASSPATH=/u02/Oracle/software/java/jdk/lib/tools.jar:/u02/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar:

Your environment has been set.

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connecting to t3://localhost:7775 with userid weblogic …

Successfully connected to Admin Server “AdminServer” that belongs to domain “ecc_domain”.

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

Location changed to edit tree.

This is a writable tree with DomainMBean as the root.

To make changes you will need to start an edit session via startEdit().

For more help, use help(‘edit’).

Starting an edit session …

Started edit session, be sure to save and activate your changes once you are done.

No stack trace available.

ebsDB does not exist

Saving all your changes …

Saved all your changes successfully.

Activating all your changes, this may take a while …

The edit lock associated with this edit session is released once the activation is completed.

Activation completed

Disconnected from weblogic server: AdminServer

JNDI created for EBS database…

Proceed with Integration? confirm(y) otherwise(n):

Enter the password for ECC DB user ECC :

Enter the password for ECC admin user weblogic :

Updating EBS Security Manager

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 07:18:33 2021

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Enter value for 4: old 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER=’&4′ where SYSTEM_NAME=’EBS’

new 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER=’oracle.ecc.security.extensions.EbsEccSecurityManager’ where SYSTEM_NAME=’EBS’

1 row updated.

Commit complete.

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

Done

Restarting the ECC managed server

Stopping ECC Managed Server …

Stopping Weblogic Server…

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connecting to t3://localhost:7775 with userid weblogic …

Successfully connected to Admin Server “AdminServer” that belongs to domain “ecc_domain”.

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

Shutting down the server eccManaged with force=false while connected to AdminServer …

……

Exiting WebLogic Scripting Tool.

Done

Stopping Derby Server…

Derby server stopped.

ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Stopping zookeeper … STOPPED

ZooKeeper JMX enabled by default

Using config: /u02/Oracle/software/zookeeper/bin/../conf/zoo.cfg

Starting zookeeper … STARTED

Zookeeper started. Starting Managed Server

Starting the eccManaged …

1.5 Import Enterprise Command Center Applications

To import the Enterprise Command Center applications, perform the following steps:

For each additional language you want to deploy, ensure that you have applied the translated patches corresponding to each patch you applied as described in Section 4.2: Apply Patches to the Oracle E-Business Suite Instance. Ensure that no other zip files exist in each product’s <prod>/patch/115/ecc/resources directory.

On the Oracle Enterprise Command Center Framework tier, navigate to the $ECC_BASE/Oracle/quickInstall/scripts directory and locate the $ECC_BASE/Oracle/quickInstall/scripts/patchEccFiles.pl script. Copy the script to the Oracle E-Business Suite instance.

Log on to the Oracle E-Business Suite server. On that server, source the environment file of your run file system.

cd <EBS_BASE_HOME>

source EBSapps.env run

Then, on the Oracle E-Business Suite server, run the patchEccFiles.pl script.

./patchEccFiles.pl

[oracle@apps staging]$ perl patchEccFiles.pl

Name “main::running_under_some_shell” used only once: possible typo at patchEccFiles.pl line 5.

Enter temporary directory for ECC Files(Should be used only for this task and be empty): /tmp/staging/temp

Enter EBS DB apps user password:

List of languages installed in EBS:

————————————————–

| Language | ECC Language Code|

————————————————–

| AMERICAN | en |

—————————————————

List of languages supported in ECC:

Arabic(ar), Brazilian Portugese(pt), Canadian French(fr-CA),Croatian(hr), Cyrillic Kazakh(kk), Cyrillic Serbian(sr), Czech(cs), Danish(da), Dutch(nl), English(en), Finnish(fi), French(fr), German(de), Greek(el), Hebrew(he), Hungarian(hu), Icelandic(is), Indonesian(id), Italian(it), Japanese(ja), Korean(ko), Latin Spanish(es-419),Latin Serbian(sr-Latn), Lithuanian(lt), Norwegian(no), Polish(pl), Portugese(pt-PT),Romania(ro), Russian(ru), Simplified Chinese(zh-Hans), Slovak(sk), Slovenian(sl), Spanish(es), Swedish(sv), Thai(th), Traditional Chinese(zh-Hant), Turkish(tr), Ukranian(uk), Vietnamese(vi)

NOTE: Only languages installed and enabled in ECC will be processed successfully

Example: Enter ar,pt for Arabic and Brazilian Portugese language respectively. Enter all(ALL) for all languages

Enter the Language code(s) from the list mentioned above to run the translation for: en

Do you want to add all products at once(Y) or specify the subset(N): N

Enter the product(s) from the list(AP,AR,BOM,CN,CS,CSD,CSE,CSF,EAM,EGO,ENG,FA,GMD,GMO,IBE,ICX,INL,INV,JMF,OKL,OKS,ONT,OZF,PA,PER,PJM,PN,PO,PON,QA,QP,WIP) to run the import for: AP,AR,WIP

Adding product top AP

Adding product top AR

Adding product top WIP

Importing application file name ap_ecc.zip

Importing application /tmp/staging/temp/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip

ECC WEB ENTRY URL:http://apps.example.com:8000/ecc

ECC Application File:/tmp/staging/temp/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip

Importing file /tmp/staging/temp/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210606145214.log”}]

Imported application /tmp/staging/temp/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip successfully

Importing application file name ar_ecc.zip

Importing application /tmp/staging/temp/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip

ECC WEB ENTRY URL:http://apps.example.com:8000/ecc

ECC Application File:/tmp/staging/temp/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip

Importing file /tmp/staging/temp/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210606145216.log”}]

Imported application /tmp/staging/temp/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip successfully

Importing application file name wip_com_ecc.zip

Importing application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_comp_ecc.zip

ECC WEB ENTRY URL:http://apps.example.com:8000/ecc

ECC Application File:/tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_comp_ecc.zip

Importing file /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_comp_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210606145218.log”}]

Imported application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_comp_ecc.zip successfully

Importing application file name wip_ecc.zip

Importing application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip

ECC WEB ENTRY URL:http://apps.example.com:8000/ecc

ECC Application File:/tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip

Importing file /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210606145219.log”}]

Imported application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip successfully

Importing application file name wip_gnt_ecc.zip

Importing application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip

ECC WEB ENTRY URL:http://apps.example.com:8000/ecc

ECC Application File:/tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip

Importing file /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20210606145221.log”}]

Imported application /tmp/staging/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip successfully

SUMMARY REPORT:

———————————————–

| Product | Application | Status |

———————————————–

| AP | ap_ecc.zip | Success |

| AR | ar_ecc.zip | Success |

| WIP | wip_comp_ecc.zip| Success |

| WIP | wip_ecc.zip | Success |

| WIP | wip_gnt_ecc.zip| Success |

———————————————–

[oracle@apps staging]$

SUMMARY REPORT:

———————————————–

| Product | Application | Status |

———————————————–

| BOM | cst_ecc.zip | Success |

| FA | fa_ecc.zip | Success |

| INV | inv_ecc.zip | Success |

| INV | pim_ecc.zip | Success |

———————————————–

[oracle@apps staging]$

Gokul kumar