Oracle Advanced Notes-BASIC preparation-use of common tools-em

Graphical Management tools EM

Server-side

1 Guaranteed Listening Startup----->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 "/>

Or

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="/>

If not up

Lsnrctl start

2 ensure database startup---->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 "/>

If not started

Shutdown abort;

startup;

3 Guaranteed EM This tool enabled--->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="/>

Default Port 1158

Or look through the port.

[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="/>

If not started

Emctl Stop Dbconsole

Emctl Start Dbconsole

Client can be accessed via browser (Google Chrome is recommended)

https://database server name or 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 "/>

Point still continues

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= "/>"

We need English.

Point settings, point Advanced Settings, point language and input settings, dot add to last point English-english-> point stay up to top

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=" "/>

Click Finish

Then refresh the page

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="/>

Who can log in: only sys system user

* User Name SYS

* Password Oracle

Connect as Sysdba

View those people can sign in 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="/>

Requirements: Set up an account with EM web_admin give DBA permission to manage the database through the EM

SYS login 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=" "/>

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="/>

Point creation

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= "/>"

Account name Web_admin

Password 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 role

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="/>

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="/>

SYSDBA Role--->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 "/>

You can click Show SQL to see the corresponding SQL statement you just clicked

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="/>

Last Click OK

Add the account to the administrator of EM

upper right corner----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=" "/>

Name Tick 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 "/>

Privilege: 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="/>

End of 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="/>

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 "/>

Requirements: Log in with Web_admin, create a table 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="/>

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="/>

> Enter user name web_admin password 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="/>

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="/>

Enter table name

Enter column name Select data type

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 "/>

Point Show SQL

Ok

Oracle Advanced Notes-BASIC preparation-use of common tools-em