oracle進階筆記-基礎準備-常用工具的使用-EM

標籤：display   blank   oracle   常用工具   

圖形管理工具 em

伺服器端

1 保證偵聽啟動----->grid

lsnrctl status

650) this.width=650;" title="clip_image002" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image002" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370020mxlZ.jpg" "244" height="187" />

或者

netstat -tunlp |grep 1521

650) this.width=650;" title="clip_image004" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image004" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370020oQfK.jpg" "244" height="38" />

如果沒有起來

lsnrctl start

2 保證資料庫啟動---->oracle

sqlplus / as sysdba

650) this.width=650;" title="clip_image006" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image006" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370023RRf6.jpg" "244" height="127" />

如果沒有啟動

shutdown abort ;

startup ;

3 保證em這個工具啟用--->oracle

[[email protected] ~]$ emctl status dbconsole

650) this.width=650;" title="clip_image008" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image008" src="http://img1.51cto.com/attachment/201407/26/9202005_14063700271enW.jpg" "244" height="90" />

預設連接埠1158

或者通過連接埠看

[[email protected] ~]$ netstat -tunlp |grep 1158

650) this.width=650;" title="clip_image010" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image010" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370027URgn.jpg" "244" height="33" />

如果沒有啟動

emctl stop dbconsole

emctl start dbconsole

用戶端就可以通過瀏覽器訪問(建議用google瀏覽器）

https://資料庫伺服器名或者ip:1158/em

https://192.168.2.1:1158/em

650) this.width=650;" title="clip_image012" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image012" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370028vcAw.jpg" "244" height="103" />

點仍然繼續

650) this.width=650;" title="clip_image014" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image014" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370031GXK8.jpg" "244" height="112" />

我們需要英文

點設定->點進階設定->點語言和輸入設定->點添加->到最後點英文-English->點住上移到最上面

650) this.width=650;" title="clip_image015" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image015" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370031mWdN.png" "244" height="140" />

點擊完成

然後重新整理頁面

650) this.width=650;" title="clip_image017" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image017" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370033GuV4.jpg" "244" height="120" />

誰可以登入： 只有sys system使用者

* User Name sys

* Password oracle

Connect As sysdba

查看那些人可以登入em

650) this.width=650;" title="clip_image019" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image019" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370034lpIi.jpg" "244" height="87" />

要求：用em建立一個賬戶web_admin 給予dba的許可權 可以通過em管理資料庫

sys登入em

650) this.width=650;" title="clip_image020" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image020" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370035DHnI.png" "244" height="85" />

Server--->Security-->Users

650) this.width=650;" title="clip_image022" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image022" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370037Kgrm.jpg" "244" height="150" />

點建立

650) this.width=650;" title="clip_image024" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image024" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370038aV46.jpg" "244" height="89" />

賬戶名web_admin

密碼 oracle

650) this.width=650;" title="clip_image026" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image026" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370039JPlb.jpg" "244" height="129" />

Roles---->editlist --->dba角色

650) this.width=650;" title="clip_image028" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image028" src="http://img1.51cto.com/attachment/201407/26/9202005_14063700438UCZ.jpg" "244" height="70" />

650) this.width=650;" title="clip_image030" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image030" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370045faQA.jpg" "244" height="131" />

System Privileges---》editlist

650) this.width=650;" title="clip_image032" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image032" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370046m68K.jpg" "244" height="83" />

sysdba角色--->ok

650) this.width=650;" title="clip_image034" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image034" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370048ewfw.jpg" "244" height="103" />

你可以點擊show sql 看到你剛才點擊相對應的SQL語句

650) this.width=650;" title="clip_image035" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image035" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370049Gl9m.png" "244" height="77" />

最後點ok

把該賬戶加入到em的管理員

右上方----》setup --->administrators --->create

650) this.width=650;" title="clip_image037" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image037" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370051MN0U.jpg" "244" height="119" />

650) this.width=650;" title="clip_image039" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image039" src="http://img1.51cto.com/attachment/201407/26/9202005_14063700536wlP.jpg" "244" height="124" />

650) this.width=650;" title="clip_image041" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image041" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370056aAVm.jpg" "244" height="85" />

Name 勾選web_admin

650) this.width=650;" title="clip_image043" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image043" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370057Y6vW.jpg" "244" height="101" />

650) this.width=650;" title="clip_image045" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image045" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370059pI5Y.jpg" "244" height="149" />

許可權： super administrator

650) this.width=650;" title="clip_image047" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image047" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370060QARI.jpg" "244" height="83" />

finish 結束

650) this.width=650;" title="clip_image049" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image049" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370062HQ1c.jpg" "244" height="67" />

650) this.width=650;" title="clip_image051" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image051" src="http://img1.51cto.com/attachment/201407/26/9202005_140637006372du.jpg" "244" height="111" />

要求：用web_admin登入，建立一個表xs (id number ,name char(10))

logout ---->login --

650) this.width=650;" title="clip_image053" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image053" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370065aQJt.jpg" "244" height="100" />

650) this.width=650;" title="clip_image055" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image055" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370066IbBv.jpg" "244" height="90" />

>輸入使用者名稱web_admin 密碼 oracle

650) this.width=650;" title="clip_image057" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image057" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370067h88B.jpg" "244" height="66" />

Schema--->tables --->create

650) this.width=650;" title="clip_image059" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image059" src="http://img1.51cto.com/attachment/201407/26/9202005_14063700711QeY.jpg" "244" height="121" />

650) this.width=650;" title="clip_image061" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image061" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370071QBeN.jpg" "244" height="99" />

輸入表名

輸入列名 選擇資料類型

650) this.width=650;" title="clip_image063" style="border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline" border="0" alt="clip_image063" src="http://img1.51cto.com/attachment/201407/26/9202005_1406370074Lp6l.jpg" "244" height="155" />

點show sql

ok

oracle進階筆記-基礎準備-常用工具的使用-EM