foalabs

Understanding Editioning in Oracle EBS R12.2 The database utilizes the Edition-Based Redefinition (EBR) feature of the Oracle 11gR2 Database to support online patching. Traditionally, applications such as Oracle E-Business Suite have had to be unavailable while their associated database objects are patched or upgraded. The EBR feature of the Oracle 11gR2 Database allows this downtime to be avoided. Every database has at least one edition, and can support multiple editions. A new edition is created as a child of an existing edition. The changes are made in the child edition, while the parent edition remains available for use. Changes to data (such as when a patch is applied) are made by writing only to new columns or new tables not seen by the old edition. This allows an application to efficiently store multiple copies of its application definition in the same database, and thereby enables online upgrade of the database tier. EBR allows an application's database objects to be change...

OACore JVM Sizing, Check and Increase JVM Size and Count To check if there are issues with sizing cd $LOG_HOME/ora/10.1.3/opmn/ ls -ltr default_group~oacore* grep 'Full GC' default_group~oacore* | wc -l grep 'Unloading class' default_group~oacore* | grep 'Full GC' | wc -l If you see there are multiple cases when Full GC is happening then,  JVM sizing is not proper. Take the following actions for this: 1. Increase the Number of OACore JVMs 2. Increase the JVM Heap Size Increase the JVM Heap Size Default Value is  “-Xmx512M -Xms128M”. Check current Size: cd $ADMIN_SCRIPTS_HOME ./adoacorectl.sh status | grep "OC4J:oacore" | awk -F"|" '{print $3}' | while read L ; do ps -fp $L | grep -v PID ; done | awk -F"-X" '{print $2 $3}' mx512M ms128M Change Memory Parameters I would start with  “-Xmx2048M -Xms1024M” set up.   To change the memory parameters, edit $CONTEXT_FILE and change the following line: [applmgr@funebs121 scrip...

What I do as an Oracle Apps DBA|Future of Apps DBA|What Next You Should Learn Next I have explained What I do as an Apps DBA,Future of Apps DBA and what should you learn next. This is based on my experience and is subjective. If you are beginner,freshers or moving to Oracle Apps DBA, must watch this. If you like Please follow and comment

Install Android  on Oracle VirtualBox if you like please follow and comment

ADOP - Useful Commands I this post I am sharing different options available for ADOP. Display examples of the various adop parameters by entering the command: adop -examples To obtain help about the basics of adop operation adop -help Online Patching Cycle source <ebs_root>/EBSapps.env run adop phase=prepare adop phase=apply patches=123456 adop phase=finalize adop phase=cutover source <ebs_root>/EBSapps.env run adop phase=cleanup Run Prepare Phase adop phase=prepare Run apply phase adop phase=apply patches=123456 Run Finalize phase adop phase=finalize Run Cutover phase adop phase=cutover Run Cleanup phase adop phase=cleanup Run fs_clone phase adop phase=fs_clone Combining multiple in a single adop command. Example – combined finalize/cutover/cleanup: adop phase=finalize,cutover,cleanup Restart the failed adop session incase you want to start from failure adop phase=apply patches=123456 restart=yes Restart the failed adop session incase you want to start from the very beginn...

Project: Create a LAMP stack bootstrap and Provision a VM using Vagrant 1) Make Directory $ mkdir ubuntu-trusty-lamp $ cd ubuntu-trusty-lamp/ 2) Create Vagrant file Do it when you're in ubuntu-trusty-lamp folder. Name the file as Vagrantfile. # -*- mode: ruby -*- # vi: set ft=ruby : # Vagrantfile API/syntax version. Don't touch unless you know what you're doing! VAGRANTFILE_API_VERSION = "2" Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|   # Every Vagrant virtual environment requires a box to build off of.   config.vm.box = "ubuntu/trusty64"   # Create a private network, which allows host-only access to the machine using a specific IP.   config.vm.network "private_network", ip: "192.168.56.10"   # Share an additional folder to the guest VM. The first argument is the path on the host to the actual folder.   # The second argument is the path on the guest to mount the folder.   config.vm.synced_folder ".", "/var/ww...

Vagrant Crash Course | Deploy your Machines Quickly Vagrant is an open-source software product for building and maintaining portable virtual software development environments e.g., for VirtualBox, KVM, Hyper-V, Docker containers, VMware, and AWS. It tries to simplify the software configuration management of virtualization in order to increase development productivity. If you like please follow and comment

Linux|Installing Virtual Box on Linux Mint OS If you like please follow and comment

Shell Script to Change Sys and System Password in Oracle Database I am running the script from a centralized DB server to connect to all DB's and changing the password. Make sure the DB is able to tnsping to all remote server I created a TEST_DB/PROD_DB file with the DB/TNS names which will be used for connecting. cat TEST_DB TEST1 TEST2 TEST3 TEST4 Script: #!/bin/bash ################################################################################# #PURPOSE: TEST DB SYS and SYSTEM password change script # Usage : sys_system_pass_change.sh [PROD]/[TEST] #Author Version Date #Himanshu Singh 1.0 15-AUG-2020 # ################################################################################## #######################Before change system password prefix####################### prefx=dundb ##############Change the below value before canging system password################## newprefx=ebs123 . $HOME/testdb.env checkfile=TNS_DB_CHECK.log passch=PASS_CHANGE.log RECEIPENTS=suppor...

