I blame all my work dummening this week on the fact that I absolutely had to solve a problem before I went to sleep on Tuesday night. Did I say Tuesday night? Because I guess I meant Wednesday morning at 2:30 am. That pretty much threw off the rest of my week.
Then today, I needed to create a database link, but I didn't know the password and the person who knows the password was at physical therapy, so instead of connect to user identified by password, I used connect to user identified by values ' '. And that apparently can trigger a bug that causes ORA-0600 errors. (ORA-00600: internal error code, arguments: [kzdlk_zt2 err] to be specific.)
Oh, the hilarious and wacky adventures that I get into at work. I bet you are all wishing I talked about it more often. The reason I am evening talking about work at all, is that I was one dummening story short for the work week, and I am saving a good one for tomorrow. But really, if I start getting hits from people searching on kzdlk_zt2 err I am totally turning this into a DBA blog and I am going to get rich off the add revenue.
Until tomorrow...
(Oh - to you DBA suckers, you need to get rid of the quotes and use the real password. See metalink note 456320.1)
5 comments:
"so instead of connect to user identified by password, I used connect to user identified by values ' '. And that apparently can trigger a bug that causes ORA-0600 errors. (ORA-00600: internal error code, arguments: [kzdlk_zt2 err] to be specific.)" You say this and all I hear is BLAH BLAH BLAH BLAHHHH!!!!!!
Let me tell you about Dummening. I am going to a scrapbook retreat this weekend, leaving straight from work today. So last night I was loading up my car with all my scrapbook stuff and bedding and clothes, etc. I turned on the inside car lights so I could see and I FORGOT TO TURN THEM OFF! This morning my car was dead and I had to call Bill to come back home from work to jump it off of the lawn mower (could not get another car close enough with it being in the garage) and I had to Power Walk Curtis to the bus stop, then the bus was 10-15 minutes late because the bus door was broke and they had to wait for another bus. Then I couldn't find my keys after Bill came all the way home. He gave me his keys to my car. I get to work and find my keys...wait for it...IN MY PANTS POCKET!!!!!!! Happy Friday the 13th!
Cindy! Sorry you off to such a bad start today! I hope the rest of the day is easy peasey.
Hey Meg, This is Bill Weeble... It must be a Family theme this week.. I had DBAs yelling at me because I stood a new server that was to run SQL 2005 and used all 700GB on a Raided C: Drive (We don't ever do this and I could not believe that I had). The policy and expectation of the DBA group is that there will be a separate data partition. So I had to find a way to shrink the C: partition and create a D: partition while trying to not brick the server. I did it, but it did extend the the change time several hours beyond what I had scheduled making my very busy DBA group grumble.
As an aside... If you ever need to shrink a NTFS partition on a Win2003 Server which has the OS installed on it and have no unallocated space use GPARTED. That has to be one of the most awesome partitioning programs ever. Open Source and Free to boot. To anyone who knows what I am talking about Diskpart will not do this.
Drain your dumb with some weekend relaxation Meg.
Bill
Oh weeble family - you had a tough week! Bill, glad that GPARTED was the magical solution!
Cindy again...in response to Bill, BLAH BLAH BLAH BLAH BLAH!!
Post a Comment