RE: SYSDBA privilege with ORAPWD utility

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Wed, 11 Sep 2002 18:42:13 +0530
Message-Id: <22541.293535@fatcity.com>

REMOTE_LOGIN_PASSWORDFILE =3D EXCLUSIVE (not true)

naveen

-----Original Message-----
From: Chindarkar,Chetan [mailto:Chetan_Chindarkar_at_Syntelinc.com] Sent: Wednesday, September 11, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject: SYSDBA privilege with ORAPWD utility

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 Received on Wed Sep 11 2002 - 08:12:13 CDT