RE: SYSDBA privilege with ORAPWD utility

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 11 Sep 2002 10:09:34 -0400
Message-Id: <22541.293543@fatcity.com>

You might be right - why else would we have the option to name the file anything we want.
I can't find NT docs at the moment, so I can't verify this.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Naveen Nahata [mailto:naveen_nahata_at_mindtree.com] Sent: Wednesday, September 11, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: SYSDBA privilege with ORAPWD utility

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

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

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

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

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