Re: [EXTERNAL] RE: ORA-1017 remote login SYS as SYSDBA

Rerun your orapwd command with these options: format=12 ignorecase=Y

On Tue, Feb 15, 2022 at 7:34 AM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> I am at Starbucks, and don’t have my notes. But I think you need to set
> the version of the password file to 12.1 or maybe 12.2. The issue has to do
> with password complexity and oracle version.
>
> Sent from my iPad
>
> On Feb 15, 2022, at 07:28, Scott Canaan <srcdco_at_rit.edu> wrote:
>
> 
>
> I know it’s basic and probably there, but did you make sure that the
> init.ora / spfile contains
>
>
>
> remote_login_passwordfile = EXCLUSIVE
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Beckstrom, Jeffrey
> *Sent:* Tuesday, February 15, 2022 8:24 AM
> *To:* andysayer_at_gmail.com; jack_at_vanzanen.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* [EXTERNAL] RE: ORA-1017 remote login SYS as SYSDBA
>
>
>
> We had a similar problem for a new 12.2 database we created manually. No
> matter what we did, we could not get remote SYS connections to work. Our
> solution was to drop the database and recreate it with DBCA, for some
> reason that made the difference. I know yours is an upgrade but just to let
> you know you are not alone.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Andy Sayer
> *Sent:* Tuesday, February 15, 2022 8:10 AM
> *To:* jack_at_vanzanen.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: ORA-1017 remote login SYS as SYSDBA
>
>
>
> Hi Jack,
>
>
>
> A couple of irrelevant things first.
>
> It’s weird that autoupgrade didn’t create a service for you, it had to run
> the upgrade somewhere so presumably it had a service at some point.
>
> <sid> should really be <tnsnames entry that points to appropriate listener
> and sid/service name>. Sid might be an appropriate name, but when you have
> many environments with the same DBs, this doesn’t make too much sense. If
> the instance is local then just set the environment parameter oracle_sid
> and connect without a connection string.
>
>
>
> Anyway…
>
> Did you make sure you are using the password you set with orapwd? Did you
> make sure you set the password file name correctly - people often use the
> wrong casing. It should be “PWDsid.ora”.
>
>
>
> Hope this helps,
>
> Andy
>
>
>
>
>
> On Tue, 15 Feb 2022 at 12:13, Jack van Zanen <jack_at_vanzanen.com> wrote:
>
> Hi All,
>
>
>
> Situation:
>
> Windows 2016 Oracle 19.14 (just upgraded from 18C using autoupgrade)
>
>
>
> At the end of the upgrade it needed me to use oradim to create the service
> as the upgrade does not do that.
>
> I ran the oradim command but it gave an error that the password did not
> meet requirements.
>
>
>
> The service was created, but no password file.
>
>
>
> No problem, stopped the database and used orapwd to create password file.
> I can see that password file gets updated when I grant sysdba or change
> sys password.
>
> However remote logon using sysdba does not work. All settings look OK but
> no luck
>
>
>
> H:\>sqlplus sys/********_at_<sid> as sysdba
>
> SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 15 23:03:56 2022
> Version 19.3.0.0.0
>
> Copyright (c) 1982, 2019, Oracle. All rights reserved.
>
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> sec_case_sensitive_logon boolean TRUE
> sec_max_failed_login_attempts integer 3
> sec_protocol_error_further_action string (DROP,3)
> sec_protocol_error_trace_action string TRACE
> sec_return_server_release_banner boolean FALSE
> remote_login_passwordfile string EXCLUSIVE
> remote_os_authent boolean FALSE
> remote_os_roles boolean FALSE
>
>
>
> Anyone have more experience on windows that understands what could
> possibly be happening here?
>
>
> Jack van Zanen
>
>
>
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l