How to run Autoconfig in Database Tier and Application Tier in Oracle EBS R12.2 ?

  

1. Database autoconfig:

 

1.  To source the environment file from the $ORACLE_HOME

 

oracle@visebsdb 12.1.0]$ . VIS_visebsdb.env 

 

2. To connect the SQLPLUS

 

[oracle@visebsdb 12.1.0]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 16 23:08:28 2021

 

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

 

Connected to an idle instance.

 

3.To Startup the Database

 

SQL> startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area 2147483648 bytes

Fixed Size     2926472 bytes

Variable Size 1006635128 bytes

Database Buffers 1124073472 bytes

Redo Buffers    13848576 bytes

Database mounted.

Database opened.

 

4. To check the database status

 

SQL> select name,open_mode from v$database;

 

NAME   OPEN_MODE

——— ——————–

VIS   READ WRITE

 

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

 

5. To startup the listener

 

[oracle@visebsdb 12.1.0]$ lsnrctl start VIS

 

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 16-JUL-2021 23:09:25

 

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

 

Starting /visdb/oracle/12.1.0/bin/tnslsnr: please wait…

 

TNSLSNR for Linux: Version 12.1.0.2.0 – Production

System parameter file is /visdb/oracle/12.1.0/network/admin/VIS_visebsdb/listener.ora

Log messages written to /visdb/oracle/12.1.0/admin/VIS_visebsdb/diag/tnslsnr/visebsdb/vis/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=visebsdb.xyz.com)(PORT=1526)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=visebsdb.xyz.com)(PORT=1526)))

STATUS of the LISTENER

————————

Alias                     VIS

Version                   TNSLSNR for Linux: Version 12.1.0.2.0 – Production

Start Date                16-JUL-2021 23:09:25

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /visdb/oracle/12.1.0/network/admin/VIS_visebsdb/listener.ora

Listener Log File         /visdb/oracle/12.1.0/admin/VIS_visebsdb/diag/tnslsnr/visebsdb/vis/alert/log.xml

Listening Endpoints Summary…

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=visebsdb.xyz.com)(PORT=1526)))

Services Summary…

Service “VIS” has 1 instance(s).

  Instance “VIS”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

 

6. To check the instance status

 

[oracle@visebsdb 12.1.0]$ ps -ef | grep tns

root        23     2  0 21:44 ?        00:00:00 [netns]

oracle   14189     1  0 23:09 ?        00:00:00 /visdb/oracle/12.1.0/bin/tnslsnr VIS -inherit

oracle   14212  7392  0 23:09 pts/3    00:00:00 grep –color=auto tns

[oracle@visebsdb 12.1.0]$ ls

addnode                  demo              nls                                         relnotes

admin                    VIS_visebsdb.env  oc4j                                        rest

apex                     diagnostics       odbc                                        root.sh

appsutil                 dmu               olap                                        scheduler

appsutilbkp              dv                OPatch                                      slax

appsutilbkp.zip          has               OPatch25bkp                                 sqlviseloper

appsutil.zip             hs                opmn                                        sqlj

appsutil.zip_bkp23mar21  install           oracore                                     sqlpatch

assistants               instantclient     oraInst.loc                                 sqlplus

bin                      inventory         ord                                         srvm

ccr                      javavm            oui                                         suptools

cdata                    jdbc              owm                                         sysman

cfgtoollogs              jdk               p32126886_121020_Linux-x86-64.zip.filepart  temp

clone                    jlib              perl                                        ucp

crs                      jpub              plsql                                       usm

css                      ldap              plugins                                     utl

ctx                      lib               precomp                                     wwg

cv                       log               QOpatch                                     xdk

dbs                      md                R

dc_ocm                   mgw               racg

deinstall                network           rdbms

[oracle@visebsdb 12.1.0]$ cd appsutil

[oracle@visebsdb appsutil]$ ls

admin  conf_VIS.txt           driver  install  log    outbound  sql       txkSetCfgCDB.cmd

bin    VIS_visebsdb.xml       etcc    java     media  perl      temp      txkSetCfgCDB.env

clone  VIS_visebsdb.xmlBKP16  html    jre      out    scripts   template

