[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?

Koen


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 
<module>
     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 
<module>
     from common.database.DBMain import DBObject, persistent
   File "/home/kuijken/SW/awe/common/database/DBMain.py", line 16, in 
<module>
     import DBMeta
   File "/home/kuijken/SW/awe/common/database/DBMeta.py", line 13, in 
<module>
     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 
<module>
     from Database import database
   File "/home/kuijken/SW/awe/common/database/Database.py", line 593, in 
<module>
     database.connect()
   File "/home/kuijken/SW/awe/common/database/Database.py", line 138, in 
connect
     connection = database_api.connect(username, password, dbname, 
threaded=1)
cx_Oracle.DatabaseError: ORA-12541: TNS:no listener 

 

awe> 



More information about the Issues mailing list