After EM agent instalation, database is not visible in EM Grid Control

Posted on 2007-12-05
Medium Priority
Last Modified: 2013-12-18
Dear Experts,
I am using Oracle 10g2 database. I have a problem with EM agent configuration. After installation the database (SID=BITEX) is not visible in the EM Grid Control, which is installed on the other host. Listener, ASM and host are visible and show actual state, only database instance is missing . Below, I attached some output from the listener, agent and targets.xml

Thanks fro any advice


Output from "lnsnctrl status":

oracle@bitex2:~/product/10.2/db_1/bin> lsnrctl status

LSNRCTL for Linux: Version - Production on 05-DEC-2007 14:33:35

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bitex2.bitex.com.pl)(PORT=1521)))
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version - Production
Start Date                05-DEC-2007 14:17:14
Uptime                    0 days 0 hr. 16 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "BITEX.WORLD" has 1 instance(s).
  Instance " BITEX ", status READY, has 1 handler(s) for this service...
Service " BITEXXDB.WORLD" has 1 instance(s).
  Instance "SA BITEX NEX", status READY, has 1 handler(s) for this service...
Service " BITEX _XPT.WORLD" has 1 instance(s).
  Instance " BITEX ", status READY, has 1 handler(s) for this service...
The command completed successfully

oracle@ bitex2:~/OracleHomes/agent10g/bin> ./emctl status agent

./emctl status agent
Oracle Enterprise Manager 10g Release
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
Agent Version     :
OMS Version       :
Protocol Version  :
Agent Home        : /opt/oracle/OracleHomes/agent10g
Agent binaries    : /opt/oracle/OracleHomes/agent10g
Agent Process ID  : 22193
Parent Process ID : 22177
Agent URL         : https://bitex2.bitex.com:3872/emd/main/
Repository URL    : https://grid. bitex.local:1159/em/upload
Started at        : 2007-12-05 14:25:46
Started by user   : oracle
Last Reload       : 2007-12-05 14:25:46
Last successful upload                       : 2007-12-05 14:33:32
Total Megabytes of XML files uploaded so far :     1.84
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    50.69%
Last successful heartbeat to OMS             : 2007-12-05 14:33:51
Agent is Running and Ready


<Targets AGENT_TOKEN="05b0697c77651ee3933abf6fa56180dd62c4be3b">
      <Target TYPE="oracle_emd" NAME="bitex2.bitex.com.pl:3872"/>
      <Target TYPE="host" NAME="bitex2.bitex.com.pl"/>
      <Target TYPE="oracle_database" NAME="BITEX.WORLD">
            <Property NAME="MachineName" VALUE="bitex2.bitex.com.pl"/>
            <Property NAME="Port" VALUE="1521"/>
            <Property NAME="SID" VALUE="BITEX"/>
            <Property NAME="OracleHome" VALUE="/opt/oracle/product/10.2/db_1"/>
            <Property NAME="UserName" VALUE="f614471b2cb8c5b7" ENCRYPTED="TRUE"/>
            <Property NAME="password" VALUE="0d16396a5b89b576b58f90a69cbd2c55" ENCRYPTED="TRUE"/>
            <Property NAME="ServiceName" VALUE="BITEX.WORLD"/>
      <Target TYPE="oracle_listener" NAME="LISTENER_bitex2.bitex.com.pl">
            <Property NAME="Machine" VALUE="bitex2.bitex.com.pl"/>
            <Property NAME="LsnrName" VALUE="LISTENER"/>
            <Property NAME="Port" VALUE="1521"/>
            <Property NAME="OracleHome" VALUE="/opt/oracle/product/10.2/db_1"/>
            <Property NAME="ListenerOraDir" VALUE="/opt/oracle/product/10.2/db_1/network/admin"/>
      <Target TYPE="osm_instance" NAME="+ASM_bitex2.bitex.com.pl">
            <Property NAME="SID" VALUE="+ASM"/>
            <Property NAME="MachineName" VALUE="bitex2.bitex.com.pl"/>
            <Property NAME="OracleHome" VALUE="/opt/oracle/product/10.2/db_1"/>
            <Property NAME="UserName" VALUE="SYS"/>
            <Property NAME="password" VALUE="0d16396a5b89b576b58f90a69cbd2c55" ENCRYPTED="TRUE"/>
            <Property NAME="Role" VALUE="SYSDBA"/>
            <Property NAME="Port" VALUE="1521"/>
Question by:adamgasior
  • 3
LVL 48

Expert Comment

ID: 20412257
I have read that Grid Control needs installation of OS specific agent
on the instance computer.
Will recommend to visit Oracle Technology network and
do download the appropriate agent and also to read and to follow the
installation docs.
LVL 48

Expert Comment

ID: 20412301
Also set the ORACLE_SID on the computer to the name of your computer and try this command
to get running the DB Control:
% emctl start dbconsole

I know DB control is not Grid Control ...

Author Comment

ID: 20412477
I am using SUSE 10
I have installed the OS specific agent (actually i have two identical servers) On BITEX1 the agent is working fine. On the other (BITEX2) it is not showing database. The only difference is that  on BITEX2 the database was deleted (using dd the ASM partition was completely cleared) and aftertaht the database was restored from backup of BITEX1. Maybe this will give you some clue

LVL 48

Accepted Solution

schwertner earned 600 total points
ID: 20418098
Either create or recreate OEM repository:
$ emca -config dbcontrol db -repos create

STARTED EMCA at Jul 24, 2006 9:59:39 PM
EM Configuration Assistant, Version Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Password for SYS user: change_on_install
Password for DBSNMP user: manager
Password for SYSMAN user: manager
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/10.2.0/db_1

Database hostname ................ linux3
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 24, 2006 10:00:12 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/TESTDB/emca_2006-07-24_09-59-39-PM.log.
Jul 24, 2006 10:00:15 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 24, 2006 10:05:51 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 24, 2006 10:06:01 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 24, 2006 10:07:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 24, 2006 10:07:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 24, 2006 10:07:49 PM

To recreate:

$ emca -config dbcontrol db -repos recreate

Alternatively using DBCA:

% dbca

in the reconfiguration section try to configure the existing Data base
with Enterprise manager.

Doing this do not forget in the profile file of Oracle user to set the
ORACLE_SID to that instance and make sure that this is efectivelly so:

% printenv | grep ORACLE%

Expert Comment

ID: 20936933
Forced accept.

Community Support Moderator

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question