Articles Comments

AskDba.org Weblog » Archive for November 2008

How To Change/Restore User Password in 11G

November 21st, 2008 | 5 Comments

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 password field in dba_users is empty. Prior to 11g we could use following technique to change/restore password SQL> create user amit identified by amit; User created. SQL> grant create session to amit; Grant succeeded. SQL> conn sys as sysdba Enter password: Connected. SQL> select username,password from dba_users where username='AMIT'; USERNAME PASSWORD ------------------------------ ------------------------------ AMIT 9DEC0D889E8E9A6B SQL> alter user amit identified by abc; User altered. SQL> conn … Read entire article »

Filed under: database, oracle

Tom Kyte Seminar in Bangalore, India

November 18th, 2008 | 5 Comments

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 P.U. College Bangalore – 560 025 SEMINAR TOPICS Storage Techniques Effective Indexing Reorganizing objects If you register before 20th November, you can save Rs 1000 You can find details here … Read entire article »

Filed under: database, oracle

10g RAC Tuning :Useful Link

November 5th, 2008 | Add a Comment

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 RAC (Real Application Clusters) Databases. Must watch for anyone who is learning RAC. You can find the recorded webcast here. You can also become member of oracleracsig to find many such webcasts/resources on RAC. … Read entire article »

Filed under: oracle, rac