Summary: Oracle sql*net and NIS

From: Anchi Zhang (anchi@starbase.neosoft.com)
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/Computervision@ausns1.cv.com
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.

Anchi

Anchi



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