Oracle Study Notes: Use of the graphic management tool EM

Oracle Study Notes: Use of the graphic management tool EM

Use of common Oracle learning notes tools-EM

Graphics Management Tool em

Server

1 Ensure Listening Starts -----> grid

Lsnrctl status

Or

Netstat-tunlp | grep 1521

If not

Lsnrctl start

2. Ensure database startup ----> oracle

Sqlplus/as sysdba

If not started

Shutdown abort;

Startup;

3. Enable the em tool ---> oracle

[Oracle @ yutianedu ~] $ Emctl status dbconsole

Default port 1158

Or you can view

[Oracle @ yutianedu ~] $ Netstat-tunlp | grep 1158

If not started

Emctl stop dbconsole

Emctl start dbconsole

The client can be accessed through a browser (google browser is recommended)

Https: // database server name or ip: 1158/em

Https: // 192.168.2.1: 1158/em

Point continues

We need English

Click Settings-> click Advanced Settings-> click language and input settings-> click Add-> click English at the end-English-> click to move up to the top

Click Finish

Then refresh the page

Who can log on: Only sys system users

* User Name sys

* Password oracle

Connect As sysdba

View who can log on to em

Requirement: Use em to create an account web_admin and grant dba permissions. You can use em to manage databases.

Sys logon em

Server ---> Security --> Users

Point Creation

Account name web_admin

Password: oracle

Roles ----> editlist ---> dba role

System Privileges --- "editlist

Sysdba role ---> OK

You can click show SQL to view the corresponding SQL statement you just clicked.

Last click OK

Add this account to the em Administrator

Upper right ---- "setup ---> administrators ---> create

Select web_admin for Name

Permission: super administrator

Finish

Requirement: Log On With web_admin and create a table xs (id number, name char (10 ))

Logout ----> login --

> Enter the username web_admin and password for oracle

Schema ---> tables ---> create

Input table name

Input column name select data type

Click show SQL

OK

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian