em的配置与使用

em的配置 

1  保证数据库处于open 
export ORACLE_SID=orcl 
sqlplus / as sysdba 
SQL> select status from v$instance; 

STATUS 
------------ 
OPEN 

如果不是：startup force 重启 

2  保证侦听启动，服务名字注册 
切换到grid 用户 --su - grid

[ grid@InX-pc ~]$ lsnrctl status 
Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=InX-pc)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM", status READY, has 1 handler(s) for this service...

Service "orcl.example.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.example.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

出现以上说明侦听已经启动，

若没有启动，执行以下命令即可

lsnrctl stop ; 
lsnrctl start ; 
3 保证EM工具启用 
su - oracle 
[ oracle@InX-pc  ~]$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. 
https://InX-pc:1158/em/console/aboutApplication 
Oracle Enterprise Manager 11g is  running.保证是running

如果不是的 执行以下命令即可
emctl stop dbconsole 
emctl start dbconsole 

[ oracle@InX-pc ~]$ netstat -tunlp |grep 1158 
(Not all processes could be identified, non-owned process info 
will not be shown, you would have to be root to see it all.) 
tcp 0 0 :::1158 :::* LISTEN 7808/java 
[ oracle@InX-pc ~]$ 

可以通过杀死进程的方式 kill -9 22448 



4 有浏览器就可以访问 ---谷歌
https://ip或者主机名:1158/em 

https://192.168.2.1:1158/em 

只有管理员sys system登录

EM的使用

要求新建立一个用户web_admin 作为新的EM管理员 ,用web_admin 管理EM 
要求用web_admin建立一个表 scott.test 
进入em主页面
Server --->Users--->create 
输入账户web_admin 
密码oracle 
确认密码oracle 
然后再选择
role --->edit list --->dba 
System Privileges---->sysdba 

设置web_admin可以管理EM 
右上角-----》setup --->Administrators ---->create ....... 

右上角-----》logout 

web_admin登录 建立一个表scott.test id number name char(10) 
Schema--->tables --->create