ORA-12505: TNS:listener in Oracle

Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]

Read More

How to Purge Listener Log in Oracle

Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database […]

Read More

Server Pools in Oracle RAC

Before Release of Oracle Clusterware 11g release 2, we define a specific instance belong to specific node.a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster. And it is pretty well with small no of nodes in your RAC database. But when no of nodes […]

Read More

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.       Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]

Read More

Log Shipping in Oracle

In this article we will learn DR creation with log shipping : Prerequisites : Source Database should be in Archive log mode . Enable Archive Log Mode In Oracle RAC Details : Database Name Source DB IP DR DB IP mgr 192.168.1.10 192.168.1.181 Step 1 : To create log shipping DR server force logging and […]

Read More

How to Check/Validate That RMAN Backups Are Good

From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms.     Some of […]

Read More

Patch 27107360 – Oracle Grid Infrastructure PSU 11.2.0.4.180116

Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]

Read More

ORA-01450: maximum key length (3215) exceeded

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem. 06:19:09 [SYS][TEST]>> ALTER index TEST.IDX_NEW rebuild online; ALTER index […]

Read More

Types of Supplemental logging at Database level

Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]

Read More

Downgrading Grid Infrastructure from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle RAC Database from 12c to 11gR2. In this article, we are going to downgrade Oracle Grid Infrastructure from 12c (12.1.0.2) to 11gR2 (11.2.0.4) which contains two nodes ( node 1 & node 2). Before doing CRS downgrade we need to take backup of following files : Take tar […]

Read More