Oracle database 21c express edition on Windows 11.
ORA-12154: TNS:could not resolve the connect identifier specified
My password is
xxxxxa@ . I see https://stackoverflow.com/a/67141887/3728901 How to enter password?
Update: Thank to Connor’s answer. I catch
Microsoft Windows [Version 10.0.19044.1889] (c) Microsoft Corporation. All rights reserved. C:\Users\Administrator>sqlplus /nolog SQL*Plus: Release 188.8.131.52.0 - Production on Thu Aug 25 10:21:18 2022 Version 184.108.40.206.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL> connect sys/"123456a@"@xe ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER SQL>
Double quotes are your friend here
SQL> create user XXX identified by 123@456; create user XXX identified by 123@456 * ERROR at line 1: ORA-00922: missing or invalid option SQL> create user XXX identified by "123@456"; User created. SQL> grant create session to xxx; Grant succeeded. SQL> connect xxx/123@456@db19_pdb1 ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. SQL> connect xxx/"123@456"@db19_pdb1 as sysdba Connected.