'전체 분류'에 해당되는 글 20건

오라클

select * from v$nls_parameters ;

티베로

select * from database_properties;

DB에서 SQL실행시에 에러 발생

Lock wait timeout exceeded; try restarting transaction

특정 테이블이나 레코드에 락이 걸려있다.

해결방법

프로세스들을 확인하고 해당 프로세스에 대해 종료한다.

프로세스 조회

- show processlist;

프로세스 종료
- kill id;

테이블 락 해제

- unlock tables;

MySQL 재시작

- /etc/init.d/mysqld restart

- service mysqld restart

java.lang.IllegalStateException: More than the maximum number of request parameters (GET plus POST) in jBoss AS 7.1

Following error occurs while submitting the request in jBoss AS 7.1.  

java.lang.IllegalStateException: More than the maximum number of request parameters (GET plus POST) for a single request ([512]) were detected. Any parameters beyond this limit have been ignored. To change this limit, set the maxParameterCount attribute on the Connector.

Explanation: jBoss limits the number of parameters to be sent to the server. The default value for the number of parameters is 512. I had a scenario where the number of fields were getting increased because of the business, which I could not control. I made the configuration to accept more number of parameters. Add the following piece of code in the standalone.xml file. 

<extensions> ....
</extensions>
 <system-properties>
        <property name="org.apache.tomcat.util.http.Parameters.MAX_COUNT" value="2000"/>
  </system-properties>
<management> ....
</management>

CentOS의 log 기본 위치는 /var/log 디렉토리에 위치해 있다.

1. /var/log/messages

- 기본적인 시스템 로그

- 관련 프로그램 : syslogd

2. /var/log/maillog

4. /var/log/boot.lo

부팅 로그 파일(데몬의 실행 상태 기록)

5. /var/log/lastlog

로그인 정보 로그 파일(마지막 로그인/ 호스트/ 포트 등)

6. /var/log/dmesg

시스템 부팅 로그 파일

7. /var/log/cron
cron에 대한 로긍 파일

8. /var/log/wtmp

로그인 정보가 기록된 로그 파일

last root < root계정에 대한 로그

last –n 10 root < root 계정에 대한 최근 접속 정보 10건

9. httpd 로그

- /var/log/httpd/access_log

- /var/log/httpd/error_log

2018-03-20 16:47:28,258 ERROR [com.bridgetec.sa.dao.SaDispatchSaDAO] [lsm] update EXCEPTION :org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [60000]; error code [600];   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

2018-03-20 16:47:28,269 ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] Application exception overridden by rollback exception

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [60000]; error code [600];   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)

at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:378)

at egovframework.rte.psl.dataaccess.EgovAbstractDAO.update(EgovAbstractDAO.java:101)

at com.bridgetec.sa.dao.SaDispatchSaDAO.update(SaDispatchSaDAO.java:61)

at com.bridgetec.sa.dao.SaDispatchSaDAO.excute(SaDispatchSaDAO.java:180)

at com.bridgetec.sa.service.SaDispatchServiceImpl.daoExcute(SaDispatchServiceImpl.java:134)

at com.bridgetec.sa.service.SaDispatchServiceImpl.excute(SaDispatchServiceImpl.java:95)

at com.bridgetec.sa.service.SaDispatchServiceImpl$$FastClassByCGLIB$$14581e26.invoke(<generated>)

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

at com.bridgetec.sa.service.SaDispatchServiceImpl$$EnhancerByCGLIB$$210a4753.excute(<generated>)

at com.bridgetec.sa.controller.SaDispatchController.invloke(SaDispatchController.java:120)

at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at egovframework.rte.ptl.mvc.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:51)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:380)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:1)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)

... 56 more

Caused by: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)

at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)

at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)

... 61 more

2018-03-20 16:47:28,269 ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] Application exception overridden by rollback exception

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [60000]; error code [600];   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)

at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:378)

at egovframework.rte.psl.dataaccess.EgovAbstractDAO.update(EgovAbstractDAO.java:101)

at com.bridgetec.sa.dao.SaDispatchSaDAO.update(SaDispatchSaDAO.java:61)

at com.bridgetec.sa.dao.SaDispatchSaDAO.excute(SaDispatchSaDAO.java:180)

