oracle oem配置端口,oracle OEM的配置

最新推荐文章于 2024-06-24 16:54:01 发布
最新推荐文章于 2024-06-24 16:54:01 发布
阅读量271 收藏
点赞数
文章标签： oracle oem配置端口

##############################################################################

# 如果OEM有问题可以按下面的方法重新配置OEM

##############################################################################

# 如何查看数据库的SID

sys@TESTDB11>select instance_name from v$instance;

INSTANCE_NAME

----------------

TestDB11

# 修改sysman的口令

sys@TESTDB11>alter user sysman identified by sysman;

User altered.

# 修改dbsnmp的口令

sys@TESTDB11>alter user dbsnmp identified by dbsnmp;

User altered.

# 查看监听的端口号

[oracle@S1011:/export/home/oracle]$ lsnrctl status

LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 05-JUN-2013 11:06:56

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production

Start Date 05-JUN-2013 09:45:07

Uptime 0 days 1 hr. 21 min. 49 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/S1011/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kiwi)(PORT=1521)))

Services Summary...

Service "TestDB11" has 1 instance(s).

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

Service "TestDB11XDB" has 1 instance(s).

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

The command completed successfully

# 把dbconsole停止掉

[oracle@S1011:/export/home/oracle]$ emctl stop dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

https://kiwi:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

# 删除dbconsole的配置库

[oracle@S1011:/export/home/oracle]$ emca -repos drop

STARTED EMCA at Jun 5, 2013 11:05:30 AM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:

Database SID: TestDB11

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

----------------------------------------------------------------------

WARNING : While repository is dropped the database will be put in quiesce mode.

----------------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y

Jun 5, 2013 11:08:26 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/TestDB11/emca_2013_06_05_11_05_29.log.

Jun 5, 2013 11:08:27 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...

Jun 5, 2013 11:11:58 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

FINISHED EMCA at Jun 5, 2013 11:11:58 AM

# 重建dbconsole的配置库

[oracle@S1011:/export/home/oracle]$ emca -repos create

STARTED EMCA at Jun 5, 2013 11:12:43 AM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:

Database SID: TestDB11

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y

Jun 5, 2013 11:13:04 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/TestDB11/emca_2013_06_05_11_12_43.log.

Jun 5, 2013 11:13:05 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Jun 5, 2013 11:21:19 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Enterprise Manager configuration completed successfully

FINISHED EMCA at Jun 5, 2013 11:21:20 AM

# 重新配置

[oracle@S1011:/export/home/oracle]$ emca -config dbcontrol db

STARTED EMCA at Jun 5, 2013 11:22:27 AM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:

Database SID: TestDB11

Database Control is already configured for the database TestDB11

You have chosen to configure Database Control for managing the database TestDB11

This will remove the existing configuration and the default settings and perform a fresh configuration

Do you wish to continue? [yes(Y)/no(N)]: y

Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1

Local hostname ................ kiwi

Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1

Listener port number ................ 1521

Database SID ................ TestDB11

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y

Jun 5, 2013 11:24:23 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/TestDB11/emca_2013_06_05_11_22_27.log.

Jun 5, 2013 11:24:25 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Jun 5, 2013 11:24:39 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) ...

Jun 5, 2013 11:25:41 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Jun 5, 2013 11:25:46 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) ...

Jun 5, 2013 11:25:53 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Jun 5, 2013 11:25:53 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Jun 5, 2013 11:27:16 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jun 5, 2013 11:27:16 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://kiwi:1158/em

Jun 5, 2013 11:27:25 AM oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/kiwi_TestDB11/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************

Enterprise Manager configuration completed successfully

FINISHED EMCA at Jun 5, 2013 11:27:25 AM

# 查看EM database control的当前状态

[oracle@S1011:/export/home/oracle]$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

https://kiwi:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/kiwi_TestDB11/sysman/log

