Posts

Azure interview questions

  Skills :  Good Experience in Sql server Backup & Recovery scenarios and worked on Azure backup Creating database on Azure on DTU basis using right tiers  Monitoring Azure sql database uisng DMV and Monitoing Azure data factory using Azure monitor .  Sample resumes :  https://www.hireitpeople.com/resume-database/87-sql-developers-resumes/259508-sql-azure-sql-dba-resume-stamford-ct Questions :  1)  A company wants to migrate 120 applications to the cloud. Budget is limited. Downtime must be close to zero. Interview Questions Where would you begin? Which applications would migrate first? How do you minimise downtime? What security challenges concern you? AWS, Azure or Hybrid—how would you decide? Which KPIs matter most? How do you estimate migration costs? What mistakes do organizations make? What would your migration roadmap look like? What defines cloud success? 💬 Cloud Architects, share your strategy
Post a Comment
Read more

Ebs online patch using adop

Image
  TEST
Post a Comment
Read more

Oracle Ebs upgrade

 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 ...
Post a Comment
Read more

ISO 2700 For Database administrators

  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...
Post a Comment
Read more

Oracle Apps Dba interview questions

  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  ,...
Post a Comment
Read more