OraFAQ Forum: Enterprise Manager » databases not showing up from oem

Home » RDBMS Server » Enterprise Manager » databases not showing up from oem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

databases not showing up from oem [message #412496]

Thu, 09 July 2009 13:44

california_6_1
Messages: 29
Registered: February 2007

Junior Member

I have created 2 databases and when i view my host from oem grid control - i dont see these newly created databases. if i go to targets - select my node and request for databsaes - all i see is the one i created at the time of installation. anything i am missing?

Report message to a moderator

Re: databases not showing up from oem [message #431641 is a reply to message #412496]

Wed, 18 November 2009 15:18

nateholtrop
Messages: 37
Registered: May 2008

Member

On the agents, do a rediscover of your targets. This should get them into oem.

Report message to a moderator

Re: databases not showing up from oem [message #433468 is a reply to message #412496]

Wed, 02 December 2009 08:06

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

In Targets, do you see the host(s) for these databases?

If yes:, click on the databases tab (top on the Targets menu) and you will find an "Add" button. Click on that and it will request the host name (server) and re-discover everything.

If not:
- Login to the target host (server)
- Make sure the databases are recorded in the /etc/oratab (or /var/opt/oracle/oratab) file
- Change directory to the Agent Home
- Execute these commands:

$ ./bin/emctl stop agent
$ rm -f sysman/emd/state/*
$ rm -f sysman/emd/upload/*
$ rm -f sysman/log/*
$ ./bin/emctl clearstate agent
$ ./bin/emctl secure agent {password}
$ ./bin/emctl start agent

- Check the logs and trace files in $AGENT_HOME/sysman/log for errors

PS: Have patience (take a coffe break) because sometimes it may take more than 15 minutes to register each database.
Razz

Report message to a moderator

Re: databases not showing up from oem [message #433478 is a reply to message #433468]

Wed, 02 December 2009 09:01

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

I have created 2 databases and when i view my host from oem grid control - i dont see these newly created databases. if i go to targets - select my node and request for databsaes - all i see is the one i created at the time of installation. anything i am missing?

You need to install agent on that server if its not installed. If agent is already installed on server then login to grid and configure database

- Babu

[Updated on: Wed, 02 December 2009 09:42] by Moderator

Report message to a moderator

Re: databases not showing up from oem [message #433979 is a reply to message #433478]

Sun, 06 December 2009 02:32

nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona

Junior Member

On target node:

export ORACLE_HOME=
now set it to the home you installed the oracle agent to:

export ORACLE_HOME=/u01/app/oracle/agent/10.2

export PATH=$ORACLE_HOME/bin:$PATH
emctl status agent

start peeking at logs as well.
Most forget it's a different agent, and must be installed into an exclusive ORACLE HOME.

Sometimes I even forget, and try and start the dbcontrol agent by mistake.

(also verify the agent registration password on grid is the one you are using.)

Good luck

Nets Edge

Report message to a moderator

Previous Topic:	unable to login enterprise manager in win7 oracle 10.2.0.1.0
Next Topic:	backup in oracle managment server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:24:18 CST 2024