Summary: Oracle sql*net and NIS

From: Anchi Zhang (
Date: Wed Jan 18 1995 - 14:51:56 CST

My original posting:

 Our network runs NIS. On our Solaris 2.3 Sparc 1000
 running Oracle 7 server, the last line of /etc/passwd is
 "+:x:::::/bin/false" and that of /etc/shadow is "+::::::::"
 and /etc/nsswitch.conf has "passwd: compat".
 On a SunOS 4.1.3_U1 Sparc 10 client, automatic sql login via
 sql*net version 1
        % sqlplus /@t:server:instance
 fails with

        ERRPR: ORA-01017: invalid username/password; login
 whereas login via sql*net version 2
        % sqlplus /@alias
 succeeds. If the server has a full /etc/passwd, sql connections
 via sql*net versions 1 and 2 will succeed.

My thanks for the only reply from Chris_Terry/
who stated that "with Oracle Rev 7 the SQL*Net Listner process must be
setuid root to allow sucessful V1 and V2 SQL*Net database connections."
This had been the case all along.

Oracle tech support was no help at all!

My solution was to convert from SQL*Net V1 to SQL*Net V2.



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:10:14 CDT