Posts

Showing posts from April, 2009

Radiator Radius Installation connecting to ORACLE (CentOS)

1. Download and install the Oracle client connectors.

http://www.oracle.com/index.html

oracle-instantclient-basic-10.2.0.3-1.i386.rpm
oracle-instantclient-devel-10.2.0.3-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

rpm -Uvh oracle-instantclient-basic-10.2.0.3-1.i386.rpm
rpm -Uvh oracle-instantclient-devel-10.2.0.3-1.i386.rpm
rpm -Uvh oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

2. Set the environment variables.

# ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib
# export ORACLE_HOME
# export LD_LIBRARY_PATH=$ORACLE_HOME

# TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin
# export TNS_ADMIN

# mkdir /usr/lib/oracle/10.2.0.3/client/admin


3. Edit /etc/profiles and insert the lines below.

ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib
export ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME

TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin
export TNS_ADMIN

4. Create a file "tnsnames.ora" and insert the settings below.

SERVER1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = …