In this post, we will discuss password file in oracle,oracle password file utility orapwd, how to create a password file in oracle , create password file in RAC Introduction to ORAPWD How to create password file in oracle Creating a password file, via orapwd, enables remote users to connect with administrative privileges. Here is the […]
Oracle password file Utility :ORAPWD Read More »
As part of learning the Oracle SQL tutorial, Here is good detail on the Aggregate functions in oracle Aggregate functions in oracle/Group Functions Group Functions unlike single value functions operate on the set of rows and return one row per group. The set of rows may be a whole table or the table split into groups
Aggregate functions in oracle Read More »
In this post, we will be discussing opatch, How to check the opatch version or opatch version command, apply the patch(opatch apply), Upgrade, opatch lsinventory etc How to check the opatch version(opatch version command) we can check the opatch version using the below command Log in to the Oracle Database serverSource the Oracle Home$ORACLE_HOME/OPatch/opatch versionOracle
opatch version command, apply the patch, Upgrade,lsinventory Read More »
We sometime might see accounts getting locked in the Oracle Database. This may be because of failed login attempt due to the wrong password. So we often look at How to check failed login attempts in Oracle. Let’s discuss those below How to check failed login attempts in Oracle we can find the failed login
How to check failed login attempts in Oracle Read More »
We have already read about the Oracle cursor in the below post What is the cursor in oracle Let’s check about the oracle cursor for loop. How it is beneficial and How to use it in PLSQL Oracle Cursor FOR Loops in oracle 1)The cursor FOR loop is a shortcut to process Explicit cursors 2)
What is oracle cursor for loop Read More »
We will discuss the difference between the Oracle database and Oracle instance in this post What is Oracle Database Oracle database is comprised of a set of operating system files containing data entered by users or applications and structural information about the database itself called database metadata. Information is stored persistently in these files. A
Oracle Database and Oracle Instance Read More »
