i dont think the name shud be PWD(sid).ora.
AFAIK it can be any name. Am i wrong?
Naveen
-----Original Message-----
Sent: Wednesday, September 11, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
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).
--
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).
