We have an NT Primary Domain Controller which provides external
authentication for our databases running on Novell servers. However, since
our AIX box is on the network via tcp/ip, the NT server does not provide
external authentication for it. Each user logs onto the AIX database as a
user as defined in the applications that connect to the database. We have
each app get the machine username via the environement variable username;
this username is stored in v$session.client_info via
dbms_utility.set_client_info, so we can differentiate between users logged
on with the same logon id..
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Nick Adair wrote in message <7547ou$db3$1_at_uuneo.neosoft.com>...
>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 - 16:57:14 CST
