Oracle Database management Tools EM

Simple use of EM

How to create a user, create a table:

Tools: EM Enterprise Management dbconsole graphical management interface

Server configuration.

To use the graphical interface first ensure that the server configuration is OK: start in sequence

1. Data startup

2. Guaranteed Listening Start

3. Guarantee em This tool starts

1. Data Startup

This is because you want to start the database. So, to use Oracle users

Su–oracle

if it is multi-instance : to specify the strength to enter , export ORACLE_SID=ORCL and then enter . then startup starts

Sqlplus/as SYSDBA

Select status from V$instance; take a look at this command .

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A5/wKioL1ShHGCSVIMCAABfcIBCaSw222.jpg "title=" 1.png " alt= "Wkiol1shhgcsvimcaabfcibcasw222.jpg"/>

good. the OPEN is displayed to indicate that it has been started.

What if it doesn't start? Start with the command startup .

2. data interception. The database ORCL service registers to listen.

because this is the general direction of the operation to listen to the entire database, so use a grid user to operate.

Su Grid

Isnrctl status

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShHPTC08iPAANRWIw1YBg290.jpg "title=" 1.png " alt= "Wkiol1shhptc08ipaanrwiw1ybg290.jpg"/>

if it does not start or. The above does not show the port 1521 or does not see the ORCL service. You need to listen again

Lsnrctl Stop stops listening

Lsnrctl Start Listening

3.em Tool Start

this is because it belongs to the database operation and is executed with the Oracle user.

Su–orcle

Emctl Status Dbconsole

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A7/wKiom1ShHPKR8RCPAAF8nWi53Go657.jpg "title=" 2.png " alt= "Wkiom1shhpkr8rcpaaf8nwi53go657.jpg"/>

the interface above appears. Note that the EM tool does not start.

or use netstat–tunlp |grep1158

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShHbTy6ooCAADT_STuRQc724.jpg "title=" 3.png " Width= "height=" border= "0" hspace= "0" vspace= "0" style= "width:700px;height:74px;" alt= "Wkiol1shhbty6oocaadt_ Sturqc724.jpg "/>

This reality is successful.

What if it doesn't start?

Emctl Stop dbconsole close EM tool

Emctl start dbconsole EM tool

Let's open it.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShHjOQaEPOAAF2302MMZ4429.jpg "title=" 4.png " Width= "height=" 139 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:700PX;HEIGHT:139PX; "alt=" Wkiol1shhjoqaepoaaf2302mmz4429.jpg "/>

See.. Started successfully.

Take a look again:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A7/wKiom1ShHZfyYTsBAAFnvDrPU50056.jpg "title=" 5.png " Width= "height=" border= "0" hspace= "0" vspace= "0" style= "width:700px;height:150px;" alt= " Wkiom1shhzfyytsbaafnvdrpu50056.jpg "/>

All right. The service configuration is complete. Here's a look at the client configuration

First, the network should be able to communicate with each other.

have Google Browser

Host Name: parsing

Open Web site input :: https://192.168.11.1:1158/em Login

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A7/wKiom1ShHaawwwFbAAK7lQ7UvHw033.jpg "title=" 6.png " Width= "height=" 443 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:443px; "alt=" Wkiom1shhaawwwfbaak7lq7uvhw033.jpg "/>

Prompt Input: by default, only the SYS system can log in em

Sys

Oracle Password

SYSDBA Select SYSDBA Manage Users

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShHxvzsITmAAC-Nyb1YBY877.jpg "title=" 2.png " alt= "Wkiol1shhxvzsitmaac-nyb1yby877.jpg"/>

After entry is the following interface:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A7/wKiom1ShHnWiPe_qAAWkd9LRnnU347.jpg "title=" 3.png " Width= "height=" 335 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:335px; "alt=" Wkiom1shhnwipe_ Qaawkd9lrnnu347.jpg "/>

Let's give an example to do this:

Example:

requirements: Establish a Admin account, allow login EM implement administrative permissions. Then use this user login EM to Create a table for the Scott user Scott.xs(ID Name )

Steps:

click:Server------Users————>create-----à Enter account and password

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShH02Qov3sAALXgOJ7Deg584.jpg "style=" width : 700px;height:256px; "title=" 4.png "width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1shh02qov3saalxgoj7deg584.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A5/wKioL1ShH02BCJgEAANZFjUWs1E994.jpg "title=" 5.png " Width= "height=" border= "0" hspace= "0" vspace= "0" style= "width:700px;height:200px;" alt= " Wkiol1shh02bcjgeaanzfjuws1e994.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A7/wKiom1ShHpriXrDvAAFhxdrMXR8749.jpg "style=" float: none; "title=" 6.png "alt=" Wkiom1shhprixrdvaafhxdrmxr8749.jpg "/>

Roles————> Select dba role . give it a role that belongs to the DBA

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A7/wKiom1ShH1DxrodIAAGIdGPKBUA097.jpg "title=" 7.png " Width= "height=" border= "0" hspace= "0" vspace= "0" style= "width:700px;height:100px;" alt= " Wkiom1shh1dxrodiaagidgpkbua097.jpg "/>

after clicking Edit List

