Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Administrator / domain user differences Oracle9i

Re: Administrator / domain user differences Oracle9i

From: rdmw <rdmw0001_at_yahoo.com>
Date: 29 Sep 2003 05:24:29 -0700
Message-ID: <a2d2dfb0.0309290424.653d6105@posting.google.com>

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0309280907.5e58e485_at_posting.google.com>...
> rdmw0001_at_yahoo.com (rdmw) wrote in message news:<a2d2dfb0.0309260625.e152926_at_posting.google.com>...
> > Hi,
> > I just installed Oracle9i on my pc (Windows XP pro). I have the
> > following problem. I can only create a database when I am logged on
> > as the Administrator user locally on my pc. When I logon as a
> > different user that is part of a domain, I can't create any database
> > and testing the connection using the Net configuration assistant
> > failes (ORA-03113 end-of-file on communication channel).
> > The domain user is part of the administrators group and ORA-DB group
> > but that doesn't seem to help.
> >
> > Can someone tell me why I can only create/connect to a database as
> > Administrator user and not as a user (with administrative rights) that
> > is part of domain. How can I solve this ?
> > As you may have figgered out, I am pretty new to Oracle.
> >
> > Regards,
> > rdmw.
>
> 3 methods:
>
> 1. read the platform-specific concepts and release notes.
> http://otn.oracle.com/documentation/oracle9i.html
> 2. logon to an account that has membership in the local group ORA_DBA
> if you have sufficient privileges, you can add a domain group to a
> local group, or add a domain account into a local group.
> 3. set the parameter sqlnet.authentication_services=(NONE)
> in the file %ORACLE_HOME%\Network\Admin\sqlnet.ora
> this will force the use of password authentication, and not
> authenticate the user against the operating system.
>
> hth.
>
> Pd

Thank you !!!
Item 3 above did it for me.

Regards,
Ronald Wouters Received on Mon Sep 29 2003 - 07:24:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US