Hello All,
I am trying to connect to Oracle database from my application on Linux which is developed using C programming. I use unixODBC API to connect to database.
DB version: 12C
ODBC: 12.1
OS: Tried on both Redhat 7 and Suse 11/12
I have observed strange behavior with Oracle ODBC driver as explained below:
- When Application binary has 0550 permissions set and owned by root/appladm group, driver loads successfully and connection to DB is successful (no sticky bit)
- When Application binary has 6550 permissions set and owned by root/root group, driver loads successfully and connection to DB is successful (with sticky bit and owned by root group)
- When Application binary has 6550 permissions set and owned by root/appladm group, driver fails to load with below error. (with sticky bit and owned by appladm group)
SQLConnect failed, 0, user = System, [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1' : file not found
Can someone explain me the reason behind this strange behavior or help me on how can i connect to database through unixODBC when application binary is owned by appladm group and sticky bit set.
Thanks in advance.
Regards,
Shiva