ORACLE DBA

  Concurrent Manager The concurrent managers serve important administrative functions. The concurrent managers ensure that the applications are not overwhelmed with requests, and the second areas of functions are the management of batch processing and report generation. In The Oracle e-Business suite has three important Concurrent Managers:   Internal Concurrent Manager:  The ICM (Internal Concurrent Manager) controls all of the other concurrent managers. Standard Manager:  The Standard Manager accepts any and all requests.  It has no predefined specialization rules and is active all the time.  It is not recommended to add specialization rules to the standard manager as it can cause problems. Conflict Resolution Manager:  The Conflict Resolution Manager resolves conflicts, such as request incompatibilities. How to check concurrent manager running or not? Log in to applications as System Administrator responsibility and navigate to the concurrent > m...

Oracle E-Business Suite Release 12.2 installation comes with a new feature called “Online Patching” with two editions (versions) of the application code and seed data. The file system contains two complete copies of the Oracle E-Business Suite and technology files. In the database, we use the Edition-based Redefinition feature to create a new database edition for each online patching cycle. The "Run Edition" is the code and data used by the running application. As a developer, you will connect to the Run Edition whenever you are engaged in normal development activity on the system. The "Patch Edition" is an alternate copy of Oracle E-Business Suite code and seed data that is updated by Online Patching. The Oracle E-Business Suite application-tier files are installed in a root directory of the customer's choosing. Within that root directory you will now find three important sub-directories: 1) How to see, the RUN, PATCH & NON-EDITIONED Filesyste...

 Major diff between Oracle EBS R12.1.3 and Oracle EBS R12.2.4 ==> In R12.2 we have two kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where as In R12.1.3 we only deal with one application filesystem. ==> In R12.2 we have the Application servers replaced by Weblogic server to manage the technology statck.        The 10.1.3 Home is replaced by FMW i.e $FMW_HOME ==> In R12.2 is involvement of Weblogic server to manager all the forms,oacore servers. ==> In R12.1.3 we had the Application server 10.1.3 to manage the web home or Java Home. ==> The adpatch(patching) in R 12.1.3 is replaced by adop (online patching) in R 12.2.4 ==> adop online patching utility doesn't require downtime. It involves minimal downtime during cutover phase where switching of filesystems happens. We can apply lot of patches and do cutover any time to minimize downtime ==> In adpatch we just apply patch most of the times by bringing down applications or i...

Oracle 12C Features: 1. Online migration of an active data file 2. Online table partition or sub-partition migration 3. Invisible column 4. Multiple indexes on the same column 5. DDL logging 6. Temporary undo in- and- outs 7. New backup user privilege 8. How to execute SQL statement in RMAN 9. Table level recovery in RMAN 10. Restricting PGA size Oracle 18C Features: 1. Integration with Microsoft Active Directory 2. Schema Only Accounts 3. Server Draining Ahead of Planned Maintenance 4. Automatic In-Memory 5. SQL Cancel Oracle 19C Features: 1. Automatic Indexing. 2. Real-Time Statistics. 3. Active Data Guard DML Redirection. 4. Automatic Resolution of SQL Plan Regressions. 5. Finer granularity Supplemental Logging. 6. Dry-Run Validation of Clusterware Upgrade. 7. AutoUpgrade for oracle database. 8. Oracle network log file segmentation.

FAQ's  Oracle GoldenGate 12c: Part I This post covers common uestions related to Oracle GoldenGate 12c that we get freuently from our trainees from our training Oracle GoldenGate 12c Administration. If you are new to Oracle GoldenGate then I highly recommend you to look at Oracle GoldenGate 12c Overview & Components and Oracle GoldenGate 12c Download & Installation  Common uestions on Oracle GoldenGate Few uestions on Oracle GoldenGate 12c raised by our trainees from our training Oracle GoldenGate 12c Administration: 1: What is the OGG s/w version to use if source DB is Oracle 12c R2 and platform Linux and destination is DB2 10.1 (32-bit) with 32-bit OS. Does it mean we have to download and install separate OGG software versions at source and target servers? Will they be able to communicate with each other? A1: In any case, you will have to install and configure Goldengate on both target and source even if versions are same. however, they will be two separate binaries....