The following interface appears

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A5/wKioL1ShIB7Rrb0EAAH6GFQEOFA970.jpg "title=" 8.png " Width= "height=" 169 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:700PX;HEIGHT:169PX; "alt=" Wkiol1shib7rrb0eaah6gfqeofa970.jpg "/>

then click OK on the right

Give it to the character and give him permission.

System privileges——————>sysdba SYSDBA rights = = Systems Permissions

then click on the upper left corner with a show SQL button to click OK

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShIDHTIONPAAIeBowqYwk877.jpg "title=" 9.png " Width= "height=" 192 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:192px; "alt=" Wkiol1shidhtionpaaiebowqywk877.jpg "/>

Click Show SQL in the top right corner to see it. How to execute with the command, then click OK on the right end.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A7/wKiom1ShH5azgPbGAADkAUHJ_UU013.jpg "title=" 11.png "Width=" "height=" 144 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:144px; "alt=" Wkiom1shh5azgpbgaadkauhj_uu013.jpg "/>

Allow login EM.. Then

the upper right corner of EM has a setup———— "administartors————>review(Review

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShIFWB19UJAARjUJEJWgI923.jpg "title=" 12.png "Width=" "height=" 213 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:213px; "alt=" Wkiol1shifwb19ujaarjujejwgi923.jpg "/>

After entering

Select Admin account

Give him super admin privileges

go inside and click on the type of user name which the same flashlight used to find the user. Click and then pattern out to the left of a box. Find admin and click the bottom Select

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShIpuTNN-kAAPDkvWujFM388.jpg "title=" 13.png "Width=" "height=" 405 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:405px; "alt=" Wkiol1shiputnn-kaapdkvwujfm388.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A8/wKiom1ShIgqTPXbKAAC4GBaRRS4571.jpg "style=" float: none; "title=" 14.png "alt=" Wkiom1shigqtpxbkaac4gbarrs4571.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A8/wKiom1ShIgvzUbULAADVw3FDbAk841.jpg "style=" float: none; "title=" 15.png "alt=" Wkiom1shigvzubulaadvw3fdbak841.jpg "/>

then click Review(review) in the top right corner ... It will pop up. The following interface is displayed:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A5/wKioL1ShIs7yZCzQAAE99WGpOy4142.jpg "title=" 16.png "alt=" Wkiol1shis7yzczqaae99wgpoy4142.jpg "/>

Click Done. Success

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A8/wKiom1ShIiaAqkSbAAJIWtfl7Mc579.jpg "title=" 17.png "alt=" Wkiom1shiiaaqksbaajiwtfl7mc579.jpg "/>

look, this super admin has more than one admin user

Last Click

the top right cornerof EM ———— logout is re-login meaning. Then log in with admin

Admin Account

Oracle Password

Login

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShIurTFuXCAABfKXIxN_U699.jpg "title=" 18.png "alt=" Wkiol1shiurtfuxcaabfkxixn_u699.jpg "/>

Click Login. Login successful.

Schema————tables————Create

Em can also input SQL statements

go back to the home page. The bottom SQL worksheet

Click Schema

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A8/wKiom1ShIkXSWWCdAAHHl3QIPL4512.jpg "title=" 19.png "Width=" "height=" 168 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:800px;height:168px; "alt=" Wkiom1shikxswwcdaahhl3qipl4512.jpg "/>

Click Tables

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/A8/wKiom1ShInzh8umrAAGDkSGS-6g246.jpg "style=" width : 700px;height:159px; "title=" 21.png "width=" "height=" 159 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1shinzh8umraagdksgs-6g246.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShIy-BqmzCAAFMpZP1rnM754.jpg "style=" width : 700px;height:100px; "title=" 22.png "width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1shiy-bqmzcaafmpzp1rnm754.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/A8/wKiom1ShIn3w2otGAAMWAAN_0JE835.jpg "style=" width : 700px;height:282px; "title=" 23.png "width=" "height=" 282 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1shin3w2otgaamwaan_0je835.jpg "/>

Click on the flashlight appears listed below

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/A8/wKiom1ShIp-gGKRyAAL6QlvDdkk143.jpg "title=" 24.png "alt=" Wkiom1ship-ggkryaal6qlvddkk143.jpg "/>

and then it's done. You can click Show SQL to see

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/A5/wKioL1ShI3WTLSaTAABdZlHf93c854.jpg "title=" 25.png "alt=" Wkiol1shi3wtlsataabdzlhf93c854.jpg "/>

then reten returns:

Click OK in the upper right corner to complete.

After the completion. Interface Automatic Transfer List interface:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/A5/wKioL1ShI4KjmL9pAAECTf8osRE626.jpg "title=" 26.png "Width=" height= "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:800PX;HEIGHT:87PX; "alt=" Wkiol1shi4kjml9paaectf8osre626.jpg "/>

Admin more than one xs table, the user created a personal table successfully.

The above em use to write more hastily, some details are not written out, if there is insufficient, please understand.

Welcome to Technical Communication

This article is from the "and Treasure" blog, please be sure to keep this source http://zjwbk.blog.51cto.com/8740969/1597396

Oracle Database management Tools EM