Shell Scripting| Reading a file and processing based on it | WriteWithMe#2 Code used in Video: #!/bin/bash ################################### vfile=$1 for i in `cat ${vfile}|grep -v "^#"|awk -F ',' '{print $2}'` do echo "The fruit name is ${i}" done If you like please follow and comment

BI Discoverer 11g: Unable To Connect To Oracle Applications Database: Invalid Username/Password  Error: unable to connect to: user@sid Failed to connect to database - Unable to connect to Oracle Applications database: invalid username/password Cause: Admin Server AUTHENTICATION is SECURE.   This is justified by running: java oracle.apps.fnd.security.AdminAppServer apps/<pwd> STATUS DBC=$FND_SECURE/PROD.dbc Database Server --------------- DATABASE_ID: PROD AUTHENTICATION: SECURE Application Server ------------------ APPL_SERVER_STATUS: VALID APPL_SERVER_ID: ERURDF876SHFNJ   SOLUTION 1. Source application tier environment file <APPL_TOP>/APPS<SID>_<hostname>.env. 2. Run the following command: java oracle.apps.fnd.security.AdminAppServer apps/<pwd> AUTHENTICATION OFF DBC=$FND_SECURE/<SID>.dbc 3. Re-try to login   If you like please follow and comment

Linux | wc Command|Word Counter If you like please follow and comment

Linux|Select Loop|Shell Scripting If you like please follow and comment

Shell Script to find if a String is Palindrome or not A palindrome is a word, number, phrase, or other sequence of characters which reads the same backward as forward. Like " MADAM " this string will be same if we reverse the characters. Note: An empty string and any single characters are palindromes by default. Script: echo "input your string without space" read vstr for i in $(seq 0 ${#vstr}) do rvstr=${vstr:$i:1}${rvstr} done echo "Input string was :" $vstr echo "After reversng string is :" $rvstr if [ "$vstr" = "$rvstr" ] then echo "String is palindrome." else echo "String is not plaindrome." fi If you like please follow and comment

Linux|Functions|Shell Scripting If you like please follow and comment

Linux|While and Until Loop |Shell Scripting If you like please follow and comment

Linux| CASE statements| Shell Scripting if you like please follow and comment

Linux |grep and egrep Commands If you like please follow and comment

Linux|Shell Scripting|Variables If you like please follow and comment

Linux|Shell Scripting|Arrays If you like please follow and comment

EBS Tables with suffix as _ALL, _TL, _B, _F, _V, _VL, _S, _A, _AVN and _ACN _ALL  These are Multi-org tables where we can see data for all operating units. Ex: oe_order_headers_all, oe_order_lines_all, po_headers_all ap_supplier_sites_all _TL These are translated tables which have the translated value for each installed language. These are tables corresponding to another table with the same name minus the TL.  These tables provide multiple language support.  For each item in the table without TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column. Ex: fnd_responsibility_tl, oe_transaction_types_tl _F These are date tracked tables which occur in HR and Payroll. In these tables there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap. Ex: per_all_people_f, per_all_assignments_f _B These are the BASE tables.  They are very impor...

FND_RESPONSIBILITY_VL not showing data for you in EBS VL views are for multi-language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV('LANG').  FND_RESPONSIBILITY_VL which combines two tables: APPLSYS.FND_RESPONSIBILITY and APPLSYS.FND_RESPONSIBILITY_TL ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' select * from fnd_responsibility_vl you will see data now If you like please follow and comment

Shell Script Example- Write a script to calculate BMI Script: #!/bin/bash #Written by Himanshu #set -x  read -p "enter the weight in kg:" wgt  read -p "enter the height in meter:" mtr  y=`expr "scale=2; $mtr * $mtr" | bc` BMI=`expr "scale=2; $wgt / $y" | bc` if [ 1 -eq "$((echo "$BMI < 18.5") | bc)" ]     then        echo "you are underweight"   elif [ 1 -eq "$((echo "$BMI > 18.5") | bc)" ] && [ 1 -eq "$((echo "$BMI < 24.5") | bc)" ]     then        echo "you are normal"      elif [ 1 -eq "$((echo "$BMI > 25") | bc)" ] && [ 1 -eq "$((echo "$BMI < 29.9") | bc)" ]     then          echo "you are overweight"     else          echo "you are obese"     fi If you like please follow and comment

You Are Trying To Access a Page That Is No Longer Active. The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed Error: In R12.1.3 instance we were getting the below error as soon as  you log in : You Are Trying To Access a Page That Is No Longer Active. The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed Cause: It was pointing to the wrong domain SQL> select session_cookie_domain from icx_parameters; .lab.training Solution Update it to Null update icx_parameters set session_cookie_domain=null; commit; Restart Apache services If you like please follow and comment

Linux |Tee Command If you like please follow and comment

Forms giving Invalid Username Password for EBS R12 after upgrade to 19c Database After Upgrade to 19c database for my EBS environment getting invalid username/password error when opening forms. Error: ORA-1017 when opening Forms and ORA-1017 Invalid username/password; logon denied FRM-41352 failed to create a new session Cause:   Mis-configuration with the listener and registration of services: Solution: 1. In 19c database service_name parameter should be set to container name      Connect to the CDB and run the following commands:         alter System set SERVICE_NAMES='<CDBNAME>' SCOPE=BOTH;         alter system register; 2. Verify that the PDB database is registered with the  listener       Connect to PDB and check value of local_listener parameter. It should be not be set at PDB level and should be same as CDB value. 3. PDB should have at a minimum of these services in 12.1 and 12.2.   select ...