Monday, December 29, 2008

steps to Install bizgres on ubuntu 8.04

1.Get the bizgres and make it executable as below

chmod 700 bizgres-0_9_GA-RHEL3.bin

2. Before execute follow the below steps to create symbolic links and other settings
And make sure JAVA_HOME env is set .

[export JAVA_HOME=/opt/jdk1.6.0_01
export PATH=$JAVA_HOME/bin:$PATH
]

sed -i "s/export LD_ASSUME_KERNEL/#xport LD_ASSUME_KERNEL/" "bizgres- 0_9_GA-RHEL3.bin"

and to system changes to take effect run $ sudo ldconfig

[error when system changes does not take effect -
exec: 2473: /tmp/install.dir.14720/Linux/resource/jre/bin/java: not found
]
ln -s /usr/lib/libreadline.so /usr/lib/libreadline.so.4

3.since libtermcap is obsolete install libncurses and make the symbolic
link
aptitide install libncurses5-dev

4.Create user bgadim , And then create the data folder as below and change the owner ship to bgadmin

mkdir /opt/BIZDATA


chown -R bgadmin:bgadmin /opt/BIZDATA

5. On bgamin .bashrc add add the following line

source /usr/local/bizgres-0_9_GA/bizgres_path.sh

6.Then install following lib files and make the sym links

libreadline5-dev
sudo ln -s /usr/lib/libreadline.so /usr/lib/libreadline.so.4

sudo ln -s /usr/lib/libncurses.so.5 /usr/lib/libtermcap.so.2


your done...
before start the server edit
/opt/BIZDATA/postgresql.conf
/opt/BIZDATA/pg_hba.conf to set access permissions as necessary.


start the server
pg_ctl -D /opt/BIZDATA -l logfile start

Sunday, June 29, 2008

Automating Oracle Installation using response file

U can download Oracle from http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxsoft.html and make sure java is running before proceed.

1. create users and groups required

groupadd oinstall
groupadd dba
groupadd nobody
useradd -g oinstall -G dba,nobody -d /opt/oracle -m -s /bin/bash oracle

2. set the oracle user password
user name=oracle
passwd=oracle

3. Tune the following kernel parameters

/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000


/etc/security/limits.conf

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

Wednesday, May 14, 2008

interactive programming

if u want to talk to the programes in linx while there are running you can use Expect to do it.
as a example u can automate the connecting to reemote host as follows

spawn ssh username@host [starting process]
expect "passwd" [expecting till the process prompt for a password]
send "passwd/r" [sending passwd to the process]
interact [giving control to the user from the Expect program]