Problem to run pdm_init with root user

[ANDRES MARQUEZ]

Hi,

 

I've installed a fresh CA SDM 14.1 because we'll want to do the test to upgrade to CA SDM 17.1 in our environment.

 

I installed CA SDM 14.1 with root user, but when I try to start with pdm_init and root user I get the following error: 

 

3/11 16:48:54.92 seusd010des confirm_db 4880 SIGNIFICANT api_misc.c 585 Requesting shutdown of system. Reason (AHD50060:Database check FAILED. SEVERE_ERROR: Unable to load OCI library (/usr/lib/oracle/11.2/client/lib/libclntsh.so) Error(libnnz11.so: cannot open shared object file: No such file or directory)SEVERE_ERROR: Unable to load OCI library (/usr/lib/oracle/11.2/client/lib/libclntsh.so) Error(libnnz11.so: cannot open shared object file: No such file or directory))

 

But if I run pdm_init with the srvcdesk user, CA SDM run fine.

 

I set LD_LIBRARY_PATH with these values: /usr/lib/oracle/11.2/client/lib:/opt/CA/ServiceDeskManager/lib:/opt/CA/SC/lib:/opt/CA/SC/lib

 

What could be the problem?

 

Reargds.

[Chi Chen]

file permission issue?

in /usr/lib/oracle/11.2/client/lib/, do "ls -la lib*" showing...?

[ANDRES MARQUEZ]

Hi

ls -la lib*

 

lrwxrwxrwx. 1 root root 17 Mar 11 13:00 libclntsh.so -> libclntsh.so.11.1
-rw-r--r--. 1 root root 44316855 Aug 25 2013 libclntsh.so.11.1
-rw-r--r--. 1 root root 7098468 Aug 25 2013 libnnz11.so
lrwxrwxrwx. 1 root root 15 Mar 11 13:03 libocci.so -> libocci.so.11.1
-rw-r--r--. 1 root root 1881900 Aug 25 2013 libocci.so.11.1
-rw-r--r--. 1 root root 118729922 Aug 25 2013 libociei.so
-rw-r--r--. 1 root root 152585 Aug 25 2013 libocijdbc11.so
-rw-r--r--. 1 root root 1499831 Aug 25 2013 libsqlplusic.so
-rw-r--r--. 1 root root 1216654 Aug 25 2013 libsqlplus.so

[Michael Mueller]

I suggest the following:

• don't start sdm as root user , but as the privileged user srvcdesk.
• make sure that the user srvcdesk has set correct Oracle environment.
• make sure that srvcdesk user is able to execute sqlplus and is able to connect to your DB using the 32bit Oracle Client.
• it might help to put the Oracle  client path into a ld Config file in /etc//ld.so.conf.d/ instead of adding it to LD_LIBRARY_PATH var.

 

hope that helps

Regards

..............Michael

[Michael Mueller]

I'm sorry,

I missed your Statement, that pdm_init with srvcdesk works fine.

I assume that you have the problem after upgrading to 17.1 ,correct?

I assume that you are using the oracle instant client, correct?

Due to some specific access right settings of some sdm binaries, the LD_LIBRARAY_PATH is set empty when these binaries are creating child processes. therefore the Oracle libraries can't be found anymore by these child processes, This is done by the OS for security reasons so that one is not able to add libraries to a process which runs in a root context.

Hence you get these Errors.

My last suggestion will help here !

create a  file in /etc/ld.so.conf.d/  and put your client path "/usr/lib/oracle/11.2/client/lib" into it

then execute ldconfig to activate this new setting. this will add the path to the standard lib search path of the dynamic linker.

Regards

..............Michael

[ANDRES MARQUEZ]

Hi..

I add the Oracle libraries into  /etc/ld.so.conf.d/ and now run fine with root user.

 

Thank you.