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 = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

5. Install Mysql Server for internal testing.

# yum install mysql-server.i386

this will install the following, and perl-DBI as well which you will need
as dependencies for Perl-Oracle-DBD.

============================
Package Arch Version Repository Size
============================
Installing:
mysql-server i386 5.0.45-7.el5 base 9.7 M

Installing for dependencies:
mysql i386 5.0.45-7.el5 base 4.1 M
perl-DBD-MySQL i386 3.0007-1.fc6 base 147 k
perl-DBI i386 1.52-1.fc6 base 605 k

6. Now we need to install Perl DBD Oracle Connector:
(note: you may need to install other dependencies
to make the configuration work)

a. Login as root

b. Create a temporary directory

# mkdir tempDBD
# cd tempDBD

c. gunzip/untar the DBD module

# gunzip DBD-Oracle-1.16.tar.gz
# tar -xvf DBD-Oracle-1.16.tar
# cd DBD-Oracle-1.16

d. Make/Install DBD

# perl Makefile.PL
# make
# make install

e. Remove temporary DBD directory and files

# cd ../..
# rm -rf tempDBD

7. To test if it is working run the following:

Make a pl file containig the line below
(replace the actual user and password).

use strict;
use DBI;

my $dbh = DBI->connect( 'dbi:Oracle:SERVER1',
'username',
'password',
{
RaiseError => 1,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect();

8. Or run a direct connection to oracle.

# sqlplus /@SID

e.g. sqlplus username@password/SERVER1

If both connection doesn't have error connecting to Oracle Server, everything goes well.

__________________________
Download Reference:

DBI-1.48.tar.gz
http://www.idevelopment.info/data/Oracle/DBA_tips/support_data/DBI_DBD/DBI-1.48.tar.gz

DBD-Oracle-1.16.tar.gz
http://www.idevelopment.info/data/Oracle/DBA_tips/support_data/DBI_DBD/DBD-Oracle-1.16.tar.gz

ref: (for installation instruction)
http://www.idevelopment.info/data/Oracle/DBA_tips/Programming/PROGRAMMING_2.shtml
http://search.cpan.org/search?query=DBD::Oracle

9. Install the radiator rpm package.

# useradd radiusd
# groupadd radiusd

# rpm -Uvh Radiator-4.3.1-1.noarch.rpm

10. Install Radmin a radius web control center.

(Note : Install first the Apache2 server)

# tar xzvf Radmin-1.11.tgz

# cd Radmin-1.11

# sh installMysql.sh ("for Mysql") or # sh installOracle.sh (for Oracle)
note : you need to edit content of the .sh file based from the
account you have for the database server .e.g username, password, etc.

# perl install.pl

11. Edit radmin.cfg located in /etc/radiator

12. To start it run "/etc/init.d/radiator start"

Comments

Post a Comment

Popular posts from this blog

Scraping an Entire Website using LINUX

Web scraping (also called Web harvesting or Web data extraction) is a computer software technique of extracting information from websites. Usually, such software programs simulate human exploration of the Web by either implementing low-level Hypertext Transfer Protocol (HTTP), or embedding certain full-fledged Web browsers, such as the Internet Explorer (IE) and the Mozilla Web browser. Web scraping is closely related to Web indexing, which indexes Web content using a bot and is a universal technique adopted by most search engines. In contrast, Web scraping focuses more on the transformation of unstructured Web content, typically in HTML format, into structured data that can be stored and analyzed in a central local database or spreadsheet. Web scraping is also related to Web automation, which simulates human Web browsing using computer software. Exemplary uses of Web scraping include online price comparison, weather data monitoring, website change detection, Web research, Web content ...
Read more

Linux OS Backup and Recovery

Image
Source :http://relax-and-recover.org/documentation/getting-started This quick start guide will show you how to run Relax-and-Recover from the git checkout and create a bootable USB backup. Start by cloning the Relax-and-Recover sources from Github: git clone https://github.com/rear/rear.git Move into the rear/ directory: cd rear/ Prepare your USB media. Change /dev/sdb to the correct device in your situation. Relax-and-Recover will ‘own’ the device in this example. This will destroy all data on that device. sudo usr/sbin/rear format /dev/sdb Relax-and-recover asks you to confirm that you want to format the device: Yes The device has been labeled REAR-000 by the ‘format’ workflow. Now edit the ‘etc/rear/local.conf’ configuration file: cat > etc/rear/local.conf < Now you are ready to create a rescue image. We want verbose output. sudo usr/sbin/rear -v mkrescue The output I get is: Relax-and-Recover 1.13.0 / $Date$ Using log file: /home/jeroen/tmp/...
Read more