OALL8이 불일치 상태입니다 에러 검색
현재 Oracle 버전을 확인한다. 10.2.0.2 버전에서는 버그라고 확인이 되고 있는데 10.2.0.4 로 패치해야 하고.
Bug 4962360
When an Enterprise Manager repository is hosted on a 10.2.0.2.0 database, OMS connections to the repository are sometimes aborted with the following error message:
SQLException java.sql.SQLException: OALL8 is in an inconsistent state.
See Bug 4961570 for once such instance while managing Collabsuite targets.
Cause:
This is caused by RDBMS Bug 5033488 - ORA-07445: exception encountered: core dump kokmrwo()+86.
Workaround:
Log on to the repository as sysdba and execute the following command:
SQL> alter system set "_optimizer_connect_by_cost_based" = false;
Solution
If the problem persists call Oracle Support.
참고: http://ubermensch.tistory.com/48
10.2.0.4 버전이면 jdbc 드라이버를 업데이트 한다. jdbc 확인하는 법은
<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<%
StringBuffer sbError = new StringBuffer();
DatabaseMetaData dbMetaData = null;
Connection conn = null;
%>
<font size="-1"><p>
<%
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
try {
conn = DriverManager.getConnection("jdbc:oracle:thin:@111.111.111.111:1521:test", "scott", "tiger");
dbMetaData = conn.getMetaData();
%>
<p>
Name of JDBC Driver : <%= dbMetaData.getDriverName() %><br>
Driver Version : <%= dbMetaData.getDriverVersion() %><br>
Major Version : <%= dbMetaData.getDriverMajorVersion() %><br>
Minor Version : <%= dbMetaData.getDriverMinorVersion() %><br>
<p>
Database Product Name : <%= dbMetaData.getDatabaseProductName() %><br>
Database Product Version Version : <%= dbMetaData.getDatabaseProductVersion() %><br>
Database Major Version: <%= dbMetaData.getDatabaseMajorVersion() %><br>
Database Minot Version: <%= dbMetaData.getDatabaseMinorVersion() %><br>
<%
} catch (SQLException e) {
sbError.append(e.toString());
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
sbError.append(e.toString());
}
}
}
if (sbError.length() != 0) {
out.println(sbError.toString());
} else {
%>
<p></font>
<%
}
%>
</body>
</html>
'DB' 카테고리의 다른 글
| oracle과 sybase의 차이점 (0) | 2012.07.29 |
|---|---|
| 마스터 디테일 구조에서 order by (0) | 2012.07.29 |
| MySql dmp (0) | 2012.07.29 |
| Oracle Trigger (0) | 2012.07.29 |
| Oracle Procedure (0) | 2012.07.29 |