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

[D.R. Boxhoorn]

Hallo Koen,

Could you please run

   awe astro/test/connection_test.py

preferably several times and report any errors?
The problem can be solved if caused by something over which we have
control. If the problem originates at a location over which we have no
control it may or may not be fixed.

Groeten,

Danny

2014-10-27 15:59 GMT+01:00 K Kuijken <kuijken at strw.leidenuniv.nl>:

> 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>
> _______________________________________________
> Issues mailing list
> Issues at astro-wise.org
> http://mailman.astro-wise.org/mailman/listinfo/issues
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.astro-wise.org/pipermail/issues/attachments/20141027/714da54d/attachment.html>