How To Manually Install Oracle OEM 13c Agent?

1- We need to download the agent software from OMS Server for the platform which we will install. Login with sysman.

[oracle@isu13c bin]$ ./emcli login -username=sysman
Enter password :

Login successful

[oracle@isu13c bin]$ ./emcli sync
Synchronized successfully

2- Get the supported platform list

[oracle@isu13c bin]$ ./emcli get_supported_platforms
———————————————–
Version = 13.1.0.0.0
Platform = Linux x86-64
———————————————–
Platforms list displayed successfully.

3- Download the agent software

[oracle@isu13c bin]$ ./emcli get_agentimage -destination=/tmp/agentinstaller -platform=”Linux x86-64″
=== Partition Detail ===
Space free : 53 GB
Space required : 1 GB
Check the logs at /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/emcli/setup/.emcli/get_agentimage_2018-04-25_12-12-30-PM.log
Downloading /tmp/agentinstaller/13.1.0.0.0_AgentCore_226.zip
File saved as /tmp/agentinstaller/13.1.0.0.0_AgentCore_226.zip
Downloading /tmp/agentinstaller/13.1.0.0.0_Plugins_226.zip
File saved as /tmp/agentinstaller/13.1.0.0.0_Plugins_226.zip
Downloading /tmp/agentinstaller/unzip
File saved as /tmp/agentinstaller/unzip
Executing command: /tmp/agentinstaller/unzip /tmp/agentinstaller/13.1.0.0.0_Plugins_226.zip -d /tmp/agentinstaller
Exit status is:0
Agent Image Download completed successfully.

4- let me copy the software to target server and unzip.

scp 13.1.0.0.0_AgentCore_226.zip oracle@172.16.3.29:/DATA/install

unzip 13.1.0.0.0_AgentCore_226.zip

5- Let me install the agent

mkdir /u01/app/oracle/agent
./agentDeploy.sh AGENT_BASE_DIR=/u01/app/oracle/agent \
-force \
-ignorePrereqs \
-invPtrLoc /etc/oraInst.loc \
AGENT_PORT=3872 \
EM_UPLOAD_PORT=4903 \
OMS_HOST=isu13c \
ORACLE_HOSTNAME=oracledrs \
AGENT_INSTANCE_HOME=/u01/app/oracle/agent/agent_inst \
AGENT_REGISTRATION_PASSWORD=xxxxxx \
SCRATCHPATH=/tmp

After installation, don’t forget to execute root.sh script as root user.

Our agent is running and ready.

/u01/app/oracle/agent/agent_13.1.0.0.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
—————————————————————
Agent Version : 13.1.0.0.0
OMS Version : 13.1.0.0.0
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/agent/agent_inst
Agent Log Directory : /u01/app/oracle/agent/agent_inst/sysman/log
Agent Binaries : /u01/app/oracle/agent/agent_13.1.0.0.0
Core JAR Location : /u01/app/oracle/agent/agent_13.1.0.0.0/jlib
Agent Process ID : 64876
Parent Process ID : 64751
Agent URL : https://oracledrs:3872/emd/main/
Local Agent URL in NAT : https://oracledrs:3872/emd/main/
Repository URL : https://isu13c.localdomain:4903/empbs/upload
Started at : 2017-11-21 09:51:57
Started by user : oracle
Operating System : Linux version 4.1.12-37.4.1.el6uek.x86_64 (amd64)
Number of Targets : 7
Last Reload : (none)
Last successful upload : 2018-04-25 13:22:43
Last attempted upload : 2018-04-25 13:22:43
Total Megabytes of XML files uploaded so far : 172.1
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 59.73%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2018-04-25 13:23:53
Last successful heartbeat to OMS : 2018-04-25 13:23:53
Next scheduled heartbeat to OMS : 2018-04-25 13:24:53

—————————————————————
Agent is Running and Ready

Advertisements

How to Change Lost SYSMAN Password On OEM Cloud Control 13c?

Hi,

To change lost SYSMAN password on Oracle Enterprise Manager 13c, follow the below steps:

1- Change the password from SQL*Plus

alter user sysman identified by “oracle_test”;

2-Go to middleware home directory

cd /u01/app/oracle/middleware/bin/
./emctl config oms -list_repos_details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oem13c)(PORT=1521)))(CONNECT_DATA=(SID=emrep)))
Repository User : SYSMAN

3- Change the password as the following command

./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle_test -new_pwd oracle_test
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.

Changing passwords in backend …
Passwords changed in backend successfully.
Updating repository password in Credential Store…
Successfully updated Repository password in Credential Store.
Restart all the OMSs using ’emctl stop oms -all’ and ’emctl start oms’.
Successfully changed repository password.

4- Restart the OMS

./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Stopping Oracle Management Server…
WebTier Successfully Stopped
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
Stopping BI Publisher Server…
BI Publisher Server Successfully Stopped
AdminServer Successfully Stopped
BI Publisher Server is Down

./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server …
BI Publisher Server Successfully Started
BI Publisher Server is Up

