Re: SYSDBA privilege with ORAPWD utility

Sorry for the late post.
I did some research some time ago and found that when connecting as sysdba you are working under user SYS no matter what user you used to logon. So, connect system as sysdba and you are sys. problem solved.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, September 13, 2002 10:28 AM

> Hey ,
>
> Im able to connect as SYSDBA from all other users (for e.g. WIP, SYSTEM)
> except SYS. Can anyone pls advise on this.
>
> Thanks, 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).

-- 
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 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).