at com.bridgetec.sa.service.SaDispatchServiceImpl.daoExcute(SaDispatchServiceImpl.java:134)

at com.bridgetec.sa.service.SaDispatchServiceImpl.excute(SaDispatchServiceImpl.java:95)

at com.bridgetec.sa.service.SaDispatchServiceImpl$$FastClassByCGLIB$$14581e26.invoke(<generated>)

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

at com.bridgetec.sa.service.SaDispatchServiceImpl$$EnhancerByCGLIB$$210a4753.excute(<generated>)

at com.bridgetec.sa.controller.SaDispatchController.invloke(SaDispatchController.java:120)

at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at egovframework.rte.ptl.mvc.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:51)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in sqlmap/sa/CA4020S600_ORA.xml.  

--- The error occurred while applying a parameter map.  

--- Check the CA4020S600.rInsertRecogAnswer-InlineParameterMap.  

--- Check the statement (update failed).  

--- Cause: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:380)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:1)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)

... 56 more

Caused by: java.sql.SQLException: ORA-00600: 내부 오류 코드, 인수: [koklismem1: r_length is 0], [], [], [], [], [], [], [], [], [], [], []

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)

at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)

at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)

... 61 more

오류 : 

- ORA-00600: 내부 오류 코드, 인수 : [koklismem1: r_length is 0], [], [], [], [], [], [], []

해결방안 :

- 원인은 정확하지 않지만 Oracle Merge문을 사용하는데 4000byte 이상의 CLOB데이터 입력 시 문제가 나왔다.

- CLOB 데이터의 경우는 Oracle Merge 대신문 대신 Inser와 Update를 따로 사용하여 해결했다.

/bridgetec/CatchAll/was/server

/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.79.x86_64

● JDK 설치

-  JAVA SE 설치 링크

https://www.oracle.com/technetwork/java/javase/archive-139210.html

● JAVA_HOME / JEUS_HOME 환경 변수를 추가

- $ vi ~/.bash_profile

- export JAVA_HOME=/home/shonm/jdk1.7.0_80

   export JEUS_HOME=/home/shonm/jeus7

   PATH=$JAVA_HOME/bin:$PATH ~~~~~~~

- $ source .bash_profile

● Tmax 사이트에 접속하여 jeus7 버전을 다운

- JEUS 7.0 Fix#4 다운

https://technet.tmaxsoft.com/ko/front/download/findDownloadList.do?cmProductCode=0101

● 권한 부여

 - $ chmon +x jeus70_unux_generic_ko.bin

● 파일을 실행

- ./jeus70_unix_generic_ko.bin

- license에 동의 하느나? 

: y

- OS 종류 선택 

: Linux x64 를 선택

- jeus 설치 경로  

: /home/shonm/jeus7

- 서버 타입 선택

: Domain Admin Server(das)  인 1번 선택

- mode 선택    

: production mode 가 일반적

- JDK 의 PATH

: /home/shonm/jdk1.7.0_80

- 웹 콘솔 비밀번호 설정 

: administrator / jeusadmin

- domain 이름  

: jeus_domain

- node manager 

: ssh 는 권장 되지 않고 일반적으로 java 타입이 권장 됨

● source ~/.bash_profile

● startDomainAdminServer -domain jeus_domain -u administrator -p password으로 실행 시켜서 

- The server state is now Running메시지 출력시 실행 성공

- $ startManagedServer -domain jeus_domain -server server1 -u administrator -p iCatch2016

jeusadmin -u adminstrator -p password

● 관리 UI 접근 방법

- http://server_ip:9736/webadmin

● server shutdown

- $ stopServer -host localhost:9736 -u administrator -p password

● nodeManager 기동

- $JEUS_HOME/nodemanager/logs 폴더를 생성

- $ nohup startNodeManager > /home/shonm/jeus7/nodemanager/logs/nm.log &

● nodeManager shutdown 방법

- $ stopNodeManager -host localhost -port 7730

Elasticsearch를 설치하기 이전에는 우선 설치 및 설정을 해야할 것들이 많다.

엘라스틱서치의 경우는 Java(JVM) 위에 실행이 되기 때문에 자바를 선 설치를 한다.

2017/12/11 - [개발/Java] - 리눅스 Java 설치 및 환경변수 설정

위에 링크를 통해 자바를 설치 한 후 아래 내용을 따라한다.

