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 […]
DATABASE
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) create table DBACLASS ( DBANO number(4), eDBANAME varchar2(30), […]
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. $ ps -ef | grep lreg oracle 3536 105780 0 17:21 pts/5 00:00:00 grep lreg oracle 95761 1 0 Oct26 […]
Find the active transactions in oracle database
Below script can be used to find the active transactions in the oracle database. col name format a10 col username format a8 col osuser format a8 col start_time format a17 col status format a12 tti ‘Active transactions’ select s.sid,username,t.start_time, r.name, t.used_ublk “USED BLKS”, decode(t.space, ‘YES’, ‘SPACE TX’, decode(t.recursive, ‘YES’, ‘RECURSIVE TX’, decode(t.noundo, ‘YES’, ‘NO UNDO […]
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: ./emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 […]
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 conn / as sysdba SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ AWR reports can be generated in the following […]
Compile Invalid objects in oracle
Objects in the database can become invalid, if there are any changes to the dependent objects. Even patch and upgrade can also make the object invalid. Compiling the invalid objects can make them valid if they are eligible. Below is the query to find the invalid objects currently present in the database. set pagesize […]