1)Configure host name lookup.
---------------
192.168.0.4 mail.yourdomain mail
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
---------------
2)Install system-switch-mail
---------------
yum install system-switch-mail
---------------
and configure MTA as postfix
3)Install and setup Postfix SMTP server.
-----------------
yum install postfix*
Edit '/etc/postfix/main.cf' and enter they following details.
inet_interfaces = all
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
home_mailbox = Maildir/
After doing this, restart postfix
/etc/init.d/postfix restart
/sbin/chkconfig postfix on
4)Install and setup Dovecot POP3 and IMAP server.
yum install dovecot*
Edit /etc/dovecot.conf' and enter the following entries.
protocols = pop3 pop3s imap imaps
mail_location = maildir:~/Maildir/
pop3_uidl_format = %08Xu%08Xv
imap_client_workarounds = delay-newmail outlook-idle netscape-eoh
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
After doing this, restart dovecot
/etc/init.d/dovecot restart
/sbin/chkconfig dovecot on
5)Install and setup SquirrelMail WebMail.
yum install squirrelmail*
From a Terminal window, type in /usr/share/squirrelmail/config/conf.pl and press Enter. This will launch the SquirrelMail Configuration utility.
Type in D and press Enter to select the Set pre-defined settings for specific IMAP servers menu. Type in dovecot and press Enter.
6) Relay Mails via gmail.
Installed postfix and removed sendmail:
# yum install postfix
# yum remove sendmail
Install openssl and openssl-perl are installed so we can generate certificates and create SSL connections to GMail
# yum install openssl openssl-perl
Create a Certificate Authority (if you don’t already have one):
# cd /etc/pki/tls/misc
# ./CA.pl -newca
You will be prompted for the file name (just hit Enter). Then you will be asked for a PEM pass phrase, which you need to remember. You can fill out the Country Name, State or Province Name, Locality Name, Organization Name, and Organizational Unit Name to your liking (or take the defaults). You need to remember the Organization Name (if you changed it) as it must match one in a key we create later. For the Common Name, fill in “CA” (without quotes). Take defaults for everything else and when prompted to enter the pass phrase you need to enter the same one you did above.
Create a client key that is sent to GMail to start the SSL encryption:
# cd /etc/pki/tls
# mkdir gmail_relay
# cd gmail_relay
# openssl genrsa -out server.key 1024
# openssl req -new -key server.key -out server.csr
# openssl ca -out server.pem -infiles server.csr
Add the following to the bottom of the file /etc/postfix/main.cf
#### GMail SSL SMTP Relay
relayhost = [smtp.gmail.com]:587
#auth
smtp_sasl_auth_enable=yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
#tls
smtp_use_tls = yes
smtp_sasl_security_options = noanonymous
smtp_sasl_tls_security_options = noanonymous
smtp_tls_note_starttls_offer = yes
tls_random_source = dev:/dev/urandom
smtp_tls_scert_verifydepth = 5
smtp_tls_key_file=/etc/pki/tls/gmail_relay/server.key
smtp_tls_cert_file=/etc/pki/tls/gmail_relay/server.pem
smtpd_tls_ask_ccert = yes
smtpd_tls_req_ccert =no
smtp_tls_enforce_peername = no
Create /etc/postfix/sasl_passwd file with your GMail login credentials that looks like below:
gmail-smtp.l.google.com user@gmail.com:password
smtp.gmail.com user@gmail.com:password
Create /etc/postfix/sasl_passwd.db file using the following command.
postmap hash:/etc/postfix/sasl_passwd
/etc/init.d/postfix restart
7) Fetch mails from gmail using fetchmail.
# vi /home/user/.fetchmailrc
Put a cron to download mails every minute.
#crontab -e
*/1 * * * * user fetchmail -k &> /dev/null
8) Login to webmail and check mails :)
Wednesday, February 29, 2012
Monday, February 6, 2012
Installing Oracle Developer 6i release 2 on Fedora 10(d2k6irelease2.tar)
Steps to install forms6i in Linux.
1)Download the following files.
a) d2k6irelease2.tar
http://download.oracle.com/otn/linux/forms/d2k6irelease2.tar
b) openmotif-2.1.30-4_MLI.i386.rpm
and openmotif-devel-2.1.30-4_MLI.i386.rpm
ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-2.1.30-4_MLI.i386.rpm
ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-devel-2.1.30-4_MLI.i386.rpm
2)Create an user “oradev” and group “dba”
#groupadd dba
#useradd oradev -g dba
#psswd oradev
(Enter the passwork you wish to give here)
3) Copy d2k6irelease2.tar file to “/home/oradev/” and extract it.
#cp -r /home/youruser/Download/d2k6irelease2.tar /home/oradev/
#tar -xvf d2k6irelease2.tar
4)If /etc/oratab already exist, please rename it.
#mv /etc/oratab /etc/oratab.bck
5) Check whether these libraries exist in /usr/X11R6/lib
# locate libX11.so
# locate libX11.so
# locate libXext.so
# locate libXmu.so
# locate libXp.so
# locate libXpm.so
# locate libXt.so
# locate libXtst.so
#locate libXm.a
# locate libXt.a
# locate libX11.a
If these libraries are not install or installed in another location, please install it and create and symbolic link to /usr/X11R6/lib/
# ln -s /usr/lib/libXmu.so /usr/X11R6/lib/
6)change the directory to /home/oradev/orainst/, the installation should start from this folder. Execute the following command to start installation.
#cd /home/oradev/orainst/
#./orainst
7)This will show a GUI for installing Forms6i
a) Select the installation method:Default Install
b)Select the Installer activity: Install, Upgrade, or De-Install Software
c) Select the Installer option: Install New Product - Do Not Create DB Objects
d) Environment Variables :Confirm, change, or enter values for the environment variables
set ORACLE_BASE:as /home/oradev/app and ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5
e) Software Asset Manager : Oracle Forms Server and Forms and Oracle Reports Server and Reports.
To Select these 2 option, keep the curser to the position Oracle Forms Server and Forms and press enter, move down the curser to Oracle Reports Server and Reports and press enter. After doing this press letter 'r' and then press letter 'i'.
f) Please enter the directory where the X-Windows libraries : /usr/X11R6/lib/
g)Please enter the directory where the MOTIF library (libXm.a) is located: /usr/X11R6/lib/
h) GUI choice : check all items:
i)In the Component Selection (for Forms), select all the items except the first:
[] Form Server for Web deployment
[X] Motif Bitmapped Interface
[X] Designer and Generater Executables
[X] Character Mode Interface
Click on OK.
j)In the Component Selection (for Reports), select all the items except the first:
[] Reports Multitier Server for Web deployment
[X] Motif Bitmapped Interface
[X] Report Designer and Converter Executables
[X] Character Mode Interface
Click on OK.
8)After installation correct the tnsnames.ora file.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.246)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
9)Set environment parameters correctly. Add these entries to .bash_profile file.
export PATH=/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/bin:
/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oradev/bin:/home/oradev/app/oracle/product/8.0.5/bin
export ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/X11R6/lib:
/home/oradev/app/oracle/product/8.0.5/network/jre11/lib/linux/native_threads:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386
export ORACLE_TERM=vt220
10) To open the file from linux PC, please browse the binary path f60runm. Now onwards you can open the fmx file without any issue
1)Download the following files.
a) d2k6irelease2.tar
http://download.oracle.com/otn/linux/forms/d2k6irelease2.tar
b) openmotif-2.1.30-4_MLI.i386.rpm
and openmotif-devel-2.1.30-4_MLI.i386.rpm
ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-2.1.30-4_MLI.i386.rpm
ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-devel-2.1.30-4_MLI.i386.rpm
2)Create an user “oradev” and group “dba”
#groupadd dba
#useradd oradev -g dba
#psswd oradev
(Enter the passwork you wish to give here)
3) Copy d2k6irelease2.tar file to “/home/oradev/” and extract it.
#cp -r /home/youruser/Download/d2k6irelease2.tar /home/oradev/
#tar -xvf d2k6irelease2.tar
4)If /etc/oratab already exist, please rename it.
#mv /etc/oratab /etc/oratab.bck
5) Check whether these libraries exist in /usr/X11R6/lib
# locate libX11.so
# locate libX11.so
# locate libXext.so
# locate libXmu.so
# locate libXp.so
# locate libXpm.so
# locate libXt.so
# locate libXtst.so
#locate libXm.a
# locate libXt.a
# locate libX11.a
If these libraries are not install or installed in another location, please install it and create and symbolic link to /usr/X11R6/lib/
# ln -s /usr/lib/libXmu.so /usr/X11R6/lib/
6)change the directory to /home/oradev/orainst/, the installation should start from this folder. Execute the following command to start installation.
#cd /home/oradev/orainst/
#./orainst
7)This will show a GUI for installing Forms6i
a) Select the installation method:Default Install
b)Select the Installer activity: Install, Upgrade, or De-Install Software
c) Select the Installer option: Install New Product - Do Not Create DB Objects
d) Environment Variables :Confirm, change, or enter values for the environment variables
set ORACLE_BASE:as /home/oradev/app and ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5
e) Software Asset Manager : Oracle Forms Server and Forms and Oracle Reports Server and Reports.
To Select these 2 option, keep the curser to the position Oracle Forms Server and Forms and press enter, move down the curser to Oracle Reports Server and Reports and press enter. After doing this press letter 'r' and then press letter 'i'.
f) Please enter the directory where the X-Windows libraries : /usr/X11R6/lib/
g)Please enter the directory where the MOTIF library (libXm.a) is located: /usr/X11R6/lib/
h) GUI choice : check all items:
i)In the Component Selection (for Forms), select all the items except the first:
[] Form Server for Web deployment
[X] Motif Bitmapped Interface
[X] Designer and Generater Executables
[X] Character Mode Interface
Click on OK.
j)In the Component Selection (for Reports), select all the items except the first:
[] Reports Multitier Server for Web deployment
[X] Motif Bitmapped Interface
[X] Report Designer and Converter Executables
[X] Character Mode Interface
Click on OK.
8)After installation correct the tnsnames.ora file.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.246)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
9)Set environment parameters correctly. Add these entries to .bash_profile file.
export PATH=/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/bin:
/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oradev/bin:/home/oradev/app/oracle/product/8.0.5/bin
export ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/X11R6/lib:
/home/oradev/app/oracle/product/8.0.5/network/jre11/lib/linux/native_threads:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386
export ORACLE_TERM=vt220
10) To open the file from linux PC, please browse the binary path f60runm. Now onwards you can open the fmx file without any issue
Sunday, November 27, 2011
Steps to Install Oracle10g Developer Suit in Linux(Fedora 10)
1. Download Oracle Developer Suite10g for Linux.
This includes the full distribution of Oracle Developer Suite 10g
- Oracle Forms Developer
- Oracle Reports Developer
- Oracle JDeveloper
File Segments
as_linux_x86_ids_101202_disk1.cpio (620,520,448 bytes) (cksum - 3772729309)
as_linux_x86_ids_101202_disk2.cpio (176,651,776 bytes) (cksum - 1501472911)
2. Create user in which you wish to install Developement suit.
# useradd oradev
# passwd oradev
Changing password for user oradev
New UNIX password:
Retype new UNIX password:
passwd: all authentication
tokens updated successfully
4. Install Location
Suppose you're installing it in /home/oradev directory, copy the cpio files to these location.
Extract each uncompressed downloadable using "cpio" as root user.
# cat as_linux_x86_ids_101202_disk1.cpio | cpio -icd
# cat as_linux_x86_ids_101202_disk2.cpio | cpio -icd
8. runInstaller
1. Log in as oradev and runInstaller
# cd Disk1
# ./runInstaller
If you are asked to run any scripts while installation to change permissions and create directories, please run that script. Another error you might get during installation is relink error. Please run this script if you get any relink error.
/home/oradev/OraHome_1/bin/OracleAS_Relink_Patch.sh
Post Installation.
Set the following environment variables.
export ORACLE_HOME=/home/oradev/OraHome_1
export LD_LIBRARY_PATH=/home/oradev/OraHome_1/lib:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386/server:/home/oradev/OraHome_1/jdk/jre/lib/i386/native_threads:/home/oradev/OraHome_1/jdk/jre/lib/i386/client:/home/oradev/OraHome_1/jre/1.4.2/lib/i386/client:/home/oradev/OraHome_1/jre/1.4.2/lib/i386/server
export MALLOC_CHECK_=0
The installation of Developer Suite 10g was successful. You can access it using the following scripts.
Form Builder:
$ORACLE_HOME/bin/frmbld.sh
Report Builder:
$ORACLE_HOME/bin/rwbuilder.sh
Start OC4J:
$ORACLE_HOME/j2ee/DevSuite/startinst.sh
Stop OC4J:
$ORACLE_HOME/j2ee/DevSuite/stopinst.sh
This includes the full distribution of Oracle Developer Suite 10g
- Oracle Forms Developer
- Oracle Reports Developer
- Oracle JDeveloper
File Segments
as_linux_x86_ids_101202_disk1.cpio (620,520,448 bytes) (cksum - 3772729309)
as_linux_x86_ids_101202_disk2.cpio (176,651,776 bytes) (cksum - 1501472911)
2. Create user in which you wish to install Developement suit.
# useradd oradev
# passwd oradev
Changing password for user oradev
New UNIX password:
Retype new UNIX password:
passwd: all authentication
tokens updated successfully
4. Install Location
Suppose you're installing it in /home/oradev directory, copy the cpio files to these location.
Extract each uncompressed downloadable using "cpio" as root user.
# cat as_linux_x86_ids_101202_disk1.cpio | cpio -icd
# cat as_linux_x86_ids_101202_disk2.cpio | cpio -icd
8. runInstaller
1. Log in as oradev and runInstaller
# cd Disk1
# ./runInstaller
If you are asked to run any scripts while installation to change permissions and create directories, please run that script. Another error you might get during installation is relink error. Please run this script if you get any relink error.
/home/oradev/OraHome_1/bin/OracleAS_Relink_Patch.sh
Post Installation.
Set the following environment variables.
export ORACLE_HOME=/home/oradev/OraHome_1
export LD_LIBRARY_PATH=/home/oradev/OraHome_1/lib:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386/server:/home/oradev/OraHome_1/jdk/jre/lib/i386/native_threads:/home/oradev/OraHome_1/jdk/jre/lib/i386/client:/home/oradev/OraHome_1/jre/1.4.2/lib/i386/client:/home/oradev/OraHome_1/jre/1.4.2/lib/i386/server
export MALLOC_CHECK_=0
The installation of Developer Suite 10g was successful. You can access it using the following scripts.
Form Builder:
$ORACLE_HOME/bin/frmbld.sh
Report Builder:
$ORACLE_HOME/bin/rwbuilder.sh
Start OC4J:
$ORACLE_HOME/j2ee/DevSuite/startinst.sh
Stop OC4J:
$ORACLE_HOME/j2ee/DevSuite/stopinst.sh
Friday, November 18, 2011
Steps to Install Oracle 10g in Linux(Fedora 13)
1) Create the new groups and users for installation
$ groupadd oinstall
$ groupadd dba
$ useradd -g oinstall -G dba oracle
$ passwd oracle
2) Fedora Core Packages required for Installation
$ yum install setarch-*
$ yum install tcl-*
$ yum installlibXau-devel-* libXp-*
$ yum installcompat-db-*
$ yum install compat-libstdc++-33*
$ yum install compat-libf2c-34-*
$ yum install compat-gcc-34-*
$ yum install libaio-*
$ yum install compat-gcc-34-c++-*
$ yum install compat-libstdc++-296*
$ yum install compat-libgcc-296*
$ rpm -Uvh openmotif21-2.1.30-14.i386.rpm
3) Checking Memory and Swap Space
Oracle recommends at least 512MB of RAM and 1GB of swap space or twice the size of RAM on the
system. For testing purpose, you can work even with 256MB as well.
To check the size of physical memory, run the following command.
$ grep MemTotal /proc/meminfo
To check the size of swap space, run the following command.
$ grep SwapTotal /proc/meminfo
What if you don’t have enough swap space?
You can add temporary swap space to your system by creating a temporary swap file instead of using
a raw device. Below is the procedure.
Login as root (su - root)
$ dd if=/dev/zero of=tmpswap bs=1k count=900000
$ chmod 600 tmpswap
$ mkswap tmpswap
$ swapon tmpswap
You can also disable the temporary swap space using the following commands.
Login as root (su - root)
$ swapoff tmpswap
$ rm tmpswap
4) Checking temporary (/tmp) Space
Oracle recommends that you should have up to 400 MB space.
To check the space in /tmp, run the following command.
$ df /tmp
What if I don’t have enough temporary space?
If you do not have enough space in the /tmp filesystem, you can temporarily create a tmp directory in
another file system. Below is the procedure to create it.
Login as root (su - root)
$ mkdir //tmp # e.g. mkdir /u02/tmp
$ chown root.root //tmp
$ chmod 1777 //tmp
$ export TEMP=/ # This is used by Oracle
$ export TMPDIR=/ # This is used by Linux programs like the linker "ld"
After Oracle installation is done, you can remove the temporary /tmp directory. I would recommend to
shutdown Oracle first.
Login as root (su - root)
$ rmdir //tmp
$ unset TEMP
$ unset TMPDIR
5) Set Kernel Parameters
Perform the following changes in the kernel parameters.
i. Add the following lines to the /etc/sysctl.conf file.
Login as root (su - root)
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
6) Run the following command to change the current kernel parameters.
$ /sbin/sysctl -p
7) Add the following lines to the /etc/security/limits.conf file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
8) Add the following line to the /etc/pam.d/login file, if it does not already exist.
session required /lib/security/pam_limits.so
9) Disable secure linux in the /etc/selinux/config file. You can do by setting value of SELINUX as
follows.
SELINUX=disabled
10) Copy the oracle zip file to "/home/oracle/"
Downloading the software and unpacking installation files
"10201_database_linux32.zip" (668,734,007 bytes) (cksum - 2737423041)
11) Uncompress the file using unzip
$ unzip 10201_database_linux32.zip
You should now have a single directory (db/Disk1) containing installation files.
12) Paste the following lines in /home/oracle/.bash_profile
--------------------------
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/home/oracle/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export
CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
--------------------------
13) Change the redhat release information
Edit the /etc/redhat-release file replacing the current release information (Fedora 13) with the following. You can copy the original file somewhere else as it will be required after
installation.
redhat-4
14) Start the Oracle Universal Installer (OUI)
As Oracle user, go to the Disk1 directory and start the Oracle Universal Installer (OUI) by issuing the
following command.
$ ./runInstaller
15)Once successfully installed we can access it using the the following URL.
iSQL*Plus URL:
http://localhost:5560/isqlplus
iSQL*Plus DBA URL:
http://localhost:5560/isqlplus/dba
Enterprise Manager 10g Database Control URL:
http://localhost:1158/em
Post Installation Steps
------------------------
1) Edit the '/etc/oratab' file to as given below.
orcl:/home/oracle/oracle/product/10.2.0/db_1:Y
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
2) Edit "/home/oracle/oracle/product/10.2.0/db_1/bin/dbstart" file.
Please make sure that oracle home is set correctly in this file.
I am pasting few lines of the orginal script.
=====================
#Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
if [ ! $ORACLE_HOME_LISTNER ] ; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
else
LOG=$ORACLE_HOME_LISTNER/listener.log
# Start Oracle Net Listener
if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
echo "$0:
=====================
#Correct the ORACLE_HOME_LISTNER path as your ORACLE_HOME, I have given this as
ORACLE_HOME_LISTNER=/home/oracle/oracle/product/10.2.0/db_1
3) Create a start up script to start all oracle related services.
File name : /etc/init.d/dbora
===============================================================
#!/bin/bash
#
# chkconfig: 12345 99 10
# description: Oracle auto start-stop script
# --------------------------------------------------------------------------
# File: oracle
#
# Purpose: Oracle auto start-stop script
#
# Location: /etc/init.d
#
# Certified: Oracle 10.2.0.3 on Enterprise Linux 5
# --------------------------------------------------------------------------
# Variables
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_BASE=/home/oracle/oracle; export ORACLE_BASE
ORACLE_SCRIPTS_DIR=$ORACLE_BASE/product/10.2.0/db_1/bin; export ORACLE_SCRIPTS_DIR
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
[ -f /etc/sysconfig/network ] && . /etc/sysconfig/network
RETVAL=0
prog="oracle"
start() {
echo -n $"Starting $prog: "
if [ ! -f $ORACLE_SCRIPTS_DIR/dbstart ]
then
echo "Oracle not started (no dbstart script)"
else
# Start RDBMS
su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbstart
# Start Enterprise Manager Console
su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl start dbconsole
# Start iSQL*Plus
su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl start
fi
RETVAL=$?
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle
return $RETVAL
}
stop() {
echo -n $"Shutting down $prog: "
if [ ! -f $ORACLE_SCRIPTS_DIR/dbshut ]
then
echo "Oracle not stopped (no dbshut script)"
else
# Stop iSQL*Plus
su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl stop
# Stop Enterprise Manager Console
su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl stop dbconsole
# Stop RDBMS
su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbshut
fi
RETVAL=$?
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle
return $RETVAL
}
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
*)
echo $"Usage: $0 {start|stop}"
exit 1
esac
exit $RETVAL
===============================================================
4) Then add the script in chkconfig.
su - root
chkconfig --add oracle
chkconfig --list oracle
--------------------------------------------------------------
Done! Nothing more to do.
Reboot your machine and check whether enterprise manager is running :)
$ groupadd oinstall
$ groupadd dba
$ useradd -g oinstall -G dba oracle
$ passwd oracle
2) Fedora Core Packages required for Installation
$ yum install setarch-*
$ yum install tcl-*
$ yum installlibXau-devel-* libXp-*
$ yum installcompat-db-*
$ yum install compat-libstdc++-33*
$ yum install compat-libf2c-34-*
$ yum install compat-gcc-34-*
$ yum install libaio-*
$ yum install compat-gcc-34-c++-*
$ yum install compat-libstdc++-296*
$ yum install compat-libgcc-296*
$ rpm -Uvh openmotif21-2.1.30-14.i386.rpm
3) Checking Memory and Swap Space
Oracle recommends at least 512MB of RAM and 1GB of swap space or twice the size of RAM on the
system. For testing purpose, you can work even with 256MB as well.
To check the size of physical memory, run the following command.
$ grep MemTotal /proc/meminfo
To check the size of swap space, run the following command.
$ grep SwapTotal /proc/meminfo
What if you don’t have enough swap space?
You can add temporary swap space to your system by creating a temporary swap file instead of using
a raw device. Below is the procedure.
Login as root (su - root)
$ dd if=/dev/zero of=tmpswap bs=1k count=900000
$ chmod 600 tmpswap
$ mkswap tmpswap
$ swapon tmpswap
You can also disable the temporary swap space using the following commands.
Login as root (su - root)
$ swapoff tmpswap
$ rm tmpswap
4) Checking temporary (/tmp) Space
Oracle recommends that you should have up to 400 MB space.
To check the space in /tmp, run the following command.
$ df /tmp
What if I don’t have enough temporary space?
If you do not have enough space in the /tmp filesystem, you can temporarily create a tmp directory in
another file system. Below is the procedure to create it.
Login as root (su - root)
$ mkdir /
$ chown root.root /
$ chmod 1777 /
$ export TEMP=/
$ export TMPDIR=/
After Oracle installation is done, you can remove the temporary /tmp directory. I would recommend to
shutdown Oracle first.
Login as root (su - root)
$ rmdir /
$ unset TEMP
$ unset TMPDIR
5) Set Kernel Parameters
Perform the following changes in the kernel parameters.
i. Add the following lines to the /etc/sysctl.conf file.
Login as root (su - root)
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
6) Run the following command to change the current kernel parameters.
$ /sbin/sysctl -p
7) Add the following lines to the /etc/security/limits.conf file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
8) Add the following line to the /etc/pam.d/login file, if it does not already exist.
session required /lib/security/pam_limits.so
9) Disable secure linux in the /etc/selinux/config file. You can do by setting value of SELINUX as
follows.
SELINUX=disabled
10) Copy the oracle zip file to "/home/oracle/"
Downloading the software and unpacking installation files
"10201_database_linux32.zip" (668,734,007 bytes) (cksum - 2737423041)
11) Uncompress the file using unzip
$ unzip 10201_database_linux32.zip
You should now have a single directory (db/Disk1) containing installation files.
12) Paste the following lines in /home/oracle/.bash_profile
--------------------------
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/home/oracle/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export
CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
--------------------------
13) Change the redhat release information
Edit the /etc/redhat-release file replacing the current release information (Fedora 13) with the following. You can copy the original file somewhere else as it will be required after
installation.
redhat-4
14) Start the Oracle Universal Installer (OUI)
As Oracle user, go to the Disk1 directory and start the Oracle Universal Installer (OUI) by issuing the
following command.
$ ./runInstaller
15)Once successfully installed we can access it using the the following URL.
iSQL*Plus URL:
http://localhost:5560/isqlplus
iSQL*Plus DBA URL:
http://localhost:5560/isqlplus/dba
Enterprise Manager 10g Database Control URL:
http://localhost:1158/em
Post Installation Steps
------------------------
1) Edit the '/etc/oratab' file to as given below.
orcl:/home/oracle/oracle/product/10.2.0/db_1:Y
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:
2) Edit "/home/oracle/oracle/product/10.2.0/db_1/bin/dbstart" file.
Please make sure that oracle home is set correctly in this file.
I am pasting few lines of the orginal script.
=====================
#Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
if [ ! $ORACLE_HOME_LISTNER ] ; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
else
LOG=$ORACLE_HOME_LISTNER/listener.log
# Start Oracle Net Listener
if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
echo "$0:
=====================
#Correct the ORACLE_HOME_LISTNER path as your ORACLE_HOME, I have given this as
ORACLE_HOME_LISTNER=/home/oracle/oracle/product/10.2.0/db_1
3) Create a start up script to start all oracle related services.
File name : /etc/init.d/dbora
===============================================================
#!/bin/bash
#
# chkconfig: 12345 99 10
# description: Oracle auto start-stop script
# --------------------------------------------------------------------------
# File: oracle
#
# Purpose: Oracle auto start-stop script
#
# Location: /etc/init.d
#
# Certified: Oracle 10.2.0.3 on Enterprise Linux 5
# --------------------------------------------------------------------------
# Variables
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_BASE=/home/oracle/oracle; export ORACLE_BASE
ORACLE_SCRIPTS_DIR=$ORACLE_BASE/product/10.2.0/db_1/bin; export ORACLE_SCRIPTS_DIR
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
[ -f /etc/sysconfig/network ] && . /etc/sysconfig/network
RETVAL=0
prog="oracle"
start() {
echo -n $"Starting $prog: "
if [ ! -f $ORACLE_SCRIPTS_DIR/dbstart ]
then
echo "Oracle not started (no dbstart script)"
else
# Start RDBMS
su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbstart
# Start Enterprise Manager Console
su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl start dbconsole
# Start iSQL*Plus
su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl start
fi
RETVAL=$?
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle
return $RETVAL
}
stop() {
echo -n $"Shutting down $prog: "
if [ ! -f $ORACLE_SCRIPTS_DIR/dbshut ]
then
echo "Oracle not stopped (no dbshut script)"
else
# Stop iSQL*Plus
su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl stop
# Stop Enterprise Manager Console
su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl stop dbconsole
# Stop RDBMS
su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbshut
fi
RETVAL=$?
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle
return $RETVAL
}
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
*)
echo $"Usage: $0 {start|stop}"
exit 1
esac
exit $RETVAL
===============================================================
4) Then add the script in chkconfig.
su - root
chkconfig --add oracle
chkconfig --list oracle
--------------------------------------------------------------
Done! Nothing more to do.
Reboot your machine and check whether enterprise manager is running :)
Sunday, October 31, 2010
Linux Plesk Backend Files
Plesk root directory : /usr/local/psa
Version : /usr/local/psa/version
Admin password is stored : /etc/psa/.psa.shadow
Plesk configuration file : /etc/psa/psa.conf
Restart Plesk : /etc/rc.d/init.d/plesk restart
Apache
Main httpd configuration file : /etc/httpd/conf/httpd.conf
Plesk httpd : /etc/httpd/conf.d/zz010_psa_httpd.conf
Include conf files are under : /etc/httpd/conf.d (depends on the location specified in main httpd)
Startup script for plesk apache : /usr/local/psa/admin/bin/httpsdctl start
Apache main log files under : /var/log/httpd
PHP
Php configuration file : /etc/php.ini
Php extension modules are taken from : /etc/php.d
Named
Conf file located : /var/named/run-root/etc/named.conf
DB record : /var/named/run-root/var/domain.com
Log file : /var/log/messages
Service to restart : /etc/init.d/named restart
FTP
Conf file : /etc/proftpd.conf
Log file : /var/log/messages
Mysql
Databases are located at : /var/lib/mysql
Configuration file : /etc/my.cnf
Mysql log : /var/log/mysqld.log
Mail Server
Location of qmail directory : /var/qmail
Mail directory of a domain : /var/qmail/mailnames/domain.com
Mail log : /var/log/maillog or /usr/local/psa/var/log/maillog
Home directory of a domain
Home directory : /var/www/vhosts/domain.com
Httpd conf file of a domain : /var/www/vhosts/domain.com/conf/httpd.include
document root directory : /var/www/vhosts/domain.com/httpdocs
Document root directory of secure website : /var/www/vhosts/domain.com/httpdsdocs
Subdomains are created under : /var/www/vhosts/domain.com/subdomains
Domain specific logs are under : /var/www/vhosts/domain.com/statistics/ logs
==============================================
To log in to plesk use
https: :8443
There are four login levels for plesk
They are
1) Administrator
2)Client/Reseller
3) Domain owner
4) Email user
Each level has got its own functions
Administrator
This login is used to by hosting administators to manage the server items . Client/reseller,Domain owner,Email user creation can be done by using this account.
Note : We cannot use the root password for login to this account as in Cpanel. To login to this account use
Username : admin
Password : (will be stored in fiel /etc/psa/.psa.shadow )
Client/Reseller
This is the second tier account . Domain owner accounts and Email user accounts can be managed from this account.
Domain owner
Everything related to one domain can be managed by using this account. usually client/reseller creates a Domain owner account.
mail user
This is the fourth tier account. Here users are allowed to manage their mail account. Only mail related functions are allowed here such as sending mails ,seting spam filters etc.
Software componets of plesk.
The following software components are used with plesk.
DNS server : bind
Webserver : Apache
FTP server : proftpd
Mail server : Mysql,mssql,postgresql
IMAP/POP : courier-IMAP
Mailing list: Mailman
Statistical softwares : Webalizer, AWstats
Types of hosting
In plesk, 3 modes of hosting are avaliable
They are
Physical hosting
The domain is actually hosted on that server.
Standard Hosting
Here url is redirected such that browser url will be changed to destination url
Frame forward
Here also redirection takes place. But browser url doesnot change
PSA DATABASE
*****************
Plesk has a database called psa. We can use the administrator username(admin) and password to login to psa database.
>Tables in psa database are
1. Domains
2. Clients
3. db_users
4.db_bases
5. disk_spaces
6.mail
7.lockout
8. web_users
Backup
> To back up all data
/plesk_installation_directory/bin/pleskbackup all name>
> To back up all user accounts with all users’ sites,
/plesk_installation_directory/bin/pleskbackup clients
Version : /usr/local/psa/version
Admin password is stored : /etc/psa/.psa.shadow
Plesk configuration file : /etc/psa/psa.conf
Restart Plesk : /etc/rc.d/init.d/plesk restart
Apache
Main httpd configuration file : /etc/httpd/conf/httpd.conf
Plesk httpd : /etc/httpd/conf.d/zz010_psa_httpd.conf
Include conf files are under : /etc/httpd/conf.d (depends on the location specified in main httpd)
Startup script for plesk apache : /usr/local/psa/admin/bin/httpsdctl start
Apache main log files under : /var/log/httpd
PHP
Php configuration file : /etc/php.ini
Php extension modules are taken from : /etc/php.d
Named
Conf file located : /var/named/run-root/etc/named.conf
DB record : /var/named/run-root/var/domain.com
Log file : /var/log/messages
Service to restart : /etc/init.d/named restart
FTP
Conf file : /etc/proftpd.conf
Log file : /var/log/messages
Mysql
Databases are located at : /var/lib/mysql
Configuration file : /etc/my.cnf
Mysql log : /var/log/mysqld.log
Mail Server
Location of qmail directory : /var/qmail
Mail directory of a domain : /var/qmail/mailnames/domain.com
Mail log : /var/log/maillog or /usr/local/psa/var/log/maillog
Home directory of a domain
Home directory : /var/www/vhosts/domain.com
Httpd conf file of a domain : /var/www/vhosts/domain.com/conf/httpd.include
document root directory : /var/www/vhosts/domain.com/httpdocs
Document root directory of secure website : /var/www/vhosts/domain.com/httpdsdocs
Subdomains are created under : /var/www/vhosts/domain.com/subdomains
Domain specific logs are under : /var/www/vhosts/domain.com/statistics/ logs
==============================================
To log in to plesk use
https:
There are four login levels for plesk
They are
1) Administrator
2)Client/Reseller
3) Domain owner
4) Email user
Each level has got its own functions
Administrator
This login is used to by hosting administators to manage the server items . Client/reseller,Domain owner,Email user creation can be done by using this account.
Note : We cannot use the root password for login to this account as in Cpanel. To login to this account use
Username : admin
Password : (will be stored in fiel /etc/psa/.psa.shadow )
Client/Reseller
This is the second tier account . Domain owner accounts and Email user accounts can be managed from this account.
Domain owner
Everything related to one domain can be managed by using this account. usually client/reseller creates a Domain owner account.
mail user
This is the fourth tier account. Here users are allowed to manage their mail account. Only mail related functions are allowed here such as sending mails ,seting spam filters etc.
Software componets of plesk.
The following software components are used with plesk.
DNS server : bind
Webserver : Apache
FTP server : proftpd
Mail server : Mysql,mssql,postgresql
IMAP/POP : courier-IMAP
Mailing list: Mailman
Statistical softwares : Webalizer, AWstats
Types of hosting
In plesk, 3 modes of hosting are avaliable
They are
Physical hosting
The domain is actually hosted on that server.
Standard Hosting
Here url is redirected such that browser url will be changed to destination url
Frame forward
Here also redirection takes place. But browser url doesnot change
PSA DATABASE
*****************
Plesk has a database called psa. We can use the administrator username(admin) and password to login to psa database.
>Tables in psa database are
1. Domains
2. Clients
3. db_users
4.db_bases
5. disk_spaces
6.mail
7.lockout
8. web_users
Backup
> To back up all data
/plesk_installation_directory/bin/pleskbackup all
> To back up all user accounts with all users’ sites,
/plesk_installation_directory/bin/pleskbackup clients
Wednesday, October 27, 2010
Windows Plesk backend.
Webserver:
To switch Plesk Control Panel web provider you can use the following commands:
-------------------
IIS to Apache
"%plesk_bin%\reconfigurator.exe" --switch-plesk-web-server --new-provider=apache
Apache to IIS
"%plesk_bin%\reconfigurator.exe" --switch-plesk-web-server --new-provider=iis
To install hosting for a domain
websrvmng.exe --install-vhost --vhost-name=
To remove hosting for a domain
websrvmng.exe --remove-vhost --vhost-name=
To reconfigure hosting for a domain
websrvmng.exe --reconfigure-vhost --vhost-name=
To reconfigure a subdomain
websrvmng.exe --update-subdomain --vhost-name= --subdomain=
Passwords for system user and IIS user can be unsynchronized or synchronised using
websrvmng.exe --update-anon-password --domain-name=
To reconfigure webmail
websrvmng.exe --reconfigure-webmail
defpackagemng.exe" --fix --type=webmail
Re-configure FTP configuration
For a particular domain.
"%plesk_bin%\ftpmng.exe" --remove-vhost --vhost-name=yourdomain.com
"%plesk_bin%\ftpmng.exe" --reconfigure-vhost --vhost-name=yourdomain.com
For all domains in the server.
"%plesk_bin%\ftpmng.exe" --remove-all
"%plesk_bin%\ftpmng.exe" --reconfigure-all
To switch Plesk Control Panel web provider you can use the following commands:
-------------------
IIS to Apache
"%plesk_bin%\reconfigurator.exe" --switch-plesk-web-server --new-provider=apache
Apache to IIS
"%plesk_bin%\reconfigurator.exe" --switch-plesk-web-server --new-provider=iis
To install hosting for a domain
websrvmng.exe --install-vhost --vhost-name=
To remove hosting for a domain
websrvmng.exe --remove-vhost --vhost-name=
To reconfigure hosting for a domain
websrvmng.exe --reconfigure-vhost --vhost-name=
To reconfigure a subdomain
websrvmng.exe --update-subdomain --vhost-name=
Passwords for system user and IIS user can be unsynchronized or synchronised using
websrvmng.exe --update-anon-password --domain-name=
To reconfigure webmail
websrvmng.exe --reconfigure-webmail
defpackagemng.exe" --fix --type=webmail
Re-configure FTP configuration
For a particular domain.
"%plesk_bin%\ftpmng.exe" --remove-vhost --vhost-name=yourdomain.com
"%plesk_bin%\ftpmng.exe" --reconfigure-vhost --vhost-name=yourdomain.com
For all domains in the server.
"%plesk_bin%\ftpmng.exe" --remove-all
"%plesk_bin%\ftpmng.exe" --reconfigure-all
Sunday, October 24, 2010
Windows shortcuts from Run
Add/Remove Programs - appwiz.cpl
Check Disk Utility - chkdsk
Command Prompt - cmd
Component Services - dcomcnfg
Computer Management - compmgmt.msc
Date and Time Properties - timedate.cpl
Device Manager - devmgmt.msc
Disk Management - diskmgmt.msc
Disk Partition Manager - diskpart
Display Properties - desk.cpl
Event Viewer - eventvwr.msc
Fonts control - fonts
Group Policy Editor -gpedit.msc
Local Security Settings - secpol.msc
Local Users and Groups - lusrmgr.msc
Network Connections - ncpa.cpl
Performance Monitor - perfmon.msc
Performance Monitor - perfmon
Power Configuration - powercfg.cpl
Registry Editor - regedit
Remote Desktop - mstsc
Services - services.msc
SQL Client Configuration - cliconfg
System Configuration Utility - msconfig
System File Checker Utility (Scan Immediately) - sfc /scannow
System File Checker Utility (Scan Once At Next Boot) - sfc /scanonce
System File Checker Utility (Scan On Every Boot) - sfc /scanboot
System File Checker Utility (Return to Default Set - sfc /purgecache
System File Checker Utility (Set Cache Size to size x) - sfc /cachesize=x
System Properties - sysdm.cpl
Task Manager - taskmgr
Utility Manager - utilman
Windows Firewall - firewall.cpl
Windows Management Infrastructure - wmimgmt.msc
Windows System Security Tool - syskey
Check Disk Utility - chkdsk
Command Prompt - cmd
Component Services - dcomcnfg
Computer Management - compmgmt.msc
Date and Time Properties - timedate.cpl
Device Manager - devmgmt.msc
Disk Management - diskmgmt.msc
Disk Partition Manager - diskpart
Display Properties - desk.cpl
Event Viewer - eventvwr.msc
Fonts control - fonts
Group Policy Editor -gpedit.msc
Local Security Settings - secpol.msc
Local Users and Groups - lusrmgr.msc
Network Connections - ncpa.cpl
Performance Monitor - perfmon.msc
Performance Monitor - perfmon
Power Configuration - powercfg.cpl
Registry Editor - regedit
Remote Desktop - mstsc
Services - services.msc
SQL Client Configuration - cliconfg
System Configuration Utility - msconfig
System File Checker Utility (Scan Immediately) - sfc /scannow
System File Checker Utility (Scan Once At Next Boot) - sfc /scanonce
System File Checker Utility (Scan On Every Boot) - sfc /scanboot
System File Checker Utility (Return to Default Set - sfc /purgecache
System File Checker Utility (Set Cache Size to size x) - sfc /cachesize=x
System Properties - sysdm.cpl
Task Manager - taskmgr
Utility Manager - utilman
Windows Firewall - firewall.cpl
Windows Management Infrastructure - wmimgmt.msc
Windows System Security Tool - syskey
Subscribe to:
Posts (Atom)