Thursday, April 14, 2011

Is Corruption India's biggest problem?

This was a question in one of the NDTV's forums and I typed in my view on it. Somehow the did not accept my post. So I am posting it here.

----------------------------------------------------------------------------------

No I don't think corruption is the No1 problem for India. It is just a way to blame someone else for our bad state. If we want to talk about real problems we need to address issues like
1) Primary Education
2) Drinking Water
3) Sanitation
4) Nutrition.....
I can go on. These are the real problems of India. If you really think of it how many times did you bribe a person in your life to get something done? Of my 23 years in India the only time that I had bribed a person was to a ticket collector in trains to get a berth. I don’t know if that were earth shattering. I know it would have reduced a miniscule amount for the Railways but I don’t think it is a bigger problem than any one of the ones that I stated above. Corruption is more of a intangible problem and it is going to exist in one form or the other. I think we should focus more on tangible problems than say that "India is not developing fast because of our corrupt politicians". Even the politician is one amongst us.

Monday, April 11, 2011

ORA-00214: Control file Version Inconsistent on Startup or Shutdown

Early in the morning to do my daily plsqlchallenge question I tried logging into my local database and bam I hit the ORA-00214 error. Well actually I hit this error when I try to start up my database. I guess the error was because I shut my machine down forcefully by plugging off my machine. I guess this was what caused the inconsistencies in the control files. The possible causes for this issue in the documentation were the following:
1) You have restored the control file from backup, but forgot to copy it onto all of the mirrored copies of the control file as listed in the "CONTROL_FILES" parameter in the initialization parameter
2) You have moved one or more copies of the control file to a different location while the database was up and running.
3) You accidentally overwrote one of the copies of the control file with an old copy.
4) The database or the system crashed while the mirrored copies of the control file were being updated, causing them to be out of sync.
5) You are restoring a database backup that was improperly taken with the database up and running ("fuzzy" backup).

In my case it was the error 4 which caused the error.


The solution was easy compared to what it could be. Below are the steps that I took to start up the database.
1) Shutdown the database
a. Shutdown immediate
2) Start up the database with nomount
a. startup nomount
3) Alter the control files to one of the control fiels.
a. ALTER SYSTEM SET CONTROL_FILES=file_name
4) Open the database.
a. Alter database open

With these commands my database was up and running and I am done for the day’s learning. I should definitely link this site for helping me out in fixing my issue.