Workday/SQL 썸네일형 리스트형 ORA-28002 PDB접속했는데 .. SQL> conn APP_USER/APP_USER@localhost:1521/pdborcl ERROR: ORA-28002: the password will expire within 7 days SQL> ★ sysdba접속 후 아래 SQL로 확인 SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE = 'DEFAULT' AND RESOURCE_TYPE = 'PASSWORD' ; SQL> SELECT RESOURCE_NAME, LIMIT 2 FROM DBA_PROFILES 3 WHERE PROFILE = 'DEFAULT' 4 AND RESOURCE_TYPE = 'PASSWORD' 5 ; RESOURCE_NAME LIMIT ------.. 더보기 PDB접속 ☆☆☆1) PS C:\Users\j75bl> sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 Production on 토 11월 14 09:27:59 2020 Copyright (c) 1982, 2014, Oracle. All rights reserved. SQL> SQL> conn sys/sys as sysdba 연결되었습니다. SQL> SQL> SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBORCL READ WRITE NO ★ MOUNT상태라면 ALTER PL.. 더보기 Oracle계정 groupadd -g 900 dbagroupadd -g 910 opergroupadd -g 920 asmadmingroupadd -g 1100 oinstallmkdir /appuseradd -g dba -G oinstall,oper,asmadmin -u 1200 -d /app/ora10g ora11gchown ora11g.dba /app 더보기 이전 1 다음