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