mysql em_安装配置Oracle的EM

安装数据库完毕之后发现em无法登录，才想起来建数据时没注意到这回事，重新配置

安装数据库完毕之后发现em无法登录，才想起来建数据时没注意到这回事，重新配置

Oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:44:14 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

oracle@tbslinux:~> emca -config dbcontrol db

STARTED EMCA at Jan 5, 2012 9:49:10 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

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

Enter the following information:

Database SID: ticket

Listener port number: 1521

Listener ORACLE_HOME [ /oracle/product/11g/db_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 ................ /oracle/product/11g/db_1

Local hostname ................ tbslinux

Listener ORACLE_HOME ................ /oracle/product/11g/db_1

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

Database SID ................ ticket

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

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

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

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

Jan 5, 2012 9:50:32 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log.

Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.DatabaseChecks performReposChecks

SEVERE: 'job_queue_processes' must be greater than or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode.Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.EMConfig perform

SEVERE: 'job_queue_processes' must be greater than or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode.

Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.

Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.

oracle@linux:~> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:56:05 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> conn / as sysdba

Connected.

SQL> alter system set job_queue_processes=5;

System altered.

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

oracle@tbslinux:~>

oracle@linux:~> emca -config dbcontrol db

STARTED EMCA at Jan 5, 2012 9:58:37 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

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

Enter the following information:

Database SID: ticket

Listener port number: 1521

Listener ORACLE_HOME [ /oracle/product/11g/db_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 ................ /oracle/product/11g/db_1

Local hostname ................ tbslinux

Listener ORACLE_HOME ................ /oracle/product/11g/db_1

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

Database SID ................ ticket

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

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

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

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

Jan 5, 2012 9:59:03 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_58_36.log.

Jan 5, 2012 9:59:20 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

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

Jan 5, 2012 10:01:08 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib

INFO: Software library configured successfully.

Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Deploying Provisioning archives ...

Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Provisioning archives deployed successfully.

Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

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

Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil startOMS

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

Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

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

Jan 5, 2012 10:07:51 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: /oracle/product/11g/db_1/tbslinux_ticket/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 Jan 5, 2012 10:07:51 AM

oracle@linux:~> emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

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

https://tbslinux:1158/em/console/aboutApplication

- An instance of Oracle Enterprise Manager 11g Database Control is already running.

以此为记，

本文原创发布php中文网，转载请注明出处，感谢您的尊重！