oracle 常用配置命令,】oracle em配置常用命令

参见：http://fourfire.javaeye.com/blog/48288

emca -repos create创建一个EM资料库

emca -repos recreate重建一个EM资料库

emca -repos drop删除一个EM资料库

emca -config dbcontrol db配置

数据库

的 Database Control

emca -deconfig dbcontrol db删除数据库的 Database Control配置

emca -reconfig ports 重新配置db control的端口，默认端口在1158

emctl start console启动EM console服务，使用前需要先设置ORACLE_SID环境变量

emctl stop console停止EM console服务，使用前需要先设置ORACLE_SID环境变量

注：通过查看$ORACLE_HOME/install/portlist.ini 文件可以知道当前dbcontrol正在使用的端口

================================================================

【收藏】Oracle 入门之EM配置

参考：http://www.linuxidc.com/Linux/2010-09/28558.htm

ORACLE 11g R2 64位启动em,出现如下错误:

[root@localhost ~]# su - oracle

[oracle@localhost ~]$ emctl start dbconsole

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

[oracle@localhost ~]$ export ORACLE_UNQNAME=online

[oracle@localhost ~]$ emctl start dbconsole

OC4J Configuration issue. /u01/app/oracle/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_online not found.

问题原因为em资料库配置不正确，或者是dbcontrol没有配置好

1：重建EM资料

[oracle@localhost ~]$ emca -repos recreate

STARTED EMCA at Sep 6, 2010 4:42:53 PM

EM Configuration Assistant, Version 11.2.0.0.2 Production

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

Enter the following information:

Database SID: online

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

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

Sep 6, 2010 4:43:30 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/cfgtoollogs/emca/online/emca_2010_09_06_16_42_52.log.

Sep 6, 2010 4:43:31 PM oracle.sysman.emcp.EMReposConfig invoke

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

Sep 6, 2010 4:46:23 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Sep 6, 2010 4:46:24 PM oracle.sysman.emcp.EMReposConfig createRepository

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

Sep 6, 2010 4:53:00 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Enterprise Manager configuration completed successfully

FINISHED EMCA at Sep 6, 2010 4:53:00 PM

2：配置dbcontrol

[oracle@localhost ~]$ emca -config dbcontrol db

STARTED EMCA at Sep 6, 2010 5:02:57 PM

EM Configuration Assistant, Version 11.2.0.0.2 Production

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

Enter the following information:

Database SID: online

Listener port number: 1521

Listener ORACLE_HOME [ /u01/app/oracle ]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN 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

Local hostname ................ localhost.localdomain

Listener ORACLE_HOME ................ /u01/app/oracle

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

Database SID ................ online

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

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

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

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

Sep 6, 2010 5:03:34 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/cfgtoollogs/emca/online/emca_2010_09_06_17_02_56.log.

Sep 6, 2010 5:03:39 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

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

Sep 6, 2010 5:04:45 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Sep 6, 2010 5:04:46 PM oracle.sysman.emcp.ParamsManager getLocalListener

WARNING: Error retrieving listener for localhost.localdomain

Sep 6, 2010 5:04:49 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib

INFO: Software library configured successfully.

Sep 6, 2010 5:04:49 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Deploying Provisioning archives ...

Sep 6, 2010 5:05:22 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Provisioning archives deployed successfully.

Sep 6, 2010 5:05:22 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

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

Sep 6, 2010 5:06:17 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Sep 6, 2010 5:06:17 PM oracle.sysman.emcp.util.DBControlUtil startOMS

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

Sep 6, 2010 5:07:00 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Sep 6, 2010 5:07:00 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localdomain:1158/em <<<<<<<<<<<

Sep 6, 2010 5:07:04 PM oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

可以看到em已经启动：

[oracle@localhost ~]$ netstat -ntpl |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      11125/java

[oracle@localhost ~]$ 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://localhost.localdomain:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

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

Logs are generated in directory /u01/app/oracle/localhost.localdomain_online/sysman/log

************************ 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/localhost.localdomain_online/sysman/config/emkey.ora.   Please 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 Sep 6, 2010 5:07:04 PM

连接

测试

：