Uniface User Forum

 View Only
  • 1.  Oracle Driver Error

    Posted 04-25-2022 10:03
    Hey all,

    Does anyone out there know what could be the cause here??
    I've checked the documentation and I cannot find what -1 / -17 is...

    I/O function: L, mode: 0, on driver: ORA; Path: $ORA
    ORA Error: -1
    ORACLE Driver Error [-17]: Logon to ORACLE failed.

    The ASN files haven't been touched in ages - the passwords work fine
    as I can use SQL*Net/Developer to access the database....

    Regards,
    Knut

    ------------------------------
    Knut Dybendahl
    ------------------------------


  • 2.  RE: Oracle Driver Error

    ROCKETEER
    Posted 04-25-2022 10:29
    Hey Knut,

    I've seen this before. The Oracle driver is not very chatty in case there is something wrong with the setup of the Oracle environment. For example when $ORACLE_SID or $ORACLE_HOME has an incorrect value. I guess there is nothing useful in $dberror or $dberrortext?

    I hope this helps.

    Regards,
    Daniel

    ------------------------------
    Daniel Iseli
    Principal Technical Support Engineer
    Uniface Services
    Rocket Software, Switzerland
    ------------------------------



  • 3.  RE: Oracle Driver Error

    Posted 04-25-2022 10:35
    Edited by Knut Dybendahl 04-25-2022 10:35
    Hey Daniel,

    This happens from the dev environment - before I even get to the main screen.

    Any chance someone in the depths of the lab might look at the source code and let us
    know what -17 means??

    Knut

    ------------------------------
    Knut Dybendahl
    ------------------------------



  • 4.  RE: Oracle Driver Error

    ROCKETEER
    Posted 04-25-2022 11:14
    Hey Knut,

    -17 simply means that the logon to Oracle failed. That's it. This is just a generic error that happened because of another problem. As mentioned in my initial reply, there might be something wrong with the Oracle environment (like e.g $ORACLE_SID or $ORACLE_HOME). I would check that first.

    Daniel

    ------------------------------
    Daniel Iseli
    Principal Technical Support Engineer
    Uniface Services
    Rocket Software, Switzerland
    ------------------------------



  • 5.  RE: Oracle Driver Error

    Posted 04-26-2022 05:04
    Edited by Richard de Vries 04-26-2022 05:05
    Hello Knut,

    I have working on a migration from Uniface 9 to Uniface 10. With this migration the database was moved to an other server. We did experience the same -17 error. We did discover that the passwords were not valid, even these had not changed. As I recall, logging on the database with SQLPlus also failed. We believe this was caused due to an other configuration of the system the database runs on.

    Our problem was solved by recreating the password on the database with the same password as before.

    Has the database server changed in any way like an other MAC-address, hostname or so on?

    ------------------------------
    Richard de Vries
    Sogeti Nederland B.V.
    Deventer NL
    ------------------------------



  • 6.  RE: Oracle Driver Error

    Posted 04-26-2022 10:24
    Hi all,

    PROCMON to the rescue - again....
    We had a wayward oci.dll file in the folder where we start the application.
    Little did I know that the base folder implicitly is the virtual 1st entry in the
    PATH variable - never visible, bu that's the very 1st location searched....

    All's good and life has settled down again.

    Regards,
    Knut

    ------------------------------
    Knut Dybendahl
    ------------------------------