change ipaddress

January 16, 2007, 7:57 pm

1. You must login as root to change ip address

2.

CODE:
# netconfig -d eth0

you can change eth0 with other eth interface if any. i.e. eth1
then type in you ip address and network configuration

-- or --

edit your /etc/sysconfig/network-scripts/ifcfg-eth0 file

CODE:
# vi /etc/sysconfig/network-scripts/ifcfg-eth0

3. Reactivate the new network configuration

CODE:
# init 6

by restarting your linux :P

-- or --

CODE:
# service network restart

if you are redhat/fedora core/centos or its derivation

-- or --

CODE:
# /etc/init.d/network restart

with other distro of linux

by am3n in Linux

SSH without Password

January 15, 2007, 9:47 pm

Sometime to automates your script you'll to copy some file via scp or sftp or may you get bored to ssh to same server everyday and asking you the same password. Here's how to automated your scp, sftp, and ssh to login without password

1. Go to your home folder

CODE:
$ cd ~

2. Pass this step if you already has .ssh folder

CODE:
$ mkdir .ssh

3. Set private

CODE:
$ chmod -R 0700 .ssh

4. Go to your ~/.ssh folder

CODE:
$ cd .ssh

5. Create a ssh public_key

CODE:
$ ssh-keygen -t dsa -f id_dsa -P ''

6. Copy PUBLIC key ONLY to .ssh folder on target server

CODE:
$ scp id_dsa.pub user@server:~/.ssh

7. Now log into the remote server as the target user

CODE:
$ ssh user@server

8. Go to it's .ssh folder

CODE:
$ cd .ssh

9. Put your public key in the authorized keys file

CODE:
$ cat id_dsa.pub >> authorized_keys2

10. Set privates the authorized_keys2

CODE:
$ chmod 0600 authorized_keys2

11. Delete the public key on the remote server

CODE:
$ rm id_dsa.pub

12. Exit the server

CODE:
$ exit

Now if everything is correct you should be able to ssh, scp and sftp to target server without password

CODE:

$ ssh user@server

$ scp testfile.txt user@server:/data

Based on http://homepage.mac.com/kelleherk/iblog/C1901548470/E20061128145420/index.html

by am3n in Linux

[Oracle] DBA Tasks

January 10, 2007, 11:53 pm

1. Evaluate the database server hardware
2. Install the Oracle Database
3. Plan the database
4. Create and open the database
5. Back up the database
6. Enroll system users
7. Implement the database design
8. Recover from database failure
9. Monitor database performance

by am3n in Computer

[Oracle] Controlling iSQLPlus

January 10, 2007, 11:01 pm

iSQLPlus is a web-based application provided by Oracle to query sql using a web browser rather than installing a client software, oracle driver and setting up a tns names. Here how to control iSQLPlus:

Login as oracle (or useraccount where OracleDB installed)

CODE:
cd $ORACLE_HOME/bin/

To Start iSQLPlus

CODE:
$isqlctlplus start

To Stop iSQLPlus

CODE:
$isqlctlplus stop

To Access iSQLPlus

CODE:
http://your.server.ip.address:5560/isqlplus

by am3n in Linux

[Oracle] Controlling Enterprise Manager

January 10, 2007, 10:16 pm

Oracle has Enterprise Manager web-based application which ease DBA to maintain their Oracle Database. Below is how to control EM :

Login as oracle (or useraccount where OracleDB installed)

CODE:
cd $ORACLE_HOME/bin/

To Start Enterprise Manager

CODE:
#emctl start dbconsole

To Stop Enterprise Manager

CODE:
#emctl stop dbconsole

To View Status of Enterprise Manager

CODE:
#emctl status dbconsole

To Access Enterprise Manager

CODE:
http://your.server.ip.address:1158/em

by am3n in Linux

just realized the new Centos and Fedora

January 5, 2007, 10:32 pm

I just install Centos 4.4 without GUI (X.org) nor KDE / Gnome selected only minimal system plus development and utility packages but somehow Redhat / CentOS install X.org by default and select KDE as it's Desktop Manager (although only kdebase packages installed). When the first I saw KDE I thought I had select the wrong packages, so I re-install my server. But the same thing happen. When I confirm this behaviour to my colleague, he said yes it will install X and KDE even you not select it. I didn't experience it when I am installing Centos 4.2. Well this is a step forward for Redhat / CentOS. Luckily my server has plenty of RAM installed so I don't have to worrying about sort of memory. Although I can setup my server to use init 3 directly from the start. LOL. This feature reminds me of Mandrake 8/9/10 when I am not selecting any X.org/KDE/GNome, it'll install X with IceWM for a simple GUI usage. Bravo Centos/Redhat

Other thing when I try a fresh Fedora Core 6. On Gnome there is a feature called Desktop Enhancement. When I activated this feature. Window behavior seem so flexible when you maximized or minimized it and also when you press Alt-Tab to change window it'll display a screenshot of a selected window. And when you want to change Desktop from Desktop 1 to Desktop 2 and so on... the desktop seems rotating from left to right or otherwise. And this the fun part (I think) you can drag a window from one desktop to another. Whahwwhahha... First I saw this I laught very loud. Because I never think of a Linux which seems to me so stiff can be so flexible like that. Good... good... I'll upgrade my Fedora Core 4 into 6 if I have some free time.

by am3n in Linux

Page : 1