develog

[oracle] sqlplus 접속 본문

카테고리 없음

[oracle] sqlplus 접속

냐옴 2022. 4. 14. 11:30

$ sqlplus / as sysdba

$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 14 01:45:11 2022
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> show user
USER is "SYS"

 

$ sqlplus

Enter user-name: / as sysdba

$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 14 01:54:09 2022
Version 19.3.0.0.0

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

Enter user-name: / as sysdba
Connected to an idle instance.

 

$ sqlplus

Enter user-name: sys / as sysdba

Enter password:

$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 14 01:54:57 2022
Version 19.3.0.0.0

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

Enter user-name: sys / as sysdba
Enter password:
Connected to an idle instance.

 

$ sqlplus /nolog

SQL> conn sys/mypassword as sysdba

$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 14 01:56:15 2022
Version 19.3.0.0.0

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

SQL> conn sys/mypassword as sysdba
Connected to an idle instance.
Comments