야솔아빠의 블로그

디버깅 권한 부여 GRANT debug connect session, debug any procedure TO scott; 오렌지를 활용 할때 procedure 선택 => check-out => cntl+F5 (디버깅 컴파일 후 실행) TIP : debug table을 생성 후 긴 동적 쿼리등을 debug table에 담아 쿼리 확인 출처 : http://parandiary.egloos.com/m/2893268

Oracle/DB 2015. 3. 17. 11:27

Oracle ATG Commerce 제품중에서 Formhandler 커스터마이징 하다가 아래와 같은 에러가 난다면.. 10:31:02,745 ERROR [nucleusNamespace.atg.store.order.purchase.CartFormHandler] (http-/0.0.0.0:8080-6) A TransactionManager is required.10:31:02,745 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/ribeiro].[jsp]] (http-/0.0.0.0:8080-6) JBWEB000236: Servlet.service() for servlet jsp threw exception: java.l..

Oracle 2014. 11. 7. 13:51

Oracle Siebel Authorization WSDL 이 WSDL 만들려고 내 할일 제안서도 못쓰고 도와준거 생각하면....황선진 선생님은 정말 밥 몇번은 크게 사야 한다고 생각함.. 아래와 같은 soap message 용 WSDL 을 만들고 싶다면... ? ? ? ? ? ? ? ? ? ? inhojung502@gmail.com 또는 david.jung@oracle.com 로 연락을 주세요~ㅎㅎ

Oracle 2014. 8. 22. 22:00

WebCenter Sites 에서 left tree panel 이 안나올때 조치방법 해별방법 : 아래 document 참고https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=317225996893836&id=1614620.1&_afrWindowMode=0&_adf.ctrl-state=n8ndel37m_4

Oracle/WebCenter 2014. 7. 25. 16:47

시나리오 설명Start the Source and Target OGG Manager processes.Create an Extract that reads from Oracle redo logs in the Source environment.Create an Extract Pump that will move captured transactions to the Target environment.Create a Replicat that will be used to sync up the two sides based on a SCN number we will get prior to an Oracle Datapump export.Start the OGG Capture process on the Source side..

Oracle/OGG 2014. 7. 21. 13:09

Source DB 의 DDL 변경을 Target DB 로 동기화 시키는 예제 환경- source DB : 10g- target DB : 11gR2 1. source DB system 설정 [oracle@ogg-wkshp 10gogg]$ cd [oracle@ogg-wkshp ~]$ source 10g.env [oracle@ogg-wkshp ~]$ cd $GG [oracle@ogg-wkshp 10gogg]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 9 19:07:51 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Datab..

Oracle/OGG 2014. 7. 11. 16:51

Oracle Golden Gate install and Lab 0. 환경설정OGG workshop virtual box 설치 아래 virutal box 설명정보 The following VirtualBox 4.2.6 image consists of Oracle GoldenGate labs running on OEL5, x64. The image memory is configured for 4 GB RAM and guest CPU's are set to 2. The image contains: Oracle GoldenGate 11.2 (labs available) Oracle GoldenGate Monitor Oracle GoldenGate Veridata (lab available) Oracle Gold..

Oracle/OGG 2014. 7. 4. 17:48

프로젝트를 하면서 b2b(EDIFACT message 를 XML로 변환) 하는 oracle solution 의 성능 지연이 발생하였다.성능지연보다는 hang 현상같음 oracle sr 가이드 및 해결책 1. 가이드 http://docs.oracle.com/cd/E28280_01/core.1111/e10108/b2b.htm Also se "http://georgie-soablog.blogspot.co.uk/2012/03/b2b-performance-issues-due-to-large.html" 2. 해결책 - B2B thread count 변경b2b.inboundThreadCount : 4 -> 9 b2b.xEngineThreadCount : 3 -> 9 b2b.outboundThreadCount : 4 ..

Oracle/SOA suite 2014. 4. 21. 10:24