Imperva Cyber Community

communities_1.jpg
 View Only
Back to discussions
Expand all | Collapse all

Error validation Oracle DB connection

  • 1.  Error validation Oracle DB connection

    Posted 07-22-2023 21:07
    Edited by Urvin Shah 07-22-2023 21:10

    Using the iSQL client shipped with the DSF installation, I am trying to verify the connection to the Oracle database and getting below error. Attached screenshots for reference. I am pulling logs from hub only. Have setup ODBC on hub. DSF - v4.6b


    [sonarw@dsfhub46 ~]$ ${JSONAR_BASEDIR}/bin/isql -v oracle-password 'sys' 'Webco#123'
    [IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
    [ISQL]ERROR: Could not SQLConnect
    [sonarw@dsfhub46 ~]$


    Reference URL - https://docs.imperva.com/bundle/onboarding-databases-to-sonar-reference-guide/page/Onboarding-an-Oracle-Multitenant-Container-Database_281247811.html


    test connection error oracle
    odbc ini
    odbc driver files


    #jSonar

    ------------------------------
    Urvin Shah
    Consultant
    M.Tech Solutions (India) PRIVATE LIMITED
    Mumbai
    ------------------------------