Posts

Posted on

output oracle sql query result to file

taka@ns2#~>sqlplus

SQL*Plus: Release 10.2.0.3.0 – Production on Sun Sep 21 16:32:13 2008

 

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: xxxxx

Enter password: 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production

With the Partitioning, OLAP and Data Mining options

 

SQL> spool sql.lst

SQL> select * from academic;

     ACNUM    DEPTNUM FAMNAME              GIVENAME             INITIALS

———- ———- ——————– ——————– ———-

** rows selected.

SQL> spool off

 

 sql.lst is saved at your home directory.

Posted on

Install VMware Server on OpenSuse 11

1. Get vmware rpm server from http://www.vmware.com

2. Install vmware rpm

ns2 ~ # rpm -ivh VMware-server-1.0.7-108231.i386.rpm

3. Configure vmware with vmware-config.pl

ns2 ~ # /usr/bin/vmware-config.pl 

agree license and where it says

 “None of the pre-built vmmon modules for VMware Server is suitable for your 
running kernel.  Do you want this program to try to build the vmmon module for 
your system (you need to have a C compiler installed on your system)? [yes] yes
Using compiler “/usr/bin/gcc”. Use environment variable CC to override.

Your kernel was built with “gcc” version “4.3.1”, while you are trying to use 
“/usr/bin/gcc” version “4.3”. This configuration is not recommended and VMware 
Server may crash if you’ll continue. Please try to use exactly same compiler as
one used for building your kernel. Do you want to go with compiler 
“/usr/bin/gcc” version “4.3” anyway? [no] yes

…………. 
4. after you install vmware is ready to use.
if you like to install VMware-mui-1.0.7-108231.tar.gz
download from www.vmware.com decompress install with ./vmware-install.pl
Posted on

file IO tuning, iotop

To check File IO, this iotop is one of best solution.

“Linux has always been able to show how much I/O was going on (the bi and bo columns of the vmstat 1 command).

Iotop is a Python program with a top like UI used to show of behalf of which process is the I/O going on. It requires Python ≥ 2.5 and a Linux kernel ≥ 2.6.20.”

For Suse 11
Simply type “yum install iotop”.

Iotop’s homepage
http://guichaz.free.fr/iotop/

Posted on

Create MS-DOS Bootdisk. without HIMEM

When we flash bios or do something simple, we still using old MS-DOS.

but how we can create MS-DOS bootable disk with windows xp or vista?

well answer is we can create one from format option of xp or vista. but what if you like to have windows 98 MS-DOS bootable disk.

 

this is how to do.

 

Get image form http://www.allbootdisks.com

follow instruction how to do at allbootdisks.com

 

few bios update program hate HIMEM support. avoid MS-DOS load HIMEM,

edit config.sys to not load HIMEM.

Posted on

Download BitTorrents on linux/unix pure console

Downloading BitTorrent on Linux without GUI.

1. Install BitTorrent

$ yum -y install bittorrent

2. get torrent that you want to download

3. let start download bittorrent

$ bittorrent-curses ‘http://www.mininova.org/get/some_file[222].torrent’

or

$ bittorrent-curses ‘some_file[222].torrent’ 

 

Requirements :

You must have Python 2.3 above.

to check version of Python simply type python -V from command line

 

Software :

http://download.bittorrent.com

Posted on

Virtualmin domain(s) configuration files

When you setup domain with virtualmin, sometime you want to change after while.

eg., administrative username

modify domain(s) without re-setup entire domain(s), edit following file.

1. [root@ns99 ~]# cd /etc/webmin/virtual-server/

2. [root@ns99 virtual-server]# cat sample.local.act

change sample.local as your domain name

3. see where it says domains=117160406314152

remember number of domains.

4. [root@ns99 virtual-server]# cd domains/

5. [root@ns99 domains]# vim 117160406314152 number you find before.

6. edit and save. done!