Source Assumption:
DB version : 11.1.0.7.0
EBS: 12.1.3
3.1 Stop all Application services and put the application in maintenance mode.
3.2 Below application patches need to applied
Patch 8796558
Patch 12923944
Patch 13473483
Patch 16289505 - 12c Release 1 interoperability patch for Release 12.1
Patch 18843706 - apply only if you have applied a Recommended Patch Collection (RPC) patch
Patch 19558309
We will use adpatch utility to apply all the mentioned patches.
[applmgr@fbsebs lib]$ cd /u01/patches/apps/8796558/
[applmgr@fbsebs 8796558]$ adpatch apply=yes driver=u8796558.drv[applmgr@fbsebs lib]$ cd /u01/patches/apps/12923944/[applmgr@fbsebs 12923944]$ adpatch apply=yes driver=u12923944.drv[applmgr@fbsebs lib]$ cd /u01/patches/apps/13473483/[applmgr@fbsebs 13473483]$ adpatch apply=yes driver=u13473483.drv[applmgr@fbsebs lib]$ cd /u01/patches/apps/16289505/[applmgr@fbsebs 16289505]$ adpatch apply=yes driver=u16289505.drv[applmgr@fbsebs lib]$ cd /u01/patches/apps/18843706/
[applmgr@fbsebs 18843706]$ adpatch apply=yes driver=u18843706.drv[applmgr@fbsebs lib]$ cd /u01/patches/apps/19558309/
[applmgr@fbsebs 19558309]$ adpatch apply=yes driver=u19558309.drv3.3 Install 12.1.0.2 binary in silent mode
Create a directory for 12c db oracle home
[oracle@fbstest tech_st 07:01 PM]$pwd/u01/app/FBS/db/tech_st[oracle@fbstest tech_st 07:01 PM]$ls -ltrtotal 4drwxr-xr-x. 77 oracle oinstall 4096 Dec 1 18:00 11.1.0[oracle@fbstest tech_st 07:01 PM]$mkdir 12.1.0 [oracle@fbstest db 07:06 PM]$ls -ltr linuxamd64*-rwxrwx---. 1 root vboxsf 1014530602 Mar 14 2018 linuxamd64_12102_database_2of2.zip-rwxrwx---. 1 root vboxsf 1673544724 Mar 14 2018 linuxamd64_12102_database_1of2.zip [oracle@fbstes database 07:32 PM]$./runInstallerStarting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 5398 MB PassedChecking swap space: must be greater than 150 MB. Actual 15992 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2020-12-03_07-32-41PM. Please wait ...[oracle@fbstes database 07:32 PM]$You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2020-12-03_07-32-41PM.logUncheck to disable receiving security updates and click on next. You will get a warning, just click OK to proceed
Select installation option as Install Database Software Only. Select database installation option as Single Instance database installation
Specify the Oracle installation location which is also known as ORACLE_HOME
Go with default groups and just click on Next and change all groups to dba
Install will perform pre-requisites check. If everything is good, then you should be presented with installation summary
Once the installation is done, you will be prompted to run root scripts. Copy those scripts and run as root user on the same OEL machine.
[root@fbstest ~ 07:41 PM]$/u01/app/FBS/db/tech_st/12.1.0/root.shCheck /u01/app/FBS/db/tech_st/12.1.0/install/root_fbstest.co.ke_2020-12-03_19-41-52.log for the output of root script[root@fbstest ~ 07:41 PM]$cat /u01/app/FBS/db/tech_st/12.1.0/install/root_fbstest.co.ke_2020-12-03_19-41-52.logPerforming root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/FBS/db/tech_st/12.1.0 Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed. 
3.4 Create 12c environment file
Copy 11g db environment to 12c home
cp /u01/app/FBS/db/tech_st/11.1.0/FBS_fbsebs.env /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env
change paths (11.1.0 to 12.1.0) and perl patch from 5.14.1 to 5.14.1
3.5 Source 12c DB env
. /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env
and run
perl $ORACLE_HOME/nls/data/old/cr9idata.pl
[oracle@fbsebs db]$ . /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env
[oracle@fbsebs db]$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl
Creating directory /u01/app/FBS/db/tech_st/12.1.0/nls/data/9idata ...
Copying files to /u01/app/FBS/db/tech_st/12.1.0/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/FBS/db/tech_st/12.1.0/nls/data/9idata!
3.6 Apply below DB patches on 12c Oracle Home using opatch.
Patch 6880880- the latest OPatch version for 12.1.0.
Patch 19382851
Patch 19393542
Patch 19591608
Patch 19627012
Patch 19649152
Patch 20204035
Patch 22660003
Patch 22731026
Patch 23645516
export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@fbsebs db]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@fbsebs db]$ cd 19382851/
[oracle@fbsebs 19382851]$ opatch apply
[oracle@fbsebs 19382851]$ cd ../19393542/
[oracle@fbsebs 19393542]$ opatch apply
[oracle@fbsebs 19393542]$ cd ../19591608/
[oracle@fbsebs 19591608]$ opatch apply
[oracle@fbsebs 19591608]$ cd ../19627012/
[oracle@fbsebs 19627012]$ opatch apply
[oracle@fbsebs 19627012]$ cd ../19649152/
[oracle@fbsebs 19649152]$ opatch apply
[oracle@fbsebs 19649152]$ cd ../20204035/
[oracle@fbsebs 20204035]$ opatch apply
[oracle@fbsebs 20204035]$ cd ../22660003/
[oracle@fbsebs 22660003]$ opatch apply
[oracle@fbsebs 22660003]$ cd ../22731026/
[oracle@fbsebs 22731026]$ opatch apply
[oracle@fbsebs 22731026]$ cd ../23645516/
[oracle@fbsebs 23645516]$ opatch apply
Verify all patches are applied using
opatch lsinventory
3.7 Make sure application and database listener services are down.
3.8 Source 11g home and connect to sqlplus
Drop SYS.ENABLED$INDEXES (conditional)
SQL> drop table sys.enabled$indexes;
Remove the MGDSYS schema (conditional)
[oracle@fbsebs 11.1.0]$ sqlplus "/ as sysdba" @?/md/admin/catnomgdidcode.sql
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
3.9 Copy the Pre-Upgrade Information Tool script preupgrd.sql and utluppkg.sql from the Oracle Database 12c Release 1 (12.1.0) to home
cd <12c_ORACLE_HOME>/rdbms/admin
cp preupgrd.sql utluppkg.sql $HOME
execute utluppkg.sql and preupgrd.sql
SQL> @utluppkg.sql
Package created.
Package body created.
SQL> @preupgrd.sql
Loading Pre-Upgrade Package...
***************************************************************************
Executing Pre-Upgrade Checks in FBS...
***************************************************************************
************************************************************
====>> ERRORS FOUND for FBS <<====
The following are *** ERROR LEVEL CONDITIONS *** that must be addressed
prior to attempting your upgrade.
Failure to do so will result in a failed upgrade.
1) Check Tag: INVALID_SYS_TABLEDATA
Check Summary: Check for invalid (not converted) table data
Fixup Summary:
"UPGRADE Oracle supplied table data prior to the database upgrade."
+++ Source Database Manual Action Required +++
2) Check Tag: PURGE_RECYCLEBIN
Check Summary: Check that recycle bin is empty prior to upgrade
Fixup Summary:
"The recycle bin will be purged."
You MUST resolve the above errors prior to upgrade
************************************************************
************************************************************
====>> PRE-UPGRADE RESULTS for FBS <<====
ACTIONS REQUIRED:
1. Review results of the pre-upgrade checks:
/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/preupgrade.log
2. Execute in the SOURCE environment BEFORE upgrade:
/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/preupgrade_fixups.sql
3. Execute in the NEW environment AFTER upgrade:
/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/postupgrade_fixups.sql
************************************************************
***************************************************************************
Pre-Upgrade Checks in FBS Completed.
***************************************************************************
***************************************************************************
***************************************************************************
3.10 Run-Preupgrade fixup
SQL> @/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/preupgrade_fixups.sql
Pre-Upgrade Fixup Script Generated on 2020-12-03 21:16:56 Version: 12.1.0.2 Build: 006
Beginning Pre-Upgrade Fixups...
Executing in container FBS
**********************************************************************
Check Tag: DEFAULT_PROCESS_COUNT
Check Summary: Verify min process count is not too low
Fix Summary: Review and increase if needed, your PROCESSES value.
**********************************************************************
Fixup Returned Information:
WARNING: --> Process Count may be too low
Database has a maximum process count of 200 which is lower than the
default value of 300 for this release.
You should update your processes value prior to the upgrade
to a value of at least 300.
For example:
ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE
or update your init.ora file.
**********************************************************************
**********************************************************************
Check Tag: OCM_USER_PRESENT
Check Summary: Check for OCM schema
Fix Summary: Drop the ORACLE_OCM user.
**********************************************************************
Fixup Succeeded
**********************************************************************
**********************************************************************
Check Tag: INVALID_SYS_TABLEDATA
Check Summary: Check for invalid (not converted) table data
Fix Summary: UPGRADE Oracle supplied table data prior to the database upgrade.
**********************************************************************
Fixup Succeeded
**********************************************************************
**********************************************************************
Check Tag: REMOVE_DMSYS
Check Summary: Check for existance of DMSYS schema
Fix Summary: The DMSYS schema is removed as part of the upgrade.
**********************************************************************
Fixup Returned Information:
WARNING: --> "DMSYS" schema exists in the database
The DMSYS schema (Oracle Data Mining) will be removed
from the database during the database upgrade.
All data in DMSYS will be preserved under the SYS schema.
Refer to the Oracle Data Mining User's Guide for details.
**********************************************************************
**********************************************************************
Check Tag: AMD_EXISTS
Check Summary: Check to see if AMD is present in the database
Fix Summary: Manually execute ORACLE_HOME/oraolap/admin/catnoamd.sql script to remove OLAP.
**********************************************************************
Fixup Returned Information:
INFORMATION: --> OLAP Catalog(AMD) exists in database
Starting with Oracle Database 12c, OLAP Catalog component is desupported.
If you are not using the OLAP Catalog component and want
to remove it, then execute the
ORACLE_HOME/olap/admin/catnoamd.sql script before or
after the upgrade.
**********************************************************************
**********************************************************************
Check Tag: PURGE_RECYCLEBIN
Check Summary: Check that recycle bin is empty prior to upgrade
Fix Summary: The recycle bin will be purged.
**********************************************************************
Fixup Succeeded
**********************************************************************
**********************************************************************
Check Tag: JOB_QUEUE_PROCESS
Check Summary: Check JOB_QUEUE_PROCESSES value
Fix Summary: Review and increase or remove the setting of job_queue_processes
**********************************************************************
Fixup Returned Information:
WARNING: --> job_queue_processes set too low
This parameter must be removed or updated to a value greater
than 4 (default value if not defined is 1000) prior to upgrade.
Not doing so will affect the running of utlrp.sql after the upgrade
Update your init.ora or spfile to make this change.
**********************************************************************
**********************************************************************
[Pre-Upgrade Recommendations]
**********************************************************************
*****************************************
********* Dictionary Statistics *********
*****************************************
Please gather dictionary statistics 24 hours prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
^^^ MANUAL ACTION SUGGESTED ^^^
*****************************************
*********** Hidden Parameters ***********
*****************************************
Please review and remove any unnecessary hidden/underscore parameters prior
to upgrading. It is strongly recommended that these be removed before upgrade
unless your application vendors and/or Oracle Support state differently.
Changes will need to be made in the init.ora or spfile.
******** Existing Hidden Parameters ********
_b_tree_bitmap_plans = FALSE
_disable_fast_validate = TRUE
_fast_full_scan_enabled = FALSE
_index_join_enabled = FALSE
_like_with_bind_as_equality = TRUE
_optimizer_autostats_job = FALSE
_sort_elimination_cost_ratio = 5
_sqlexec_progression_cost = 2147483647
_system_trig_enabled = TRUE
_trace_files_public = TRUE
^^^ MANUAL ACTION SUGGESTED ^^^
**************************************************
************* Fixup Summary ************
3 fixup routines were successful.
4 fixup routines returned INFORMATIONAL text that should be reviewed.
**************** Pre-Upgrade Fixup Script Complete *********************
PL/SQL procedure successfully completed.
3.11 To avoid Tablespase issues please autoextend all your datafiles
select file_name from dba_data_files;
alter database datafile '/u01/app/FBS/db/apps_st/data/system12.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system11.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system10.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system03.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system04.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system05.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system06.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system07.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system08.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/system09.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/ctxd01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/owad01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_queue02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/odm.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/olap.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/sysaux01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/apps_ts_tools01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_data04.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind06.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_ref03.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_int02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/sysaux02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/portal01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/undo01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_data01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_ref01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_int01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_summ01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_nolog01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_archive01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_queue01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_media01.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_data02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_data03.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind02.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind03.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind04.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_txn_ind05.dbf' autoextend on maxsize unlimited;
alter database datafile '/u01/app/FBS/db/apps_st/data/a_ref02.dbf' autoextend on maxsize unlimited;
select tablespace_name, file_name from dba_temp_files;
alter database TEMPFILE '/u01/app/FBS/db/apps_st/data/temp01.dbf' autoextend on maxsize unlimited;
alter database TEMPFILE '/u01/app/FBS/db/apps_st/data/temp02.dbf' autoextend on maxsize unlimited;
3.12 Some manual steps to be performed.
SYSAUX tablespace has to extended as per preupgrade.log file
set below parameter in init file and restart the database.
PROCESSES=300
job_queue_processes=65
EXECUTE dbms_stats.gather_dictionary_stats;
Comment these values:
_b_tree_bitmap_plans = FALSE
_disable_fast_validate = TRUE
_fast_full_scan_enabled = FALSE
_index_join_enabled = FALSE
_like_with_bind_as_equality = TRUE
_optimizer_autostats_job = FALSE
_sort_elimination_cost_ratio = 5
_sqlexec_progression_cost = 2147483647
_system_trig_enabled = TRUE
_trace_files_public = TRUE
SQL> EXECUTE dbms_stats.gather_dictionary_stats;
3.13 Copy admin directory from 11G_HOME/network to 12c_HOME/network
Change all the paths from 11.1.0 to 12.2.0
listener.ora
sqlnet.ora
tnsnames.ora
Make sure 11g DB entry is there in /etc/oratab
Source 12c.env file
unset ORA_TZFILE
[oracle@fbstest db]$ cd /u01/app/FBS/db/tech_st/12.1.0/bin/
and launch
./dbua
Select the values as per screenshots below
If any XML parsing error is seen during the upgrade, kindly ignore it.
The database has been successfully upgraded
3.14 Verify invalid objects
SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*)---------- 483.15 Copy $APPL_TOP/admin/adgrants.sql from the application server node to the database server node.
Run as below
[applmgr@fbsebs appl]$ cp $APPL_TOP/admin/adgrants.sql /u01/app/FBS/db/tech_st/11.1.0/appsutil/adminON DB server
$ sqlplus "/ as sysdba" @$ORACLE_HOME/appsutil/admin/adgrants.sql appsSQL> @?/rdbms/admin/prvtxdbschmig.plb
3.16 Grant create procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node. Use SQL*Plus to connect to the database as APPS and run the script using the following command:
$ sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYSe.g.
$ sqlplus apps/apps @adctxprv.sql manager CTXSYS
3.17 Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');3.18 Validate Workflow ruleset
On the administration server node, use SQL*Plus to connect to the database as APPS and run the $FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command:
$ sqlplus apps/apps @wfaqupfix.sql APPLSYS APPS3.19 Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. Note that adstats.sql has to be run in restricted mode. Use SQL*Plus to connect to the database as SYSDBA and use the following commands to run adstats.sql in restricted mode:
$ sqlplus "/ as sysdba"SQL> alter system enable restricted session;SQL> @adstats.sql $ sqlplus "/ as sysdba"SQL> alter system disable restricted session;SQL> exit;3.20 Run FND_CONC cleanup
sqlplus apps/appsSQL> exec fnd_conc_clone.setup_clean;3.21 Recreate appsutil and copy to DB server Oracle Home
[applmgr@fbstest ~ ]$cd $APPL_TOP[applmgr@fbstest ~ ]$. APPFBS_fbstest.env [applmgr@fbstest ~ ]$ perl $AD_TOP/bin/admkappsutil.plStarting the generation of appsutil.zipLog file located at /u01/app/FBS/inst/apps/FBS_fbstest/admin/log/MakeAppsUtil_12011758.logoutput located at /u01/app/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zipMakeAppsUtil completed successfully.[applmgr@fbstest ~ 05:58 PM]$
Copy the apputil.zip file to Database oracle home On DB-Tier: Source the DB environment and start the listener. [oracle@fbstest ~ ]$. 12c.env[oracle@fbstest ~ ]$cd $ORACLE_HOME[oracle@fbstest 12.1.0 ]$mv appsutil.zip appsutil.zip_orig[oracle@fbstest 12.1.0 ]$cp /u01/app/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip . unzip -o appsutil.zipRecreate Context File on DB -Tier
cd $ORACLE_HOME/appsutil/bin[oracle@fbstest bin 02:46 AM]$perl adbldxml.pl appsuser=apps appspasswd=apps jtop=$ORACLE_HOME/jdk Starting context file generation for db tier..Using JVM from /u01/app/FBS/db/tech_st/12.1.0/jdk/bin/java to execute java programs.. The log file for this adbldxml session is located at:/u01/app/FBS/db/tech_st/12.1.0/appsutil/log/adbldxml_12080746.log Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hostname of Database server: fbstest Enter Port of Database server: 1546 Enter SID of Database server: FBS Enter the value for Display Variable: fbstest:0.0 The context file has been created at:/u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbstest.xml3.22 Run adconfig on DB Tier
[oracle@fbstest bin 07:55 AM]$perl adconfig.pl contextfile=/u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbstest.xmlEnter the APPS user password: The log file for this session is located at: /u01/app/FBS/db/tech_st/12.1.0/appsutil/log/FBS_fbstest/12080755/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /u01/app/FBS/db/tech_st/12.1.0 Classpath : :/u01/app/FBS/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/u01/app/FBS/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/u01/app/FBS/db/tech_st/12.1.0/appsutil/java:/u01/app/FBS/db/tech_st/12.1.0/jlib/netcfg.jar Using Context file : /u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbstest.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 db121Updating rdbms type in Context file to 64 bitsConfiguring templates from ORACLE_HOME ... AutoConfig completed successfully.3.23 Run autoconfig on application Tier.
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*vi $ORA_CONFIG_HOME/Apache/Apache/conf/httpd.conf
3.23.1 Locate the KeepAlive directive in httpd.conf
KeepAlive On
Timeout 300
3.23.2 Replace the KeepAlive directive in httpd.conf with
KeepAlive Off
Timeout 600
3.24 Apply patch 18039691 on the application layer.
[applmgr@fbsebs lib]$ cd /u01/patches/apps/18039691/
[applmgr@fbsebs 18039691]$ adpatch apply=yes driver=u18039691.drv3.25 Disable maintenance mode in Application and start services. Verify the services and the DB version.
Reference Notes:
Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)
No comments:
Post a Comment