혼돈의 오라클 logon denied

정말 제목이랑 똑같음..

 

혼돈의 오라클

sqlplus...나도 할래...

 

 

도대체 계속 logon denied

연결할 수 없대....계속 없대....

Enter user-name: sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@node-app:~$ conn sys /as sydba

Command 'conn' not found, did you mean:

  command 'cons' from deb cons
  command 'ronn' from deb ruby-ronn

Try: apt install <deb name>

oracle@node-app:~$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on 화 8월 23 15:34:40 2022

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

Enter user-name: oracle
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: SYSDBA
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

 

 

 

******해결법*******

 

걍 바로 sqlplus sys as sysdba했더니 됐음!!

패스워드도 설치했을 때 입력했던 걸로 해결

 

oracle@node-app:~$ sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on 화 8월 23 15:35:50 2022

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

Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>
SQL>