Abdul Hafeez Kalsekar -- Oracle database tuning case studies

  TEST

 Upgrading Oracle E-Business Suite from 11.5.10.2 (11i) to 12.2 is a major technical and functional upgrade. Oracle supports a direct path from 11.5.10.2 CU2 → 12.2 , but you must first meet the required baseline patch and database levels. Activity Usually Owned By EBS upgrade execution Apps DBA Database upgrade DBA WebLogic / Apache config Apps DBA / Middleware DNS updates Infra / Network Load balancer VIP switch Infra / Network / F5 team Smoke testing Application / Functional team User validation Business users Here’s a practical high-level manual upgrade sequence typically followed by DBAs and Apps DBAs. 1. Verify Source Environment Confirm: EBS version = 11.5.10.2 CU2 Database version minimum = 11.2.0.4 OS version certified for 12.2 Required disk space Backup strategy tested Run: SELECT release_name FROM fnd_product_groups; Check DB version: SELECT * FROM v$version; Oracle requires DB 11.2.0.4 or higher before 12.2 upgrade. 2. Apply Mandatory 11i ...

  For Database Administrators (DBAs), ISO/IEC 27001 (often loosely referred to as ISO 2700) provides the gold standard framework for securing organizational data . The core goal is to protect databases from breaches, unauthorized access, and data loss by strictly maintaining the Confidentiality, Integrity, and Availability (CIA) of information.  Understanding the standard's impact involves looking at four core pillars: 1. Access and Identity Control Principle of Least Privilege: Grant permissions only to the extent required for users to perform their jobs. Privileged Access Rights (Annex A 8.2): Limit super-admin privileges (e.g., sysadmin or root ) to an absolute minimum and closely monitor their usage. Segregation of Duties: Ensure developers and DBAs cannot push code/schema changes to production without peer reviews or management approval  2. Data Protection and Masking Encryption: Protect data at rest (using Transparent Data Encryption) and in transit (using TL...

  Interview Questions :  1) What are latest version  11.5.10.2  to 12.2 https://anjaniappsdba.blogspot.com/2018/12/ebs-upgrade-from-11i115102-to-1225-or.html 2)  Difference between ERP /SCM /CRM CRM -- Sales  ERP - Finance  SCM - Market distribution  3)  What  is default port for EBS  8000 4)   How do you  upgrade from 11.5 to 12.2  https://anjaniappsdba.blogspot.com/2018/12/ebs-upgrade-from-11i115102-to-1225-or.html https://abdul-hafeez-kalsekar-tuning.blogspot.com/2026/05/oracle-ebs-upgrade.html Tools and Utilities Used  1) Installation :  Rapid Install  2) Upgrade :  Rapid Install , adop , adpatch  , rapidwiz  3) Cloning  :  Rapid clone  4) Other  tools :  Ad utilities , FNDCPASS , AFPASSWD  5) Management :   Oracle Application manager  6) Backups :  rman , manual ( copy or tar )  7) Patching  adpatch , adop  ,...

  NoSQL, standing for “not only SQL,” refers to databases that store and manage data differently than relational databases. NoSQL databases are designed to handle unstructured data and are known for their flexibility. They can be categorized into four main types: document, key-value, wide-column, and graph databases. Key Features: Unstructured Data: NoSQL is suitable for unstructured or semi-structured data. Scalability: These databases offer horizontal scalability. Schema-less: NoSQL databases do not require a fixed schema. Database transactions imply ACID properties, where “I” stands for isolation and concurrency control.  ( Used to control deadlock )  The (serializable) isolation property ensures that the result of concurrently executed transactions is the same as if they had been executed in some serial order. Many DBMSs provide weaker isolation levels for performance reasons, leaving it up to the application developer to choose the proper one. Moreover, a weaker is...