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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
