oracle if function within select

DECODE

REMEMBER U ASS!

cpanel multiple forwarder

just create multiple lines of forwarders
info@x --> me@x
info@x--> you@x

windows check listening ports

netstat -an |find /i "listening"

THANKS A MIL to PETRI

linux sendmail delete outgoing mails

delete in files in /var/spool/mqueue

also you can see the queue using mailq

linux install i2o raid

to install linux on servers like supermicro X6DH8-G you should install the i2o driver, to install the i2o driver do a
"linux noprobe text" and when "add device" is displayed, load the i2o block driver and things will be LA LA LA LA

mikrotik load balancing

Load balancing, connection aggregation, multi-homing, miltiple internet connections teaming

http://wiki.mikrotik.com/wiki/NTH_load_balancing_with_masquerade

LOVE IT!

Photoshop incorrect color, white is shown as yellow

Do a View->Proof Setup->Custom

EASEUS FREE Partition Manager

EASEUS FREE Partition Manager (epm.zip)

http://www.partition-tool.com/download.htm

Terminal server has exceeded maximum number of allowed connection

Simply do an

mstsc /admin

FTP server behind iptables firewall

To enable firewall access behind firewall other than opening port 21 on the firewall one needs to
Add
IPTABLES_MODULES="ip_nat_ftp"
to
/etc/sysconfig/iptables-config

BIG Thanks to RAMPALO

mount iso in /etc/fstab

add the below to /etc/fstab
/mnt/centos.iso /media/iso iso9660 loop 0 0

windows delete share and connect to the same share with another username

windows delete share and connect to the same share with another username

net use \\servername\sharename /delete

WEEHA

mikrotik select gateway based on source address

ip firewall mange
prerouting, mark packets from a special source with a routing mark (any name you like) and add the 0.0.0.0/0 route again and choose the routing mark you specified before with a desired gatway which can be different from the original 0.0.0.0/0 route gatway

change timezone in centos

yum -y install tzdata
cp /usr/share/zoneinfo/Asia/Tehran /etc/localtime

BIG thanks to: http://blog.connexeon.com/sysadmin/linux/change-timezone-on-centos/

mikrotik data connections with other types of interfaces

there are 2 interfaces that seem to work ethernet/ip and ip/ip both need for the two end points to have accessible valid ip addresses.
In case you use mikrotik to do PPPOE, you need to put the host OS nic in PROMISC=yes mode so that the PPPOE ack packets can be received by the gust OS.

linux enable NTSF mount in read/write mode

yum -y install dkms-fuse fuse fuse-ntfs-3g

httpd.conf and the Aliases

When the alias reads like below
Alias /cacti/ /var/www/cacti/

DirectoryIndex index.php
Options -Indexes
AllowOverride all
order deny,allow
deny from all
allow from 127.0.0.1
AddType application/x-httpd-php .php
php_flag magic_quotes_gpc on
php_flag track_vars on


to display the alias successfully in the browser do not forget the terminating slash at the end, so
http://localhost/cacti/ is right.

Persistent SSH SOCKS5 tunnel in Linux

ssh -c arcfour -o TCPKeepAlive=yes -N -f -D localhost:1080 user@remoteserver.com

instead of -c arcfour one can use -c blowfish-cbc as well. The performance of the tunnel gets better with a more lightweight cipher.

dbca logs

here you can find dbca logs $ORACLE_HOME/cfgtoollogs/dbca
thanks to OTN

Oracle dbca press finish nothing happens

If you press finish at the end of database creation of dbca and nothing happens, it is (in my case) an X problem. What I did was not to use the X server on windows instead I installed X11 on linux and used that one and it went smoothly.

check linux distribution

