I have a software need to be install on Linux. Basically, from the CDs, I was able to run and install the software on disk. Follow the software instruction, I have to run another package to create the service and create table in Oracle. Any way, when I type: ./sdesetupora9i, I got the error:

./sdesetupora9i: error while loading shared libraries: libclntsh.so.9.0: cannot open shared object file: No such file or directory


when I cd to the bin directory, sdesetupora9i is there.

any advises of what happened here????

thanks,

libclntsh.so.9.0 isn't installed or not in libpath

If you are sure it is installed you need to add the libpath to /etc/ld.so.conf

Don't forget to run ldconfig after you changed ld.so.conf

I think I know what's the problem I have.

Basically, I have an user called ORACLE who own oracle software and this user belong to a group call OINSTALL. I have another user called TEST and TEST belong to LINUX group. basically, what I need is when I log in as TEST and I should be able to run the sqlplus executable who owns by ORACLE.

Please advise what I need to do. Change TEST user to the group OINSTALL, but I still have problem.

thanks

You might try parsing the ORACLE profile. Something like this:

. /home/oracle/.profile

This will give you the environment settings that Oracle needs. Don't know if this will solve permission problems you might have.

I don't understand this. I have another server which was setting up similar to this server and everything works fine.

the bottom like is I try to change permission so TEST user can run anything in ORALCE. what I did was I change TEST user belong to OINSTALL (oracle belong to this group) and change whoever in this group has the right to read, write, and execute but I still have problem to run executable in ORACLE. please see the permission as follow:

drwxrwx--- 21 oracle oinstall 4096 Sep 22 12:46 oracle
drwx------ 10 sde oinstall 4096 Sep 22 12:47 sde

when I log in as SDE I still can run anything in ORACLE


any advises???

What I mean with 'parsing profile' is this:

Oracle (and/or sde) need special settings to run. These settings are put in the .profile (I think, don't know where this is done with linux) so that if you log in as user oracle these settings are available and oracle can do its thing.

If you log in as user test you don't have these settings. To make sure that user test has access to these settings you can parse oracles .profile. After this, user test has access to oracle variables.

Before you copy/paste . /home/oracle/.profile make sure that the settings are actually in .profile and that the path (/home/oracle) is correct.

But all this should be included in the documentation that came with the oracle cd......