RE: SYSDBA privilege with ORAPWD utility

To get the logon for SYS to work you must ensure that the password in the password file, and SYS's own password are the same!

Do an ALTER USER sys IDENTIFIED BY xxxx to change the password of SYS so that it matches the one in the file. The alias INTERNAL is just another name for SYS so the password in the password file must match SYS's own password , if you are attempting to log in from another machine other than the Oracle server.

I hope this helps.

RWB "Naveen Nahata" <naveen_nahata_at_mindtree.com>@fatcity.com on 09/13/2002 05:18:20 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Check for these things...

1. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in initSID.ora
2. ORA_SID_PWFILE = location_of_ur_passwordfile in the WINDOWS REGISTRY of the server.
3. Check the SYS password, or from some other USER do a 'ALTER USER sys IDENTIFIED BY ...' and then try connecting

I hope this works out. Most of the times we miss a very small and obvious thing. Go systematically.

Regards
Naveen

-----Original Message-----
Sent: Friday, September 13, 2002 2:58 PM To: Multiple recipients of list ORACLE-L

Yechiel ,

I have administrator permission on the NT domain; but its still not working.
What can be possible cause of this ?

Thx, Chetan

> ----------
> From: Yechiel Adar[SMTP:adar76_at_inter.net.il]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, September 12, 2002 6:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SYSDBA privilege with ORAPWD utility
>
> Hello Chetan
>
> I think that you need to have administrator permission on the NT domain
to
> be able to logon as sysdba.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 11, 2002 2:38 PM
>
>
> > 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.
> >
> > 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: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> 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: 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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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: 
  INET: Reginald.W.Bailey_at_jpmorgan.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).