DESDM
Space shortcuts

easyaccess: error when trying to connect to database

 
1
0
-1

I have installed easyaccess on my mac (OS X El Capitan) using conda. As the .desservices.ini file was not created, I had to create it manually in my $HOME directory (as explained here: Error Starting Easyaccess).

However, now when I run easyaccess I get the following error:

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. **

As suggested in a previous post (easyaccess database connection error) I have added my computer name in the /etc/hosts file and after open a new terminal to run easyaccess but I still have the above error message.

 

Is there another way to solve this problem?

Thanks

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Estelle,

      Usually the solution you tried already work on ~ 90% of the cases I've seen. Sometimes there is Firewall issues as well, have you tried suing the same computer from a different network.

       

      Others needed to include the whole host in the /etc/hosts line (not just the name of the computer) and that has helped as well.

       

      Other than that, we might need to look a network issues that are harder to trace.

       

      In the meantime, there is a jupyterhub server running for collaborators (in beta mode) here:

      http://141.142.211.168/

       

      Using your DES credential, there you can open a terminal (or a ipython notebook) 

       

       

      and use easyaccess there,  

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        There is another question where Mattias answered this.  It was: 

        easyaccess database connection error

        I have a vague recollection that this solution has not solved the problem for everyone, so if does not work for you please contact Mattias directly.

          CommentAdd your comment...