DATABASE

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 […]

Hash partitioning in oracle

Hash partitioning is one of the partitioning method, where hash algorithm is used to distribute data equally among multiple partitions. It is usually used for large tables, where we can’t use RANGE key, and column contains lot of distinct value. EXAMPLE: TABLE WITH HASH PARTITION:(WITH PREDEFINED PARTITION_NAME)

TABLE WITH HASH PARTITION:(WITH DEFAULT PARTITION_NAME) […]

How to get block size of redologs in oracle

We all know about the database block size. Remember db_block_size. But where the redo block size is defined.??? Answer is -> Redo block size is platform specific . It will the take the default value depending upon the operating system. The easy way to find redo block size is to get trace of redolog and […]

LREG Background Process in oracle

Prior to 12c, PMON process used to handle the instance registration with listner, From oracle 12c, a new background process called lreg takes care of this instance registration, Which reduces the load from pmon process.

Basically, LREG process does below things. 1. Registers instance information with the listener. 2. It is a critical background […]

Find the active transactions in oracle database

Below script can be used to find the active transactions in the oracle database.

How to change http port of EM dbconsole

By default , when we setup enterprise Manager database console(dbconsole), 1158 port will be configured. But we can change this port easily using emca utility. In the below example, we will change the port from 1158 to 7100 1. Check the current dbconsole details:

Currently the port is 1158 . https://prodb:1158/em/console/aboutApplication 2. Invoke emca […]

How to generate AWR report in oracle

The Automatic Workload Repository (AWR) collects and maintains statistics of the database. We can generate awr report for a particular time frame in the past using the script awrrpt.sql ( located under $ORACLE_HOME/rdbms/admin) script – @$ORACLE_HOME/rdbms/admin/awrrpt.sql

For rac databases, the script awrrpt.sql script need to be run again each instance.   For NON-SYSDBA USERS, […]

Page 1 of 512345
Skip to toolbar