废话下：好久没来这写文章了，一是没时间，二是部分文章写在其他地方了
，三是还没找到理想的平台，所以犹豫着呢
，真希望有个自己的网站呢，最后就是还没有养成写文章的习惯，毕竟写篇文章还是挺费力的，就像解决问题一样，有时候顺利，有时候却一发不可收拾，上次写一文章，在测试并截图时突发新的问题，因此花了近一天的时间。当然不可否认，写文章是对知识的整理、提炼以及审核，从中可以进一步巩固和学习。废话完毕！
鉴于Oracle数据库是如此庞大，而我的本本是如此的瘦小，可是却又必须装个Oracle玩玩，不然对Oracle的了解将停滞不前呢。几经周折，在Oracle官网上发现了XE版，官方中文称其为快捷版即express edition。不过用起来确实很快捷。
下载页面：http://www.oracle.com/technetwork/cn/products/express-edition/downloads/index.html
安装包只有300M多，还是蛮理想的。而安装步骤也很简洁（就不截图了），中途只需选择安装路径及输入数据库登录的密码即可。不过安装完后将占有1.5G多的空间，这个给人感觉还是挺大的。
安装完后即可配置plsql进行连接了，配置SID为XE即可，登录名为system或sys，密码即安装时输入的那个。
由于本人会折腾，所以把XE装在了虚拟机中，结果plsql怎么连都报错，后来发现虚拟机中的系统开了防火墙，阻挡了连接
，当然关了防火墙就不安全了，因此我就添加了个规则，让1521端口的通信给放行就ok了。
最后终于连接上了，plsql却弹出了编码不一致的警告：
database character set(AL32UTF8) and Client character set(ZHS16GBK) are different ......
编码不一致问题（俺不是数据库专业的，对此不了解额），百度了下原来由于XE的安装太简洁了，因此导致编码设置也略去了，所以需要手动来调整了。以下命令即我在网上找到的命令，可修改编码使plsql在登录时不会有警告了。这里需要在安装XE的系统上执行开始菜单中oracle目录中的“运行sql命令行”，即sqlplus程序。
SQL*Plus: Release 11.2.0.2.0 Production on 星期日...
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys as sysdba
输入口令:
已连接。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 167387136 bytes
Fixed Size 1382288 bytes
Variable Size 146802800 bytes
Database Buffers 16777216 bytes
Redo Buffers 2424832 bytes
数据库装载完毕。
SQL> alter system enable restricted session;
系统已更改。
SQL> alter system set JOB_QUEUE_PROCESSES=0;
系统已更改。
SQL> alter system set AQ_TM_PROCESSES=0;
系统已更改。
SQL> alter database open;
数据库已更改。
SQL> alter database character set internal_use ZHS16GBK;
数据库已更改。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup;
ORACLE 例程已经启动。
Total System Global Area 167387136 bytes
Fixed Size 1382288 bytes
Variable Size 146802800 bytes
Database Buffers 16777216 bytes
Redo Buffers 2424832 bytes
数据库装载完毕。
数据库已经打开。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
SQL>
至此已解决编码问题，虽然不知所以，有兴趣的可以自己摸索下，记得告诉我为什么呢！
参考文章：
http://publish.it168.com/2005/1109/20051109065101.shtml
http://www.oschina.net/question/12_27650
http://wtdyb.blog.163.com/blog/static/1803533022011424105524321/
http://blog.163.com/magicc_love/blog/static/18585366220123111128283/
http://dbanotes.net/database/oracle_10g_xe_nls_lang.html
http://dbanotes.net/database/oracle_xe_hwo_to_create_a_database.html
2021年5月11日 16:50
What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. 123 movies
2022年9月29日 20:51
Kendriya Vidyalaya Sangathan has provided the practice question paper for Preschool Kindergarten education subject-wise practice question paper with model sample paper for all LKG/PP1/KG1 students through KVS Teaching staff at all region schools across the Country. KVS KG1 Question Paper Kendriya Vidyalaya Sangathan has provided the practice question paper for Preschool Kindergarten education subject-wise practice question paper with model sample paper for all LKG/PP1/KG1 students through KVS Teaching staff at all region schools across the Country.
2024年9月26日 20:17
You developed something that individuals could understand along with making the subject outstanding for every person. As a matter of fact, First of all let me tell you, you have got a great blog .I am interested in looking for more of such topics and would like to have further information
2024年9月26日 20:30
When I read your article on this topic, the first thought seems profound and difficult. There is also a bulletin board for discussion of articles and photos similar to this topic on my site, but I would like to visit once when I have time to discuss this topic
2024年9月26日 20:32
Decent data, profitable and phenomenal outline, as offer well done with smart thoughts and ideas, bunches of extraordinary data and motivation, both of which I require, on account of offer such an accommodating data her
2024年9月26日 20:35
Our the purpose is to share the reviews about the latest Jackets,Coats and Vests also share the related Movies,Gaming, Casual,Faux Leather and Leather materials available
2024年9月26日 20:36
Thanks for all the tips mentioned in this article! it’s always good to read things you have heard before and are implementing, but from a different perspective, always pick up some extra bits of information.
2024年9月26日 20:38
There have been online casinos around for a long time, with each of them offering various versions of roulette, blackjack, baccarat, and poker with random number generators. With the evolution of new technologies, casinos now have the ability to offer games with real dealers in a live casino environment. This new ability has all of us looking at online casinos and wondering if the new live dealer casinos are fads or the future of online casinos
2024年9月26日 20:40
Youre so right. Im there with you. Your weblog is definitely worth a read if anyone comes throughout it. Im lucky I did because now Ive received a whole new view of this.
2024年9月26日 20:42
Excellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thank you for lunch.
2024年9月26日 20:43
it's really nice and meanful. it's really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information I bookmark this site and will track down your posts often from now on. Much obliged once more
2024年9月26日 21:22
Excellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thank you for lunch.
2024年9月26日 21:50
It has fully emerged to crown Singapore's southern shores and undoubtedly placed her on the global map of residential landmarks. I still scored the more points than I ever have in a season for GS. I think you would be hard pressed to find somebody with the same consistency
2024年9月26日 21:52
While looking for articles on these topics, I came across this article on the site here. As I read your article, I felt like an expert in this field. I have several articles on these topics posted on my site
2024年9月26日 21:53
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Feel free to visit my website
2024年9月26日 21:54
really like this post,and i parent that they having a ton of a laugh to peruse this post,they might take a respectable website to make an information,thanks for sharing it to me. First-rate job for publishing this type of useful internet website online. Your internet log isn’t only useful but it's miles moreover clearly creative too "`i like viewing net web sites which recognise the price of handing over the incredible beneficial useful resource freed from rate. I honestly cherished studying your posting. Thanks!
2024年9月26日 21:54
Your article is very interesting. I think this article has a lot of information needed, looking forward to your new posts. Get permission to share .I bookmark this site and will track down your posts often from now on. Much obliged once more
2024年9月26日 21:55
I was very pleased to find this page. I wanted to thank you for your time due to this wonderful read!! I definitely loved every part of it and I have you bookmarked to check out new information on your blog. Feel free to visit my website;
2024年9月26日 22:22
to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thank..great article. thank you for sharin..Great post. Thank You For Sharing Valuable. information. It is Very Informative article..I urge you to peruse this content it is fun portrayed .
2024年9月26日 22:23
really like this post,and i parent that they having a ton of a laugh to peruse this post,they might take a respectable website to make an information,thanks for sharing it to me. First-rate job for publishing this type of useful internet website online. Your internet log isn’t only useful but it's miles moreover clearly creative too "`i like viewing net web sites which recognise the price of handing over the incredible beneficial useful resource freed from rate. I honestly cherished studying your posting. Thanks!
2024年9月26日 22:24
your mental health is often the most efficient. Because no two weight-loss journeys are alike, we asked a bunch of women who’ve accomplished a major weight loss exactly how they did it
2024年9月26日 22:25
This surely helps me in my work. Lol, thanks for your comment! wink Glad you found it helpful..f you want to be successful in weight loss, you have to focus on more than just how you look. An approach that taps into how you feel, your overall health
2024年9月26日 22:26
Decent data, profitable and phenomenal outline, as offer well done with smart thoughts and ideas, bunches of extraordinary data and motivation, both of which I require, on account of offer such an accommodating data her
2024年9月26日 22:27
There have been online casinos around for a long time, with each of them offering various versions of roulette, blackjack, baccarat, and poker with random number generators. With the evolution of new technologies, casinos now have the ability to offer games with real dealers in a live casino environment. This new ability has all of us looking at online casinos and wondering if the new live dealer casinos are fads or the future of online casinos
2024年9月26日 22:28
’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website I bookmark this site and will track down your posts often from now on. Much obliged once more