The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

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.

Steve

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 
Web: http://smxemail.com 

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