I am trying to use easyaccess for the first time and get the following message. My .desservices.ini, which worked in the days of trivailAccess, still appears to have the correct information. Is the database down or is there a problem on my end?
68:~ akim$ easyaccess
Connecting to DB ** dessci ** ...
Error when trying to connect to database: ORA-21561: OID generation failed
** Could not successfully connect to DB. Try again later. Aborting. **
This might help,
Problem with connection to the database, OID
Basically is adding the name of your computer to the /etc/hosts next to 127.0.0.0 1 localhost line
If this doesn't work we can look for other possible solutions,
Matias, thanks for your quick response. Indeed this solution solved this problem, although I have not been able to access the database yet!
I am still unable to access the database and it doesn't have to do with easyaccess, but perhaps your expertise would be helpful. To get down to the basics I am reverting to sqlplus...
68:~ akim$ sqlplus email@example.com:1521/dessci
SQL*Plus: Release 188.8.131.52.0 Production on Wed Nov 2 09:09:03 2016
Copyright (c) 1982, 2012, Oracle. All rights reserved.
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Apologies, I find that what I wrote above was due to a syntax error on the command line. I have added to my /etc/hosts the computer name as follows
127.0.0.1 localhost tibia
What is the error?
The easyaccess error remains unchanged, and the sqlplus error is identical.
68:~ akim$ sqlplus firstname.lastname@example.org:1521/dessci
SQL*Plus: Release 184.108.40.206.0 Production on Wed Nov 2 09:16:19 2016
ORA-21561: OID generation failed
That's odd. Usually the /etc/hosts hack solve the problem for both sqlplus and easyaccess. Since you have sqlplus it seems the oracle installation went ok. Another alternative is to check a possible firewall issues.
Is this a Mac/Linux system? private managed?
Indeed I am using a Mac that I mange myself. My firewall is off.
Could this be due to something as mundane is my password changing without my noticing?
is not the password, that'd be another error code. A quick way to check credentials is to see whether you can access the cutout services http://descut.cosmology.illinois.edu/
This is something to do with connecting to the DB. In the meantime, I've set up (yet to be widely advertised) a jupyeterhub server http://deslabs.ncsa.illinois.edu/ (click on jupyter) which would give you access to a ipython notebook space where you can run easyaccess from python (there are a couple of examples) or open a Terminal (New → Terminal) and run easyaccess cli.
I'm cutting a new release soon, with more alternatives for installation,
Thanks for directing me to the python notebook space. This solution may be sufficient for my current needs.
Matias, the ipython notebook link you sent no longer is functioning. I may have crashed it.
It works for me, I've restarted yours maybe that fixes the problem.
Powered by a free Atlassian Confluence Open Source Project License granted to NCSA OpenSource. Evaluate Confluence today.