Hai, Here are the list of topics covered under this blog are Categorized respectively.
========================================================
========================================================
adop/adcfg export jvm options
export USER_MEM_ARGS="-Xms10240m -Xmx10240m -XX:MaxPermSize=2048m"
export CONFIG_JVM_ARGS="-Xmx4096m -Xms2048m -XX:MaxPermSize=512m -XX:-UseGCOverheadLimit"
export TIMEDPROCESS_TIMEOUT=-1
EBS Cloning:
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
EBS and Components Upgrade:
========================================================
========================================================
DB Cloning with (RMAN)
Data Guard Topics RAC and non RAC:
========================================================
========================================================
RAC Installations:
ASM Disk Creation:
RAC Upgrades:
GRID and RDBMS upgrade form Release 12c(12.1.0.2) to 19c (19.12.0) <<<--- Along with EXPDP upgrade Steps
RAC DB Cloning:
========================================================
========================================================
################################################################################################################
################################################################################################################
Most Useful EBS Documents Reference from MOS:
Specially for OCI Database: DBCLI Commands in DATABASE Install
To check list of RDBMS homes(only) on servers from root:
OCI db home CPU patches methods Parts Need to check and verify
Use the cliadm update-dbcli command to update the database CLI with the latest new and updated commands.
[root@prod1 ~]# dbcli describe-latestpatch
[root@prod1 ~]# dbcli describe-component
Database Important Docs:
Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)
Oracle Database (RDBMS) Releases Support Status Summary (Doc ID 161818.1)
Master Note For OPatch (Doc ID 293369.1) OPatch Latest 6880880
Supported Java SE Downloads on MOS (Doc ID 1439822.1)
Latest Java SE Patch Updates on MOS (Doc ID 1414485.1)
Oracle Critical Patch Update January 2021 Documentation Map (Doc ID 2739466.1)
HISTORICAL: Database Patch Set Update Overlay Patches Required for
Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Doc ID 1147107.1)
Patch Set Updates for Oracle Products (Doc ID 854428.1)
Knowledge Base Search key word for OJVM & PSU( Database Proactive Patch Information)
Release Schedule of Current Database Releases (Doc ID 742060.1)
Primary Note for Database Proactive Patch Program (Doc ID 888.1)
Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1)
Database 12.1.0.2 Proactive Patch Information (Doc ID 2285558.1)
Database 18 Proactive Patch Information (Doc ID 2369376.1)
Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1)
Oracle Database 21c Proactive Patch Information (Doc ID 2796590.1)
Oracle Recommended Patches -- "Oracle JavaVM Component Database PSU and Update" (OJVM PSU and OJVM Update) Patches (Doc ID 1929745.1)
SELECT version, status FROM dba_registry WHERE comp_id='JAVAVM';
Diagnostic Scripts of database common information collection
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)
SRDC - Invalid Components and Objects across Database areas : Checklist of Evidence to Supply (Doc ID 2859407.1)
EBS Important Docs:
Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12 (Doc ID 2484000.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Bug Fixes (Doc ID 2877607.1)
How to Identify - Confirm What is the Framework Bundle - Framework Level - Applied in 12.1 and 12.2 Installations (Doc ID 2300940.1)
Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (Month YEAR)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1)
Sharing The Application Tier File System in Oracle E-Business Suite Release 12.2 (Doc ID 1375769.1)
Configuring Oracle Workflow for OAuth 2.0 in Oracle E-Business Suite Release 12.2 and Release 12.1.3 (Doc ID 2884072.1)
E-Business Suite Concurrent Processing Requests / Reports That Should Be Scheduled Periodically By The System Administrator (Doc ID 1066117.1)
How to Collect Bne Log Files for Web ADI Integrators (Doc ID 2128542.1)
Installing Oracle Enterprise Command Center Framework, Release 12.2 (Latest Version) (Doc ID 2495053.1)
Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID 387859.1)
Tuning Performance on E-Business suite (Doc ID 744143.1)
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
Database Initialization Parameters for Oracle Applications Release 11i (Doc ID 216205.1)
Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (Doc ID 2655839.2)
Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade (Doc ID 1349240.1)
Export/Import Process for Oracle EBS 12.2 Using Oracle Database 12c Release 1 (Doc ID 1926203.1)
Application Tier Platform Migration with Oracle E-Business Suite Release 12.2 (Doc ID 2048954.1)
Enabling TLS in Oracle E-Business Suite Release 12.2 (Doc ID 1367293.1)
Use with PSUs and Oracle E-Business Suite (Doc ID 2056342.1)
Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems: Exadata Database Machines and SuperClusters (Doc ID 1392527.1)
Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Doc ID 1375670.1)
HISTORICAL Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems: Exadata Database Machines and SuperClusters (Doc ID 2023232.1)
JAVA downloads Docs:
upgrading JDK to latest version
Using the Latest JDK 7.0 Update with Oracle E-Business Suite Release 12.2 (Doc ID 1530033.1)
Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)
Latest Java SE Patch Updates on MOS (Doc ID 1414485.1)
Supported Java SE Downloads on MOS (Doc ID 1439822.1)
ADOP Important Docs:
DataInstall and HRGLOBAL Application: 12.2 Specifics (Doc ID 1469456.1)
Adop apply fails with " Do you wish to apply this patch now [No] ? No *" (Doc ID 2355751.1)
R12: AP: How do you run admsi.pl for the Patch Application Assistant? (Doc ID 2591487.1)
Autoconfig Fails With "Timed out( 300000 ): Interrupted Exception" Error (Doc ID 2177265.1)
Adop Prepare Phase Fails While Calling ad_zd.prepare" With Error "ORA-04031: unable to allocate 256 bytes of shared memory" (Doc ID 2043199.1)
12.2 E-Business Suite Applications DBA Online ADOP Utility Fs_clone Fails With
"ERROR: Number of servers are not in sync between Run and Patch Context" [1582473.1]
Getting Error Could not drop covered object while Running Adop Cleanup phase (Doc ID 2511377.1) Alter session set edition = V_20190109_1434;
Cleanup Phase Is Successful But Has Some Errors And Warnings In The Log File: [WARNING] Could not drop covered object (Doc ID 2496457.1)
Adop Cleanup Issue: "[ERROR] [CLEANUP] ORA-04020: deadlock detected " (Doc ID 2424333.1)
[CLEANUP 1:1 ddl_id=50088] ORA-04020: deadlock detected while trying to lock object SYS.DBMS_SYS_SQL SQL: begin sys.ad_grants.cleanup; end;
EVENT Cleanup crossedition triggers
Application Modules Important Docs:
Useful SQL Statements to Check What Makes FND_LOBS Grow? (Doc ID 1245974.1)
FAQ - Performance Considerations For FND_LOBS (Doc ID 829235.1)
################################################################################################################
################################################################################################################
Miscellaneous Works on PROD:
========================================================
========================================================
putty.exe (the SSH and Telnet client itself)
========================================================
yum repository:
# ping yum.oracle.com
# mv /etc/yum.repos.d/public-yum-ol7.repo /etc/yum.repos.d/public-yum-ol7.repo_bkp
# wget https://yum.oracle.com/public-yum-ol7.repo
- enable as shown in EBS Installation doc
# yum search oracle-ebs oracle-rdbms oracle-database oracleasm-support (for EBS-R12, 11g,12c,18c,19c,21c)
# yum -y install oracle-ebs-server-R12-preinstall
# yum -y install openmotif21
# yum -y install xorg-x11-libs-compat
# rpm -qa oracle-ebs*
========================================================
Remote Session:
[root@rac1 ~]# tmux -f ~/.tmux.conf (force load all customizing in tmux session)
tmux attach -t 0 --> attach recent session from tmux ls
[root@rac1 ~]# screen -ls
[root@rac1 ~]# screen -r 22409
========================================================
While Applying AD Patch, Getting “The following middle tier fixes have not been applied” Even After Applying ETCC Patches (Doc ID 2958876.1)
========================================================
Apply Download Latest OPatch
$ORACLE_HOME/OPatch/opatch version
$ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch lspatches |sort -nr (need to test)
$ORACLE_HOME/OPatch/opatch lsinventory | grep applied
$ORACLE_HOME/OPatch/opatch lsinventory | grep description
time $ORACLE_HOME/OPatch/datapatch -verbose
When we have to apply multiple optachs to oracle home it can be done once with napply make sure you order it as per etcc (note: for napply no need to unzip/chown just make sure to pkill user and change directory to zip files folder to skip parameter -phBaseDir before starting.
cd /u01/DB_Patches
$ORACLE_HOME/OPatch/opatch napply -id 30614876,15894842
$ORACLE_HOME/OPatch/opatch nrollback -id 30614876,15894842
How To Apply Several Patches At The Same Time With Napply (Doc ID 1321718.1)
How to Apply Multiple Fusion Middleware Patches with OPatch (Doc ID 2865196.1)
Check Patch Conflict methods with current applied patches to HOME:
1. Manual Command to check patch Conflict is go to patch folder and run:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
2. Run patch conflict check online, with option "Analyze with opatch" prior downloading patch (useful if having Big patch, check conf. without downloading patch)
$ORACLE_HOME/OPatch/opatch lsinventory > Analyze_with_OPatch_Online.txt
- click Analyze with opatch (near Download Button)
- Attach/upload the above txt file to the patch with which need to check conflicts
- click "Analyze for Conflict"
========================================================
========================================================
EBS Start/stop shortcut:
col NVL(owner,'GRAND_TOTAL') for a25;
select NVL(owner,'GRAND_TOTAL'),object_type,count(*) from dba_invalid_objects where status='INVALID' group by grouping sets((),(owner,object_type));
select count(*) "INVALID Objects Count" from dba_objects where status !='VALID' and owner='APPS';
SQL> @?/rdbms/admin/utlrp.sql <<--invalid object compile
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> select value from gv$diag_info where name='Diag Trace'; <--alert log
kills Only Remote DB Connection (do not execute from root instead, use with OS user)
ERROR: ORA-00020: maximum number of processes (200) exceeded
[root@rac1 ~]# ps -ef |grep -i LOCAL=NO | awk '{print $2}' | xargs kill -9
EBS Database Autoconfig
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh
$ORACLE_HOME/appsutil/bin/adbldxml.pl <-- to rebuild new xml file
EBS Database check
Running ADOP Fails With Error "ETCC Not Run In The Database Node" (Doc ID 2191678.1)
SQL> select node_name from apps.TXK_TCC_RESULTS;--check scripts ran or not
$ORACLE_HOME/appsutil/etcc/checkDBpatch.sh
$ORACLE_HOME/OPatch/opatch lsinventory | grep -i 'description\|applied'
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediate
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start $ORACLE_SID
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop $ORACLE_SID
lsnrctl start $ORACLE_SID (for NON-RAC DB)
lsnrctl start $ORACLE_UNQNAME (for RAC DB start on all DB Nodes)
adstrtal.sh -mode=allnodes apps/apps (after starting db listener on all RAC nodes)
adstpall.sh -mode=allnodes apps/apps
ls -ltrh $APPL_TOP/APPS$CONTEXT_NAME.env
grep -A 5 MISSING_TRANSLATED_VERSION $APPL_TOP/admin/${TWO_TASK}/adalldefaults.txt
Regular logs files to delete from PROD Run FS -- not for cloning
vi $APPLCSF/log/find1rm.sh (check Linux Basic blog for details)
. If files not deleted, then java heap size error during fsclone
. Do not delete or rename the current file or logs folder directly
GRID Listener (alert & trace)logs:
du -sh /u01/app/grid/diag/tnslsnr/host_name/*
du -sh $GRID_HOME/log/host_name/* #testing for first time
RDBMS Generated Logs::
du -sh /u01/app/oracle/diag/rdbms/prod/PROD
du -sh $ORACLE_HOME/dbs #verified,tested it is safe to remove core_* folders inside dbs
du -sh $ORACLE_HOME/rdbms/audit
Application Generated Logs
du -sh $PATCH_TOP $PATCH_TOP/*
du -sh $EBS_DOMAIN_HOME/servers/*
du -sh $IAS_ORACLE_HOME/instances/* (or)
du -sh $IAS_ORACLE_HOME/instances/EBS_web_*OHS*/diagnostics/logs/OHS/EBS_web*
du -sh $INST_TOP/logs $INST_TOP/logs/ora/10.1.2/reports/cache
du -sh $FMW_HOME/utils/bsu/cache_dir
du -sh $EBS_DOMAIN_HOME/core*
verified can be deleted unwanted other than clone folder or not:
grep s_clonestage $CONTEXT_FILE
du -sh $COMMON_TOP/*
ls -ltrh $COMMON_TOP/*/FMW/FMW_Home.jar
ls -ltrh $PATCH_BASE/EBSapps/comn/*/FMW/FMW_Home.jar (created when ran adpreclone this can be deleted)
find $COMMON_TOP/adopclone_* -iname FMW_Home.jar (this can be deleted which has previous server names)
APPLCSF Logs for old CM when ever stop/start apps occurred
ls -ltrh $APPLCSF/log/FNDCPGSC*.txt $APPLCSF/log/FNDSM*.mgr $APPLCSF/log/FNDOPP*.txt
ls -ltrh $APPLCSF/log/w*.mgr $APPLCSF/log/c*.mgr $APPLCSF/log/t*.mgr
if log files in EBS domain server folder (Admin, forms & oacore_server) have reached more than 10GB the delete all acess0, log0 & out0 files: (alternately carefully delete first command by *000* for most of all logs at once)
cd $EBS_DOMAIN_HOME/servers/AdminServer/logs/
rm access.log0* AdminServer.log0* AdminServer.out0* EBS_domain.log0* AdminServer-diagnostic-*
cd $EBS_DOMAIN_HOME/servers/forms_server1/logs/
rm access.log0* forms_server1.log0* forms_server1.out0*
cd $EBS_DOMAIN_HOME/servers/oacore_server1/logs
rm access.log0* oacore_server1.out0* oacore_server1.log0*
cd $EBS_DOMAIN_HOME/servers/oacore_server2/logs
rm access.log0* oacore_server2.out0* oacore_server2.log0*
cd $EBS_DOMAIN_HOME/servers/oacore_server3/logs
rm access.log0* oacore_server3.out0* oacore_server3.log0*
################################################################################################################
################################################################################################################
Basic Sanity Testing DB, Application and OS:
-------------------------------------------------------
Weekly/monthly checks:
-------------------------------------------------------
- FS_CLONE
- Gather Schema Stats
- RMAN, Tablespace, Storage for AJDB
- Purge % Conc Req. check for 30 days
- $APPLCSF/log check from crontab
- du -sh $EBS_DOMAIN_HOME/servers/*
- Run OCI Backups from Console
-------------------------------------------------------
Database Sanity Testing (Safe Harbour Statement)
-------------------------------------------------------
(Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
(utl_file_dir, NLS, All Optimizer Parameters & Performance related Parameters)
- EBS DB parameters check (EBS Release 12.2 (Doc ID 396009.1)
- select * from dba_registry_sqlpatch; -->Last Applied DATABASE BUNDLE PATCH
- select POLICY_GROUP, POLICY_NAME, OBJECT_NAME, PACKAGE, FUNCTION from DBA_POLICIES;
- select OWNER, TABLE_NAME, LAST_ANALYZED from dba_tab_statistics where table_name like 'X$%' order by last_analyzed; --- to check when gather stats run last time -- for procedure check flashback blog
- select * from fnd_nodes;-- total nodes
- select * from dba_db_links; --all_db_links; --user_db_links;
- Tablespace Storage Size.
- JRE Version
[oracle@ahcclouddevdb ~]$ $ORACLE_HOME/appsutil/jre/bin/java -version
java version "1.7.0_251"
Java(TM) SE Runtime Environment (build 1.7.0_251-b08)
Java HotSpot(TM) 64-Bit Server VM (build 24.251-b08, mixed mode)
[oracle@ahcclouddevdb bin]$
- Inventory Location
- OPatch Inventory & PSU Versions
- Invalid Objects
- Interface Tables data clear
- $ORACLE_HOME/appsutil/etcc/checkDBpatch.sh ------->>> Latest ETCC patch check for missing recommended patch
- Export/ Import (AJAR,XXTIME)
- RMAN Archivelog & Duplicate Commands
- DGMGRL Config & Status
- Standby Server Setup & Log Shipping
-
- RAC Cluster Services & Management
-
- du -sh $ORACLE_HOME/rdbms/audit
find $ORACLE_HOME/rdbms/audit |wc -l
- crontab -l (to check RMAN/applmgr/root scheduled jobs running properly)
-------------------------------------------------------
Application Sanity Testing
-------------------------------------------------------
####################################################
------------------------------
Update JVM Mem. for OA_CORE
- oacore_server1 --> (tab)Server Start --> Arguments: -Xms2048m -Xmx4096m
adnodemgrctl.sh stop/start oacore_server1
ps -ef | grep oacore_server1
ps -ef | grep Xmx4096
#############################################################
- number of OA_CORES servers and JVM Memory Argument per OA_Core (Xms, Xmx)
- grep SwapTotal /proc/meminfo
du -sh $EBS_DOMAIN_HOME/servers/*
du -sh $EBS_DOMAIN_HOME/core
du -sh $APPLCSF/log
find $APPLCSF/log | wc -l
du -sh $APPLCSF/out
find $APPLCSF/out | wc -l
crontab -l (to check tar scheduled jobs running properly)
- No. of Application Nodes / Load Balancer
- Schedule Request (daily, weekly)
- AD & TXK Versions
- installed JDK Version ($ADJVAPRG -version $AFJVAPRG -version)
- checkMTpatch.sh --> Latest ETCC patch check for missing recommended patch
- Database Session (Load Balance for RAC)
- Workflow Mailer Configuration & Test Mail & WFM Log ( $APPLSCF/log/FNDCPGSC*.txt )
- autoconfig for DB & APPS
- fs clone, adop Complete cycle
- File System Change RFS->PFS
- Gather Schema Stats "ALL"
- Concurrent Request Test (Submit)
- Arabic Language Setup
- Printer Setup & (Arabic Printing)
- SSL Setup Related Checks
- fndlogs/BNE url access and logs generation after upgrade/migrate (Doc ID 2128542.1)
- Web ADI data export to excel for HR and Finance Modules
- Mount points (u01,u02) if on NFS open SR and check compatibility with Application Version (12.1 12.2, Multi Node Shared/not-shared During 1st iteration)
- Cache delete after stop apps
ls -ltrh $OA_HTML/cabo/images/cache/*.gif $OA_HTML/cabo/images/cache/*.imx
ls -ltrh $OA_HTML/cabo/styles/cache/*.css
EBS Module Testing
-------------------------------------------------------
DBA ADMIN Tasks
- SELECT * FROM dba_editions; -- lists all pending editions of ADOP cycles
SELECT * FROM ad_adop_sessions;
HR/Payroll
- Bursting Programme for salary slip
- select * from pay_action_parameters; -- where PARAMETER_NAME='THREADS';-- speed payroll run check adop blog for configure
------------------------------------------------------- -- Oracle_Home , Middel ware Home Weblogic Applied Patches check Oracle E-Business Suite Release 12.2: Patching Technology Components Guide (Doc ID 1355068.1) ------------------------------------------------------- -- Weblogic Console Url with echo command: echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console" [applmgr@rac1 ~]$ adstpall.sh apps/apps ls $OA_HTML/WEB-INF/classes/_pages |wc -l mv $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pagesbkp`date +%d-%m-%y` mkdir $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages du -sh $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/* cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages ls $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages |wc -l time perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 4 (approx. time 25 Mins) tailf $INST_TOP/logs/appl/rgf/ojsp/ojspc_error.log |
-- EBS HOME 1 (EBS Apps Home 10.1.2) echo $ORACLE_HOME /u01/OCI/fs1/EBSapps/10.1.2 $ORACLE_HOME/OPatch/opatch lspatches $ORACLE_HOME/OPatch/opatch lsinventory | grep applied |
-- EBS HOME 2 (Web Tier and Utilities (OHS) version, applied patches) echo $OHS_VERSION 11.1.1.9.0 echo $OHS_SUB_VERSION 11.1.1.9 export ORACLE_HOME=$IAS_ORACLE_HOME export ORACLE_HOME=$FMW_HOME/webtier $ORACLE_HOME/OPatch/opatch lsinventory | grep WebTier Oracle WebTier and Utilities CD 11.1.1.9.0 $ORACLE_HOME/OPatch/opatch lsinventory | grep applied |
-- EBS HOME 3 : (oracle common home) export ORACLE_HOME=$FMW_HOME/oracle_common $ORACLE_HOME/OPatch/opatch lsinventory | grep Common Oracle AS Common Toplevel Component 11.1.1.2.0 $ORACLE_HOME/OPatch/opatch lsinventory | grep applied |
-- EBS HOME 4: Weblogic Home patches check (for weblogic patching click here) $Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Bug Fixes (Doc ID 2877607.1) Method-1 [oraerp@rac1 scripts]$ . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh java weblogic.version WebLogic Server 10.3.6.0.220118 PSU Patch for BUG33494814 Mon Dec 13 10:08:03 UTC 2021 Method-2 go to bsu folder and run below and check/identify with patch ID for the mentioned patch in Readme or from patch description cd $FMW_HOME/utils/bsu bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -verbose -view [oraerp@rac1 bsu]$ bsu.sh -version Method-3a only for check applied PSU on Weblogic from checkMTpatch.sh results: [applmgr@rac1 ~]$ grep 10.3.6 /home/applmgr/log/checkMTpatch_7428.log Product Version = 10.3.6.0.201020 Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.201020. [applmgr@rac1 ~]$ grep Checking /home/applmgr/log/checkMTpatch_7428.log Checking for prerequisite bugfixes in File Edition: run Checking for ETCC results table. Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0. Checking required bugfixes for RSF within Forms 10.1.0.5.0. Checking required bugfixes for FMW - Web Tier 11.1.1.9.0. Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0. Checking required bugfixes for FMW - oracle common 11.1.1.9.0. Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.201020. [applmgr@rac1 ~]$ Method-3b [applmgr@ebsprodapp3 ~]$ . $FMW_HOME/user_projects/domains/EBS_domain/bin/setDomainEnv.sh [applmgr@ebsprodapp3 EBS_domain]$ java weblogic.version WebLogic Server 10.3.6.0 Tue Nov 15 08:52:36 PST 2011 1441050 [applmgr@ebsprodapp3 ~]$ -- EBS Tips for context variables [applmgr@ebsprodapp3 ~]$ echo $APPL_TOP/admin/${TWO_TASK}/adalldefaults.txt [oracle@ebsproddb1 ~]$ perl $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh -- EBS Application 5 Apply latest Missing Framework Patches for FWK RELEASE XXX BUNDLE: How to Identify - Confirm What is the Framework Bundle - Framework Level - Applied in 12.1 and 12.2 Installations (Doc ID 2300940.1) |
-------------------------------------------------------
OS Level Testing
-------------------------------------------------------
Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)
- Mount points (u01,u02) or on local server or NFS for DB/App Tier
NFS Storage level changes/updated also Required if upgrading form 12.1 to 12.2
Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1)
cat /etc/mtab
cat /etc/fstab
blkid
ll /dev/disk/by-uuid
----------------------
-------------------------------------------------------
list all cronjobs running on server (root/all_users)
[root@prd1 ~]# tail -n +1 /var/spool/cron/*
-------------------------------------------------------
[root@rac1 ~]# cat /etc/hosts
-------------------------------------------------------
[root@rac1 ~]# free -h -w
# Note, we are using "echo 3", but it is not recommended in production instead use "echo 1"
[root@rac1 ~]# echo 1 > /proc/sys/vm/drop_caches && swapoff -a && swapon -a && printf '\n%s\n' ' Ram-cache and the swap get cleared'
kill all zombie process in Linux 6.10:
[root@rac1 ~]# ps aux | grep -w Z ß to list all zombie process
[root@rac1 ~]# kill -9 $(ps -A -ostat,ppid |grep -e '[zZ]'|awk '{print $2}') ß to kill all zombie process
[root@rac1 ~]# ps -eo pid,lstart,cmd|grep -i 'sqlplus\|datapatch\|adop\|tar.gz\|zip' (to check adop/tar session start time)
[root@prd1 ~]# grep Hugepagesize /proc/meminfo
Hugepagesize: 2048 kB
[root@prd1 ~]# grep Huge /proc/meminfo
AnonHugePages: 0 kB
HugePages_Total: 15322
HugePages_Free: 742
HugePages_Rsvd: 14
HugePages_Surp: 0
Hugepagesize: 2048 kB
[root@prd1 ~]# vi /etc/security/limits.conf
[root@prd1 ~]#
[root@prd1 ~]# grep memlock /etc/security/limits.conf
# - memlock 45000000
grid soft memlock unlimited
grid hard memlock unlimited
oracle soft memlock unlimited
oracle hard memlock unlimited
[root@prd1 ~]# vi /etc/sysctl.conf
[root@prd1 ~]#
[root@prd1 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 8388604 kB
[root@prd1 ~]#
-------------------------------------------------------
OS Server Prechecks RDA Report before installing any product (DB, RAC, EBS)
-------------------------------------------------------
Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)
How To Generate HCVE Report - Step By Step Instructions (Doc ID 2324096.1)
[applmgr@rac1 ~]$ unzip p21769913_204201020_Linux-x86-64.zip
[applmgr@rac1 ~]$ cd rda
[applmgr@rac1 rda]$ ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Linux)
3. Oracle Database 11g R1 (11.1) Preinstall (Linux)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Linux)
5. Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)
6. Oracle Database 12c R2 (12.2.0) Preinstallation (Linux)
7. Oracle Database 18c Preinstallation (Linux)
8. Oracle Database 19c Preinstallation (Linux)
9. Oracle Identity and Access Management PreInstall Check: Oracle Identity
and Access Management 11g Release 2 (11.1.2) Linux
10. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 11g Release 2
(11.1.2.4) Linux
11. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 12c (12.1.3)
Linux
12. OAS PreInstall Check: Application Server 10g R2 (10.1.2) Linux
13. OAS PreInstall Check: Application Server 10g R3 (10.1.3) Linux
14. OFM PreInstall Check: Oracle Fusion Middleware 11g R1 (11.1.1) Linux
15. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.1.3) Linux
16. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.2.1.3.0) Linux
17. Oracle Forms and Reports PreInstall Check: Oracle Forms and Reports 11g
Release 2 (11.1.2) Linux
18. Portal PreInstall Check: Oracle Portal Generic
19. IDM PreInstall Check: Identity Management 10g (10.1.4) Linux
20. BIEE PreInstall Check: Business Intelligence Enterprise Edition 11g
(11.1.1) Linux
21. EPM PreInstall Check: Enterprise Performance Management Server (11.1.2)
Generic
22. Oracle Enterprise Manager Cloud Control PreInstall Check: Oracle
Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) Linux
23. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 and
x86_64)
24. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 and
x86_64)
25. Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)
Available Post-Installation Rule Sets:
26. RAC 10G DB and OS Best Practices (Linux)
27. Data Guard Postinstall (Generic)
28. WLS PostInstall Check: WebLogic Server 11g (10.3.x) Generic
29. WLS PostInstall Check: WebLogic Server 12c (12.x) Generic
30. Portal PostInstall Check: Oracle Portal Generic
31. OC4J PostInstall Check: Oracle Containers for J2EE 10g (10.1.x) Generic
32. SOA PostInstall Check: Service-Oriented Architecture 11g and Later
Generic
33. OSB PostInstall Check: Service Bus 11g and Later Generic
34. Oracle Forms 11g Post Installation (Generic)
35. Oracle Enterprise Manager Agent 12c Post Installation (Generic)
36. Oracle Management Server 12c Post Installation (Generic)
37. Network Charging and Control Database Post Installation (Generic)
Enter the HCVE rule set number or 0 to cancel the test
Press Return to accept the default (0)
> 25
Performing HCVE checks ...
Enter value for < Planned application tier installation directory >
>
Test "Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)" executed at 12-Jan-2022 07:43:56
Thanks for Reading
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux | DATABASE | RMAN | RAC | EBS |
| R1229 M7 Clone | ||||
| RAC DataGuard | Pluggable DB Clone | |||
| appsutil for DB | ||||
| JDK JRE upgrade | ||||
| Add EBS Node | ||||
My-Orcl@Areef Dba, My-Orcl@Arif Dba: List Of Topics (Linux, Database, Rac, Ebs) >>>>> Download Now
ReplyDelete>>>>> Download Full
My-Orcl@Areef Dba, My-Orcl@Arif Dba: List Of Topics (Linux, Database, Rac, Ebs) >>>>> Download LINK
>>>>> Download Now
My-Orcl@Areef Dba, My-Orcl@Arif Dba: List Of Topics (Linux, Database, Rac, Ebs) >>>>> Download Full
>>>>> Download LINK