[oracle@visebsdb appsutil]$ cd scripts/

[oracle@visebsdb scripts]$ ls

VIS_visebsdb

[oracle@visebsdb scripts]$ cd VIS_visebsdb/

[oracle@visebsdb VIS_visebsdb]$ ls

adautocfg.sh  addbctl.sh   adexecsql.pl  adpreclone.pl  adstrtdb.sql

adchknls.pl   addlnctl.sh  adlsnodes.sh  adstopdb.sql

 

7. To run the Autoconfig 

[oracle@visebsdb VIS_visebsdb]$ ./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /visdb/oracle/12.1.0/appsutil/log/VIS_visebsdb/07162309/adconfig.log

 

AutoConfig is configuring the Database environment…

 

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /visdb/oracle/12.1.0

 

Value of s_dbcset is AL32UTF8

 

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

 

Library orai18n.jar exists.

 

Value of s_dbcset is AL32UTF8

 

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

 

Library orai18n.jar exists.

Classpath                   : :/visdb/oracle/12.1.0/jdbc/lib/ojdbc6.jar:/visdb/oracle/12.1.0/appsutil/java/xmlparserv2.jar:/visdb/oracle/12.1.0/appsutil/java:/visdb/oracle/12.1.0/jlib/netcfg.jar:/visdb/oracle/12.1.0/jlib/ldapjclnt12.jar:/visdb/oracle/12.1.0/jlib/orai18n.jar

 

Using Context file          : /visdb/oracle/12.1.0/appsutil/VIS_visebsdb.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.

[oracle@visebsdb VIS_visebsdb]$ 

 

 

 

2) Application autoconfig:

 

1, To check tha Application Instance

 

[applmgr@visebsapp ~]$ ps -ef | grep tns

root        23     2  0 Jul16 ?        00:00:00 [netns]

applmgr  31637 31577  0 11:19 pts/0    00:00:00 grep –color=auto tns

[applmgr@visebsapp ~]$

 

Note: if run auto config run, we can run in application down only 

 

2. To source the environment file in Application

 

[applmgr@visebsapp applmgr]$ . EBSapps.env

 

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /visapps/applmgr/fs2/EBSapps/appl

  PATCH File System         : /visapps/applmgr/fs1/EBSapps/appl

  Non-Editioned File System : /visapps/applmgr/fs_ne

 

 

  DB Host: devebsdb.bescom.com  Service/SID: DEV

 

 

  E-Business Suite Environment Setting

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

  – Enter [R/r] for sourcing Run File System Environment file, or

  – Enter [P/p] for sourcing Patch File System Environment file, or

  – Enter anything else to exit

 

  Please choose the environment file you wish to source [R/P]:R

 

  Sourcing the RUN File System …

 

3.To change directory in $ADMIN_SCRIPTS_HOME

 

[applmgr@visebsapp applmgr]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@visebsapp scripts]$ ls

03292126.log      adautocfg.sh        adnodemgrctl.sh  cz64bitengine.pl    jtffmctl.sh        shtiloglib.pl

05052013.log      adcmctl.sh          adopmnctl.sh     EBSProvisioner.log  msc

adadminsrvctl.sh  adexecsql.pl        adpreclone.pl    gsmstart.sh         mwactl.sh

adalnctl.sh       adformsrvctl.sh     adstpall.sh      ieo                 mwactlwrpr.sh

adapcctl.sh       admanagedsrvctl.sh  adstrtal.sh      java.sh             pon64bitengine.pl

 

4. To Execute the Autoconfiq:

 

applmgr@visebsapp scripts]$ ./adautocfg.sh

Enter the APPS user password:

 

The log file for this session is located at: /visapps/applmgr/fs2/inst/apps/VIS_visebsapp/admin/log/07162314/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     : /visapps/applmgr/fs2/inst/apps/VIS_visebsapp

Classpath                   : /visapps/applmgr/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/visapps/applmgr/fs2/EBSapps/comn/java/classes

 

Using Context file          : /visapps/applmgr/fs2/inst/apps/VIS_visebsapp/appl/admin/VIS_visebsapp.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@visebsapp scripts]$ 

Leave a Comment

Your email address will not be published. Required fields are marked *