New feature in Oracle 11g database to kill session

Now we can kill session after finishing existing transaction to be finished. Means in previous release there was no scope to finish on going transaction. Instead of “alter system kill session” here we can use “alter system disconnect session”. Using syntax “POST_TRANSACTION” we can kill session for active transaction has to be completed first and […]

Read More

Feature Enable In Oracle

Note: Just illustration for fun It in fact violates the license. This is only study purpose. All Features are enable in EE (Enterprise Edition). Actually some features not enabled, if you are using Oracle SE (Standard Edition). Follow the point to see the feature is enable or not in  (SE) . In my case 1. […]

Read More

Oracle Exadata X5 Administration (1Z0-070)

Hi Readers Finally, I’ve successfully passed 1Z0-070, Oracle Exadata X5 Administration. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 90 questions related to Exadata X5 and X6. To earn this certification you need to get 60% marks. This was the result of the journey: Oracle Certified Expert, Oracle […]

Read More

How to connect to ASM Instance Remotely

Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate […]

Read More

Understanding and managing client connectivity

While managing Data Guard Standby databases in our environment one of the key responsibility of DBA is End-user connectivity to a proper database or we can say clients connect to the correct database even in case of failover. To know Oracle DataGuard Oracle Dataguard Architecture   Your client connectivity should be managed in such a […]

Read More

Recover Data File in Primary Database in Data Guard Environment

Recovering Data File in Primary Database from the standby database. You have two approaches for data file restoration when your data file gets corrupted or deleted in data guard environment. Restore from RMAN backup Recover it from Standby Database. In our routine, we use the first approach where we simply restore it using RMAN restore command […]

Read More

Highly Available VIP (HAVIP)

Highly Available IP (HAIP) comes from 11.2.0.2 on-words and maximum 4 define for Private network Now in 12c version introduces Highly Available VIP (HAVIP) a Clusterware-monitored VIP that can be used for non-Database applications. Typically, VIPs are created for VIP or SCAN listeners for Database connections. In some cases, the need arises to create a […]

Read More

rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

In My Case Cause of below the issue at storage level. failing currently due to LVM inconsistency Below screenshot where CRS services are running on another node. iocp0 is now available on pdb02   Ref: AIX 12.1.0.2 Installation Fails with “rtld: 0712-001 Symbol CreateIoCompletionPort was referenced ” (Doc ID 1949184.1)

Read More