oracle database stand alone test connection error

asiddek

Hello,

I get the following error when trying connect standalone oracle database:

DB data test: Invalid data make sure DB has permissions it needs .

ORACLE_BASE: /usr/lib/oracle

ORACLE_HOME: /usr/lib/oracle/19.6/client64/bin

LIBPATH(AIX):

LD_LIBRARY_PATH(Linux): /usr/lib/oracle/19.6/client64/bin:/home/lpar2rrd/db2_cli_odbc_driver/odbc_cli/clidriver/lib:/usr/lib/oracle/19.6/client64/bin:/home/lpar2rrd/db2_cli_odbc_driver/odbc_cli/clidriver/lib:

I have create the user and give it the required grants successfully.

damerva

Hello,

are you sure you have granted the permissions?

https://lpar2rrd.com/OracleDB-performance-monitoring-install.php#OracleDB

section: Create DB user for LPAR2RRD

Solution:

Either re-grant them or you can check their status like so("/as sysdba"):

SELECT grantee, table_name, privilege FROM DBA_TAB_PRIVS WHERE grantee LIKE '%LPAR%';