버전 : 10.2.0.5 E/E
<NLS 관련 파라미터>
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
<oracle user 의 .profile>
umask 022
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2
#export ORACLE_HOME=$ORACLE_BASE/product/crs
export ORA_CRS_HOME=$ORACLE_BASE/product/crs
export ORACLE_SID=ORADBP1
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
export TMP=/oracle/tmp
export TMPDIR=/oracle/tmp
export NLS_LANG=American_America.AL32UTF8
export nls_date_format='YYYY-MM-DD HH:MI:SS:FF'
#export DISPLAY=localhost:0.0
export DISPLAY=10.128.69.248:0.0
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/ccs/bin:/usr/bin/X11:/usr/lbin:/usr/local/bin:$PATH:$ORACLE_BASE/product/crs/bin:$ORACLE_HOME/OPatch:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/usr/lib
export SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export LANG=C
export PS1=[`hostname`-`whoami`:'$PWD] '
<alert log 파일>
Fri Sep 27 14:08:20 KST 2013
Thread 1 advanced to log sequence 35196 (LGWR switch)
Current log# 3 seq# 35196 mem# 0: /ora_data1/ORADBP/redo03.log
Fri Sep 27 14:28:52 KST 2013
Errors in file /ora_dump/ORADBP/bdump/oradbp1_j006_20165.trc:
ORA-12012: ???? 1729543?? ???? ?ㅽ??以? ?ㅻ쪟 諛???
ORA-20000: ORA-20000: ORA-00001: 臾닿껐??????議곌굔(GOALS.PK_TP_A_SUM_HBL_ACC_REV)?? ??諛곕?⑸???
ORA-06512: "EACCT.PROC_MAKE_SUM_REV_EXP", 以? 177????
ORA-06512: 以? 1????
Fri Sep 27 14:29:57 KST 2013
Errors in file /ora_dump/ORADBP/bdump/oradbp1_j002_26793.trc:
ORA-12012: ???? 1729545?? ???? ?ㅽ??以? ?ㅻ쪟 諛???
ORA-20000: ORA-20000: ORA-00001: 臾닿껐??????議곌굔(GOALS.PK_TP_A_SUM_HBL_ACC_REV)?? ??諛곕?⑸???
ORA-06512: "EACCT.PROC_MAKE_SUM_REV_EXP", 以? 177????
ORA-06512: 以? 1????
위 로그파일과 같이 한글로 쓰여지는 부분이 깨져서 나오는데
해결방안이 있나요?
어느것을 바꿔줘야 하는지 모르겠습니다.
아시는 분 안계신가요???
감사합니다.