The Multifunctioning DBA:

February, 2009


February 27, 2009  2:34 PM

Oracle Upgrade

Colin Smith Colin Smith Profile: Colin Smith

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 27, 2009  2:26 PM

Interview

Colin Smith Colin Smith Profile: Colin Smith

A couple weeks ago I had mentioned that my company was forcing all of us to take unpaid time off work. Well I have an interview today. Sounds like a good place to work and it is in the Medical field so I am very excited about it. I think the Medical field is a great place to be in this type of...


February 25, 2009  4:58 PM

Oracle Upgrade

Colin Smith Colin Smith Profile: Colin Smith

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 24, 2009  6:18 PM

Powershell commands for Active Directory

Colin Smith Colin Smith Profile: Colin Smith

I have been asked how to manage Active Directory with Powershell. The best way is with the Quest Software cmd-lets for Active Directory. They are free and available at http://www.quest.com/powershell/activeroles-server.aspx. Once...


February 20, 2009  9:20 PM

Sybase Kill Runaway Process

Colin Smith Colin Smith Profile: Colin Smith

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 19, 2009  5:06 PM

Great Powershell Site

Colin Smith Colin Smith Profile: Colin Smith

I ran across this site the other day and signed up. It has some great stuff and I have uploaded a couple of my powershell scripts to the site as well. If you love powershell like I do then you will check it out and sign up for a free account. Enjoy. http://powershell.com/cs/


February 19, 2009  4:53 PM

AD Migration Script Q and A

Colin Smith Colin Smith Profile: Colin Smith

I received a question from Sandeep as follows: Hi Colin, I saw your answer to one of the AD user creation question on IT Knowledge...


February 17, 2009  10:42 PM

File Copy with Powershell

Colin Smith Colin Smith Profile: Colin Smith

I have a friend that I work with that has to copy files out to the same 10 servers anytime our developers create a new report. To do this manually he has to log into the UNC of each server, verify that the server does not already have a report with the same name, if it does he needs to rename it,...


February 5, 2009  5:06 PM

Sybase 15 Driver Q and A

Colin Smith Colin Smith Profile: Colin Smith

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 5, 2009  4:57 PM

GP Question and Answer

Colin Smith Colin Smith Profile: Colin Smith

Satish wrote me the following question: Hi, I would like to know that, is there any way that we ( as a normal domain user with out any admin privileges )logon to a desktop which has been added to a domain and then manage to do admin tasks like changing time ,or editing grouppolicy on the local...


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: