How to connect to a remote Oracle database

29 Apr

Here is how to connect to a remote Oracle database using SQLPlus: sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=protocol)(HOST=host)(PORT=port))(CONNECT_DATA=(SID=sid))) Please note that the words in Italics represent variables: user – user name for the remote database pass – password for the remote database protocol – protocol used to connect to remote database, usually TCP host – IP address or hostname of the remote host port – remote …

How to change IP address on CentOS Linux

29 Apr

A few weeks back I needed to change my IP address on a Linux CentOS installed in a VirtualBox machine. Here is how to do it: ifconfig eth0 192.168.0.34 ifconfig eth0 netmask 255.255.255.0 Sources: http://www.tecmint.com/ifconfig-command-examples/ http://christophermaier.name/blog/2010/09/01/host-only-networking-with-virtualbox

How to get your MAC address in Windows 7

29 Apr

I needed to get mine today, the command is very simple and needs to be executed in a cmd window. Here is how to get the MAC address with the name of the adapter. C:Usershecperez>getmac -v You will see something like this: