由于是別的人文章，在此就記下個LINK吧 http://blog.csdn.net/ferry_passion/article/details/7607489

快過年了，但在2011年還有不到2個月的時候，發(fā)篇隨筆吧~
今年的計劃到目前看，都基本實(shí)現(xiàn)了。但是，我知道，挑戰(zhàn)和未來的規(guī)劃也已經(jīng)開始。
以后一段日子本人將專注分布式應(yīng)用的學(xué)習(xí)和研究，希望能與大家分享一下心得體會吧。本論壇的高手很多，也希望能得到你們的指導(dǎo)。

     摘要: ORA-01461: can bind a LONG value only for insert into a LONG column(點(diǎn)睛)  閱讀全文

     摘要: set_context與set_identifier  閱讀全文

     摘要: Ibatis中#和$兩個符號的使用區(qū)別  閱讀全文

     摘要: java這樣也能寫，我還真沒用過。學(xué)習(xí)學(xué)習(xí)  閱讀全文

     摘要: 在很多大型應(yīng)用中都會對數(shù)據(jù)進(jìn)行切分，并且采用多個數(shù)據(jù)庫實(shí)例進(jìn)行管理，這樣可以有效提高系統(tǒng)的水平伸縮性。而這樣的方案就會不同于常見的單一數(shù)據(jù)實(shí)例的方案，這就要程序在運(yùn)行時根據(jù)當(dāng)時的請求及系統(tǒng)狀態(tài)來動態(tài)的決定將數(shù)據(jù)存儲在哪個數(shù)據(jù)庫實(shí)例中，以及從哪個數(shù)據(jù)庫提取數(shù)據(jù)。  閱讀全文

     摘要: 很多人在進(jìn)行數(shù)據(jù)遷移時，希望把數(shù)據(jù)導(dǎo)入不同于原系統(tǒng)的表空間，在導(dǎo)入之后卻往往發(fā)現(xiàn)，數(shù)據(jù)被導(dǎo)入了原表空間。
本例舉例說明解決這個問題:  閱讀全文

     摘要: 很多人在進(jìn)行數(shù)據(jù)遷移時，希望把數(shù)據(jù)導(dǎo)入不同于原系統(tǒng)的表空間，在導(dǎo)入之后卻往往發(fā)現(xiàn)，數(shù)據(jù)被導(dǎo)入了原表空間。
本例舉例說明解決這個問題:  閱讀全文

     摘要: 根據(jù)項(xiàng)目需要，最近在做一個關(guān)于owc透視表的功能（PivotTable），這個東西啊讓我可是郁悶了將近10天，網(wǎng)上很多資源都是直接連接數(shù)據(jù)源的方式，但對于實(shí)現(xiàn)系統(tǒng)開發(fā)來說，不實(shí)用，因?yàn)閎/s系統(tǒng)多數(shù)是分層架構(gòu)，并且部署實(shí)施時，很難由客戶端直接向數(shù)據(jù)庫服務(wù)器發(fā)出請求。原因就不多說了。
  閱讀全文

     摘要: Struts2上傳文件  閱讀全文

     摘要: 注意：在jdk1.4下運(yùn)行時，不要多加jar包。struts2-core,xwork這兩個轉(zhuǎn)換成jdk1.4下的版本后，別的不會再轉(zhuǎn)了。如果使用別的包時，轉(zhuǎn)一個加一個試試，struts2在加入jar包時，可能有問題，使用時小心。  閱讀全文

     摘要: 在jsp中操作FCKeditor  閱讀全文

     摘要: row_number() /rank()/dense_rank()學(xué)習(xí)之二  閱讀全文

     摘要: ORACLE分析函數(shù)學(xué)習(xí)  閱讀全文

     摘要: Selecting the first n rows with Oracle  閱讀全文

     摘要: document.selection.createRange方法  閱讀全文

     摘要: 處理中文問題  閱讀全文

     摘要: 向原作者學(xué)習(xí)一下，從感性上  閱讀全文

     摘要: 在以前的一篇文中介紹到，當(dāng)用parameterMap作為ibatis映射輸入?yún)?shù)時，要在ibatis的配置文件中
作相應(yīng)的聲明。但我們也可以不在ibatis映射文件中作聲明，應(yīng)用方法如下：   閱讀全文

     摘要: 關(guān)于自動完成的別人的例子，學(xué)習(xí)一下。  閱讀全文

     摘要: 今天遇到要用replaceAll()，看到很多人對其也有困惑．我在此記錄下來  閱讀全文

今天打算啟用一下Oracle Database 11g的Database Control，發(fā)現(xiàn)初始并未安裝:

[oracle@test126 ~]$ emctl start
EM Configuration issue. /opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd not found.

 

遇到這類問題，可以通過重新配置，來創(chuàng)建EM的配置文件：

[oracle@test126 11.1.0]$ emca -config dbcontrol db -repos recreate

 

STARTED EMCA at Aug 28, 2007 11:54:40 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: dodd
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional): eygle@eygle.com
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/oracle/product/11.1.0

Local hostname ................ test126.hurray.com.cn
Listener port number ................ 1521
Database SID ................ dodd
Email address for notifications ............... eygle@eygle.com
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 28, 2007 11:56:58 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/dodd/emca_2007_08_28_11_54_40.log.
Aug 28, 2007 11:57:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 28, 2007 11:57:16 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 28, 2007 11:57:16 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...

Aug 28, 2007 12:08:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 28, 2007 12:08:47 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 28, 2007 12:11:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 28, 2007 12:11:51 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 28, 2007 12:11:51 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 28, 2007 12:12:13 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 28, 2007 12:12:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 28, 2007 12:12:39 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 28, 2007 12:12:39 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 28, 2007 12:14:04 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 28, 2007 12:14:04 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://test126.hurray.com.cn:1158/em <<<<<<<<<<<
Aug 28, 2007 12:14:16 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 28, 2007 12:14:16 PM

 

Oracle 10g中，配置方法與此相同。
配置完成之后就可以啟動EM了：

[oracle@test126 11.1.0]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://test126.hurray.com.cn:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ........ started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd/sysman/log

 

如果是Linux環(huán)境，你可能還需要在iptables中開放1158端口，增加如下一行:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1158 -j ACCEPT

重新啟動防火墻之后就可以通過IE在遠(yuǎn)端連接EM的Database Control了：

[root@test126 sysconfig]# service iptables restart
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
Applying iptables firewall rules: [ OK ]
Loading additional iptables modules: ip_conntrack_netbios_ns [ OK ]

 

-The End-