How to Resolve ‘Null Pointer Exception’ Error On Top Activity Page In Oracle Enterprise Manager 13c

Hi,

When you login  Oracle Enterprise Manager 13c, the top activity page shows ‘Null Pointer Exception’ errors.   This is due to bug number 25455462. You can do following steps to resolve this issue.

oem13c_error

1-Set the following property on OEM 13c machine

emctl set property -name use_pooled_target_connections -value false

2-Restart the oms

cd <OMS_HOME>/bin

(cd /u01/app/oracle/middleware/bin/)

./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Stopping Oracle Management Server…
WebTier Successfully Stopped
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
Stopping BI Publisher Server…
BI Publisher Server Successfully Stopped
AdminServer Successfully Stopped
BI Publisher Server is Down

./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server …
BI Publisher Server Successfully Started
BI Publisher Server is Up

Creating OEM Repository and ORA-00955/ORA-01921 Errors

Hi Friends,

A month ago, I wrote an article about OEM configuration when the database hostname or ip address changed. You can find that in this link https://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/ .

We can get an error while re-creating (emca -config dbcontrol db -repos create) OEM repository as below:

SEVERE: Error creating the repository

Refer to the log file at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details.

Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details.

The error is also seen in the log file of errors is analyzed you can see following lines (/oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log).

CONFIG: ORA-00955: name is already used by an existing object
CONFIG: ORA-01921: role name ‘MGMT_USER’ conflicts with another user or role name

In this case we must do following operations in SQL*Plus.

SQL> DROP USER SYSMAN CASCADE;

SQL> DROP ROLE MGMT_USER;

SQL> DROP USER MGMT_VIEW;

SQL> spool synonym.sql

SQL> select ‘drop public synonym ‘||object_name||’;’ from dba_objects where object_type=’SYNONYM’ and and object_name like ‘MGMT_%’ and status=’INVALID’;

SQL> spool off

SQL> @synonym.sql

Now, please retry to create OEM respository. It will be success.

emca -config dbcontrol db -repos create

 

Talip Hakan Öztürk

OEM Configuration When the Database Host Name or IP Address Changes

The Enterprise Manager console will not work when database host name and / or IP address changes. We must run EMCA tool for reconfiguring the OEM database console. To do this, use the following commands.

emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create

or

emca -deconfig dbcontrol db

emca -config dbcontrol db -repos recreate

TNS konfigürasyonumuz değişir ise (Örneğin dinleyici(listener) portumuz değişirse), bu durumda yine EMCA aracı ile aşağıdaki gibi tekrar konfigürasyonumuzu yapabiliriz.

If our TNS configuration changes (for example, the listener (listener) port is changed), in this case we can still configure with the EMCA tool as follows.

emca -config dbcontrol db

Example: EMCA wants some information during repository drop and create operation. Such as SID, listener port number, SYS and SYSMAN passwords.

talip /oracle/ora11gR2> emctl stop dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

http://dbtalip:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control … … Stopped.

talip /oracle/ora11gR2> emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 29, 2011 9:16:31 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database SID: TEST11GR2

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

———————————————————————- WARNING : While repository is dropped the database will be put in quiesce mode. ———————————————————————-

Do you wish to continue? [yes(Y)/no(N)]: y

Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_16_30.log.

Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) …

Nov 29, 2011 9:16:55 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) …

Nov 29, 2011 9:19:15 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 29, 2011 9:19:18 AM

talip /oracle/ora11gR2> emca -config dbcontrol db -repos create

STARTED EMCA at Nov 29, 2011 9:19:25 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database SID: TEST11GR2

Listener port number: 1521

Listener ORACLE_HOME [ /oracle/ora11gR2 ]:

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 ……………. /oracle/ora11gR2

Local hostname ……………. dbtalip

Listener ORACLE_HOME ……………. /oracle/ora11gR2

Listener port number ……………. 1521

Database SID ……………. TEST11GR2

Email address for notifications ……………

Outgoing Mail (SMTP) server for notifications ……………

—————————————————————–

Do you wish to continue? [yes(Y)/no(N)]: y

Nov 29, 2011 9:19:46 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_19_24.log.

Nov 29, 2011 9:19:47 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) …

Nov 29, 2011 9:26:16 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Nov 29, 2011 9:26:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) …

Nov 29, 2011 9:27:19 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Nov 29, 2011 9:27:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) …

Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) …

Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://dbtalip:1158/em <<<<<<<<<<<

Nov 29, 2011 9:28:13 AM 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 th file:

/oracle/ora11gR2/dbtalip_TEST11GR2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will becom unusable if this file is lost.

***********************************************************

Enterprise Manager configuration completed successfully

FINISHED EMCA at Nov 29, 2011 9:28:13 AM

talip /oracle/ora11gR2> emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. https://dbtalip:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running. ——————————————————————

Logs are generated in directory /oracle/ora11gR2/dbtalip_TEST11GR2/sysman/log talip /oracle/ora11gR2>

 

Now, OEM is available.

Talip Hakan Öztürk