Re: tnsping problem

Another poster had this problem as well. It turned out that tnsping was running setuid root and a security feature in Solaris prevents shared libraries from being used by setuid applications.

Check the permissions on the executable. If the setuid bit is enabled, turn it off.

                                            Rick

"Joseph Chia" <blackeye_at_singnet.com.sg> writes:

> I have a problem with Oracle client [ 8i running on a Solaris 2.7 box ]
>
> executing tnsping gives
> -> libclnt.so.8.0 not found permission denied
> killed
>
> I have checked the paths, it works for other users in the same machine but
> not that particular user, why?
>
> ORACLE_HOME and ORACLE_BASE is correct, path is set for $ORACLE_HOME/bin
> the file is definitely there.
>
> if I try tnsping0, it works (BTW why tnsping0 and tnsping, what's the diff?)
>
> Thanks for any advice.
>
> --
> Regards,
> Joe
>
>

--

                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.