OMS Server: Where runs the Enterprise Manager Middleware
Client Server: Where we’re going to install the agent

1.Pre-requisites setup to be done in Client Server

Create directory where agent will be installed in Client Server

In Client,You need to create a directory or mount point as /u01/oemcc

Install telnet in Client Server

yum install telnet -y

Test if the server can reach the OMS Server

# telnet xxx.tdenopcl.internal 4903
Trying 10.x.x.x…
Connected to xxx.tdenopcl.internal.
Escape character is ‘^]’.

Check if exists the filesystem /u01/oemcc with 4.8G and there is NO files/directories on it, delete even the directory lost+found

# df -h /u01/oemcc
Filesystem                  Size  Used Avail Use% Mounted on
/dev/mapper/vg_ora-oemcclv  4.8G   20M  4.6G   1% /u01/oemcc

2.Please install agent from cloud control console url

Please navigate to Setup => Add Target => Add Targets Manually

Install Agent on HOST

Name the session according to your server (where you’ll install the agent)
Fulfill the hostname (using domain if exists), chose the platform and click Next.

Click in + and add a credential which oracle connects to client

Fulfill the Installation Base Directory with “/u01/oemcc” use tab to go to another field and automatically the Instance Directory field is going to be fulfilled.

Test if the port 3872 is free on Client Server.
# netstat -an | grep 3872

The command above should not return values. If it returns any value, please chose another port. After choosing the port, click NEXT

Review the configuration and click on Deploy Agent

You may receive the warning below. Just click on Continue => Continue All Hosts

In determined time, OEM will ask you to run a script as root.

On Client Server, run the script mentioned above.

# /u01/oemcc/agent_13.1.0.0.0/root.sh

Finished product-specific root actions.

/etc exist

Creating /etc/oragchomelist file…

After it, click on DONE.

Ok, now you need to add targets to be monitored on this Server Client, for instance Oracle Grid, Oracle Database, Listener, etc…

Click on Add Using Guided Process

 

Click on Oracle Cluster and High Availability Service

Choose the Client Server you want to work with

And then click on DISCOVEY TARGET.Check the information and click on SAVE

Now, click on Close.

Now if added High Availability Services, we’re going to discover other monitored targets, like DB, Listeners, etc…

Click on Add Using Guided Process

 

Click on Oracle Database, Listener and Automatic Storage Management

Choose the Client Server you want to work with

And then click on NEXT

Connect to all database on the Client Server and grant sysdba to dbsnmp. Unlock the password and set new profile as below:

 

   ALTER USER DBSNMP ACCOUNT UNLOCK;
   CREATE PROFILE “APP_PROFILE”
    LIMIT
         COMPOSITE_LIMIT UNLIMITED
         SESSIONS_PER_USER UNLIMITED
         CPU_PER_SESSION UNLIMITED
         CPU_PER_CALL UNLIMITED
         LOGICAL_READS_PER_SESSION UNLIMITED
         LOGICAL_READS_PER_CALL UNLIMITED
         IDLE_TIME UNLIMITED
         CONNECT_TIME UNLIMITED
         PRIVATE_SGA UNLIMITED
         FAILED_LOGIN_ATTEMPTS UNLIMITED
         PASSWORD_LIFE_TIME UNLIMITED
         PASSWORD_REUSE_TIME UNLIMITED
         PASSWORD_REUSE_MAX UNLIMITED
         PASSWORD_VERIFY_FUNCTION NULL
         PASSWORD_LOCK_TIME UNLIMITED
         PASSWORD_GRACE_TIME UNLIMITED;
   ALTER USER DBSNMP PROFILE “APP_PROFILE”;

ALTER USER DBSNMP IDENTIFIED BY p4ssw0rd;

GRANT SYSDBA TO DBSNMP;

Choose SYSDBA for the databases, put the dbsnmp password and Test the connection

Connect to +ASM database on Client Server and define a password and grant sysasm to user asmsnmp.

SQL> alter user asmsnmp identified by p4ssw0rd;

User altered.

SQL> grant sysasm to asmsnmp;

Grant succeeded.

OBS: Don’t forget to flag all target  and click NEXT

Check the summary information and click SAVE

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *