Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

RANK, DENSE_RANK and ROW_NUMBER :Oracle Analytic functions

Oracle Analytic functions compute an aggregate value based on a group of rows called window which determines the range of rows used to perform the calculations for the current row. Following are most used Analytic functions. – RANK, DENSE_RANK and ROW_NUMBER – LAG and LEAD – FIRST_VALUE and LAST_VALUE I would be discussing about RANK, DENSE_RANK and ROW_NUMBER analytics functions Here is the general syntax … Continue reading RANK, DENSE_RANK and ROW_NUMBER :Oracle Analytic functions »

Analytic function in oracle

This post is part of SQL tutorial and we would be discussing Analytic function in oracle with examples, detailed explanation . We have already studied about Aggregate function like avg ,sum ,count. Lets take an example select count(*) from EMP; select sum (bytes) from dba_segments where tablespace_name=’TOOLS’; select deptno ,count(*) from emp group by deptno; SQL> desc emp Name Null? Type —————————————– ——– —————————- EMPNO … Continue reading Analytic function in oracle »

How to apply the technology patches to EBS R12.2

We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches  to the R12.2 tech stack. We can apply the same online patching cycle for the below technology patches a. Weblogic … Continue reading How to apply the technology patches to EBS R12.2 »

5 Tests Your Dissertation Must Pass to Be Submitted Finally.

The dissertation is a serious and voluminous scientific work. The list of key requirements for it is very long. And even when you cope with all the questions in the content of the work, it is very easy to get lost in the formatting requirements. So, after you have written everything in your final paper, test it thoroughly. Check once again fit corresponds to all … Continue reading 5 Tests Your Dissertation Must Pass to Be Submitted Finally. »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »

Top and most common OPATCH issues in Windows server

Here are the 4 Top and most common  OPATCH issues in Windows server Issue 1 OPatch cannot find a valid oraInst.loc file to locate Central Inventory. OPatch failed with error code = 104 Cause On UNIX-based systems, OPatch uses an oraInst.loc file to determine the location of the central inventory. On Windows, this is done by a registry entry instead: the key is Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\inst_loc. On … Continue reading Top and most common OPATCH issues in Windows server »

How to solve ORA-28000 the account is locked

Last updated on March 22nd, 2019 at 05:38 pmWe often come across the error ORA-28000 the account is locked. Reasons This can happen due to multiple reasons a. Oracle DBA has purposely locked the account alter user <username> account lock; select status from dba_users where username=’&1′; b. Wrong password has been attempted many times resulting in locking. The number of FAILED_LOGIN_ATTEMPTS  can be found using … Continue reading How to solve ORA-28000 the account is locked »

RMAN Backup commands

Last updated on March 9th, 2019 at 04:07 amWe can use RMAN to backup all the parts of the oracle database. RMAN backup command can be used backs up Oracle database files, copies of database files, archived logs, or backup sets. Here is the general syntax for RMAN backup command Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options BACKUP INCREMENTAL LEVEL [=] … Continue reading RMAN Backup commands »

RMAN List backup commands

Last updated on April 11th, 2019 at 05:28 pmRMAN List backup is a useful command to list the backup taken in the system.It shows all the details about the backup taken,what time it was taken, location of the backup. LIST BACKUP List all the backup taken in the system RMAN> LIST BACKUP; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed … Continue reading RMAN List backup commands »

Useful Oracle provided sql scripts for R12.2

All the below scripts are present in $AD_TOP/sql ADZDDBCC.sql This sql is for database compliance checker, shows violations of the database object development standards described later in this document. Warning: this script takes a long time to run. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDDBCC.sql ADZDSHOWED.sql This sql show database editions and current edition. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDSHOWED.sql Edition Name Type Status Current? ————— ——– ——– ——– ORA$BASE … Continue reading Useful Oracle provided sql scripts for R12.2 »