仙道SEVEN
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle 11G oem 配置及问题解决
weiyya的博客
01-17 3659
第一步：删除当前的 Database Control 资料档案库。命令为：emca -repos drop 第二步：创建新的 Database Control 资料档案库。命令为：emca -repos create 第三步：配置、部署数据库的 Database Control EM资料档案库。命令为：emca -config dbcontrol db   修改监听端口号后企业管理器（En
oracle oem配置端口,oracle 配置 oem
weixin_32487557的博客
04-07 126
1、启动命令是[[emailprotected] ~]$ cd $ORACLE_HOME/bin[[emailprotected] ~]$ ./emctl start dbconsole停止命令是[[emailprotected] ~]$ ./emctl stop dbconsole查看oem状态[[emailprotected] ~]$ ./emctl status dbconsoleo...
oracle 12c/19c OEM 无法访问怎么办?
最新发布
老苏畅谈运维
06-24 725
EM Express(Oracle Enterprise Manager Database Express)是一种轻量级的数据库管理工具,用于管理单个Oracle数据库。它取代了之前的OEM(Oracle Enterprise Manager)Database Control。EM Express的主要功能有:启动/关闭数据库:可以启动、关闭数据库实例或数据库。连接到目标数据库:可以使用SYSDBA或普通用户权限连接到数据库。管理用户和角色:可以创建、修改和删除用户、角色、角色授权等。
oracle oem配置端口,Oracle OEM 配置
weixin_29536515的博客
04-07 221
OEM 配置(1)创建一个EM资料库 ¬emca -reposcreate ¬(2)重建一个EM资料库 ¬emca -reposrecreate ¬(3)删除一个EM资料库 ¬emca -reposdrop ¬(4)配置数据库的DatabaseControl ¬emca -configdbcontrol db ¬(5)删除数据库的DatabaseControl配置 ¬emca -deconfigd...
oracle 配置 oem
__Yoon
01-29 442
1、启动命令是 [oracle@yoon ~]$ cd $ORACLE_HOME/bin [oracle@yoon ~]$ ./emctl start dbconsole 停止命令是 [oracle@yoon ~]$ ./emctl stop dbconsole 查看oem状态 [oracle@yoon ~]$ ./emctl status dbconsole   oracle的环境变量UNQNA
Oracle 13c OEM 安装使用手册.docx
08-22
Oracle 13c OEM 的安装及配置涉及多个步骤，包括软件安装、添加监控主机、部署 Agent 以及添加数据库目标。 #### 二、安装准备工作 **2.1 Oracle Management Service 依赖** Oracle Management Service 需要特定...
网络同传后ORACLE 10g OEM配置解决方案.pdf
10-09
【网络同传后ORACLE 10g OEM配置解决方案】 在网络通信领域，高效的数据管理和维护是至关重要的。ORACLE 10g是一个广泛使用的的关系型数据库管理系统，它提供了强大的数据存储和管理功能。然而，在使用网络同传技术...
OEM12c r2安装与配置.docx
08-13
* 配置 Oracle DB listener 需要设置监听地址和端口号。 * 配置 Oracle DB listener 还需要设置安全参数，以确保数据库的安全性。 三、 Oracle DB oemdb 特殊操作 * oemdb 是 Oracle Enterprise Manager 的数据库...
oracle-OEM
08-29
Oracle Enterprise Manager Cloud Control 12c（简称OEM Cloud Control）是甲骨文公司推出的一款集成的、可扩展的IT管理平台，主要面向整个Oracle技术栈的监控、管理和自动化任务。它提供了对Oracle数据库、中间件、...
Linux系统ORACLE 19C OEM监控管理
Friendsofthewind的博客
06-10 979
是采用图像化界面来控制和管理ORACLE数据库的工具集。查看端口： 修改默认端口： exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501)登录地址 格式为: https://hostname:5500/em (19c默认端口是5500)。 Resources资源 显示主机cpu使用率 活跃会话 内存 数据存储 SQL Monitor，sql语句监测 Incidents，事件...
设置Oracle 12C OEM 端口
weixin_30273763的博客
01-13 269
SQL> exec dbms_xdb_config.sethttpport(8087); 打开OEM: http://DBSIPOrName:8087/em/ 转载于:https://www.cnblogs.com/krisy/p/5126742.html
oracle 11g oem端口如何看,调试ORACLE 11G OEM
weixin_39573287的博客
04-14 303
前提：在win7 professional 版上安装oracle 11g 后，在数据库进行自动配置时，提示协议出错，当时也没管他，就直接点退出了。启动oracle 的相关服务进程，进入sql plus，执行相关操作，一切正常，但当要进入OEM 时，系统提示找不到相应页面。初步估计就是当时配置时协议出错后没有继续完成OEM 的原因造成的。动作：根据安装时所报的错误，暂定为em 没有完成配置，手动进行...
Oracle OEM 配置
a743044559的专栏
09-04 2657
OEM 配置 （1）创建一个EM资料库 ¬ emca -reposcreate ¬ （2）重建一个EM资料库 ¬ emca -reposrecreate ¬ （3）删除一个EM资料库 ¬ emca -reposdrop ¬ （4）配置数据库的DatabaseControl ¬ emca -configdbcontrol db ¬ （5）删除数据库的DatabaseControl配置
Oracle OEM安装配置
keepdba的博客
05-14 2560
OEM是一个图形化的数据库管理员工具。它为数据库管理员提供了一个集中的系统管理工具，同时它也是一个用来管理、诊断和调试多个数据库的工具.如下是Oracle Enterprise Manager安装配置过程： 获取帮助 [oracle@vastdata1 admin]$ emca|grep recreate -config dbcontrol db [-repos (create | recreate
oracle OEM的配置
kiwi的专栏
03-11 699
############################################################################## # 如果OEM有问题可以按下面的方法重新配置OEM ############################################################################## # 如何查看数据库的SID sy
oracle oem 安装配置,Oracle OEM 配置
weixin_28818559的博客
04-12 309
OEM 配置(1)创建一个EM资料库 ¬emca -reposcreate ¬(2)重建一个EM资料库 ¬emca -reposrecreate ¬(3)删除一个EM资料库 ¬emca -reposdrop ¬(4)配置数据库的DatabaseControl ¬emca -configdbcontrol db ¬(5)删除数据库的DatabaseControl配置 ¬emca -deconfigd...
Oracle实验——配置OEM
weixin_43352003的博客
04-26 257
配置OEM 1.查询端口号 select dbms_xdb_config.gethttpsport FROM DUAL; 2.设置企业管理器将来要用到的tcp的端口号 exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); 3.在浏览器地址栏输入访问OEM的URL地址https://localhost:5500/em/ 4.在登录页面输入账号密码 ...
oracle OEM的安装与配置（常用命令）
xiaofan23z的专栏
06-14 5328
oracle OEM的安装与配置    如果用OEM或者isqlplus等，不知道端口号的，可以查找portlist.ini文件； echo %homedrive% echo %homepath% OEM(9i OCP培训资料): OEM组成：OMS(oracle management server)，OIA(oracle intelligent ag
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值