Mac OSX and TOra DMG - Unable to connect to the database

Help
PapuPapu
2014-02-19
2014-02-20
  • PapuPapu
    PapuPapu
    2014-02-19

    I've just installed TOra 2.1.3 using DMG on my Mac with Maverick.
    After installation I'm not able to connect any database.
    On my Mac I already use SQLdeveloper from Oracle and sqlplus from instantclient and I can connect everywehere using tnsnames.ora.

    On term I have following environment variables:

    ORACLE_HOME=/usr/local/oracle/instantclient_11_2
    TNS_ADMIN=/usr/local/oracle/instantclient_11_2
    DYLD_LIBRARY_PATH=/usr/local/oracle/instantclient_11_2

    and following contents of /etc/launchd.conf:

    setenv ORACLE_HOME /usr/local/oracle/instantclient_11_2
    setenv TNS_ADMIN /usr/local/oracle/instantclient_11_2
    setenv DYLD_LIBRARY_PATH /usr/local/oracle/instantclient_11_2

    and, of course, I have Oracle Instant Client 11.2 installed (and working) in /usr/local/oracle/instantclient_11_2

    When I try to create new connection - Oracle (TNS) or Oracle (Instant Client) - I receive following error message:

    Unable to connect to the database.
    ORA--1802895497 missing error description

    where the number is (apparently) random.

    Please help me...

     
    • PapuPapu wrote:

      I've just installed TOra 2.1.3 using DMG on my Mac with Maverick.
      After installation I'm not able to connect any database.
      On my Mac I already use SQLdeveloper from Oracle and sqlplus from instantclient and I can connect everywehere using tnsnames.ora.

      On term I have following environment variables:

      /ORACLE_HOME=/usr/local/oracle/instantclient_11_2
      TNS_ADMIN=/usr/local/oracle/instantclient_11_2
      DYLD_LIBRARY_PATH=/usr/local/oracle/instantclient_11_2/

      and following contents of /etc/launchd.conf:

      /setenv ORACLE_HOME /usr/local/oracle/instantclient_11_2
      setenv TNS_ADMIN /usr/local/oracle/instantclient_11_2
      setenv DYLD_LIBRARY_PATH /usr/local/oracle/instantclient_11_2/

      Can you provide an "ls -l /usr/local/oracle/instantclient_11_2/" ?

       
      • PapuPapu
        PapuPapu
        2014-02-20

        Thank you for your answer.

        Following ORACLE_HOME content:


        massimo@Mac:~$ ll /usr/local/oracle/instantclient_11_2/
        total 383088
        drwxr-xr-x@ 28 massimo wheel 952B 13 Feb 10:28 ./
        drwxr-xr-x 3 root wheel 102B 6 Feb 15:38 ../
        -rwxr-xr-x@ 1 massimo wheel 484B 15 Feb 2013 BASIC_README*
        -rwxr-xr-x@ 1 massimo wheel 482B 15 Feb 2013 JDBC_README*
        -rwxr-xr-x@ 1 massimo wheel 488B 15 Mar 2013 SQLPLUS_README*
        -rwxr-xr-x@ 1 massimo wheel 10K 15 Feb 2013 adrci*
        -rwxr-xr-x@ 1 massimo wheel 40K 15 Feb 2013 genezi*
        -rwxr-xr-x@ 1 massimo wheel 368B 11 Apr 2011 glogin.sql*
        lrwxr-xr-x 1 root wheel 20B 6 Feb 15:42 libclntsh.dylib@ -> libclntsh.dylib.11.1
        -rwxr-xr-x@ 1 massimo wheel 62M 19 Dic 2012 libclntsh.dylib.11.1*
        -rwxr-xr-x@ 1 massimo wheel 13K 19 Dic 2012 libheteroxa11.dylib*
        -rwxr-xr-x@ 1 massimo wheel 2,7M 15 Feb 2013 libnnz11.dylib*
        lrwxr-xr-x 1 root wheel 18B 6 Feb 15:43 libocci.dylib@ -> libocci.dylib.11.1
        -rwxr-xr-x@ 1 massimo wheel 1,8M 19 Dic 2012 libocci.dylib.11.1*
        -rwxr-xr-x@ 1 massimo wheel 113M 15 Feb 2013 libociei.dylib*
        -rwxr-xr-x@ 1 massimo wheel 155K 19 Dic 2012 libocijdbc11.dylib*
        -rwxr-xr-x@ 1 massimo wheel 1,3M 15 Mar 2013 libsqlplus.dylib*
        -rwxr-xr-x@ 1 massimo wheel 1,4M 15 Mar 2013 libsqlplusic.dylib*
        -rwxr-xr-x 1 massimo wheel 393B 9 Feb 23:42 login.sql*
        -rwxr-xr-x@ 1 massimo wheel 2,0M 29 Mag 2012 ojdbc5.jar*
        -rwxr-xr-x@ 1 massimo wheel 2,6M 29 Mag 2012 ojdbc6.jar*
        -rwxr-xr-x@ 1 massimo wheel 2,7K 20 Lug 2012 orai18n-mapping.jar*
        -rwxr-xr-x@ 1 massimo wheel 5,8K 20 Lug 2012 orai18n.jar*
        drwxr-xr-x@ 7 massimo wheel 238B 15 Feb 2013 sdk/
        -rwxr-xr-x@ 1 massimo wheel 8,5K 15 Mar 2013 sqlplus*
        -rwxr-xr-x 1 massimo wheel 45K 13 Feb 10:26 tnsnames.ora*
        -rwxr-xr-x@ 1 massimo wheel 159K 15 Feb 2013 uidrvci*
        -rwxr-xr-x@ 1 massimo wheel 65K 19 Dic 2012 xstreams.jar*

         
        Last edit: PapuPapu 2014-02-20
  • PapuPapu
    PapuPapu
    2014-02-19

    Adding NLS_LANG=AMERICAN_AMERICA I get following error:

    Unable to connect to the database.
    Missing error description. This may be caused by a library version mismatch. Check that your ORACLE_HOME and library path is correct.

    Where am I wrong??

     
    • PapuPapu wrote:

      Adding NLS_LANG=AMERICAN_AMERICA I get following error:

      That setting is wrong.

      Try american_america.UTF8 or american_america.WE8ISO8859P15

      An erroneous NLS_LANG may prevent you from connecting.

       
      • PapuPapu
        PapuPapu
        2014-02-20

        Gerard H. Pille wrote:

        Try AMERICAN_AMERICA or american_america.WE8ISO8859P15

        Nothing changes in this way. SQLPLUS in term is working using all three formats:
        - AMERICAN_AMERICA
        - american_america.UTF8
        - american_america.WE8ISO8859P15