Skip to Content.
Sympa Menu

en - [sympa-users] issue with sympa 6.2.35b.1 and oracle db

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Ellie Cartman <address@concealed>
  • To: address@concealed
  • Subject: [sympa-users] issue with sympa 6.2.35b.1 and oracle db
  • Date: Wed, 26 Sep 2018 12:00:54 -0400

I have been trying to get sympa to connect to an Oracle database. I have verified that the database is available using sqlcl.

[ellie] ./sql -L address@concealed:1521/sympadev


Additionally I wrote a short script in perl and was able to attach the database.

[ellie]# ./TestOracle
                ID = 106

so, tnsnames.ora is correct.

When I run --health_check, however, I get:

[root]# --health_check
Database sympadev defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf

from the log:

Sep 25 15:47:29 davies sympa/health_check[20915]: err main::#212 > Sympa::DatabaseManager::probe_db#94 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::Oracle::connect#71 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::Oracle <db_env=NLS_LANG=American_America.AL32UTF8;ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1;db_host=oraclebox.uwo.pri;db_name=sympadev;db_port=1521;db_user=sympa>: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
Sep 25 15:47:29 davies sympa/health_check[20915]: err main::#212 > Sympa::DatabaseManager::probe_db#96 Could not check the database structure.  Make sure that database connection is available

I have set the following values in /etc/sympa/sympa.conf

db_type Oracle
db_host oraclebox.uwo.pri
db_port 1521
db_name         sympadev
db_user         sympa
db_passwd       ********************
db_env  NLS_LANG=American_America.AL32UTF8;ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1

What am I doing wrong?


Archive powered by MHonArc 2.6.19+.

Top of Page