DBA hallucinationsPosted: October 11, 2007
Every once in a while something happens that makes me question not only my skills as a DBA, but my sanity as well. Today’s event was one of the stranger ones that happened to me.
A coworker asked me to export a schema and import it into the same database but under a different name. Very common request, not something that is very likely to go wrong. I’m running the expdp command, finished without warnings. Time to run impdp command, with remap_schema to load the data into a new schema, again it finishes with no warnings. I log on to the database and change the password for the new user, again it finished successfully.
Great, I call the co-worker and I tell him his new schema is ready. Two minutes later he is back, and complains that he gets an error logging in. Puzzled, I try logging in as that user myself:
SQL> conn test_user_copy/secret
ORA-01017: invalid username/password; logon denied
Even more puzzled I check dba_users for the user I just created. It is not there. Blinking, I check again. Still not there. I know that I successfully ran “alter user… identified by….” on that user not two minutes ago. It is a large user – dropping the schema would take significantly longer, even if someone was so inclined, which I doubt.
I recheck the import log, and it still seems that the new user was created and the data was imported successfully. Resigned, I reran the import command. It succeeded, which means that the user really was no longer there. I altered the password again, verified that the user still exists and notified the coworker that he can try again. He confirmed that everything is fine, so I guess the user didn’t disappear this time.
Puzzled, I consulted a senior DBA with my problem. He suggested looking at the alert log, as exports and imports also write a rather cryptic line there. I checked. The alert log clearly showed only one import – the second one.
The senior DBA kindly suggested that I was imagining things when I thought I was running the first import, and maybe I should go home early today and get some rest.
I really have no explanation for this event. I’m not even planning on contacting Oracle Support with this story, it is just too strange.
While searching for something vaguely NFS related in Google, I found out that someone in Netapp has a blog. I was unable to find out what is he doing in Netapp besides blogging, but I found his posts interesting. I happen to love working with Netapp – both the appliance and the vendor, and the blog really echo the competent and friendly vibe I get when dealing with the company.