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