1
0
-1

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

 

   Retrying...

 

Error when trying to connect to database: ORA-21561: OID generation failed

 

   Retrying...

 

Error when trying to connect to database: ORA-21561: OID generation failed

 

   Retrying...

 

 

 ** Could not successfully connect to DB. Try again later. Aborting. ** 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi,

      This might help,

      78874410

      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,

       

      Cheers

       

      1. Alex Kim

        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 agkim@leovip148.ncsa.uiuc.edu:1521/dessci

         

        SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 2 09:09:03 2016

         

        Copyright (c) 1982, 2012, Oracle.  All rights reserved.

         

        ERROR:

        ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

      2. Alex Kim

        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

        and I am still unable to connect with easyaccess.
        I do believe though this doesn't have to do with easyaccess but rather with oracle.
      3. Alex Kim

        The easyaccess error remains unchanged, and the sqlplus error is identical.

         

        Connecting to DB ** dessci ** ...

        Error when trying to connect to database: ORA-21561: OID generation failed

         

           Retrying...

         

        Error when trying to connect to database: ORA-21561: OID generation failed

         

           Retrying...

         

        Error when trying to connect to database: ORA-21561: OID generation failed

         

           Retrying...

         

         

         ** Could not successfully connect to DB. Try again later. Aborting. ** 

        68:~ akim$ sqlplus username/passwd@leovip148.ncsa.uiuc.edu:1521/dessci

         

        SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 2 09:16:19 2016

         

        Copyright (c) 1982, 2012, Oracle.  All rights reserved.

         

        ERROR:

        ORA-21561: OID generation failed

      4. Matias Carrasco Kind

        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?

      5. Alex Kim

        Indeed I am using a Mac that I mange myself.  My firewall is off.

      6. Alex Kim

        Could this be due to something as mundane is my password changing without my noticing?

      7. Matias Carrasco Kind

        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,   

      8. Alex Kim

        Thanks for directing me to the python notebook space.  This solution may be sufficient for my current needs.

      9. Alex Kim

        Matias, the ipython notebook link you sent no longer is functioning.  I may have crashed it.

      10. Matias Carrasco Kind

        It works for me, I've restarted yours maybe that fixes the problem.

      CommentAdd your comment...