[Issues] failure to connect to database (no listener)

K Kuijken kuijken at strw.leidenuniv.nl
Mon Oct 27 15:59:56 CET 2014

Question for the DB gurus (I think):

There is a problem connecting to the AW db from the command line in 
Leiden (was intermittent, now very frequent). I updated to the most 
recent version of awe, to no avail.
Can this be fixed?


Python 2.7.1 (r271:86832, Apr 14 2011, 10:03:23)
[GCC 4.5.1 20100924 (Red Hat 4.5.1-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.

                Welcome to the Astro-WISE Environment

|07-May-14   Planned Groningen database downtime:
|             Tuesdays: June 3, July 8, August 5, September 2, October 7,
|                       November 4, December 2

Importing Astro-WISE packages. Please wait...

Traceback (most recent call last):
   File "/home/kuijken/SW/awe/astro/config/startup.py", line 65, in <module>
     from astro.recipes.aweimports import *
   File "/home/kuijken/SW/awe/astro/recipes/aweimports.py", line 6, in 
     from AssociateList import AssociateListTask
   File "/home/kuijken/SW/awe/astro/recipes/AssociateList.py", line 6, 
in <module>
     from astro.main.AssociateList import AssociateList
   File "/home/kuijken/SW/awe/astro/main/AssociateList.py", line 13, in 
     from common.database.DBMain import DBObject, persistent
   File "/home/kuijken/SW/awe/common/database/DBMain.py", line 16, in 
     import DBMeta
   File "/home/kuijken/SW/awe/common/database/DBMeta.py", line 13, in 
     import DBProperties
   File "/home/kuijken/SW/awe/common/database/DBProperties.py", line 32, 
in <module>
     from DBSelect import LinkRef, Select
   File "/home/kuijken/SW/awe/common/database/DBSelect.py", line 11, in 
     from Database import database
   File "/home/kuijken/SW/awe/common/database/Database.py", line 593, in 
   File "/home/kuijken/SW/awe/common/database/Database.py", line 138, in 
     connection = database_api.connect(username, password, dbname, 
cx_Oracle.DatabaseError: ORA-12541: TNS:no listener 



More information about the Issues mailing list