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: Steve Shipway <address@concealed>
  • To: address@concealed, Ellie Cartman <address@concealed>
  • Subject: Re: [sympa-users] issue with sympa 6.2.35b.1 and oracle db
  • Date: Fri, 28 Sep 2018 09:52:56 +1200

It's been a long time since I used Perl to talk to Oracle, but if I remember correctly, it works better if you set TWO_TASK (or ORACLE_SID) to the database SID in the environment as specified in the tnsnames.ora file.

Your error message  would seem to indicate that the driver is not finding the specified SID; the connect string is using the db_name= rather than sid= which may be the issue.


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;TWO_TASK=sidgoesinhere

Steve Shipway | Senior Email Systems Administrator 
Phone: +64 9 302 0515 Fax: +64 9 302 0518 
Freephone: 0800 SMX SMX (769 769) 
SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand 

This email has been filtered by SMX. For more information visit

Archive powered by MHonArc 2.6.19+.

Top of Page