cat /etc/*-release

Linksys WAP54GS to act as router with dd-wrt

to make WAP54GS a router
1. Install dd-wrt
2. change the assignment of WAN port from vlan1 to vlan0
3. TADA!!!!!

/etc/sysconfig/desktop

/etc/sysconfig/desktop to choose the window manager permanently

vmware change MAC

in the virtual machine (config) vmx file:

# ethernet0.addressType = "generated"
# RANGE ALLOWED: 00:50:56:00:00:00-00:50:56:3F:FF:FF
ethernet0.addressType = "static"
# ethernet0.generatedAddress = "00:0c:29:94:43:71"
ethernet0.Address = "00:0c:29:94:43:70"

rsync without SSH

rsync -av rsync://server/rsync_share_name

slow sendmail startup

When sendmail is slow at startup do either of these things in /etc/hosts
127.0.0.1 localhost.localname machinename

or

192.168.1.100 machinename.domainname

if you have only machinename sendmail will be slow

firefox download flash

do a about:cache?device=disk and search for the URL or filename


many thanks to
http://labnol.blogspot.com/2005/11/save-flash-from-firefox-and-ie.html

MYSQL grant REMEBER 'user'@'server'

REMEMBER THIS:
grant all on DB1 to 'user'@'localhost' identified by 'password';

putty connect to session instead of server from command line

to make putty connect to session (based on the name of the session) instead of server from command line DO:

putty @SESSION_NAME

putty default font permanent

To change the default font in putty change the font settings in the Default Settings in the main window

linux upgrade problem

If you get something like "there are multiple partitions labelled /, they must be unique" simply use remove the label by:

tune2fs /dev/sda2 -L ''

# HOORAY

error reading information on service keytable: No such file or directory

if you get
error reading information on service keytable: No such file or directory
error: %trigger(kbd-1.08-10.2.i386) scriptlet failed, exit status 1

rpm -e kbd-1.08-10.2 --noscripts

Grub set default boot option just once

echo "savedefault --default=1 --once" | grub --batch
reboot

Remote upgrade linux RHEL redhat 3 to 4

1. mount the installation cd and copy vmlinuz and initrd.img to /boot renaming them to vmlinuz_remote and initrd_remote.img
2. vi /etc/grub.conf
# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You have a /boot partition. This means that
# all kernel and initrd paths are relative to /boot/, eg.
# root (hd0,0)
# kernel /vmlinuz-version ro root=/dev/hda2
# initrd /initrd-version.img
#boot=/dev/hda
default=0
timeout=10
splashimage=(hd0,0)/grub/splash.xpm.gz
title Red Hat Enterprise Linux AS (2.4.21-15.EL)
root (hd0,0)
kernel /vmlinuz-2.4.21-15.EL ro root=LABEL=/
initrd /initrd-2.4.21-15.EL.img
title Remote Install
root (hd0,0)
kernel /vmlinuz_remote ks=hd:hda1:/ks.cfg vnc vncconnect=192.168.162.1 ramdisk_size=8192
initrd /initrd_remote.img

replace the above devices with the ones on your system(hd:hda1->points to /boot)
3. vi /boot/ks.cfg
#System language
lang en_US
#Language modules to install
langsupport --default=en_US
#System keyboard
keyboard us
#System mouse
mouse generic3ps/2
#network
network --bootproto static --ip 192.168.162.129 --netmask 255.255.255.0 --gateway 192.168.162.1 --nameserver 192.168.162.1 --hostname l
#Use interactive kickstart installation method
interactive
#Use hard drive installation media USE YOUR OWN HARDDRIVE
harddrive --dir=/iso --partition=hda2 #replace with your own device (this points to /)
bootloader --location=mbr
#Reboot after installation
reboot
#Upgrade existing installation
upgrade
%pre

#!/bin/sh

mkdir /tmp/boot # create mount point
#-USE YOUR OWN HARDDRIVE ADDR
# mount filesystem on /dev/sda1 onto /tmp/boot (hiding mount's boot dir)
# /dev/hda1 point to /boot
mount -t ext3 /dev/hda1 /tmp/boot
# so below here /tmp/boot/... is actually /boot/... on harddrive device
# 'date' preserves original grub.conf through multiple boot attempts
cp /tmp/boot/grub/grub.conf /tmp/boot/grub/grub.conf.$(date"+%Y%m%d-%H%M%S")
cp /tmp/boot/grub/grub.conf /tmp/boot/grub/grub.sve
cp /tmp/boot/grub/grub.bak /tmp/boot/grub/grub.conf

4. put your CD or DVD iso in /iso, they can be multiple isos

5. just to be safe try loading the second option to grub you just added once as below, so if things went wrong you can come back

echo "savedefault --default=1 --once" | grub --batch
reboot

Linux YP NIS config with autofs

1. mkdir /data/user10

2. useradd -g users -d /data/user10 user10

3. vi /etc/auto.master
# add this
/data auto.data --ghost

4. vi /etc/auto.data
* /data/& #something like this

5. vi /var/yp/Makefile
make an auto.data entry just like auto.home

6. do a make in var/yp

7. on the client service autofs restart

ubuntu network configuration

root@ali-desktop:~# cat /etc/network/interfaces
auto lo
iface lo inet loopback

auto usb0

iface usb0 inet static
address 192.168.111.2
netmask 255.255.255.0

auto eth0
iface eth0 inet dhcp

Couldn't make mmap of X bytes - mmap

mount -t tmpfs none /var/cache/apt
mkdir -p /var/cache/apt/archives/partial
apt-get update

pango ARM cross compile

./configure --prefix=/home1 --host=arm-ip-linux-gnueabi LDFLAGS=-L$YOUR_OWN_COMPILED_GLIB_DIR (eg /opt/lib)

GLIB ARM Cross compile

IPLinux GLIB BUILD

cat config.cache
glib_cv_stack_grows=yes
ac_cv_func_posix_getpwuid_r=yes
ac_cv_func_posix_getgrgid_r=yes
glib_cv_uscore=yes

./configure --host=arm-linux --cache=config.cache

samba passwordless login

smbpasswd -a ali

/etc/samba/smb.conf
security=share
[public]
path = /home/ali
read only = no
guest ok = yes
public = yes
browsable = yes
force user = ali

ubuntu howto stop X from auto start

sudo update-rc.d -f gdm remove

VOIP FXO FXS

REMEMBER

FXO = Foreign Exchange Office is connected to PSTN.
FXS = Foreign Exchange Subscriber is connected to a normal phone.

http://www.patton.com/technotes/fxs_fxo.pdf

DISPLAY to connect to X from SSH

export DISPLAY=`who -um | awk '{print $8}' | tr -d '()'`:0.0

microsoft fonts for linux i386

taken and rpm-built from http://corefonts.sourceforge.net/

for rpm based Linuces
msttcorefonts-2.0-1.noarch.rpm

Wive 0.61 on DWL-G700AP

When installing Wive on DWL-G700AP remember that after putting the access point in TFTP mode you have to use the EXACT ip address "192.168.1.6" for tftp regardless of whatever the actual LAN interface IP is.

trixbox backup and restore

Install tbm-backup trixbox module in both machines, create a backup in BOTH machines, restore the backup from old machine into the new one (mysql password for asteriskuser may not be the same so before the restoration of the backup file make them the same).

windows 2003 limit bandwidth usage per IP

1. squid with delay pools support
(http://markus.revti.com/2007/06/installing-squid-cache-for-windows/)

2. softperfect bandwidth manager
(http://markus.revti.com/2009/01/squid-transparent-proxy-server-on-windows-server-2003/)

windows delete a service from command line

sc delete "service_name"

multiple domain controllers (DC) on the same LAN

Use the DHCP of one of the DCs and split the LAN into 2 SUB-LANS
this is done using a superscope in the DHCP of domain controller.

- one scope 192.168.1.0/255.255.255.128
- another scope 192.168.1.128/255.255.255.128

The two sub scopes will not be able to access one another

Put one of the servers in first scope and the other in the second one.

In the scope options each have their own DNS and default route

To make the clients become a member of a certain scope fix the clients MAC address and create a reservation

vmware guest OS on windows RRAS host OS problem

If you need to have vmware installed on a machine with RRAS, because of incompatibilities between proxy arp of RRAS and vmware your guest OS packets will not be routed, what you need to do is:
[in this example host machine has 2 NICs. One toward Internet and one local.]
1. Add a NIC to the host machine. (not virtual)
2. In the guest OS bridge one NIC to the Internet NIC of the host OS and the other to the newly added NIC of the host OS (which is connected to the local LAN)
3. Assign an IP address to the host and guest machine (the same range as the host machine)

Walla! ping outside

vnc enterprise vncconfig problem

run vncconfig with the -service parameter to change the config of the service mode not user mode
"E:\Program Files\RealVNC\VNC4\vncconfig.exe" -service

mysql import and export

export:
mysqldump -u user -p db > dump.sql

import:
mysql -u user -p db < dump.sql

howto install cpanel

It is not free, needs a licence from cpanel.net after the trial period
Installing cPanel on a linux box is as simple as:
cd /home
wget layer1.cpanel.net/latest
sh latest
from: http://paragonhost.wordpress.com/2006/11/16/howto-install-cpanel-on-a-linux-os-server/

experts exchange free readonly account

http://www.experts-exchange.com/registerFree2.jsp

Office 2003 Slow send in Vista

simply remove all office 2007 components on your PC and things will be cooooooool :)

نیاز به حساب درست و حسابی بانکی و نتایج اعتماد

ما سرویس "حساب بانکی آمریکا" را در سایت ابزارها ازگوگل پیدا کردیم http://www.abzarha.com

پول دادیم (130 هزار تومان). و برای ما با پست یک عدد کارت فرستادند و یک بروشور.

بعد 2 بار سعی کردیم طبق فرمایشات فروشنده پول ترنسفر کنیم به دیوار خوردیم.

با خدمات مشتریان صادر کننده کارت در آمریکا تماس گرفتیم و فرمودند این فقط کارت است حساب بانکی نیست.

سعی کردیم در پی پل رجیستر کنیم دوباره به دیوار خوردیم.



جواب های این فروشنده محترم جناب آقای مهدی جزینی را بینید.


نامه دوم و جواب ایشان

-----Inline Attachment Follows-----

Dooste aziz in hesabha hich moshkeli nadare! (lotfan bejaye karhaye bachegane kami ham be harfhaye man deghat konin bad nist !!!) ini ke shoma migin paypal ekhtar mide ke nemitoone add kone. ehtemalan az shanse shoma boode. (motasefane hamishe ham shanse bad dare khooneye kasaii ro mizane ke az hame talabkaran !!! ) gooya kasi ehtemal midam shomareye hesabesho dar paypal masalan yeki do adad pasopish zade (ke hesabe shoma boode) va hamoontor ke midoonin vaghti kasi shomare hesabi ro be paypal add kone. hata ghabl az confirm oon. hich rahi baraye pak kardane oon nadare. magar inke shoma ba customer support paypal tamas begirin va begin >>> ehtemalan kasi shomareye hesabe shoma ro be eshtebah dar paypalesh add karde ke confirm ham nashode. va oonha ba kamale meyl va be sadegi pas az gereftane etelaati az shoma va taiide oon be sadegi oono pak mikonan ta shoma betoonin hamoon banketoon ro add konin. be hamin sadegi. dige vaghte pasokhgooii bishtar ro be shoma nadarimchoon saremoon sholooghebe khatere 5 toman sood dahane tarafo service nemikonan ke shoma kardin !!!bye

On Tue, Dec 30, 2008 at 2:23 AM, Ali Sadeghi-Ardestani wrote:

Dear Sir,Looks like my account number which no one knew except you and me has been already registered in paypal. Please check attachment.

Regards,
Ali Sadeghi Ardestani

نامه اول و جواب ایشان

dooste man eshtebah az ma naboode bank be ma etela nadade bood ke tarigheye doroste wire be in accountha chi hast. choon taze oomade. hamoontor ke dobare khedmatetoon email kardam shoma bayad be soorati ke dar file attach shode dar in email dadam havale konin na mostaghim!

va agar balad nistin ke yek sarafi dorost peyda konin inkar ro ham baratoon anjam midam vali dige baghish be ma marboot nist. ma ke nabayad ta payane omre donya shoma ro support konim!!! ma faghat forooshandeiim. har moshkeli darin dige ba poshtibaniye hamoon bank tamas begirin moshala englishetoon ham ke khoobe!!!

in linke yek sarafi dar tehran hast ke ba (bank of america) ham kar mikone:
http://www.ketabeavval.ir/Profile/?id=136433

dige baghish be ma marboot nemishe bazam migam ma faghat forooshandeiim va support ba hamoon telephoni hast ke dar broshooretoone



On Mon, Dec 29, 2008 at 3:35 PM, Ali Sadeghi-Ardestani wrote:
Dear Sir,

After the attached transaction was rejected twice by two different exchange houses and I lost 135,000 TOMANS for money transfer costs and right after I got the Bank of America Transfer Information from you, I talked to customer support and told them that I need to have this account to buy stocks so the my brokrage firm that is buying the stocks for me needs to have access to my account using a direct method like
ACC NUMBER+NAME+BANK+ROUTING or any other method like this.

They said and I quote "Your account with us is not connected to a bank, so you can not get your brokerage firm to access your account. All you can do with this card is to get your employer to put your salary here and you can then get cash from ATMs". Alhamdolella I did not try the second method you offered otherwise I would have lost more. They asked where I got the card from and I gave them your website, they said that I can ask you for the same card but the Visa enabled one. I do not think you have it, because I asked you once.

When I asked about transfers from paypal, they said I can use paypal but as you may already know paypal has really strict rules about fraud and once they get a feeling that your activity is strange they simply block your account just like my old paypal account.

Now what I am asking you is to refund me and get your card back and also to remove the "HESABE BANKI AMRIKA" from your website because it is misleading and very simply put not TRUE not forgetting how time/money consuming it is to come to the above conclustion.

Regards
Ali Sadeghi Ardestani

Excel find nth occurrence of a string within another

Function FindN(sFindWhat As String, _
sInputString As String, N As Integer) As Integer
Dim J As Integer

Application.Volatile
FindN = 0
For J = 1 To N
FindN = InStr(FindN + 1, sInputString, sFindWhat)
If FindN = 0 Then Exit For
Next
End Function

Napoli Pizza

I liked it, esp the Chano with extra garlic sauce one.

utorrent slow download

remember to update tcpip.sys using http://www.lvllord.de/?url=downloads&lang=en every time you install a service pack. This helps increase the number of half open connections from 10 to 50. And downloads will explode.

create RPM repository from ISO DVD CD

Thanks to http://www.cyberciti.biz/tips/redhat-centos-fedora-linux-setup-repo.html
# mkdir -p /var/www/html/centos/5/os/i386
# mount -o loop /path/to/centos.iso /var/www/html/centos/5/os/i386

** (put it in /etc/fstab later)

createrepo /var/www/html/centos/5/os

# vi /etc/yum.repos.d/iso.repo
[My ISO Repository]
baseurl=http://$IP_ADDRESS/centos/5/os/
enabled=1
gpgcheck=0

service httpd restart

** not other servers is the subnet can use this repository as well as this service onto which the iso resides

Wordpress Persian (Farsi) bluehost

1. Install wordpress from bluehost interface
2. Install the farsi patch from wp-persian.com
3. edit the wp-config-sample.php and remove the below:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

mysql change database charset to unicode

SELECT concat('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt

FROM `information_schema`.`TABLES` t

WHERE 1

AND t.`TABLE_SCHEMA` = 'database_name'

ORDER BY 1

OLAT email problem

once you could not send emails and came accross this:

DEBUG: setDebug: JavaMail version 1.3

DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,gnu.mail.providers.smtp.SMTPTransport,nferrier@tapsellferrier.co.uk]

java.lang.NoSuchMethodException: gnu.mail.providers.smtp.SMTPTransport.(javax.mail.Session, javax.mail.URLName)

you should install java mail components, I installed:

geronimo-javamail-1.3.1-api-1.1-4jpp

sun-mail-1.4-3jpp

classpathx-mail-1.1.1-4jpp.2




And the problem was solved.

jdk installation

when installing jdk depenging on the version for JRE to work correctly as well

java-sun-compat

has to be installed too.

for example for jdk-6u6-linux-i586.rpm to work along with tomcat you need to install java-1.6.0-sun-compat-1.6.0.06-1jpp.i586.rpm as well, otherwise tomcat and the applications that need jre 1.5 upwards will not work.

Strange Linux PPTP problem

When using Linux PPTP service web pages fail to load completely [freeze] (aka common PPTP MTU problem) all one has to do is to:

> cat /etc/ppp/ip-up.local
#!/bin/bash
/sbin/ifconfig $1 mtu 1400

Tor problem

When Tor can not connect the first thing you do is to check the date/time of your machine!

Jalali Date - Javascript

Jalali date in java script as active desktop element
it can be downloaded from:
http://sites.google.com/site/alisade/Home/fdate.zip?attredirects=0

a simple bash prompt PS1

export PS1="\[\e[32;1m\]\d \t\[\e[36;1m\]\n\u@\h\n\[\e[31;1m\]\w > \[\e[0m\]"

openvpn config parameter seems compulsory

Although I used to do openvpn TLS without the "tls-auth ta.key 0" directive for years, now it looks like it has become compulsory, otherwise handshake will not occcur completely although the first
TLS: Initial packet from xxx.xx.xx.xx:1194, sid=42fb5c72 1f286ab1
is exchanged with no problems

linux disable single user mode

do not try to disable the single user mode instead use a grub password.

Join a computer to windows 2003 domain

When joining a computer to a windows 2003 box remember to add the .com at the end of the domain name otherwise the dns will not find the SRV record of the domain name

free totally legal Nastaliq font by http://www.scict.ir/

http://www.box.net/shared/bh9ioqs2ss originally from http://www.scict.ir/

command line download accelerator for windows

AXEL is a command line accelerator for the *nix, I have compiled it under cygwin and have put it here:

http://www.box.net/shared/avraot95w8

Enjoy!

iptables enable passive mode ftp

just do this:
modprobe ip_conntrack_ftp

red hat root login in telnet,...

edit /etc/pam.d/login and /etc/pam.d/remote and

comment out

auth required pam_securetty.so

crontab does not accept

crontab does not accept commands with `command to execute` within command line

Simple web sharing in apache

httpd.conf:

Alias /cbt "/users/WWW"

Order Allow,Deny
Allow from All

Error: Can't open Display

although you do an xhost + still you cannot do an xclock so:

on the machine connecting to the other do a
vi /etc/X11/gdm/gdm.com

DisallowTCP=false


** REMEMBER to check iptables

XTERM execute parameter

XTERM -e (exexute switch) MUST be the last one passed to XTERM.

Oracle Move from one computer/directory to another

1. Edit and replace paths in

/etc/oratab
/etc/rc.d/rc5.d/S99zzoracle_orasid
/etc/rc.d/init.d/orastop_orasid
/etc/rc.d/init.d/listener_orasid
/etc/rc.d/init.d/orastart_orasid
/etc/rc.d/rc6.d/K10zzoracle_orasid
/etc/rc.d/rc0.d/K10zzoracle_orasid
/etc/rc.d/rc3.d/S99zzoracle_orasid
/etc/rc.d/rc1.d/K10zzoracle_orasid
/etc/oraInst.loc

2. Edit and replace paths in
listener.ora tnsnames.ora

3. login as sys as sysdba (listener must be on and database mounted)
create pfile='/apps/oracle/OraHome1/dbs/initorasid.ora' from spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora'

4. Edit /apps/oracle/OraHome1/dbs/initorasid.ora and change paths

5. Now do the reverse
create spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora' from pfile='/apps/oracle/OraHome1/dbs/initorasid.ora'

6. The last step is to alter internal files names:
alter database rename file '/home/gf_admin/oradata/gftt/control01.ctl' to '/apps/gf_admin/oradata/gftt/control01.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control02.ctl' to '/apps/gf_admin/oradata/gftt/control02.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control03.ctl' to '/apps/gf_admin/oradata/gftt/control03.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/redo01.log' to '/apps/gf_admin/oradata/gftt/redo01.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo02.log' to '/apps/gf_admin/oradata/gftt/redo02.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo03.log' to '/apps/gf_admin/oradata/gftt/redo03.log';
alter database rename file '/home/gf_admin/oradata/gftt/system.dbf' to '/apps/gf_admin/oradata/gftt/system.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/temp.dbf' to '/apps/gf_admin/oradata/gftt/temp.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsdata.dbf' to '/apps/gf_admin/oradata/gftt/tsdata.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsindex.dbf' to '/apps/gf_admin/oradata/gftt/tsindex.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/undotbs.dbf' to '/apps/gf_admin/oradata/gftt/undotbs.dbf';

oracle spfile and pfile

startup using spfile
STARTUP

startup using pfile
STARTUP PFILE=’C:\oracle\product\10.2.0\admin\MarlonDB\initMarlonDB01.ora’

convert one to another:
CREATE SPFILE=’C:\oracle\product\10.2.0\db_1\database\spfileMarlonDB01.ora’ FROM PFILE=’C:\oracle\product\10.2.0\admin\MarlonDB\initMarlonDB01.ora’;

CREATE PFILE=’C:\oracle\product\10.2.0\admin\MarlonDB\initMarlonDB01.ora’ FROM SPFILE=’C:\oracle\product\10.2.0\db_1\database\spfileMarlonDB01.ora’;

linux increase swap

mkdir /opt
dd if=/dev/zero of=swapfile01 bs=1024M count=1
mkswap swapfile01
swapon swapfile01

vi /etc/fstab

/opt/swapfile01 swap swap defaults 0 0

oracle 9i export

if exporting from an oracle 9 instance ended in error you have to run $ORACLE_HOME/rdbms/admin/catexp.sql first.

connect to network resources on another domain

To connect to network resources in form of \\server\share on a computer which is a member of a domain other than the one you are and when you get "There are currently no logon servers available to service your request" error, do the following

1. You should know the exact share name on the server that you are connecting to.
2. explorer->Tools->Map network drive
3. specify the share name
4. user other username and password
5. Specify DOMAIN_NAME\username as username

whenever you come accros this.....

symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

you have to set LD_ASSUME_KERNEL=2.4.1 in the environment of whatever user trying to run Oracle tools like dbca

Ubuntu as nis client for Solaris

Since YP reports map files from Solaris to have dots like auto.master instead of underscores like auto_master; /etc/init.d/autofs must be changed to replace underscores with dot just like REDHAT.


a varible UNDERSCORETODOT=1 is added under the debian section and when the value is checked I replceed the below statement

map=`basename $map | sed -e s/^auto_home/auto.home/ -e s/^auto_mnt/auto.mnt/`

with

map=`basename $map | sed -e s/auto_/auto./g`

now all underscores are converted into dots.

oracle 9 default alret log

$ORACLE_HOME/rdbms/log

ethernet conenction bonding RHEL

This one works
http://www.howtoforge.com/network_card_bonding_centos

linux create iso

dd if=/dev/cdrom of=/root/my_cd1.iso

Solaris Automount NFS with linux clients

Solaris Box:
0. /et/defaultdomain :: Put NIS domain name here

1. vi /etc/dfs/dfstab
share -F nfs -o rw /apps1
share -F nfs -o rw /home1
share -F nfs -o rw /data

2. vi /etc/auto_master
/apps1 auto_apps -nosuid,nobrowse

3. vi /etc/auto_apps
oracle -ro s2:/apps1/oracle
gf_admin -rw s2:/apps1/gf_admin

4. vi /var/yp/Makefile
Copy the section auto_home and auto.home and create corresponding auto_apps and auto.apps sections

5. make

6. *TO DO*: to prevent the NIS server from automounting its own directories and consecutively not seeing the contents of those - falsely automounted - directories I removed the "files nis" tags in front of automount in /etc/nssswitch.conf

Linux Box:
7. /etc/sysconfig/network :: put NISDOMAIN=$nisdomainname

8. /etc/yp.bind :: specify server and NIS Domain name

Password proetct pages in Apache

create a password encoded .httaccess file with

http://www.4webhelp.net/us/password.php
http://shop.alterlinks.com/htpasswd/htpasswd.php
http://www.htmlite.com/HTA006a.php

in form of user:encoded_password

then add the following to corerct section in httpd.conf file

AuthUserFile /full/path/to/.htaccess
AuthType Basic
AuthName "Authorization Required"
Require valid-user

restart apache

Cacti on Windows

The following have to be set in the cacti->settings

PATH
spine path is to be set
rrdtool font is to be set like c:/cacti/arial.ttf

GENERAL
RRDTOOL version must match the installed rrdtool

NIS AUTOMOUNT

1. server: /etc/exports, define exportable directories

/users *(rw,no_root_squash,no_all_squash,sync)
/apps *(ro,sync)

2. server: service nfs restart

3. server: /var/yp/Makefile, edit to include auto.* in make all
(YP server is to be installed first)

4. server: /etc/auto.master :: <--- REMEMBER NO /etc in front of auto.*
/users auto.home --ghost
/apps auto.local --ghost

5. server: /etc/auto.home ::
* -rw dcssrv4:/users/&

6. server: /etc/auto.local ::
oracle -ro dcssrv4:/apps/oracle
gf_admin -ro dcssrv4:/apps/gf_admin

7. server: cd /var/yp;make

8. server: service ypserv restart

9. client: edit /etc/nsswitch.conf :: automount nis files

10. client /etc/sysconfig/network :: put NISDOMAIN=xxxxxxx

11. client /etc/yp.conf :: put domain NISDOMAIN server XXXX

12. client: service ypbind restart & service autofs restart

look at http://penguin.triumf.ca/recipes/nis-auto/index.html
(it has an error, check the instrucion #4 above)

geoframe document errors

1. gf_admin must be of group dba
2. chmod 775 /home/oracle

qemu resize image file

1. qemu-img convert system.qcow -O raw system.raw
2. dd if=/dev/zero of=system.raw seek=N obs=1GB count=0 (N=final size)
3. qemu-img convert system.raw -O qcow growed-system.qcow

QEMU change cdrom

1. start qemu with -monitor stdio option along with other options
2. press CTRL+ALT+2 to enter CLI mode and CTRL+ALT+1 to exit
3. enter command "change cdrom isofilename.iso"

remember you stupid that

files that start with . (dot) in linux will be hidden from plain ls, Gnome deskop,...

Oracle SNMP for Cacti monitoring

from http://forums.cacti.net/about6209.html
Step 0 : Enverionment

OS : SunOS dbateam 5.8
Oracle Version: 8.1.6

Step 1 : Stop Sun's snmpdx process.

login as root account:
1-0
%ps -ef | grep snmp | grep -v grep
root 6438 1 0 Sep 10 ? 0:01 /usr/lib/dmi/snmpXdmid -s bscss02d
root 6427 1 0 Sep 10 ? 0:20 /usr/lib/snmp/snmpdx -y -c /etc/snmp/conf
%
%kill -9 6438 6427

1-2
# ps -ef | grep mib
root 6405 1 0 Nov 01 ? 0:24 mibiisa -r -p 32934
root 2373 1 0 Oct 21 ? 3:23 mibiisa -r -p 32882
root 6512 1 0 Nov 01 ? 0:25 mibiisa -r -p 32956
root 6578 1 0 Nov 01 ? 0:26 mibiisa -r -p 32977
root 6620 1 0 Nov 01 ? 0:01 mibiisa -r -p 32998
root 6558 1 0 Nov 01 ? 0:24 mibiisa -r -p 32972
root 6434 1 0 Nov 01 ? 0:30 mibiisa -r -p 32941
root 7284 7280 0 19:03:46 ? 0:00 mibiisa -r -p 40714
# kill -9 6405 2373 6512 6578 6620 6434 7284

1-3
check process of oracle snmp
%ps -ef | grep peer
root 6607 1 0 Nov 01 ? 0:06 ./encap_peer -t 1162 -s 1160 -c CONFIG.encap
root 6605 1 0 Nov 01 ? 0:13 ./master_peer CONFIG.master NOV
%kill -9 6607 6605


Step 2 : Start Oracle Snmp

2-0: check $ORACLE_HOME/network/snmp/peer/CONFIG.master
COMMUNITY public
ALLOW ALL OPERATIONS
USE NO ENCRYPTION
MANAGER xxx.xxx.xxx.xxx
SEND ALL TRAPS

2-1: check $ORACLE_HOME/network/snmp/peer/CONFIG.encap
AGENT AT PORT 1161 WITH COMMUNITY public
SUBTREES 1.3.6.1.2.1.1,
1.3.6.1.2.1.2,
1.3.6.1.2.1.3,
1.3.6.1.2.1.4,
1.3.6.1.2.1.5,
1.3.6.1.2.1.6,
1.3.6.1.2.1.7,
1.3.6.1.2.1.8,
1.3.6.1.4.1.11.2
FORWARD ALL TRAPS;

2-3: check start_peer
SNMPD=/usr/lib/snmp/snmpdx
SNMPD_CONFIG=/etc/snmp/conf
SNMPD_OPTIONS=-y


2-4: loging as root

%/bin/ksh
%export ORACLE_HOME=/oracle/816/product/8.1.6
%cd $ORACLE_HOME/network/snmp/peer/
%./start_peer -a
Starting master_peer ...
./master_peer CONFIG.master NOV >master_peer.out 2>&1 &
Done!

Starting encap_peer ...
./encap_peer -t 1162 -s 1160 -c CONFIG.encap >encap_peer.out 2>&1 &
Done!

Starting /usr/lib/snmp/snmpdx ...
/usr/lib/snmp/snmpdx -y -c /etc/snmp/conf -p 1161 >snmpd.out 2>&1 &
Done!

check files ( master_peer.out,encap_peer.out,snmpd.out )
there will be no content,if start oracle snmp success,like ..
%ls -ltr *.out
-rw-r--r-- 1 root other 0 nov 2 19:11 master_peer.out
-rw-r--r-- 1 root other 0 nov 2 19:11 encap_peer.out
-rw-r--r-- 1 root other 0 nov 2 19:11 snmpd.out

startup oracle listener for dbsnmp
su - oracle account
agentctl start
%snmpwalk -Os -v 1 -c public 172.16.28.223 1.3.6.1.4.1.111

Windows: computer cannot connect to some sites

Windows: Computer cannot connect to some websites to which other have absolutely no problems connecting:

ipconfig /flushdns

can help A LOT!!!

Thanks to my brother Moslem Saleh

Solaris check 64 bit

isainfo -vk