OEM CONFIGURATION IN RAC

OEM CONFIGURATION IN RAC



SQL> alter user sysman identified by sysman;

User altered.

SQL> alter user sysman account unlock;

User altered.

SQL>  alter user dbsnmp  account unlock;

User altered.

SQL> alter user dbsnmp  identified by dbsnmp;

User altered.

SQL> conn sysman/sysman;
Connected.
SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
UNLIMITED TABLESPACE
ALTER USER
CREATE TABLE
CREATE CLUSTER
CREATE PUBLIC SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER

PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
SELECT ANY DICTIONARY

15 rows selected.

SQL> select * from session_roles;

ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE
MGMT_USER

SQL>

SQL> conn dbsnmp/dbsnmp
Connected.
SQL>  select * from session_roles;

ROLE
------------------------------
OEM_MONITOR
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE

SQL>  select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE PROCEDURE
ANALYZE ANY
MANAGE ANY QUEUE
SELECT ANY DICTIONARY
ANALYZE ANY DICTIONARY
ADVISOR
CREATE JOB

10 rows selected.

SQL>


You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11204/dbhome

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11204/grid
Listener port number ................ 1521
Cluster name ................ rcscan
Database unique name ................ DEV
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/11204/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP


192.168.1.111   rac1pub111.dba.com    rac1pub111

INFO: >>>>>>>>>>> The Database Control URL is https://rac1pub111.dba.com:1158/em <<<<<<<<<<<
Aug 12, 2017 6:31:59 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

DEV               rac1pub111               rac1pub111.dba.com
DEV               rac2pub112               rac1pub111.dba.com


Aug 12, 2017 6:31:59 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/11204/dbhome/rac1pub111_DEV/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 Aug 12, 2017 6:31:59 PM



SQL> select status from gv$instance;

STATUS
------------
OPEN
OPEN

SQL> desc v$instance;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 INSTANCE_NUMBER                                    NUMBER
 INSTANCE_NAME                                      VARCHAR2(16)
 HOST_NAME                                          VARCHAR2(64)
 VERSION                                            VARCHAR2(17)
 STARTUP_TIME                                       DATE
 STATUS                                             VARCHAR2(12)
 PARALLEL                                           VARCHAR2(3)
 THREAD#                                            NUMBER
 ARCHIVER                                           VARCHAR2(7)
 LOG_SWITCH_WAIT                                    VARCHAR2(15)
 LOGINS                                             VARCHAR2(10)
 SHUTDOWN_PENDING                                   VARCHAR2(3)
 DATABASE_STATUS                                    VARCHAR2(17)
 INSTANCE_ROLE                                      VARCHAR2(18)
 ACTIVE_STATE                                       VARCHAR2(9)
 BLOCKED                                            VARCHAR2(3)

SQL> select INSTANCE_NUMBER,INSTANCE_NAME,ACTIVE_STATE from  gv$instance;

INSTANCE_NUMBER INSTANCE_NAME    ACTIVE_ST
--------------- ---------------- ---------
              1 DEV1             NORMAL
              2 DEV2             NORMAL

SQL>

How to check oem is running or not

[oracle@rac1pub111 u01]$ export ORACLE_UNQNAME=DEV
[oracle@rac1pub111 u01]$ 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/11204/dbhome/rac1pub111_DEV
Agent binaries    : /u01/app/oracle/product/11204/dbhome
Agent Process ID  : 51983
Parent Process ID : 51937
Agent URL         : https://rac1pub111.dba.com:3938/emd/main
Repository URL    : https://rac1pub111.dba.com:1158/em/upload/
Started at        : 2017-08-12 18:29:36
Started by user   : oracle
Last Reload       : 2017-08-12 19:05:34
Last successful upload                       : 2017-08-12 21:39:51
Total Megabytes of XML files uploaded so far :    24.32
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    87.84%
Data channel upload directory                : /u01/app/oracle/product/11204/dbhome/rac1pub111_DEV/sysman/recv
Last successful heartbeat to OMS             : 2017-08-12 21:42:43
---------------------------------------------------------------
Agent is Running and Ready

How to start OEM:

$ emctl start dbconsole

from chrome: https://racpub111.dba.com