RE: SYSDBA privilege with ORAPWD utility

Yechiel ,

I have administrator permission on the NT domain; but its still not working. What can be possible cause of this ?

Thx, Chetan

> ----------
> From: Yechiel Adar[SMTP:adar76_at_inter.net.il]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, September 12, 2002 6:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SYSDBA privilege with ORAPWD utility
>
> Hello Chetan
>
> I think that you need to have administrator permission on the NT domain to
> be able to logon as sysdba.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 11, 2002 2:38 PM
>
>
> > Hi List ,
> >
> > I have Oracle 8.1.5 server on Win 2K machine.
> >
> > When I try to connect as SYSDBA using SYS account from a remote machine
> it
> > says "ORA-01017: invalid username/password; logon denied". Then I
> created
> a
> > password file using ORAPWD utility and granted SYS and WIP (a newly
> created
> > schema) the SYSDBA privilege. I also ensured that
> REMOTE_LOGIN_PASSWORDFILE
> > is set to TRUE, but still I can not connect as SYSDBA.
> >
> > Following are the steps which I took.
> >
> > Step 1. Created a password file as followed :
> >
> > D:\Oracle\Ora815\BIN>cd ..\dbs
> > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i
> > entries=30
> >
> > Step 2. Grant SYS user the SYSDBA privilege by the following method
> >
> > D:\Oracle\Ora815\DBS>svrmgrl
> >
> > Oracle Server Manager Release 3.1.5.0.0 - Production
> >
> > (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
> >
> > Oracle8i Release 8.1.5.0.0 - Production
> > With the Java option
> > PL/SQL Release 8.1.5.0.0 - Production
> >
> > SVRMGR> connect internal
> > Password:
> > Connected.
> > SVRMGR> grant SYSDBA to SYS;
> > Statement processed.
> >
> > SVRMGR> select * from v$pwfile_users ;
> > USERNAME SYSDB SYSOP
> > ------------------------------ ----- -----
> > INTERNAL TRUE TRUE
> > SYS TRUE TRUE
> > 2 rows selected.
> >
> > Pls help me if possible.
> >
> > Thanks in advance.
> >
> > Chetan
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Chindarkar,Chetan
> > INET: Chetan_Chindarkar_at_Syntelinc.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chindarkar,Chetan
  INET: Chetan_Chindarkar_at_Syntelinc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).