본문 바로가기

Settings 1. Project 선택 (1) project facets -> 1.8 변경 2 . pom.xml 수정 (1) version 수정 1.8 4.1.7.RELEASE 1.6.10 1.6.6 (2) junit 변경 junit junit 4.1.2 test (3) MyBatis org.mybatis mybatis 3.2.8 org.mybatis mybatis-spring 1.2.2 org.springframework spring-jdbc ${org.springframework-version} org.springframework spring-test ${org.springframework-version} (4) JSON com.fasterxml.jackson.core jackson-databind 2.5.4 (5.. 더보기
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.. 더보기
HelloServlet package com.acrm.common; import java.io.IOException; import javax.annotation.PostConstruct; import javax.annotation.PreDestroy; import javax.servlet.ServletException; import javax.servlet.annotation.WebInitParam; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Ser.. 더보기
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 더보기