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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.