현재 자카르타톰캣과 오라클,jdbc2.0,apache를 리눅스에서 돌리고 있습니다. 오라클의 경우 제대로 작동하고 있구요. tnsping 등 아무런 문제가 없습니다.
근데 며칠전 jdbc를 classpath잡고서 게시판 관련 프로그램을 돌리니까 이런 에러가 뜹니다.(게시판의 소스에는 아무런 에러가 없음) 리스너가 잘못된 거 같진 안구요(잘 쓰고 있음). jdbc가 좀 이상한 거같은데.. 해답을 좀 주십시요.. 같은 문제로 고생한 분들이 있을 거 같은데...
아래는 환경설정파일의 일부와 체크했을 경우 나오는메시지입니다.
1. tnsping의 경우----------------------------------------------------------
./tnsping overland
TNS Ping Utility for Linux: Version 8.1.6.0.0 - Production on 25-OCT-2000 16:08:
45
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=211.174.163.251)(PORT=1521))
OK (0 msec)
2. classpath ---------------------------------------------------------------
CLASSPATH=.:/usr/local/java/lib/classes.zip:/home/oracle/8i/jdbc/lib/classes12.zip:/home/oracle/8i/jdbc/lib/nls_charset12.zip:.
3. 오라클계정 내에 있는 .bashrc의 내용
##
# Enviroment variablees for Oracle
##################################
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=/home/oracle/8i
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORACLE_SID=ORCL
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
4. tnsnames.ora의 내용
OVERLAND =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.174.163.251 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = overland)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
5. listener.ora의 내용
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.174.163.251) (PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.174.163.251)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = overland)
(ORACLE_HOME = /home/oracle/8i)
(SID_NAME = ORCL)
)
)
6. 브라우저가 출력하는 내용..
Internal Servlet Error:
javax.servlet.ServletException: IO ?? ??: The Network Adapter could not establish the connection
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java, Compiled Code)
at _0002findex_0002ejspindex_jsp_0._jspService(_0002findex_0002ejspindex_jsp_0.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, Compiled Code)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled Code)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, Compiled Code)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
|