The Multifunctioning DBA:

Database


February 27, 2009  2:34 PM

Oracle Upgrade



Posted by: Colin Smith
Database, Database Administration, Oracle

I did my Oracle upgraded yesterday and overall I think that it went pretty well. We are still testing but so far so good. The process was not too bad. First you need to create a new $ORACLE_HOME as two Oracle installations can not be in the same $ORACLE_HOME. Then install the media. I did run into...

February 25, 2009  4:58 PM

Oracle Upgrade



Posted by: Colin Smith
Database, Database Administration, Oracle

It looks like I might get the chance to upgrade one of our Test oracle systems today. I will be moving from 9.2.0 to 10.2. This should be interesting as I am still pretty new to Unix and to Oracle. I am looking forward to this and it really looks pretty straight forward. Looks like I will have to...


February 20, 2009  9:20 PM

Sybase Kill Runaway Process



Posted by: Colin Smith
SQL, Sybase

I am working on a stored proc that will be launched by a threshold that I set up on the log segment of my databases. It is a bit of work but I think that it will be nice not to get the page that someone has written some poor SQL and is filling up the log segment. I will not be running this in...


February 5, 2009  5:06 PM

Sybase 15 Driver Q and A



Posted by: Colin Smith
Database, DBA, Sybase

From my post http://itknowledgeexchange.techtarget.com/dba/sybase-15-upgrade-project/ about my company migrating one instance to ASE 15 I had the following Question as a comment.


February 2, 2009  4:18 PM

Oracle Statspack Help



Posted by: Colin Smith
Database, Oracle, Statspack

Recently I received an email from Ram. It said the following:

I am ram,I have a question regarding development DBA.I need to Optimize SQL and...


January 22, 2009  5:24 PM

Putty Connection Manager Tool



Posted by: Colin Smith
Linux, Oracle, Sybase, Unix

If you are working in Unix or Linux you are most likely using some tool to connect via ssh to that server for your session. Putty is a free tool that manages this very nicely. Many of you are already using Putty I am sure. If you are I did find a Putty Connection Manager that is really very nice....


December 26, 2008  6:15 PM

Sybase DBCC



Posted by: Colin Smith
Database, Sybase

Sybase DBCC or Database Consistency Checks. This was something that was talked about in my training class and so I thought I would implement this when I got back to work. I mentioned it to my team and they both said that I sounded just like them when they got back from class and they laughed a...


December 26, 2008  6:14 PM

Sybase DBCC



Posted by: Colin Smith
Database, Sybase

Sybase DBCC or Database Consistency Checks. This was something that was talked about in my training class and so I thought I would implement this when I got back to work. I mentioned it to my team and they both said that I sounded just like them when they got back from class and they laughed a...


December 26, 2008  5:59 PM

Sybase Training Day 5



Posted by: Colin Smith
Database, Sybase

Sorry that I have not done this entry yet. I have been busy with the holidays and my wife just graduated from ASU. I am back now and should be getting back to a more regular schedule. So I have touched on the first 4 days of training and it was a five day class. The last day of class was very...


December 10, 2008  10:26 PM

Sybase Training Day 4



Posted by: Colin Smith
Database, Sybase

Day 4 of training was really all about backup and restore. This was a good class and I learned a lot about why my company does some of the things that they do. I knew how to do a Database dump and a Database load, but I did learn a lot and found a couple things to be very...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: