 |
 |
*********************************************************************************
* Description: Oracle Enterprise Manager[OEM] family, and dbconsole installation
* Date: 05:44 PM EST, 04/17/2018
*********************************************************************************
<1> Oracle Enterprise Manager:
|
|__ o. OEM is a general Oracle environment management platform, and includes several products:
|
|__ o. OEM DBConsole .............. Web GUI to manage database locally.
|
|__ o. OEM Grid Control ........... Web GUI to manage whole Oracle db environment, especially for RAC environment.
|
|__ o. OEM Cloud Control .......... Web GUI to manage Oracle cloud environment.
|
|__ o. OEM Fushion Middleware ..... Web GUI to manage Fushion Middleware.
|
|__ o. OEM Application ............ Web GUI to manage WebLogic.
|
|__ o. OEM ODA .................... Web GUI to manage Oracle engineering system, such as ODA and ExData.
<2> OEM DbcCnsole installation:
|
|__ o. Passwords of user SYS/SYSMAN/DBSNMP are required in advanced.
|
|__ $ set oracle_sid = <database_name>
| $ set oracle_unqname = <db_unique_name>
| $ set oracle_home = <oracle_home>
|
|
|__ $ emca -config dbcontrol db -repos create
STARTED EMCA at Apr 9, 2018 4:00:30 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: wcp_1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.4/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):
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0.4/dbhome_1 ]:
ASM SID [ +ASM ]: +ASM1
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Local hostname ................ testdb.emeralit.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Listener port number ................ 1521
Database SID ................ wcp_1
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
ASM SID ................ +ASM1
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]:
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database TESTDB : testdb.emeralit.com
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: testdb.emeralit.com
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1521
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: wcp_1, oracleHome: /u01/app/oracle/product/11.2.0.4/dbhome_1, and user: SYS
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Apr 9, 2018 4:02:21 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
<3> If repository already exists, the "recreate" option is needed:
|
|__ $ emca -config dbcontrol db -repos recreate
STARTED EMCA at Apr 9, 2018 6:30:57 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: wcp_1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.4/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):
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0.4/dbhome_1 ]:
ASM SID [ +ASM ]: +ASM1
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Local hostname ................ testdb.emeralit.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Listener port number ................ 1521
Database SID ................ wcp_1
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
ASM SID ................ +ASM1
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 9, 2018 6:32:05 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/TESTDB/emca_2018_04_09_18_30_56.log.
Apr 9, 2018 6:32:06 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 9, 2018 6:33:24 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 9, 2018 6:33:24 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 9, 2018 6:37:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 9, 2018 6:37:21 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 9, 2018 6:38:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 9, 2018 6:38:12 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for testdb.emeralit.com
Apr 9, 2018 6:38:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 9, 2018 6:38:18 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 9, 2018 6:38:18 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 9, 2018 6:38:33 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 9, 2018 6:38:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://testdb.emeralit.com:5500/em <<<<<<<<<<<
Apr 9, 2018 6:38:35 PM oracle.sysman.emcp.EMDBPostConfig invoke
************************ 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.4/dbhome_1/odase0_TESTDB/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 Apr 9, 2018 6:38:35 PM
<4> Checking Dbcontrol process status, and dashboard URL:
|
|__ $ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://testdb.emeralit.com:5500/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0.4/dbhome_1/odase0_TESTDB/sysman/log
<5> Verify agent status:
|
|__ $ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /u01/app/oracle/product/11.2.0.4/dbhome_1/odase0_TESTDB
Agent binaries : /u01/app/oracle/product/11.2.0.4/dbhome_1
Agent Process ID : 1059
Parent Process ID : 976
Agent URL : https://testdb.emeralit.com:3938/emd/main
Repository URL : https://testdb.worldcue.com:5500/em/upload/
Started at : 2018-04-09 18:38:19
Started by user : oracle
Last Reload : 2018-04-09 18:45:01
Last successful upload : 2018-04-09 19:19:03
Total Megabytes of XML files uploaded so far : 14.77
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 52.61%
Data channel upload directory : /u01/app/oracle/product/11.2.0.4/dbhome_1/odase0_TESTDB/sysman/recv
Last successful heartbeat to OMS : 2018-04-09 19:19:35
---------------------------------------------------------------
Agent is Running and Ready
<6> DBCnsole Folder Structure under ORACLE_HOME:
|
|__ o. /u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_<ServerName>_<DBUnique_Name>
|
|__ o. /u01/app/oracle/product/11.2.0.4/dbhome_1/<ServerName>_<DBUnique_Name>
<7> The DBConsole will occupy on port 5001:
|
|__ o. If the DBConsole of one database using 5001, the second database will use 5002 on same server.
|
|__ o. After OEM DBConsole coming up, DBA can use regular individual db user credential to login.
<8> Reference:
|
|__ o. http://www.oracle-wiki.net/premium:startdocshowtoinstalldeinstalldbconsole#toc4
Your Comments