Blog Aggregator - Amardeep Sidhu

  • Tags

  • Archives

  • Meta

  •  

Archive for March 24th, 2008

24 Mar

Attempted Murder of a 4-Socket AMD Opteron Server with RHEL4. Oracle Can’t Kill It.

But my, oh my, how I’ve tried. OK, I guess my new name is Fan Boy. I know for a fact that I’ve been pretty relentless on this particular server for over 100 days of its current 215-day life.
-sh-3.00$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 3)

-sh-3.00$ uptime
14:41:17 up 215 days, […]

24 Mar

EXP-00008: ORACLE error 600 encountered

Today I was running export of an Oracle 9.2.0.1 database. The export completed but with an ORA-600 error:

EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [xsoptloc2], [4], [4], [0], [], [], [], []
ORA-06512: in "SYS.DBMS_AW", line 347
ORA-06512: in "SYS.DBMS_AW", line 470
ORA-06512: in "SYS.DBMS_AW_EXP", line 270
ORA-06512: in line 1
EXP-00083: The previous problem occurred when calling […]

24 Mar

Pop Quiz: MySQL Password Hashing

The answers to the last pop quiz are up: http://www.pythian.com/blogs/868/pop-quiz-mysql-cluster
So here’s another pop quiz. Given the following:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16450949 to server version: 4.1.14-standard-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> select count(*),length(password) from mysql.user group […]

24 Mar

So Much Upset….

I want to write so much about some things but at the moment , its just that every thing inside is like closed. There are some very tough times which are coming ahead and the entire credit for it will be for those people in my professional life for whom I did so much but at […]

24 Mar

Distribution Cleanup job and xp_cmdshell

Recently I encountered a SQL Server 2005 Replication setup where the following error message was appearing about every 5 minutes in the SQL Server error logs.

Replication-@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only […]

24 Mar

Is Summer Canceled in Ottawa This Year?

If you are a regular reader of this blog, you know that I was at the Hotsos Symposium 2008 this year. You might not know that I also had a chance to take few days off and spend 1+ week vacation in Texas after the symposium — enjoyed the sun and warm weather. My family […]

24 Mar

Back To Home….

Yes I got back last evening. It was a long and grueling tour. Some how,I was so much tired in doing it. And to make things more interesting, I fell sick and that too not just sick but a very bad one sick. It was so much difficult to say a word as throat was […]

24 Mar

10,000 BC and Die Hard 4.0…

I’m not sure what I can say about 10,000 BC. It wan’t a terrible film, it just wasn’t all that good. As Noons pointed out, the time-line was very dubious to say the least.
The thing that bugged me the most was the galloping mammoths. As far as I can remember elephants, and therefore mammoths by […]

© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)

Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette