DATABASE

how to change archivelog destination in oracle

If your present archivelog mountpoint is FULL or for any other reason, you want to change the archivelog destination in the database, then follow the below steps. NOTE – > It can be done ,when the database up are running. No downtime required.  FOR STANDALONE DATABASE: 1. Find the current archivelog location:

create the […]

Invisible index in oracle database

Invisible index is introduced in oracle 11g. As the name suggest, this type of index will be ignored by database optimizer, as if it doesn’t exists. EXAMPLE: —  CREATE AN INDEX ( BY DEFAULT THE INDEX WILL BE A VISIBLE ONE)

Check the explain plan:

As expected optimizer is using the index for […]

Restart MMON process in oracle database

The job of MMON( Manageability Monitor) background process is to perform tasks like taking AWR snapshots and automatic diagnostic analysis. Sometime, MMON process crashes or get suspended . Follow below steps to restart the MMON process: 1. Grant restricted session to public: This grant is required to avoid any impact on the sessions connecting to […]

How to move controlfile to a new location in oracle

Below are steps to move or rename controlfile to a new location(Mount point or diskgroup). In ORACLE RAC:(Move from +ORACLDG diskgroup to +DATA diskgroup) 1. Get the current control_file location

2. Set the new location of controlfile:

3. start the database in nomount stage:

4. Restore controlfile to new location:

5. […]

How Recyclebin in oracle database works

Like windows have recyclebin, Oracle database has also provided recyclebin, which keep all the dropped objects. When we drop a table(DROP TABLE TABLE_NAME) in the database, the tables will logically be removed, but it still exists in the same tablespace but with a prefix BIN$$. And it will not release the space also. NOTE – The […]

How to install oracle client in silent mode using response file

Though GUI is a preferable method to do client installation, But sometimes DBAs might be not to be able to xmanager to enable GUI for the server. In that case, installation using response file will be useful. In this example, we will do the installation of Oracle client 12.1.0.2 version. 1. Download Oracle client software […]

Steps to Apply PSU patch on oracle 11g database

Below are the steps for applying quarterly PSU patch on Oracle 11g database. 1. Download the patch from Oracle support portal.   2. Validate patch version: opatch utility is used to apply patches to the database. So before applying patch, we need to check whether the existing opatch version is supported for the patch or […]

How to create listener using NETCA utility

This article explains the steps for creating a listener using NETCA GUI utility. NOTE – > utility need to execute from XMANAGER/XSHELL(From where we can call GUI),Just like DBCA or DBUA utility. 1. Set appropriate ORACLE_HOME as per requirement( EITHER GRID HOME OR ORACLE DB BINARY HOME) export ORACLE_HOME=/oracle/app/oracle/product/12.2.0/dbhome_3 export PATH=$ORACLE_HOME/bin:$PATH 2. execute NETCA   […]

SETUP ORACLE 18C DATABASE – STEP BY STEP

Recently Oracle has released its Oracle 18c in premise version.(previously it was only for oracle cloud). This release has lot of new features, which need to to be explored.   So let’s start with Oracle binary installation and database creation. Download the Oracle software from oracle website.(DOWNLOAD LINK)   Copy the software to your server and unzip […]

GLOBAL_NAMES parameter and database link in oracle

GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects. GLOBAL_NAMES is either set to FALSE OR TRUE. If the value of GLOBAL_NAMES is false, then any name can be given to DB_LINK. If value is TRUE, then database link name should be same as […]

Page 1 of 612345...Last »
Skip to toolbar