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).
