The mailing list for listmasters using Sympa

[Soji Ikeda <address@concealed>]

Hi Ellie,

2018/09/28 22:38、Ellie Cartman <address@concealed>のメール:

Hi Soji,

We are set up for high availability, and are trying to get sympa  to connect via a service name, behind which lie two instances of the same database. Is there a way to get sympa to do that? The Perl script I wrote had no issues. Do I need to tweak (modify) the sympa code to achieve that? 

Can you show us the script you wrote?

I have no experiences on high availability and I want to figure out what

we have to do according to your success.

Regards,

— Soji

Thanks,

-ellie

On Thu, Sep 27, 2018 at 18:34 Soji Ikeda <address@concealed> wrote:

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.

Regards,

— 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

SQL> select USER_ID from ALL_USERS where USERNAME='SYMPA';
   USER_ID
----------
       106



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 sympa.pl --health_check, however, I get:

[root]# sympa.pl --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?

Thanks,
-ellie

--