Modern Oracle DBA

1. Disk and File System Checks Objective: Monitor disk usage and verify file system configurations. Commands and Steps:   View Disk Space Usage: Command:  df -h Verify the available and used space in a human-readable format.   Check File System Configurations: Command:  cat /etc/fstab Ensure all required file systems are configured to mount at boot.   Verify Permissions of fstab File: Command:  ls -ld /etc/fstab Check permissions to ensure security and avoid unauthorized changes. 2. Network Configuration and Connectivity Objective: Validate DNS configurations and network routes. Commands and Steps:   Verify DNS Resolver Permissions: Command:  ls -ld /etc/resolv.conf   Display DNS Server Configuration: Command:  cat /etc/resolv.conf   Check Kernel Routing Table: Command:  ip route Confirm active routes for ...

When working with Oracle E-Business Suite (EBS) R12.2, granting privileges to applicatation objects requires special care to avoid invalidating objects in the current edition.  Grants cannot be performed in the run edition when the application is being used. A direct GRANT (DDL) command can potentially cause object invalidation when the application is actively being used. To handle this in a more controlled manner, Oracle introduced the AD_ZD.GRANT_PRIVS utility. Why Use AD_ZD.GRANT_PRIVS? In Oracle EBS R12.2, all grants should be performed using the AD_ZD.GRANT_PRIVS procedure rather than the traditional GRANT statement.  The reason is simple: the GRANT statement directly modifies objects in the database, and this can invalidate them in the current edition. Invalidations during runtime can cause service interruptions, which is unacceptable in a live system. Syntax for Granting and Revoking Privileges The AD_ZD package provides two p...

 When you managing resources(Storage,Network,etc) in Oracle Cloud Infrastructure (OCI), understanding how to effectively use compartments, users, and groups is crucial. These elements help you organize, control access, and manage resources efficiently. What is a Compartment? A compartment in OCI is a logical container to organize and control access to your resources, such as compute instances, networks, and load balancers. Here's how you can use compartments: Compartments: Create Policies : Write policies to protect resources in specific compartments. Business Requirement s: Based on your needs, you can create multiple compartments (e.g., Finance, HR, Network). Management : For finance compartment can help manage all finance-related projects. Key Points About Compartments 1.  Root Compartment : When you create a cloud account, a root compartment is created automatically. 2.  Global Sharing : Compartments are global, meaning you can share them across regions (e.g.,  ...

Cloud services Models  Here we will see the simple definaltion and concepts for cloud service models. Saas Software as a services Paas Platform as a service Iaas Infrastructure as a service.   Exactly how each service differs from the other is shown in the diagram below. Traditional on-premises Everything is handled by the client. For example, we need to manage complete servers and applications, networks, operating systems, and so on. Infrastructure as a service Infrastructure side managed by the cloud vendor ex(Oracle, azure, aws) and application data Middleware and OS clint responsibility For example, it is the client's duty if an OS patch needs to be applied. Vendor responsibility if any N/W or storage-related setups   Platform as a service: - A cloud vendor will offer the services on any platform required to operate the application. Ex:...

Encountering configuration issues post-cutover. However, here's a straightforward solution to resolve these errors efficiently. Follow these steps to modify the config.xml file and get your system back on track. Solution:  Go to config.xml locatation and take backup for the "config.xml" file cd /apps/applmgr/r12/fs1/FMW_Home/user_projects/domains/EBS_domain/config/ ls -ltr config.xml cp config.xml config.xml_bkp Search the config.xml file in " connection-filter-rule " Change the value " deny "  to " allow " [applmgr@vtebstest config]$diff config.xml_bkp config.xml 33d32 <     <OTM >vtebstest.appl.com * * allow </connection-filter-rule> 35d33 <     <connection-filter-rule>0.0.0.0/0 * * deny </connection-filter-rule> [applmgr@vtebstest config]$ Save the config.xml file and bounce the adadminsrvctl.sh Login weblogic page and retest the issue

 Login to the DB Server and execute below commands Copy SQL> select count(*) from WRH$_ACTIVE_SESSION_HISTORY; COUNT(*) ------------------ 0           Copy SQL> alter system set "_ash_enable"=false; System altered.   Copy SQL> alter system set "_ash_enable"=true; System altered.   Login in to OEM and Retest the issue Reference:- OEM Top Activity Graphs Are Not Displayed (Doc ID 2229483.1)