Author Archive
Upgrade to WordPress 2.7.1
WordPress 2.7.1 is out..While using upgrade button, it will be stuck at downloading files and will not proceed further. This issue will be faced by people using “Automatic Upgrade” plugin available in prior release. You need to disable the plugin and then re-try [Read More]
Scheduling Job through Cron??
In case you came across this link searching for Cron syntax, then you can refer to following link http://www.adminschoice.com/docs/crontab.htm Other’s can continue reading the article …. This was a problem which I faced yesterday. We had a mview refresh which [Read More]
Creating ASM devices on AIX
I thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA’s. Suppose SysAdmin gives you list of Serial numbers for LUN instead of device Name pcmpath query device DEV#: 33 DEVICE NAME: hdisk33 TYPE: 2107900 ALGORITHM: Load [Read More]
CRS Fails to Start – 10.2.0.1 RAC Install on AIX
I was installing 10.2.0.1 on IBM AIX 5L and while running root.sh from first node (as part of Clusterware installation) got following messages Now formatting voting device: /dev/voting_disk01 Now formatting voting device: /dev/voting_disk02 Now formatting voting device: [Read More]
Input is too long (> 2499 characters) – line ignored
There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve this issue. Copy the code in Text file and while in escape mode enter following command [Read More]
Recreating Database Link
I was trying to recreate database links as part of database migration activity. This involved mixture of 8i,9i and 10g database. In case of 8i/9i it is very easy to find the old password which was used to create database link as passwords for database links are stored in [Read More]
Changes To 10g OCA Certification
People planning to appear for 10g OCA Exam will be startled to find that they need to pass additional exam to get the certificate. Starting from December 1, 2008, in addition to the existing exam (Oracle Database 10g: Administration I (1Z0-042)), candidates are also [Read More]
Index Access best approach?? Not Always…
There is a common misconception that Index access is the best access method for query execution. This approach leads to people concentrate on removing Full Table Scans (FTS) from the Query execution plan. I recently worked on a performance tuning issue where I found such [Read More]
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 password field in dba_users is empty. Prior to 11g we could use following technique to [Read More]
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 P.U. College Bangalore – 560 025 SEMINAR TOPICS Storage Techniques [Read More]
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 RAC (Real Application Clusters) Databases. Must watch for anyone who is learning RAC. You can [Read More]
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 . exporting user definitions . exporting roles . exporting resource costs . exporting [Read More]
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 Dell MD3000 with 44x300GB HDDs (protected by RAID-10) and we’re planning to create LUNs of 2TB on the [Read More]
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 true for Database startup entries in Alert log. If I did the [Read More]
10,000 Hits – First Milestone
Hi All. Yesterday we crossed 10,000 Blog Visits on our 2.5 month old blog . Actually this blog was started 5 months back on blogger and after some time we moved to wordpress hosted blog. After moving to wordpress, we saw our blog gaining popularity with 5000+ blog visits. [Read More]