1) 다운로드

- curl을 통한 다운로드(centos)

$ curl -L -O https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-5.6.3.tar.gz

- wget을 통한 다운로드(ubuntu)

$ wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-5.6.3.tar.gz

2) 압축 해제

$ tar xvfz elasticsearch-5.6.3.tar.gz

3) 실행

$ cd elasticsearch-5.6.3/bin/

$ ./elasticsearch

/* 백그라운 실행시 $ ./elasticsearch & */

하지만 문제는 분명 실행을 했는데 본인의 PC에서는 붙을 수 없을 것이다.

방화벽과 엘라스틱 자체적인 설정에 network.bind_host 설정을 해줘야 한다.

1) network.bind_host 설정

$ vi elasticsearch-5.6.3/conf/elasticsearch.yml

network.bind_host: 0.0.0.0

bootstrap.seccomp: false

으로 변경 후 저장한다.

network.bind_host는 접근 가능한 ip에 대한 설정인데, 0.0.0.0으로 변경을 하면 모든 ip에 대해서 접근이 가능하다.

2) 9200 PORT에 대한 방화벽 설정

$ iptables -I INPUT 1 -p tcp --dport 9200 -j ACCEPT

9200 포트에 대해 오픈을 하는데, 보안의 문제가 있으니 테스트에서만 개방을 하고, 실 운영시 잘 알아보고 열어준다.

위와 같이 설정 후 elasticsearch를 다시 한번 실행해준다.

우선 리눅스에 Elasticsearch를 설치하기 전 Java8 버전을 설치하겠습니다.

자바 설치 파일은 다운 받는데 리눅스  64bit 환정에 맞게 

jdk-8u151-linux-x64-demos.rpm을 설치하겠습니다.

다운로드 방법은 Oracle 홈페이지에서 다운받아 FTP를 통해 넘겨주거나 curl wget 등을 통해 다운받을 수 있습니다. (centos의 경우는 wget을 따로 설치해야하기 때문에 curl로 다운받아보겠습니다.)

- 홈페이지 다운

자바 8 링크 (http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html)

- curl 명령어를 통한 다운

$ curl -L -O http://download.oracle.com/otn-pub/java/jdk/8u151-b12-demos/e758a0de34e24606bca991d704f6dcbf/jdk-8u151-linux-x64.rpm

- wget 명령어를 통한 다운

$ wget http://download.oracle.com/otn-pub/java/jdk/8u151-b12-demos/e758a0de34e24606bca991d704f6dcbf/jdk-8u151-linux-x64.rpm

rpm 설치

$ sudo rpm -ivh jdk-8u151-linux-x64.rpm

rpm 설치의 경우는 패키지를 설치하기 때문에 권한이 없으면 설치가 안될 수 있습니다. sudo 권한 혹은 root 계정으로 설치를 추천드립니다.

java 설치 확인

$ java -version

리눅스 java 환경변수 설정

해당 계정의 .bash_profile 파일에서 환경변수(JAVA_HOME)를 등록해준다.

1) 계정 디렉토리 이동

$ cd ~

2) .bash_profile 읽기

$ vi .bash_profile

3) 환경변수 추가

i를 눌러 insert 모드 후

export PATH=$PATH:/usr/java/latest/bin

export JAVA_HOME=/usr/java/jdk1.8.0_151

삽입 후 ESC키 입력 후

:wq 저장

4) 소스 적용

$ source .bash_profile

5) JAVA_HOME 확인

$ echo $JAVA_HOME

리눅스상의 복사 명령어는 cp이다.

우선 해당 파일 or 디렉터리가 있는 곳으로 이동하여 아래와 같은 예제로 명령어를 실행한다.

- 파일의 경우

cp [복사할 파일명] [복사할 디렉토리 or 파일명]

예) home 디렉토리에 있는 ab.sh을 /home/ab 디렉토리에 abs.sh로 변경하여 복사하려면 다음과 같다.

$ cp /home/ab.sh /home/ab/abs.sh

- 디렉토리의 경우

cp -R [복사할 디렉토리명] [복사할 디렉토리]

예) home 디렉토리에 있는 aa디렉토리를 /home/bb디렉토리로 안으로 복사하려는 경우는 다음과 같다.

$ cp -R /home/aa /home/bb/