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