【My Ora Life】dbconsole & 更新 &解除安裝

利用 emctl status dbconsole 指令：

[[email protected] bin]$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0

Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

https://***:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

------------------------------------------------------------------

Logs are generated in directory /scratch/aime/prod_install/app/product/11.1.0/db_1/slc00bkw.us.oracle.com_orcl/sysman/log

故位址為: https://***:1158/em/   注意是https!!! 不是http!

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

1、樓主輸入的登入位址是什麼？一般要輸入http://ip位址:1158/em

2、em服務是否啟動，通過emctl status dbconsole查一下，如沒啟動執行emctl start dbconsole，然後注意觀察em啟動時的端口号，一般預設端口為1158

3、确認em是否正确安裝

4、試着執行emca -repos create重建em資料庫，重建時要指定oracle sid、端口号、sys使用者名和密碼

 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

更新：

相關幫助文檔： https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocID=800550.1&bmDocDsrc=KB&from=BOOKMARK&viewingMode=1143&bmDocTitle=11.1.0.7%20Patch%20Set%20-%20Linux%20x86%2064bit%20README&bmDocType=README))

利用database upgrade assistant：

Upgrade database using dbua

注意設定環境變量：setenv ORACLE_HOME /scratch/aime/prod_install/app/product/11.1.0/db_1

沒有"/" 不是setenv ORACLE_HOME /scratch/aime/prod_install/app/product/11.1.0/db_1/

否則會彈出消息：

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

使用DBCA建立資料庫時走到第四步時：

提示："You need to run Netca to configure a listener before you can proceed.Otherwise you may choose to continue without Database Control configuration"

解決辦法：

If you need a port to connect to Oracle, then you certainly need to configure a LISTENER, which is not done by the install. To do this, you should run "netca" ("Net configuration assistant"), located at $ORACLE_HOME/bin/netca in UNIX (it should be something like this in Windows, and you must have a shortcut in your "Start" menu). Choose " Configure a listener" (or something like this), then "Add a listener" ... go on ... and it will ask for the port on which the listener is gonna listen (1521 by default). Once the listener is configured, quit netca, and retry your connection from Enterprise Manager. Now it should work. If the Oracle server is on another machine, you should also configure your "tnsnames.ora" file, which can be done either "by hand" or with "Net Manager" ($ORACLE_HOME/bin/netmgr, "Local->service name resolution" menu or something like this).

I hope that will help.

備注：其實不一定建立，如果原來有listener的話，重新配置一下即可（也不需要更改什麼東西） +++++++++++++++++++++++++++++++++++++++ 解除安裝：