The mailing list for listmasters using Sympa

[Soji Ikeda <address@concealed>]

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