Oracle

How To Purge The UNIFIED AUDIT TRAIL ?

by

Oracle Database – Enterprise Edition – Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  You can also use the last_arch_timestamp, if you don’t want to purge all the audit record and kept the most recent record: Since Unified Auditing caches the audit trail in memory to implement a … Read more

Patching !!

by

In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single Patch, can you use opatch utility? Yes, you can use Opatch incase of single patch. The only type of patch that cannot be used with OPatch is a patchset. Is it possible to apply OPATCH without downtime? As you know … Read more

SQL Developer

by

SQL Developer is a convenient way for database developers to edit and develop basic tasks using SQL*Plus. SQL Developer is a graphical version of SQL*Plus, written in Java, that supports development in SQL and PL/SQL. You can connect to any Oracle database schema using standard database authentication. SQL Developer enables you to: * Browse, create, … Read more

Parameter Files in Oracle

by

To start a database instance, Oracle Database must read either a server parameter file, which is recommended, or a text initialization parameter file, which is a legacy implementation. These files contain a list of configuration parameters. To create a database manually, you must start an instance with a parameter file and then issue a CREATE … Read more

Running nohup commands

by

The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up signals (SIGHUP) or modifies the process specified with the -p option to ignore all SIGHUP signals. SIGHUP is a signal that is sent to a process when the controlling terminal of the process is closed. … Read more

Split Brain Syndrome in RAC

by

Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private interconnect and end users connects to cluster through public network. When nodes are physically up and running and Database Instance on each of these servers is also running but private interconnect fails between two or … Read more

About Oracle Database Release Numbers

by

Oracle products follow a custom release-numbering and -naming convention. The “c” in the current release, Oracle Database 23c, stands for “Cloud”. Previous releases (e.g. Oracle Database 10g and Oracle9i Database) have used suffixes of “g” and “i” which stand for “Grid” and “Internet” respectively. Prior to the release of Oracle8i Database, no suffixes featured in … Read more

How INSERT Statement get executed in Oracle??

by

1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2. This login credential is accepted by the Listener Process which is present on the server side. 3. PMON checks the authenticity of the user in the data dictionary cache of the Shared Pool. If the … Read more

What Are Root.sh And OrainstRoot.sh Scripts ?

by

The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to oraInventory>/orainstRoot.sh and $ORACLE_HOME/root.sh. After the installation is complete a prompt is diplayed to run these scripts as the root user. The following configuration scripts need to be executed as the “root” user Scripts to be … Read more