How to see Last added datafile in Oracle
Introduction We will see how to find the last added datafile in oracle Posted by Arun Below query will give you the last added datafile in oracle. This will be useful…
Read MoreSYSADMIN login taking long time to log in
Introduction Solution for sysadmin taking long time to login Posted by Arun Sometimes, SYSADMIN login in particular instance will take long time to log in as it will have open workflow…
Read MoreERROR: Invalid username and/or password LOG: Local Authentication failed…Attempt PAM authentication…PAM failed with error: Authentication failure
Introduction Solution to fix Invalid username and/or password LOG: Local Authentication failed Attempt PAM authentication Issue: Got the following error while setting preferred credentials for the host target ERROR: Invalid…
Read MoreMDB application XXXX is NOT connected to messaging system
Introduction Solution for MDB application is not connected to messaging system Posted by Mahendran This can be avoided by using the parameter below <start-mdbs-with-application>false</start-mdbs-with-application> In the weblogic-application.xml, Setting start-mdbs-with-application to…
Read MoreHow to deconfig oracle rac grid installation, deinstall oracle rac grid
Introduction: We will see how to uninstall oracle rac grid Posted by Karthik Steps to deinstall wrongly installed oracle RAC GRID. [root@test ~]# cd /u01/app/grid/crs/install/rootcrs.pl -deconfig -force [root@test ~]# rm…
Read MoreSteps for tuning Redo logs and Checkpoints (Contention, Waits, Number/Duration of Checkpoints)
Introduction: Steps for tuning Redo logs and Checkpoints Posted by Sandeep 1). Redolog Buffer Contention —————————– SELECT SUBSTR(name,1,20) “Name”,gets,misses,immediate_gets,immediate_misses FROM v$latch WHERE name in (‘redo allocation’, ‘redo copy’); Name …
Read MoreOEM Agent Upgrade From 12 1 0 1 to 12 1 0 3
Introduction We will see how to upgrade OEM Agent From 12 1 0 1 to 12 1 0 3 Posted by gopinath 1.1) Steps to Upgrade target OEM agent from 12.1.0.1…
Read MoreOPP “outofmemory” best practices
Introduction OPP “outofmemory” best practices Posted by gopinath OPP “outofmemory” best practices The “outofmemory” error occurs – when the Output Post Processor does not have sufficient heap size per process defined…
Read MoreOpatch lsinventory or Apply Output Issue Because of Lock File
Introduction We will see how to Apply Output Issue Because of Lock File or Opatch lsinventory Posted by Selvakumar Raja When performing command “opatch lsinventory or opatch apply” in oracle RDBMS…
Read MoreTuning SQL Statements Using SQL Tuning Advisor (without Enterprise Manager)
Introduction uning SQL Statements Using SQL Tuning Advisor Posted by Arun Tuning SQL Statements Using SQL Tuning Advisor (without Enterprise Manager) Below are the steps to use SQL Tuning Advisor for…
Read More