注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

风之人生

人生如风,却无法如风般潇洒。

 
 
 

日志

 
 
关于我

一介草民,苟活于上海滩,以甲骨文为生,偶尔对一些国家大事有些兴趣,日常无事常以丝竹之声为乐。

网易考拉推荐

Managing the Oracle Oracle Enterprise Manager Express  

2013-12-23 11:11:10|  分类: Oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
When you finished installing the Oracle database 12.1, you can use the new manage tool — Oracle Enterprise Manger Express, a light weight web-based tool to mange your database. This article tellls that how to configure the EM express before using it.
1. Check your listener status.
Run the command lsnrctl status by oracle user.
[oracle@oserver database]$ lsnrctl status
 
LSNRCTL for Linux: Version 12.1.0.1.0 – Production on 03-JUL-2013 15:11:07
 
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 – Production
Start Date                03-JUL-2013 14:12:24
Uptime                    0 days 0 hr. 58 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oserver/listener/alert/log.xml
Listening Endpoints Summary…
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oserver.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “orcl.localdomain” has 2 instance(s).
  Instance “orcl”, status UNKNOWN, has 1 handler(s) for this service…
  Instance “orcl”, status READY, has 1 handler(s) for this service…
Service “orclXDB.localdomain” has 1 instance(s).
  Instance “orcl”, status READY, has 1 handler(s) for this service…
Service “pdborcl.localdomain” has 1 instance(s).
  Instance “orcl”, status READY, has 1 handler(s) for this service…
The command completed successfully
2. Check the current settings of your EM.
We have a package provided  by Oracle to you DBMS_XDB for manging the new EM Express in 12c. There’re lots of useful procedures and runfunctions under this package. You can check the package for details. First, we check the port setting in the current db using this package.
SQL> show parameter DISPATCHERS
 
NAME                                 TYPE        VALUE
———————————— ———– ——————————
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=orclXD
                                                 B)
max_dispatchers                      integer
SQL> set serveroutput on
SQL> declare
  2  v_ret number;
  3  begin
  4  v_ret := dbms_xdb.gethttpport();
  5  dbms_output.put_line(v_ret);
  6  end;
  7  /
0
 
PL/SQL procedure successfully completed.
 
 
You can see that we fisrt check the parameter dispatchers to sse if the protocol is TCP and  the port is 0, which means you didn’t set the port right now. Then we will set it.
SQL> exec dbms_xdb.setHTTPPORT(8080);
 
PL/SQL procedure successfully completed.
or you can check if it is okay using the method above.
3. Login to the em.
Now you can use the browser  to manage your database. enter the http://<server>:8080/em to login to the EM Express 12c.
EM Express Login 2013-07-03 15_28_53-EM Express - Database Home
Input your database user and password, you can login it! What look familiar? Yes, the UI is like the Oracle Support. Enjoy your self.

  评论这张
 
阅读(137)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017