RE: SYSDBA privilege with ORAPWD utility

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Fri, 13 Sep 2002 01:58:27 -0800
Message-ID: <F001.004CF59E.20020913015827@fatcity.com>

Hei...

Is your sys password is correctly mentioned while logon?..... I tested your case, it's doing proper, while i misspelled sys pwd, it thrown the error as u mentioned...

HTH, Nirmal

-----Original Message-----
Sent: Wednesday, September 11, 2002 3:38 PM 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: Nirmal Kumar Muthu Kumaran
INET: NIRMALK_at_qtel.com.qa

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