본문 바로가기

Database/Oracle

12 - [Oracle 19C] Connecting sys user

 

 

 

[oracle@test ~]$
[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 14 16:01:39 2023
Version 19.3.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.3.0.0.0

SQL>

 

 

 

특수 문자가 포함된 비밀번호를 사용할때 편리하다.

 

[oracle@test ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 14 16:02:21 2023
Version 19.3.0.0.0

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

SQL> conn sys/"xxx@@@" as sysdba
Connected.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>