OpenBSD 4.7 - network interfaces

steps

rebooted laptop with just wireless switch on

iwn0 wireless interface only
$ netstat -rn
Routing tables

Internet:
Destination        Gateway            Flags   Refs      Use   Mtu  Prio Iface
default            192.168.1.1        UGS        0        4     -    12 iwn0
127/8              127.0.0.1          UGRS       0        0 33200     8 lo0
127.0.0.1          127.0.0.1          UH         2        0 33200     4 lo0
192.168.1/24       link#2             UC         1        0     -     4 iwn0
192.168.1.1        00:25:9c:4d:b5:46  UHLc       1        0     -     4 iwn0
192.168.1.25       127.0.0.1          UGHS       0        0 33200     8 lo0
224/4              127.0.0.1          URS        0        0 33200     8 lo0

plugged in ethernet cable without doing a "sh /etc/netstart"

both iwn0 and msk0
$ netstat -rn
Routing tables

Internet:
Destination        Gateway            Flags   Refs      Use   Mtu  Prio Iface
default            192.168.1.1        UGS        1        1     -     8 msk0
default            192.168.1.1        UGS       18     2262     -    12 iwn0
127/8              127.0.0.1          UGRS       0        0 33200     8 lo0
127.0.0.1          127.0.0.1          UH         3        0 33200     4 lo0
192.168.1/24       link#2             UC         1        0     -     4 iwn0
192.168.1.1        00:25:9c:4d:b5:46  UHLc       2        0     -     4 iwn0
192.168.1.24       127.0.0.1          UGHS       0        0 33200     8 lo0
192.168.1.25       127.0.0.1          UGHS       0        0 33200     8 lo0
224/4              127.0.0.1          URS        0        0 33200     8 lo0

Oracle PL/SQL - Pipelined functions

Pipelined functions are

1) simplicity, elegance of PL/SQL
+ SQL Performance
= PipeLined functions

2) row based solutions to set based solutions


to be continued.

DW keywords

Conformed dimensions
conformed facts
slowly changing dimensions
factless fact tables

oracle dblink howto connect between 2 hosts

1) setup a service using netmgr on machine where dblink will be created.
in the NET service name put in cert11
in the service name put cert11.xps8100***.org
there are other screens like "hostname" , "protocol".
you should be able to test connection right here in the last screen.


2) create public database link cert11 connect to user identified by password using 'cert11'


The dblink should work now.

Centos 5, Oracle 11.1 error - sqlplus

[oracle@localhost ~]$ sqlplus
sqlplus: error while loading shared libraries: /opt/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied



open /etc/selinux/config
change
SELINUX=enforcing -> SELINUX=permissive

reboot

CentOS 5 making flash + wireless work

source : http://www.yqed.com/install-flash-player-10-centos-64-bits/

# yum install curl compat-libstdc++-33 glibc nspluginwrapper

# rpm -ivh /tmp/flash-plugin-10.0.12.36-release.i386.rpm
or install the plugin from adobe site.

type: about:plugins in firefox address bar

if things still dont work then locate libflashplayer.so file and then
cp libflashplayer.so $HOME/.mozilla/plugins


Wireless Installation

source : http://wiki.centos.org/HowTos/Laptops/Wireless

download iwl4965-firmware-228.57.2.23-1.el5.rf.noarch.rpm from net (google it)

rpm -Uhv iwl4965-firmware-228.57.2.23-1.el5.rf.noarch.rpm

modprobe -r iwlagn; modprobe iwlagn


Start the network manager
source : http://wiki.centos.org/HowTos/Laptops/NetworkManager

/sbin/chkconfig NetworkManager on


/sbin/service NetworkManager start


/sbin/chkconfig network off
/sbin/chkconfig wpa_supplicant off

On the up right corner you will now see a newtworking icon, right click on the icon and setup your wireless.

Vista Partimage backup

Taken a Vista backup using "partimage" (System rescue cd)
on 500 gb ext drive.
read the readme.txt file.

+

mbr backup

System Rescue CD options

net-setup eth0
/etc/init.d/sshd start

mkdir /mnt/mydir
ntfs-3g /dev/sda1 /mnt/windows

Xwindows

startx or wizard


Partition manager
gparted

Partition Image
partimage