FAQ：ora-06550;pls-00553: 問題的解決
2024-07-21 02:41:07
供稿：網友
因為有一次數據不小心關機，導致數據庫crash之后，想盡各種方法最終recovery database 之后，可是發現原來的apache，php，Oracle建立的web server 卻無法運行，在頁面上總是提示ora-06550;pls-00553: character set name is not recognized 。 害的我費勁周折，浪費了3天多的時間才搞定這個問題。剛開始發現這個問題的時候就覺得是什么參數設置變動之后引發的錯誤。因為找不問題，一直非常郁悶，花了好久重新安裝php和apache server。還是不行。最后在網絡上看到set NLS_LANG AMERICAN_AMERICA.US7ASCII可以成功。
最后自己試了一下，果然奏效，我原來一直以為就是NLS_LANG American_America.WE8ISO8859P1。現在才明白。下面試我操作的過程
[oracle@ccdevsvr php-4.3.6]$ su root
PassWord:
[root@ccdevsvr php-4.3.6]# set NLS_LANG AMERICAN_AMERICA.US7ASCII
[root@ccdevsvr php-4.3.6]# set
BASH=/bin/bash
BASH_ENV=/root/.bashrc
BASH_VERSINFO=([0]="2" [1]="05b" [2]="0" [3]="1" [4]="release" [5]="i686-pc-linux-gnu")
BASH_VERSION='2.05b.0(1)-release'
COLORS=/etc/DIR_COLORS
COLUMNS=132
CVSROOT=/opt/class/jackey/cvsroot
DIRSTACK=()
EUID=0
GROUPS=()
G_BROKEN_FILENAMES=1
HISTFILE=/root/.bash_history
HISTFILESIZE=1000
HISTSIZE=1000
HOME=/root
HOSTNAME=ccdevsvr
HOSTTYPE=i686
IFS=$' /t/n'
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=:/u01/PRodUCt/8.1.7/lib
LESSOPEN='/usr/bin/lesspipe.sh %s'
LINES=49
LOGNAME=oracle
LS_COLORS='no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.BTm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.XPm=01;35:*.png=01;35:*.tif=01;35:'
MACHTYPE=i686-pc-linux-gnu
MAIL=/var/spool/mail/root
MAILCHECK=60
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
OPTERR=1
OPTIND=1
ORACLE_BASE=/u01
ORACLE_HOME=/u01/product/8.1.7
ORACLE_SID=EMCDB
ORA_NLS=/u01/product/8.1.7/ocommon/nls/admin/data
ORA_NLS33=/u01/product/8.1.7/ocommon/nls/admin/data
OSTYPE=linux-gnu
PATH=/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin
PIPESTATUS=([0]="0")
PPID=17922
PS1='
[/u@/h /W]/$ '
PS2='> '
PS4='+ '
PWD=/u01/php-4.3.6
QTDIR=/usr/lib/qt3-gcc3.2
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:monitor
SHLVL=4
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SUPPORTED=en_US.UTF-8:en_US:en
TERM=vt100
UID=0
USER=oracle
USERNAME=root
_=AMERICAN_AMERICA.US7ASCII
i=/etc/profile.d/which-2.sh
langfile=/root/.i18n
[root@ccdevsvr php-4.3.6]# set NLS_LANG=AMERICAN_AMERICA.US7ASCII
[root@ccdevsvr php-4.3.6]# set
BASH=/bin/bash
BASH_ENV=/root/.bashrc
BASH_VERSINFO=([0]="2" [1]="05b" [2]="0" [3]="1" [4]="release" [5]="i686-pc-linux-gnu")
BASH_VERSION='2.05b.0(1)-release'
COLORS=/etc/DIR_COLORS
COLUMNS=132
CVSROOT=/opt/class/jackey/cvsroot
DIRSTACK=()
EUID=0
GROUPS=()
G_BROKEN_FILENAMES=1
HISTFILE=/root/.bash_history
HISTFILESIZE=1000
HISTSIZE=1000
HOME=/root
HOSTNAME=ccdevsvr
HOSTTYPE=i686
IFS=$' /t/n'
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=:/u01/product/8.1.7/lib
LESSOPEN='/usr/bin/lesspipe.sh %s'
LINES=49
LOGNAME=oracle
LS_COLORS='no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:'
MACHTYPE=i686-pc-linux-gnu
MAIL=/var/spool/mail/root
MAILCHECK=60
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
OPTERR=1
OPTIND=1
ORACLE_BASE=/u01
ORACLE_HOME=/u01/product/8.1.7
ORACLE_SID=EMCDB
ORA_NLS=/u01/product/8.1.7/ocommon/nls/admin/data
ORA_NLS33=/u01/product/8.1.7/ocommon/nls/admin/data
OSTYPE=linux-gnu
PATH=/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/u01/product/8.1.7/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin
PIPESTATUS=([0]="0")
PPID=17922
PS1='[/u@/h /W]/$ '
PS2='> '
PS4='+ '
PWD=/u01/php-4.3.6
QTDIR=/usr/lib/qt3-gcc3.2
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:monitor
SHLVL=4
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SUPPORTED=en_US.UTF-8:en_US:en
TERM=vt100
UID=0
USER=oracle
USERNAME=root
_=NLS_LANG=AMERICAN_AMERICA.US7ASCII
i=/etc/profile.d/which-2.sh
langfile=/root/.i18n
[root@ccdevsvr php-4.3.6]#
