Início / dba / Perguntas / 244161
Accepted
Just a learner
Asked: 2019-07-31 13:10:01 +0800 CST

Senha de usuário Oracle com caractere de espaço nele

  • 772

Conectei-me a um banco de dados Oracle 19c e executei o seguinte SQL:

alter user sys identified by "a b" container=all;

Executou com sucesso. No entanto, depois disso não consigo me conectar ao Oracle usando o SQLPlus. Abaixo está minha tentativa:

oracle:[~]$ sqlplus
Enter user-name: sys as sysdba
Enter password:
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name: oracle:[~]$
oracle:[~]$
oracle:[~]$
oracle:[~]$ sqlplus sys/"a b"@localhost:1521/ORCLCDB as sysdba
... (not work)
oracle:[~]$ sqlplus sys/\"a b\"@localhost:1521/ORCLCDB as sysdba
... (not work)
oracle:[~]$ sqlplus sys@localhost:1521/ORCLCDB as sysdba
... (type "a b" without quotes and not work)

Como posso me conectar ao banco de dados?

oracle connectivity

1 respostas

  1. Best Answer

    Não é possível fazer login no oracle usando o utilitário sqlplus porque o nome de usuário e a senha contêm espaço

    [oracle@o71 ~]$ sqlplus sys/Oracle123@\'localhost/MIN19_O71\' as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 30 23:12:19 2019
Version 19.4.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0

SQL> alter user sys identified by "Oracle 123";

User altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0

[oracle@o71 ~]$ sqlplus sys/\""Oracle 123\""@\'localhost/MIN19_O71\' as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 30 23:19:25 2019
Version 19.4.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0

SQL>
    • 2

relate perguntas