Error running OIP policy: libclntsh.so: cannot open shared object file: Permission denied

[mauog_]

Hello,

I'm trying to run an OIP policy on a linux client with Oracle 19 installed.

In the bpdbsbora i can read:

12:29:58.800 [2027198.2027198] <2> OracleDllManager::open: Using library at [/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so] (../OracleDllManager.cpp:104) 12:29:58.800 [2027198.2027198] <2> OracleDllManager::open: Failed to open library [/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so] (../OracleDllManager.cpp:151) 12:29:58.800 [2027198.2027198] <2> OracleDllManager::open: Error was:/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so: cannot open shared object file: Permission denied (../OracleDllManager.cpp: 152) 12:29:58.800 [2027198.2027198] <2> OracleOci::init: failed to load oci library [4] (../OracleOci.cpp:116) 12:29:58.803 [2027198.2027198] <2> NCFBlockUntil::addToWait(count): 1 non-object reasons added to the blocker (../NcfRefCounted.cpp:119) 12:29:58.803 [2027198.2027198] <2> NCFBlockUntil::finished: 1 non-object reasons removed from the blocker (../NcfRefCounted.cpp:167) 12:29:58.803 [2027198.2027198] <16> CFECallback::reportStatus: There was an error initializing the OCI library.

I checked the library and it is:

oot@toren [ /usr/openv/netbackup/logs/bpdbsbora ]# ls -la /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so
lrwxrwxrwx. 1 oracle oinstall 17 Aug 6 08:48 /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so -> libclntsh.so.19.1
root@toren [ /usr/openv/netbackup/logs/bpdbsbora ]# ls -la /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1
-rwx------. 1 oracle oinstall 79889800 Aug 6 08:48 /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1

Do you have any idea about what is wrong?

How should permissions be set?

Thanks

[Nicolai · Accepted solution]

hi @mauog_ 

Make sure Oracle and Oinstall has read and execute permission on all directories leading to libclntsh.so.19 file. Either in /usr/openv/ or /u01/app.

Does the Oracle backup fails or is just a status message in the log file you are trying to resolve ?

[mauog_]

Backups fail with 5455 error.

I just checked and all the tree from /u01 is group writable and executable.

Just /u01 an /u01/app belong to user grid group oinstall and then from /u01/app/oracle the tree belongs to oracle:oinstall.

[davidmoline · Accepted solution]

Hi @mauog_ 

As @Nicolai says, it looks like a simple file system permission problem. Try su'ing to the user that runs the Oracle backup (is it oracle or some other user?) and see if you can view the file, and if not where it blocks. 

David

[mauog_]

Using the user specified as OS credential on the Application>Oracle>ALL Instances I can get to library directory.

The library has 755 permission so it looks there is no problem on this

Is there any way to be sure about what user is executing the backup?

Anyway it looks that the error is changed in "cannot open shared object file: No such file or directory"

OracleInstances::getFirst: Not enumerating instances. SID and Home were passed in. (../OracleInstances.cpp:124)
12:45:27.458 [2176318.2176318] <2> OracleDllManager::open: Using library at [/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so] (../OracleDllManager.cpp:104)
12:45:27.459 [2176318.2176318] <2> OracleDllManager::open: Failed to open library [/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so] (../OracleDllManager.cpp:151)
12:45:27.459 [2176318.2176318] <2> OracleDllManager::open: Error was:libclntshcore.so.19.1: cannot open shared object file: No such file or directory (../OracleDllManager.cpp:152)
12:45:27.459 [2176318.2176318] <2> OracleOci::init: failed to load oci library [4] (../OracleOci.cpp:116)
12:45:27.461 [2176318.2176318] <2> NCFBlockUntil::addToWait(count): 1 non-object reasons added to the blocker (../NcfRefCounted.cpp:119)
12:45:27.461 [2176318.2176318] <2> NCFBlockUntil::finished: 1 non-object reasons removed from the blocker (../NcfRefCounted.cpp:167)
12:45:27.461 [2176318.2176318] <16> CFECallback::reportStatus: There was an error initializing the OCI library.

[mauog_]

I went deep again and I found some permissions wrong.

Now it looks that the error is disappeared even though there still is a problem with the oracle user permission in oracle but this is another story

Thanks a lot