Common oracle em configuration commands

Emca-repos create creates an EM Database

Emca-repos recreate re-creates an EM Database

Emca-repos drop delete an EM Database

Emca-config dbcontrol db Configuration
Database
Database Control

Emca-deconfig dbcontrol db deletes the Database Control Configuration of a Database

Emca-reconfig ports: reconfigure the port of db control. The default port is 1158.

Emctl start console to start the EM console service. You need to set the ORACLE_SID environment variable before use.

Emctl stop console to stop the EM console service. You need to set the ORACLE_SID environment variable before use.

Note: You can check the $ ORACLE_HOME/install/portlist. ini file to find the port currently used by dbcontrol.

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

[Add to favorites] EM configuration for Oracle getting started

ORACLE 11g R2 64-bit start em with the following error:

[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

Enter the Configuration file in the Configuration file./u01/app/oracle/Solaris/j2ee/OC4J_DBConsole_localhost.localdomain_online not found.

The cause is that the em database is incorrectly configured or dbcontrol is not configured.

1. re-build EM data

[Oracle @ localhost ~] $ Emca-repos recreate

Started emca at Sep 6, 2010 4:42:53

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003,200 5, 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 oracle. sysman. emcp. EMConfig perform

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

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

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

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

INFO: Repository successfully dropped

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

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

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

INFO: Repository successfully created

Enterprise Manager configuration completed successfully

Finished emca at Sep 6, 2010 4:53:00

2: Configure dbcontrol

[Oracle @ localhost ~] $ Emca-config dbcontrol db

Started emca at Sep 6, 2010 5:02:57

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003,200 5, 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 communications (optional ):

Outgoing Mail (SMTP)
Server
For communications (optional ):

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

You have specified the following settings

Database ORACLE_HOME.../u01/app/oracle

Local hostname ......

Listener ORACLE_HOME.../u01/app/oracle

Listener port number... 1521

Database SID ...... online

Email address for communications ...............

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

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

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

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

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

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

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

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

INFO: Uploaded configuration data successfully

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

WARNING: Error retrieving listener for localhost. localdomain

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

INFO: Software library configured successfully.

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

INFO: Deploying Provisioning archives...

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

INFO: Provisioning archives deployed successfully.

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

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

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

INFO: Database Control secured successfully.

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

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

Sep 6, 2010 5:07:00 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration

INFO: Database Control started successfully

Sep 6, 2010 5:07:00 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration

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

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

WARNING:

You can see that em has been started:

[Oracle @ localhost ~] $ Netstat-ntpl | grep 1158

(Not all processes cocould be identified, non-owned process info

Will not be shown, you wowould 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,200 9 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

Connection
Test
:

Author: "small ocean Enterprises"