faq:ora-06550;pls-00553: The solution of the problem

Solve | The problem
Because once the data was accidentally shut down, resulting in the database crash, after the various methods to eventually recovery the DB, but found that the original apache,php,oracle established Web server is not running, Always prompt Ora-06550;pls-00553:character set name is not recognized on the page. I had a hard time wasting more than 3 days to fix the problem. When you first found out about this problem, it was the error that was raised after the parameter set changes. Because the search is not a problem, has been very depressed, spent a long time to reinstall PHP and Apache server. It's still not working. Finally, see Set Nls_lang American_america on the network. Us7ascii can succeed.

Finally I tried it, it worked, I always thought that is Nls_lang american_america.we8iso8859p1. Only now understand. Let's try the procedure I'm working on.

[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]#