Re: ORA-1017 remote login SYS as SYSDBA
Date: Wed, 16 Feb 2022 08:07:09 +1100
Message-ID: <CAFeFPA-xPm=Q4-sKUyvc18+1rRKcY82H3qt_VhSFKG4BF8qaiw_at_mail.gmail.com>
Hi Andy
it specifically states during the analyze phase that at the end you need to
run the ORADIM to create the service..
It uses a temporary service during the upgrade. Local sysdba works but
remote is an issue
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
On Wed, Feb 16, 2022 at 12:09 AM Andy Sayer <andysayer_at_gmail.com> wrote:
> 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
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 15 2022 - 22:07:09 CET