Last login: Thu Oct 20 22:19:13 on ttys000
seungri@choeseungliui-MacBookPro ~ % docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6e7386bab035 deepdiver/docker-oracle-xe-11g "/bin/sh -c 'sed -i …" 6 weeks ago Up 13 hours 0.0.0.0:1521->1521/tcp, 22/tcp, 0.0.0.0:8080->8080/tcp oracle11g
seungri@choeseungliui-MacBookPro ~ % docker start oracle11g
oracle11g
seungri@choeseungliui-MacBookPro ~ % docker exec -it oracle11g sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 20 13:22:10 2022
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
seungri@choeseungliui-MacBookPro ~ % sqlplus /nolog
zsh: command not found: sqlplus
seungri@choeseungliui-MacBookPro ~ % docker exec -it oracle11g sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 20 13:25:36 2022
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: system
Enter password:
ERROR:
ORA-28001: the password has expired
Changing password for system
New password:
Retype new password:
Password changed
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> connect system/oracle;
Connected.
SQL> show user;
USER is "SYSTEM"
SQL> conn khacademy/khacademy;
Connected.
SQL> exit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
seungri@choeseungliui-MacBookPro ~ % docker exec -it oracle11g sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 20 13:33:25 2022
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> alter profile default limit password_life_time_unlimited;
alter profile default limit password_life_time_unlimited
*
ERROR at line 1:
ORA-02376: invalid or redundant resource
SQL> conn
Enter user-name: system
Enter password:
Connected.
SQL> alter profile default limit
2 password_life_time unlimited;
Profile altered.
SQL> user;
SP2-0042: unknown command "user" - rest of line ignored.
SQL> conn
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> exit
seungri@choeseungliui-MacBookPro ~ %
'Hardcode > error' 카테고리의 다른 글
[ERROR] 'dependencies.dependency.version' for javax.servlet:jstl:jar is missing (0) | 2023.01.10 |
---|