SYSDBA privilege with ORAPWD utility

From: Chindarkar,Chetan <Chetan_Chindarkar_at_Syntelinc.com>
Date: Wed, 11 Sep 2002 07:34:38 -0400
Message-Id: <22541.293516@fatcity.com>

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. Received on Wed Sep 11 2002 - 06:34:38 CDT