Re: No other user but oracle can connect

Is the set user id and set group id bit set on 'oracle' binary in bin directory? Compare the binaries with the original installation. There are 3 more binaries whose bits needs to be set. You can use chmod u+s oracle and chmod g+s oracle to set the bits.

raghuvir

Jeff <jcbeau_at_bpasystems.com> wrote in article <6rq6rm$pqe_at_dfw-ixnews8.ix.netcom.com>...
> Hello,
>
> I have copied an installation of Oracle 7.3.3 from one Solaris 2.5.1 box
to
> another. When I try to connect to the database using SQL*PLUS from any
UNIX
> user OTHER THAN ORACLE, I get the following error:
>
> ld.so.1: oracledev11: fatal: libsunmath.so.1: can't open file: errno=2
> ld.so.1: oracledev11: fatal: libsunmath.so.1: can't open file: errno=2
> ld.so.1: oracledev11: fatal: libsunmath.so.1: can't open file: errno=2
> ERROR: ORA-12547: TNS:lost contact
>
> If I try to connect to SQL*PLUS logged in as the UNIX oracle user, it
works
> fine.
>
> Any help would be greatly appreciated. Thanks! --Jeff
>
> jcbeau_at_bpasystems.com
>
>
>
>
>
>
>
Received on Sun Aug 23 1998 - 20:34:54 CDT