Chetan, The NAME of the password file should be:
PWD{sidname}.ORA. For example, if your Oracle Sid name is SB815, your password file should be named PWDSB815.ORA On NT boxes, upper/lower case of the file name does not matter. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Wednesday, September 11, 2002 8:38 AM To: Multiple recipients of list ORACLE-L 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: Mercadante, Thomas F 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).