Subscribe

Subscribe

Vladstudio

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.

via sp_addserver Transact-SQL.

February 25th, 2010 | Tags: | Category: Database, SQL Server | Leave a comment

How to turn on or off colors in bash

Type the following command for just this listing,
$ ls –color=none
Or remove the alias with the unalias command:
$ unalias ls

via How to turn on or off colors in bash.

February 22nd, 2010 | Category: Linux, UNIX | Leave a comment

Moving an Oracle database to a newer Oracle home

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

NOTE : This is how is worked in my environment. It might not work the same in your environment. This is meant as a guide only.

February 18th, 2010 | Category: Database, Oracle | Leave a comment

Changeing an Oracle database character set

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

Shutdown the database.
SQL> shutdown immediate;

Startup in mount mode.
SQL> startup mount;

Restrict the database.
SQL> alter system enable restricted session;

Check the current job_queue_processes setting.
SQL> show parameter job_queue_processes;

Set it to 0 for now.
SQL> alter system set job_queue_processes=0;

Open the database.
SQL> alter database open;

Change the character [...]

February 12th, 2010 | Category: Database, Oracle | Leave a comment

Using cpio

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

gunzip lnx_920_disk1.cpio.gz
gunzip lnx_920_disk2.cpio.gz
gunzip lnx_920_disk3.cpio.gz

Next unpack the contents of the files:

cpio -idmv < lnx_920_disk1.cpio
cpio -idmv < lnx_920_disk2.cpio
cpio -idmv < lnx_920_disk3.cpio

February 9th, 2010 | Category: Database, Oracle, UNIX | Leave a comment
 
  Older Entries »