August 2012
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  

Categories

August 2012
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  

How to setup Oracle 11g DB

To install Oracle 11g DB, just install the following packages at the startup and continue

# yum install binutils gcc glibc glibc-devel cpp make setarch pdksh libaio libaio-devel compat-gcc-34 compat-gcc-34-c compat-libstdc-296 compat-libstdc-33 sysstat -y

Creating groups and user for Oracle Installation:

# groupadd oinstall # groupadd dba # useradd -m -g oinstall -G dba -d […]

Oracle Startpup script

Oracle Startup script used for Automatic start up of oracle db after rebooting the machine. I have already explained how to install oracle 11g in previous posts and just note how to add a startup script with respect to that settings

For automatically restart the oracle after system reboot create a file called oracle ( […]

How to install Oracle DB Client

Installing Oracle database Client to access DB Either you can use sqldeveloper as oracle client or you can execute it from the command line using # sqlplus We can access oracle server graphically by using a package called sqldeveloper. sqldeveloper-2.1.1.64.45-1.noarch.rpm # rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm if the front end not getting install the jdk package and […]

Oracle DB startup Scripts

Starting oracle listener

$ lsnrctl start

Start the database

$ dbstart

Starting oracle Enterprise manager $ emctl start dbconsole

Shutting down the database $ dbshut

Stopping the listener $ lsnrctl stop

Stopping oracle Enterprise manager $ emctl stop dbconsole

Starts sqlplus without logging in to a database # su ­ oracle $ sqlplus /nolog

Logging […]

Oracle Schema Creation

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. $ sqlplus /nolog

SQL> connect / as sysdba […]

Mysql Performance Tuning

Mysql Performance Tuning MySQL Performance tuning [my.cnf file parameters + description]

[mysqld]

# Maximum allowed number of connections to the MySQL Server max_connections = 1500

# The key buffer is a variable that is shared amongst all MySQL clients on the server. A large setting is recomended, particularly helpful with tables that have unique keys. […]

Multicasting

Multicast is the protocol which allow nodes inside to a cluster to communicate without knowing each other.

You can think of multicast of a radio or a TV channel, only those who are tuned received the information.

Communication between nodes is provided by JGroups, which is library for multicast communication.

 

What is multicasting? There […]

Recompile Apache 2.4.2 and Apache 2.2.22

How to Install Apache 2.4.2 from Source on CentOS 6.3 with SSL

yum install gcc yum install openssl-devel

yum install apr-devel yum install apr-util-devel

yum install libtool

yum install gcc-c++

# APR # http://mirrors.axint.net/apache//apr/apr-1.4.6.tar.gz

tar -xvzf apr-1.4.6.tar.gz

cd apr-1.4.6/

./configure

make

make install

cd ..

# APR Utils # http://mirrors.axint.net/apache//apr/apr-util-1.4.1.tar.gz

tar -xvzf apr-util-1.4.1.tar.gz

cd apr-util-1.4.1

[…]

Apache commands

# apachectl ­-k graceful In a server environment, should use the command apachectl instead of /etc/init.d/httpd. apachectl command is used to control the apache httpd daemon.

# apachectl -­k restart difference between apachectl -k graceful and apachectl -k restart is that in case of the former current requests are not aborted but in the latter […]

Jboss Server 6

Jboos 6

 

ollow the installation steps for jboss server

1. Install jdk ——-> jdk-6u7-linux-i586.bin 2. install Jboss ——> jboss-as-distribution-6.0.0.Final.zip First Install Java

 

# ./jdk-6u7-linux-i586.bin # cd jdk1.6.0_07/ Export the java home and path in .profile files # vim .bash_profile export JAVA_HOME=/opt/jdk1.6.0_07 export PATH=$PATH:$JAVA_HOME/bin # . .bash_profile # vim /etc/profile export JAVA_HOME=/opt/jdk1.6.0_07 export PATH=$PATH:$JAVA_HOME/bin […]