Category: Database

Renaming a SQL Server instance.

SQL> sp_dropserver 'oldservername'; SQL> sp_addserver 'newservername'; don’t run in same batch. the two statements must be executed separately....

malcolmFeb 25, 2010

Moving a database to a new oracle home, owned by a different user and running a newer version....

malcolmFeb 18, 2010

Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter='NLS_CHARACTERSET'; Shutdown...

malcolmFeb 12, 2010

Some files that you get from Oracle download come in cpio format. Here’s what to do with them....

malcolmFeb 9, 2010

Possible Cause : root.sh not run after the EM 10G installation. Fix: Check the permissions and ownership of...

malcolmJan 22, 2010

I was trying to setup an instance of Oracle 10.2.0.3 a while back and was running into a...

malcolmJan 7, 2010

Every time I have to setup users in MySQL I seem to have problems. I was setting up...

malcolmSep 10, 2009

One of the jobs I do the most as a DBA is added space to peoples schemas. It’s...

malcolmSep 3, 2009

One of the cool new features of Oracle 10g is Flasback. “Flashback Database quickly rewinds an Oracle database...

malcolmAug 27, 2009

We’ve had an Oracle Manage Server (OMS) running here at work for some time now. I think it...

malcolmAug 20, 2009