QSqlDatabase: QOCI driver not loaded QSqlDatabase: available drivers: QSQLITE QPSQL7 QPSQL

[Romaniy]

Hello Everyone,
as you can see, I have problem with loading libqsqloci.so.

I compiled this library in Debian 3.9.8-1 x86_64 GNU/Linux with success.
Now I have this library, but it doesn't work.

All dependencies present in system, like you can see bellow
ldd /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqloci.so
linux-vdso.so.1 (0x00007fff5d7fe000)
libclntsh.so.11.1 => /lib/x86_64-linux-gnu/libclntsh.so.11.1 (0x00007fb3173ae000)
libQt5Sql.so.5 => /home/roma/qt/qtbase/lib/libQt5Sql.so.5 (0x00007fb317171000)
libQt5Core.so.5 => /home/roma/qt/qtbase/lib/libQt5Core.so.5 (0x00007fb316a7e000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fb316862000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fb31655f000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fb316260000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fb31604a000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fb315c9e000)
libnnz11.so => /home/oracle/u00/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so (0x00007fb3158d5000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fb3156d1000)
libnsl.so.1 => /lib/x86_64-linux-gnu/libnsl.so.1 (0x00007fb3154b9000)
libaio.so.1 => /lib/x86_64-linux-gnu/libaio.so.1 (0x00007fb3152b6000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fb3150ae000)
/lib64/ld-linux-x86-64.so.2 (0x00007fb319c11000)

But during debuging my project, I see error message like this
QSqlDatabase: QOCI driver not loaded
QSqlDatabase: available drivers: QSQLITE QPSQL7 QPSQL
DB not open

But this library defined in
/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/
libqsqlite2.so libqsqlite.so libqsqlmysql.so libqsqloci.so libqsqlodbc.so libqsqlpsql.so libqsqltds.so

II added in main.cpp this string @qDebug() << app->libraryPaths();@
for checking enviroment and after compiling this project I saw next:
("/usr/lib/x86_64-linux-gnu/qt4/plugins", "/home/roma/Project/build-Astelit_1-Qt_4_8_4_in_PATH_System-Debug")

In both directories this library is present:
/home/roma/Project/build-Astelit_1-Qt_4_8_4_in_PATH_System-Debug/libqsqloci.so
/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqloci.so

Code where I using connection to DB looks like
@bool MainWindow::createConnection() {
QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
db.setDatabaseName("myDB");
db.setUserName("roma");
db.setHostName("localhost");
db.setPassword("roma");

if(!db.open()){
    qDebug() << "DB not open";
    return false;
}
return true;

}@

I know, that were several topics with the same title, but I haven't found answer for last several day.
If somebody need an additional information, i will present it.
Thank for you help.

[ChrisW67]

The Oracle run time library is probably not in the run time library path of the program.

[Romaniy]

Thank for fast responce, ChrisW67,

bq. The Oracle run time library is probably not in the run time library path of the program.

If you talk about that $LD_LIBRARY_PATH, I already have had it:
echo $LD_LIBRARY_PATH
/home/oracle/u00/app/oracle/product/11.2.0/dbhome_1/lib/

But problem still exist.
Waiting for your responce.
Thank a lot

[Romaniy]

I have found the solution.
My QtCreator worked with using Qt 4.8.4 and I compiled library with Qt 5.1.1.
So I added new library to QTCreator and now I have new problem.
But previous problem was solved.

Thank a lot everybody