Oracle 8.0.5 and os_roles=true on UNIX (Solaris)

Can someone help who has experienced the agony of getting os_roles to work with two different servers?

Here's the scenario:
Two UNIX server running Oracle 8.0.5 and Solaris 2.6, NIS, same domain. Server "NMSOracle" running with os_roles = false, One database, SID=N80 Server "NMSDenise" running with os_roles = true, One database, SID=N805

In my environment I set the usual stuff, ORACLE_HOME, ORACLE_SID, TWO_TASK, LD_LIBRARY_PATH, ORA_NLS33. I set ORACLE_SID to N80 and TWO_TASK to NMSOracle. It's my operational database
and that's the one I usually hit.

Now, this is where the fun starts. When I start sqlplus I connect to NMSOracle with sid N80.
I connect normally with the command 'sqlplus username/password'. Things work OK and as expected When I try and connect to NMSDenise at N805 from sqlplus I use the following command:

connect /@N805 -- does not work connect username/password_at_N805 -- works

which should connect to the server at N805 in my tnsnames.ora file. If I try and use os authentication it does not work. If I specify a username and password that works fine.

If I unsetenv TWO_TASK and set ORACLE_SID to N805 I can connect OK with the following command:

sqlplus /

If I setenv TWO_TASK to NMSDenise and set ORACLE_SID to N805 I get the following:

ORA-01004: default username feature not supported; logon denied Cause: An attempt was made to use automatic logon on a system not supporting this feature.
Action: Provide the complete username and password to log on to Oracle.

I need to get os_roles working...

Any thoughts?

Nick Adair
adairn_at_houstoncellular.com Received on Mon Dec 14 1998 - 17:42:11 CST