CODEWITHSUNDEEP
oracle-databasesqlplus
Vy Do
Vy Do

Reputation: 52646

Oracle database SQLPLUS: How to enter password has character @?

Oracle database 21c express edition on Windows 11.

enter image description here

My error

ORA-12154: TNS:could not resolve the connect identifier specified

enter image description here

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 21.0.0.0.0 - Production on Thu Aug 25 10:21:18 2022
Version 21.3.0.0.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>

enter image description here

Upvotes: 0

Views: 1033

Answers (2)

Vy Do
Vy Do

Reputation: 52646

sqlplus /nolog
connect sys/"123456a@"@xe as sysdba

SQL> alter session set "_ORACLE_SCRIPT"=true;  
SQL> create user donhuvy identified by "123456a@";
SQL> grant create session to donhuvy;
SQL> connect donhuvy/"123456a@"@xe

Upvotes: 0

Connor McDonald
Connor McDonald

Reputation: 11591

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.

Upvotes: 1

Related Questions