Re: connect / as sysdba - What am I missing?
Date: Fri, 19 Nov 2010 12:23:07 +0100
Message-ID: <4CE65E1B.2000504_at_nordea.com>
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 connectingwithout password
> Jeremy Sheehan
> Oracle DBA
> Jeremy.Sheehan_at_nexteraenergy.com<mailto:Jeremy.Sheehan_at_fpl.com>
> (561) 304-5769 - office
> (561) 625-7196 - fax
> DBA Requests: [cid:image001.gif_at_01CB84B7.ACA50A90] <notes:///85256DFF006B0BA9>
>
> From: David Pintor [mailto:painterman_at_gmail.com]
> Sent: Monday, November 15, 2010 11:20 AM
> To: Sheehan, Jeremy
> Cc: oracle-l_at_freelists.org
> 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_at_nexteraenergy.com<mailto:JEREMY.SHEEHAN_at_nexteraenergy.com>> 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_at_nordea.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 19 2010 - 05:23:07 CST