Sheehan, Jeremy pisze: > Yes. The user is in the ORA_DBA group on the server. Not sure, if there was a note about it: - one needs also to be a local administrator Besides - group AFAIK is ORA_DBA - check of course if a password file is created - SQLNET.AUTHENTICATION_SERVICES=(TNS) -- if wa talk about connecting without password > Jeremy Sheehan > Oracle DBA > Jeremy.Sheehan@xxxxxxxxxxxxxxxxx<mailto:Jeremy.Sheehan@xxxxxxx> > (561) 304-5769 - office > (561) 625-7196 - fax > DBA Requests: [cid:image001.gif@01CB84B7.ACA50A90] <notes:///85256DFF006B0BA9> > > From: David Pintor [mailto:painterman@xxxxxxxxx] > Sent: Monday, November 15, 2010 11:20 AM > To: Sheehan, Jeremy > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: connect / as sysdba - What am I missing? > > Hi, > > Does your Windows user belong to the DBA group? > > David > > > On 15 November 2010 16:14, Sheehan, Jeremy > <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>> > wrote: > Hello, > > I'm trying to get > > Sqlplus /nolog > Connect / as sysdba <-- has to be like this, script does not work otherwise > > To work on a Windows 2003 server, but keep on getting an ORA-01031 - > Insufficient privileges error. > > I've followed 3 different notes on metalink, looked all over the web and > still can't get it working. > > Here are the stats.... > > Windows 2003 SP3, 64-bit > Oracle 10.2.0.3 Enterprise > 2 DB's on the server using a shared listener > Does not work for BOTH DB's on the server > Rebuild password file > REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE > > SQLNET.ora file (tried commeting out sqlnet.auth..., also tried with NTS) > > # SQLNET.ORA Network Configuration File > # Generated by Oracle configuration tools. > > NAMES.DEFAULT_DOMAIN = fpl.com<http://fpl.com> > > SQLNET.AUTHENTICATION_SERVICES=(NONE) > > NAMES.DIRECTORY_PATH=(TNSNAMES,LDAP) > > I can't figure this out for the life of me. If anyone has any ideas on what > I'm doing wrong or some hints in the right direction, I'd be much > appreciative! > > Thank you! > > Jeremy > > -- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem: 0000021828, dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku, VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego, o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych, NIP: 586-000-78-20, REGON: 190024711 -- //www.freelists.org/webpage/oracle-l