Skip to Content.
Sympa Menu

en - Re: [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: Soji Ikeda <address@concealed>
  • To: Ellie Cartman <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [sympa-users] issue with sympa 6.2.35b.1 and oracle db
  • Date: Fri, 28 Sep 2018 07:33:57 +0900

Hi Ellie,

ORA-12505 means that the instance specified by client with a SID has
not been registered to listener (see also description shown by
running “oerr ora 12505”).

You may have to check listener.ora to register (dynamically or staticky)
SID you want to use.

Sorry for rough description because I have no environments to run
Oracle just now.

— Soji

2018/09/27 1:00、Ellie Cartman <address@concealed>のメール:

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