OEM reconfiguration

-



Set ORACLE_HOSTNAME=sourcenode01

[oracle@sourcenode01 ~]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db

STARTED EMCA at Sep 24, 2018 12:20:04 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: src01

Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 24, 2018 12:20:13 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_20_03.log.
Sep 24, 2018 12:20:13 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 24, 2018 12:20:13 PM
[oracle@sourcenode01 ~]$


[oracle@sourcenode01 ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 24, 2018 12:21:22 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: src01
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.1.0/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 ................ /u01/app/oracle/product/11.2.0.1.0/db_1

Local hostname ................ sourcenode01
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.1.0/db_1
Listener port number ................ 1521
Database SID ................ src01
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 24, 2018 12:21:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_21_22.log.
Sep 24, 2018 12:21:53 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_21_22.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_21_22.log for more details.

Workaround:

old configuration change:
[oracle@sourcenode01 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
192.168.1.20       sourcenode01    sourcenode01    sourcenode01
::1     localhost.localdomain   localhost6      localhost

TO:

[oracle@sourcenode01 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
127.0.0.1       sourcenode01    sourcenode01    sourcenode01
::1     localhost.localdomain   localhost6      localhost

NOTE : In this case once DBConsole configuration is completed you can revert the changes to the hosts file. You can expect to access this dbconsole on the local server only. Unless you make modifications to the client's hosts file and add this host and its current IP address.

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

[oracle@sourcenode01 ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 24, 2018 12:30:18 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: src01
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.1.0/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 ................ /u01/app/oracle/product/11.2.0.1.0/db_1

Local hostname ................ sourcenode01
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.1.0/db_1
Listener port number ................ 1521
Database SID ................ src01
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 24, 2018 12:30:40 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_30_24.log.
Sep 24, 2018 12:30:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 24, 2018 12:31:47 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 24, 2018 12:31:47 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 24, 2018 12:34:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 24, 2018 12:34:48 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 24, 2018 12:35:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 24, 2018 12:35:14 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Sep 24, 2018 12:35:14 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Sep 24, 2018 12:35:27 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Sep 24, 2018 12:35:27 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 24, 2018 12:35:46 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 24, 2018 12:35:46 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 24, 2018 12:36:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 24, 2018 12:36:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://sourcenode01:1158/em <<<<<<<<<<<
Sep 24, 2018 12:36:36 PM 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.1.0/db_1/sourcenode01_src01/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 24, 2018 12:36:36 PM



Starting and Stopping the Oracle Enterprise Manager Console

To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server. The dbconsole process is automatically started after installation.

However, in the event of a system restart, you can start it manually at the command line or start it as a service in Windows.

To start the dbconsole process from the command line:

Navigate into your ORACLE_HOME/bin directory.

Run the following statement:

./emctl start dbconsole



Additionally, you can stop the process and view its status.

To stop the dbconsole process:

./emctl stop dbconsole



To view the status of the dbconsole process:

./emctl status dbconsole





Comments

Post a Comment

Popular posts from this blog

Installation of Oracle10g on LINUX

-
Table of Contents 1.  Pre-installation Tasks for the ORACLE 10g Database. 2. Installing the ORACLE 10g Database. 3. Post-installation tasks for the ORACLE 10g Database. 4. Testing the installation.  Pre-installation Tasks for the ORACLE 10g Database. Before starting the oracle 10g installation ,several parameters must be checked. To perform these checks login as the root user or switch user to root using the command su – root. Checking Memory and Swap space. For successful installation of Oracle 10g, the system is required to have atleast 512MB of RAM and 1 GB of Swap space.You can verify this using :-- grep MemTotal /proc/meminfo  grep SwapTotal /proc/meminfo Checking /tmp space. The Oracle Universal Installer requires 400 MB of free space in the /tmp directory. The command to check this is as follows:-- df /tmp Checking The Existence of following Softwares/RPM Packages.The following packages or later versions must be installed :--- · make-3.79.1· gcc-3.2.3-...
Read more

RMAN compression

-
RMAN Compression: There are 3 three types of compression by default: 1.       Null compression ·         Usages only till Oracle version 10.1 by default ·         RMAN skips the block that have never been used when backing up datafiles into backup sets. ·         E.g. let’s tablespace having once datafile of size 100MB and out of 100 MB only 50 is used. Then RMAN will backup only 50 MB. 2.       Unused block compression ·         Oracle version 10.2 forward, uses ‘Null’ and ‘unused block’ compression. ·         More compact backups of datafiles by skipping datafile blocks that are not currently used to store data. ·         In previous release, RMAN only supported NULL compression, which skipped space in ...
Read more

Database upgrade -11.2.0.1 to 11.2.0.4

-
Database upgrade -11.2.0.1 to 11.2.0.4 Complete Checklist for out-of-Place Manual Upgrade from Previous 11.2.0.N Version to the Latest 11.2.0.N Patchset (Doc ID 1276368.1) STEP 1) Download the 11.2.0.4 or RDBMS software. STEP 2) Install the latest 11.2.0.4 RDBMS Software into a new ORACLE_HOME. STEP 3 ) After installing the latest 11.2.0.4 RDBMS software, run Pre-upgrade tool (utlu112i.sql) on database (11.2.0.1). You need to review pre-upgrade output and fix if any issues before upgrading to the latest release of 11.2.0.4. STEP 4) Run  dbupgdiag.sql  script from the below My Oracle Support article to verify that all the components in dba_registry are valid and no invalid data dictionary objects exist in dba_objects. Note 556610.1  Script to Collect DB Upgrade/Migrate Diagnostic Information ( dbupgdiag.sql ) $ sqlplus / as sysdba sql> alter session set nls_language=’American’; sql> @ dbupgdiag.sql sql> exit If the  db...
Read more