Re: No other user but oracle can connect

Check the LD_LIBRARY_PATH variable.
It should be set to ORACLE_HOME/lib.

Jay

Jeff wrote:

> 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 Sep 06 1998 - 00:00:00 CDT