RE: SYSDBA privilege with ORAPWD utility

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Wed, 11 Sep 2002 19:06:33 +0530
Message-Id: <22541.293536@fatcity.com>

i dont think the name shud be PWD(sid).ora.

AFAIK it can be any name. Am i wrong?

Naveen

-----Original Message-----
From: Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us] Sent: Wednesday, September 11, 2002 6:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: SYSDBA privilege with ORAPWD utility

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.=20

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=3Dorapwsb815 password=3Doracle8i

entries=3D30

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

	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
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Chindarkar,Chetan
INET: Chetan_Chindarkar_at_Syntelinc.com

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: ListGuru_at_fatcity.com (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).
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------