SYS user getting ORA-01017 (invalid username/password; logon denied) even putting right password in Oracle 19c
0
votes
1
answer
547
views
**→ OS: Oracle Linux Server release 8.7**
**→ DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0**
After cloning a virtual machine that we can connect normally on sqlplus with sys user, we cannot say the same about the clone and reconfigured machine, even change sys password and putting the right one:
> oracle@somedb ~]$ sqlplus sys@somecdb as sysdba
>
> SQL*Plus: Release 19.0.0.0.0 - Production on Seg Set 23 09:39:55 2024
> Version 19.3.0.0.0
>
> Copyright (c) 1982, 2019, Oracle. All rights reserved.
>
> Informe a senha: ERROR: ORA-01017: senha/nome do usu�rio inv�lido;
> log-on negado
But I can connect with SYSTEM user and probably with the other users, on both machines:
> oracle@somedb ~]$ sqlplus system@somecdb
>
> SQL*Plus: Release 19.0.0.0.0 - Production on Seg Set 23 09:56:01 2024
> Version 19.3.0.0.0
>
> Copyright (c) 1982, 2019, Oracle. All rights reserved.
>
> Informe a senha: Hor�rio do �ltimo log-in bem-sucedido: Seg Set 23
> 2024 09:03:09 -03:00
>
> Conectado a: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
> - Production Version 19.3.0.0.0
>
> SQL>
The root connection is ok (sqlplus / as sysdba), but the CDB connection not - same problem happens trying to connect with SQL Developer.
How can I solve it?
Asked by Alan Homobono
(11 rep)
Sep 24, 2024, 01:06 PM
Last activity: Sep 24, 2024, 02:14 PM
Last activity: Sep 24, 2024, 02:14 PM