Modern Oracle DBA

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 primary pr

 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.,       Ashburn, UK

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: Oracle of

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)

Here I have collected the List of good Oracle Apps DBA interview Questions/Answers. How Many Oracle homes there in R12.2? Oracle 10.1.2 home and Oracle fusion middleware home oracle application is running on top of the FMW home. What is EBR? Edition based redefinition is R12.2 online patching new fecture. EBR has been introduced in 11g R12 database EBR is allows multiple version of plsql objects views and synonyms in single schema. EBR is enabled via database users and all EBS users including custon schemas. While running adadmin What is batchsize parameter in EBS? It means number of rows to commit at one time to the Database.  What is multi ligual tables in ebs? EBS applications allow users to create their programs in a variety of languages.   Ex:-   If table name ending with "_TL" those tables are corresponding to another table with same name minus the _TL those tables provide the multiple language support.   FND_PROFILE_OPTIONS_TL FND_PROFILE_OPTIONS

EBS applicatations User access the Oracle Application login page from the below URL http://<URL_HOSTNAME>:<PORT> Ex:- http://vtebs.oracle.com:8000/OA_HTML_AppsLoginin From this URL will be redirected to the central login page, In the http.conf file, locate DocumentRoot. The DocumentRoot is the base location for where the first access the apache file is stored. Locatation :  $FMW_HOME/webtier/instances/EBS_WEB_OHS/config/OHS/EBS_web/ httpd.conf Ex:- DocumentRoot : "/u01/applmgr/DEV/fs1/inst/apps/dev_ebsvis/portal" Under this DocumentRoot folder, index.html will redirect to the application login page. http://<URL_HOSTNAME>:<PORT>/OA_HTML/AppsLogin The application identified the context in OA_HTML and redirected the connection to the OACORE server. The application connects to the database using the APPLSYSPUB user and displays the login page. The password was obtained from the DBC file. The password for APPLSYSPUB is available in two lo

This step requires a minimum version of R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later. TXK 7's functionality has been simplified and largely automated with the introduction of a new utility that handles previously manual procedures. 1. Shutdown the all application tier services except the Admin Server. Primary node, run the below command cd $ADMIN_SCRIPTS_HOME /adstpall.sh -skipNM -skipAdmin Secondary nodes, stop the application services cd $ADMIN_SCRIPTS_HOME /adstpall.sh 2. To change the Oracle WebLogic Server Administration User password, execute the below command on the primary node's run file system. Source the environment on the run file system. perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword 3. Start all services on all nodes, using the command: cd $ ADMIN_SCRIPTS_HOME /adstrtal.sh Reference: How To Change or Reset The WebLogic Administration Password In 12.2 E-Business Suite (Doc ID 1385751.1 )

How to check EBS CPU level Copy Select max (CODELEVEL) "CPU" from AD_TRACKABLE_ENTITIES where ABBREVIATION in ('ebscpu'); How to check AD and TXK Code level Copy Select abbreviation,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','cc_pf','atg_pf','scp_pf' ) order by abbreviation; How to check Patch applied status Copy Select bug_number,creation_date from ad_bugs where bug_number= How to check Installed language in EBS Copy SELECT Language_code, NLS_language, Installed_flag FROM fnd_languages WHERE installed_flag IN ('I', 'B'); I- Installed Language B- Base Language Is System crash/Unable to continue the Adop session  Execute below querys to find which session is causing theissue Copy select adop_session_id from ad_adop_sessions where status='R'; Copy select ADOP_SESSION_ID,PREPARE_

Adop Apply Phase Frequently Using Commands:- How to apply the patch adop phase=prepare adop phase=apply patches=<Patch_Number> adop phase=finalize adop phase=cutover adop phase=cleanup adop phase=fs_clone How to apply Multiple patches  adop phase=apply patches=<Patch1>,<Patch2>,<Patch3> How to apply Merge patch adop phase=apply patches=<Patch1>,<Patch2>,<Patch3>  merge=yes How to apply Patch Run File System/Hot Patch Mode adop phase=apply patches=<Patch_Number>  hotpatch=yes How to apply the patch downtimemode adop phase=apply patches=<Patch_Number>  apply_mode=downtime How to reapply the patch adop phase=apply patches=<Patch_Number>  options=forceapply How to restart the patch from where patch failed adop phase=apply patches=<Patch_Number>  restart=yes How to restart the failed patch from begining adop phase=apply patches=<Patch_Number>  abandon=yes How to ignore the failed patch and apply the new patch adop phase

Prerequest:- DBLink Name Schema name and password Connection string(tnsping SID) Creating Database Link:- Check DBLink is allreday existist or not Copy SQL> Select * from dba_db_links where db_link='db_link_name'; Copy CREATE DATABASE LINK CONNECT TO IDENTIFIED BY USING 'TEST=( DESCRIPTION=( ADDRESS=( PROTOCOL=TCP (HOST=ebstest.vis.com) (PORT=1521) ) (CONNECT_DATA=( SERVICE_NAME=test INSTANCE_NAME=test )) ) )'; If you want to recreate a DB Link first get the source code from the database link before you drop the DBLink Copy SQL>set long 1000 SQL> select DBMS_METADATA.GET_DDL('DB_LINK','DB.DBLINK,'DB.OWNER') from dba_db_links; Connectivity Test:- Copy select * from global_name@DB_LINK_NAME select * from global_name; Drop DB Link: Check the D

1. Download pacthes 2. Patch Alasysis 3. Conflicts check and system space check  4. Backups (GI Home, DB Home and Database) 5. Apply  6. Post checks Download the Patches:- Search the below keyword in metalink to download the CPU Patches Critical patch Update (CPU) Program JAN 2022 Critical patch Update (CPU) Program Apr 2022   Critical patch Update (CPU) Program JUL 2022   Critical patch Update (CPU) Program OCT 2022 I opened for the July patch, and here we need to click Patch availability for Oracle products -> 3.1 Oracle database. Oracle database (3.1) Many Oracle products patches are listed here. I need only Oracle database patches. So, I'll go with the Oracle database 3.1.7 My DB version is 19c So I will choose 3.1.7.3 Oracle database 19c Here I will download the below database patch and grid patch (GI) One interesting fact is that if you download the GI Patch Database patch, it will also come under GI Patch. As a result, there is no need to download a database pat