AIX서버 날짜타입 오류

.profile 파일에 옵션 추가

# 오라클 쿼리에서 날짜 오류시 profile파일에 추가#

export NLS_DATE_FORMAT=yyyymmdd  

########################################

 

 

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/usr/java7_64/bin:/sbin:.

 

export PATH

 

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal

then echo "$MAILMSG"        # operation, the Shell checks

fi                          # periodically.

 

set -o vi

 

export HOST=`hostname`

PS1='[$HOST:$PWD]'

export PS1

export NLS_DATE_FORMAT=yyyymmdd

 

# New environment setting added by JEUS 7 on Thu Sep 27 13:56:10 KST 2018 1.

# The unmodified version of this file is saved in /home/jeus/.profile1406862707.

# Do NOT modify these lines; they are used to uninstall.

PATH="/app/jeus/bin:/app/jeus/lib/system:/app/jeus/webserver/bin:${PATH}"

export PATH

 

###############################################

#   JEUS ENV                          @TmaxSoft

###############################################

########## JEUS_HOME Set ##############

export JEUS_HOME=/app/jeus

export JEUS_LOG_HOME=/app/jeus/logs

 

########## DomainAdminServer Set  ##############

export DOMAIN_NAME="jeus_domain"

export DAS_HOSTNAME="mwwas1"

export DAS_PORT="10000"

export DAS_URL=${DAS_HOSTNAME}:${DAS_PORT}

export ENCODE_FILE=${JEUS_HOME}/bin/jeusEncode

 

########## JEUS Config Alias #################

alias jcfg='cd ${JEUS_HOME}/domains/${DOMAIN_NAME}/config'

alias jbin='cd ${JEUS_HOME}/bin'

alias jlog='cd ${JEUS_LOG_HOME}'

###########################################^

 

########## In case of IBM

export IBM_HEAPDUMP=true

export IBM_HEAP_DUMP=true

export IBM_HEAPDUMP_OUTOFMEMORY=true

export IBM_JAVADUMP_OUTOFMEMORY=true

export IBM_HEAPDUMPDIR=$JEUS_LOG_HOME/dump

export IBM_JAVACOREDIR=$JEUS_LOG_HOME/dump

# End comments by InstallAnywhere on Thu Sep 27 13:56:10 KST 2018 1.