야솔아빠의 블로그

* How to check service name of PDB : 1. Using Cloud Console Screen capture using SQL Developer OR2. Using ssh[oracle@ORCL1 opc]$ lsnrctl status ....Service "ORCL.moosangkim.oraclecloud.internal" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) for this service...Service "ORCLXDB.moosangkim.oraclecloud.internal" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) ..

Oracle/Oracle Cloud 2016. 5. 18. 13:09

환경 : Oracle Cloud 12c + Spring framework 문제 : JDBC로 PDB 연결시, 아래 에러 발생. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 해결 : 1. JDBC 연결방법 변경 ( app.jdbc.url=jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521/pdb1.moosangkim.oraclecloud.internal )2. Oracle DB Cloud 에 ssh로 접속하여 USE_SID_AS_SERVICE_listener=on 추가 및 listener 재기동 * How to check service name of PDB : [oracle@ORCL1 ..

Oracle/Oracle Cloud 2016. 5. 17. 21:06

java.lang.NoSuchMethodError: org.springframework.beans.MutablePropertyValues.add in WebLogic 12c solutions:Add below script in weblogic.xml in WEB-INF directory true for example: 12.1.3 inho true I tried to deploy Web Application packed war to Oracle Java Cloud and Oracle Developer Cloud, But I met above error message.So I tried to treat with below actions:1) add system properties-Dweblogic.spri..

소프트웨어/spring 2016. 5. 16. 20:07

환경 : Oracle 12c 1. Create User and role [oracle@ORCL1 opc]$ sqlplus sys/Welcome1#@pdb1 as sysdba -- USER SQLCREATE USER "DAVID" IDENTIFIED BY "Welcome1@" DEFAULT TABLESPACE "USERS"TEMPORARY TABLESPACE "TEMP"; -- QUOTAS -- ROLES -- SYSTEM PRIVILEGES GRANT CREATE SESSION TO DAVID; GRANT CREATE DATABASE LINK TO DAVID;GRANT CREATE MATERIALIZED VIEW TO DAVID;GRANT CREATE PROCEDURE TO DAVID;GRANT CREA..

소프트웨어/spring 2016. 5. 16. 20:04

How to open specific port to public-internet 1. Move to the Oracle Compute Cloud Service 2. Click on Security Application and Create Security Application 3. Create Security Application 4. Add Security List 5. Move to the Security Rules and Create Security Rule 6. Add security role to the Compute Cloud instance

Oracle/Oracle Cloud 2016. 5. 13. 11:35

Please refer below captured image steps. After connection to the Oracle Computing Cloud Service with PuTTY, change your Id from the opc to oracle. [opc@javacloudservice02-wls-1 ~]$ sudo -u oracle bash

Oracle/Oracle Cloud 2016. 5. 13. 10:59

Subject : deploy a web application to the WebLogic Server 12c through maven project. 1. please prefer below link and do it. (install maven)https://docs.oracle.com/middleware/1212/wls/WLPRG/maven.htm#WLPRG587 instead of [ https://docs.oracle.com/cd/E24329_01/web.1211/e24368/maven.htm#WLPRG585 ]

Oracle/Weblogic 2016. 5. 11. 11:33

Java 프로젝트를 maven 프로젝트로 변환하는 방법. 1. 아래 주소를 참고http://crunchify.com/how-to-convert-existing-java-project-to-maven-in-eclipse/ 2. 프로젝트 우클릭 > Maven > Update Project

소프트웨어/Maven 2016. 5. 4. 16:33