Check for these things... 1. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in initSID.ora 2. ORA_SID_PWFILE = location_of_ur_passwordfile in the WINDOWS REGISTRY of the server. 3. Check the SYS password, or from some other USER do a 'ALTER USER sys IDENTIFIED BY ...' and then try connecting
I hope this works out. Most of the times we miss a very small and obvious thing. Go systematically. Regards Naveen -----Original Message----- Sent: Friday, September 13, 2002 2:58 PM To: Multiple recipients of list ORACLE-L 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:[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: Naveen Nahata 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).