Lpar2rrd can't connect ORACLE DB

damthanhlong

Dear all
We've installed the Virtual Appliance 7.30 ver and we cant connect ORACLE DB  by GUI as link Oracle Database Monitoring (lpar2rrd.com).
Please help us to support the errors as below

On sever LPAR2RRD modify existing setup.
Set Oracle environment variables in lpar2rrd/etc/lpar2rrd.cfg

On Oracle DB configure



Thanks in advance

Pavel

Hi,

edit ORACLE_HOME in etc/lpar2rrd.cfg and remove "/bin" at the end

try it again

damthanhlong

Hi,
When I removed "/bin" error as below.

damerva

Hello,
run these commands.

su - lpar2rrd

cd /home/lpar2rrd/lpar2rrd/   #or where your LPAR2RRD work dir is

. etc/lpar2rrd.cfg

echo $ORACLE_HOME

$ORACLE_HOME/sqlplus

damthanhlong

Hi,
Thanks all
This case works. We 've reinstalled and step by step as below.
Command on LPAR2RRD Server.
# mkdir /opt/oracle
# cd /opt/oracle/
# unzip instantclient-basic-linux.x64-19.6.0.0.0dbru.zip
# unzip instantclient-sqlplus-linux.x64-19.6.0.0.0dbru.zip
# sh -c "echo /opt/oracle/instantclient_19_6 > \
> /etc/ld.so.conf.d/oracle-instantclient.conf"

#export ORACLE_HOME=/opt/oracle/instantclient_19_6

#export ORACLE_HOME=/opt/oracle/instantclient_19_6

#export LD_LIBRARY_PATH=/opt/oracle/instantclient_19_6:$LD_LIBRARY_PATH

#su - lpar2rrd

# vi lpar2rrd/etc/lpar2rrd.cfg

  ORACLE_BASE=/opt/oracle/

  ORACLE_HOME=/opt/oracle/instantclient_19_6