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