알짜 리눅스(레드햇6.0)에 오라클8.0.5를 깔았습니다.
모든 것을 잘쓰고 있는상황에서 jdbc테스트를 해보려 했습니다.
오라클 설치시.. 모든 드라이버(oci7,oci8,thin*)를 모두 깔았습니다.
그런데.. 설치도 완전히 되었죠.
* jdk : ibm_linux_jdk1.1.8
그런데 jdbc디렉토리의 샘플들을 실행하면 다음과 같은 알수없는 에러 메세지가
나옵니다.
아무래도 언어셋팅문제일까 싶은데 어디를 손봐야될지 참조로 언어값들은 다음과
같습니다. 그리고 자바컴파일및 실행화면은 그 다음에 있습니다.
1. 언어셋팅
1) .bash_profile내의 NLS_LANG값
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
2) oracle내부의 값
select name,value$ from props$ where name like '%NLS%';
NAME VALUE$
======================================
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET KO16KSC5601
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_RDBMS_VERSION 8.0.5.0.0
2. 자바 컴파일및 실행화면
#cd $ORACLE_HOME/jdbc/samples/oci8/
#javac Employee.java
#java Employee
SIGSEGV received at bffff15c in /u01/app/oracle/product/8.0.5/lib/liboci805jdbc.so. Processing terminated
Writing stack trace to javacore4495.txt ... OK
Segmentation fault
그래서 추적화일을 보면 다음과 같은 내용이 있습니다. 해결좀 해주세요.
================= 내용 javacore4495.txt ===================================
v 9 17:33:39 2000
SIGSEGV received at bffff15c in /u01/app/oracle/product/8.0.5/lib/liboci805jdbc.so. Processing terminated
java full version "JDK 1.1.8 IBM build l118-20000713 (JIT enabled: jitc)"
args: /usr/jdk118/bin/linux/native_threads/java Employee
Operating Environment
---------------------
Host : kevin.xxx.yyy.
OS Level : 2.2.5-22.#1 Wed Jun 2 09:17:03 EDT 1999
glibc Version : 2.1.1
No. of Procs : 1
Memory Info:
total: used: free: shared: buffers: cached:
Mem: 131166208 126590976 4575232 40890368 2793472 29519872
Swap: 410255360 10526720 399728640
MemTotal: 128092 kB
MemFree: 4468 kB
MemShared: 39932 kB
Buffers: 2728 kB
Cached: 28828 kB
SwapTotal: 400640 kB
SwapFree: 390360 kB
User Limits (in bytes except for NOFILE and NPROC) -
RLIMIT_FSIZE : infinity
RLIMIT_DATA : infinity
RLIMIT_STACK : 2088960
RLIMIT_CORE : 0
RLIMIT_NOFILE : 1024
RLIMIT_NPROC : 256
Application Environment
-----------------------
Signal Handlers -
SIGQUIT : ignored
SIGILL : sysThreadIDump (libjava.so)
SIGABRT : sysThreadIDump (libjava.so)
SIGFPE : sysThreadIDump (libjava.so)
SIGBUS : sysThreadIDump (libjava.so)
SIGSEGV : sysThreadIDump (libjava.so)
SIGPIPE : ignored
SIGUSR1 : doSuspendLoop (libjava.so)
Environment Variables -
USERNAME=
GTK_DEFAULT_FONTSET=-*-helvetica-medium-r-normal--12-*,-*-kodig-medium-r-normal--12-*
QT_HANFONT=-*-kodig-medium-r-normal--12-*-ksc5601.1987-0,-*-kodig-medium-r-normal--14-*-ksc5601.1987-0,-*-kodig-medium-r-normal--16-*-ksc5601.1987-0,-*-kodig-medium-r-normal--18-*-ksc5601.1987-0,-*-kodig-medium-r-normal--20-*-ksc5601.1987-0,-*-kodig-medium-r-normal--24-*-ksc5601.1987-0
QT_KEYBOARD=2
HISTSIZE=1000
HOSTNAME=kevin.mpeon.net
LOGNAME=oracle
ORACLE_SID=ora1
HISTFILESIZE=1000
NLS_LANG=AMERICAN_AMERICA.UTF8
GTK_KEYBOARD=2
MAIL=/var/spool/mail/oracle
LD_LIBRARY_PATH=/usr/jdk118/lib/linux/native_threads:/u01/app/oracle/product/8.0.5/lib
ORACLE_BASE=/u01/app/oracle
CLASSPATH=.:/usr/jdk118/lib/classes.zip:/usr/local/JSDK2.0/lib/jsdk.jar:/u01/app/oracle/product/8.0.5/jdbc/lib/classes111.zip:/u01/app/oracle/product/8.0.5/jdbc/lib/classes102.zip:/usr/jdk118/classes:/usr/jdk118/lib/classes.jar:/usr/jdk118/lib/rt.jar:/usr/jdk118/lib/i18n.jar:/usr/jdk118/lib/classes.zip
TERM=xterm-color
HOSTTYPE=i386
PATH=/usr/jdk118/bin:/usr/local/JSDK2.0/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/oracle/bin:/u01/app/oracle/product/8.0.5/bin
KDEDIR=/usr
HOME=/home/oracle
INPUTRC=/etc/inputrc
SHELL=/bin/bash
USER=oracle
PERL_BADLANG=0
LESSCHARSET=latin1
ORACLE_TERM=vt100
QTDIR=/usr/lib/qt
JAVA_HOME=/usr/jdk118
ORACLE_HOME=/u01/app/oracle/product/8.0.5
LANG=ko
OSTYPE=Linux
SHLVL=1
<계속>
|