ORACLE相關內容

 1） em,dbca,netca,netmgr出現亂碼方案：

$cd $ORACLE_HOME/JRE/lib
$mv font.properties font.properties.bak
$mv font.properties.zh font.properties

 

Ⅰ）em,dbca,netca,netmgr詳細說明：

 

  em使用說明：

　emctl start dbconsole
  emctl stop dbconsole

 

    

EM如果未安裝，可以通過重新設定，來建立EM的設定檔

 

①首先檢查是否已經安裝

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

 

②建立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

 

③配置完成之後就可以啟動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環境，你可能還需要在iptables中開放1158連接埠，增加如下一行: -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1158 -j ACCEPT  

 

④重新啟動防火牆之後就可以通過IE在遠端串連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 ]