Re: Cannot see any created databases in Enterprise Manager (9i-EE) when logged into Management Server

Hi Mike,

When you log into the console (through the OMS), you see the databases that have been "discovered". When you don't use the OMS, you use a local configuration file that works with the tnsnames.ora to see the databases.

If you look at the server(s) you are trying to discover (in the ORACLE_HOME/network/agent/ directory) you will find a services.ora file. This file has a list of all of the services the Intelligent Agent has found on your server. I suspect if you check the O_H/network/log/nmiconf.log file, you will see warnings about "No listener found for SID xyz. xyz will be skipped." This is because the agent requires a SID_LIST_ section in your listener.ora file. The agent uses configuration files to determine what services actually exist, and cannot use the same type of automatic registration the database and listener use.....

This should get you headed in the right direction...

Marty

Michael Kers <m.k_at_mailandnews.com> wrote in message news:3bc48878.434079653_at_news.easynews.com...
> Hi,
>
> Running Oracle 9i Enterprise Edition, Windows 2000 Server (very
> similar to 8i 8.1.7)
>
> After creating a new repository and making sure the management server
> is running, I can start Enterprise manager stand alone and see the
> database. If I double click it in the tree view I can log in as SYS
> or SYSTEM and view the schema.
>
> When I try to log into Enterprise Manager as SYSMAN I can get in, but
> I can only see Events, Jobs, Report Definitions, Groups, HTTP Servers
> and Nodes ... BUT NO DATABASES.
>
> Where are the databases hiding? How do I add them to the +Network
> treeview? If I try a discovery I don't get them. I know they are
> there because I can see them in the tree view in stand alone mode.
>
> My repository is inside of the database I created that has all my
> other schema. Is there something I have to do to add the database to
> the SYSMAN account (via the repository) so that the SYSMAN account can
> see the databases?
>
> Thanks
> Mike
Received on Wed Oct 10 2001 - 14:27:46 CDT