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: Ellie Cartman <address@concealed>, address@concealed
  • Subject: Re: [sympa-users] issue with sympa 6.2.35b.1 and oracle db
  • Date: Sun, 30 Sep 2018 14:49:57 +0900

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.

— Soji


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.

— 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