How To Change/Restore User Password in 11G
Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) and reset it back to old , you will find that…
Read Full RecipeAuthor: Amit Bansal
Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions.
Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
Tom Kyte Seminar in Bangalore, India
All India Oracle user Group (AIOUG) has arranged for Seminar by Tom Kyte on 18th December 2008. Venue- The Good Shepherd Auditorium Residency Road- Museum Road Junction Opp. St. Joseph's…
Read Full Recipe
10g RAC Tuning :Useful Link
I came across useful link which contains 10g RAC Tuning tips from Joel Goodman (Oracle). It discusses RAC Instance Recovery concepts and key things to look out for while tuning…
Read Full Recipe
Full Database Export Failing With ORA-00980
While trying to do a full export for 10.2.0.3 database, we were getting following errors About to export the entire database ... . exporting tablespace definitions . exporting profiles .…
Read Full Recipe
Question:Sizing ASM LUN
We received following question from Mr Orlando through our Contact Page How about a discussion on how to size our LUNS to use with ASM. For instance we have a…
Read Full Recipe
Issues with CLUSTER_DATABASE parameter
Yesterday, I faced an interesting scenario while upgrading 2 Node RAC Database. I tried setting up CLUSTER_DATABASE=FALSE in spfile from Node 1,but it displayed value as TRUE after restarting database.Same was…
Read Full Recipe