Enterprise Manager - can't see database

Hi there,

I am having a problem with Enterprise Manager Console.

I am logging into the management server, however I can't see a database which was has been created since the management server was installed.

I have discovered the node that the database resides on, and I can successfully ping it's agent, however even after a refresh I can't see the database.

Any help would be appreciated.

Kind Regards

Allie

Try stopping/starting the intelligent agent on the host.

Regards

I stopped and started the Agent and refreshed the node - still no database.

A

funny!
Did you use the discover node wizard in the oem console?
:D sorry didn't read that top part of your post..
no compatibility issues here, right?

The only issue I can think of is that the Management Server is on NT and the Database is on Linux, but I don't think that would be the problem.

If I go in to Enterprise Management Console standalone then I can add the missing database to the tree and perform actions against it, however it's backup and recovery that I really want to do so I need to use the management server. I can see 2 other databases that were created before the Management server!!

I am using Oracle Enterprise Manager version Oracle 9.2.0.1.0 and the database is Oracle9i Enterprise Edition Release 9.2.0.1.0.

A

Alison -

I have a problem that is similar to yours. I'm trying to setup my connection to the database but keep getting an error...

Failed to parse tnsnames.ora file
Error 101 - NLNV - Null for RHS Atom.

Do you know how to fix that? Even if I try setting up the DB manually I get the same message. Similar to you, our database is stored on a Sun Solaris machine and the Management Software is on Win2K.

Any suggestions?

Thanks.

Hi Indy

I looked up your error on metalink and the problem may be whitespace or corruption in your TNSNAMES.ORA file.

I don't know how to paste the full link, however if you paste the following string into the search on metalink it will take you to the relevant post.
Failed to parse TNSNAMES.ORA file Error 100:NLNV String Format Error

If you don't have access to it then give me a shout and I'll post the whole reply to you.

Back to my problem, anyone go any ideas??

A

Alison,

Thanks for getting back to me. I'll have to take you up on your offer to post the reply. If the reply is too long stick it on an email to me at [email protected]

Thanks.

There is lots of back and forth in the post but the final solution is:

. When the "EM Tools" parse the TNSNAMES.ORA file, it is finding either a white space in the very first position or something else has corrupted your files. Please recreate the TNSNAMES.ORA file either with Net8 Configuration Assistant or manually and make sure the first position of the file is not a space or blank line. You can also follow note: 164166.1 if you need more help.

Hope this helps - doesn't help me though!!!

Allie

Alison,

A BIG thanks for helping me out - much appreciated ;)

I'm sorry I couldn't help you out with your problem. However, I'm sure like you some will be out there that can help you.

Thanks again.

Hi there,

This is getting to be time critical - If anyone can help I would be eternally grateful.

A

Have you checked to see if you have an entry for the database in the services.ora?

This doc should help

http://support.oracle.co.uk/metalink...&p_id=185547.1

Regards

Hi Jovery,

I looked at the note you suggested, I ran the lsnrctl status command and received the following result:

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date 19-NOV-2002 11:58:53
Uptime 15 days 22 hr. 9 min. 26 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/portals/NETWORK/ADMIN/listener.ora
Listener Log File /opt/oracle920/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cream.eclecticgroup.co.uk)(PORT=1521)))
Services Summary...
Service "PORTALS.world" has 1 instance(s).
Instance "PORTALS", status READY, has 1 handler(s) for this service...
The command completed successfully


This shows the service PORTALS.WORLD, it's the database that I can't see - I don't have the option to use the GUI Configuration assistant on this machine.

The Services.ora file is as follows (no mention of PORTALS)

cream.eclecticgroup.co.uk = (ORACLE_NODE, cream.eclecticgroup.co.uk, cream.eclec
ticgroup.co.uk, (PLATFORM=(osName=Linux)(osVersion=2.4.18)(oracleHomes=/opt/orac
le920)))
cream.eclecticgroup.co.uk:4443 = (oracle_sysman_webserver, cream.eclecticgroup.c
o.uk, http://cream.eclecticgroup.co.uk:4443/server-status, unavailable, /opt/ora
cle920/Apache/Apache/conf/httpd.conf, /opt/oracle920/Apache/Apache)

Any further ideas would be appreciated.

Allie

You could try the following:

On the target host

1. Take backups of services.ora and snmp*.ora
2. Delete the services.ora and snmp*.ora
3. Stop and restart the agent.
4. Check to see if the service is added to services.ora

Regards

Did what you suggested with no success, strangely over the past hour I created an instance on another NT machine, this database show's up in the navigator, however the database on the Linux machine still doesn't.

I refreshed the discovery of all the nodes.

Thanks for all your help, any new suggestions.

A

Very odd :confused:

Do you get any errors/warnings in the following log on the target

$ORACLE_HOME/network/agent/log/nmiconf.log

Regards

There isn't any log created, there is nothing in the /agent/log directory.

This is totally stumping me - and metalink dosent' seem to be helping me.

Is the service now listed in the services.ora or is it still missing. Also can you discover the host if you use an IP address instead of the hostname/dns

Regards

The services are still not in the services.ora file - I added the portals service manually, however as soon as I stopped and started the agent the entries were (as expected) overwritten.

I have noticed something else, in the navigator tree (where I can't see the database) I also can't see the listener associated with cream (the node) but I can see the listeners for the other 2 NT nodes that are discovered.

I discovered all my nodes through IP addresses rather than host names.

For reference I have added the contents of the listener.ora file.

Thanks again for sticking with this..

PORTALS =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = tcp)
(Host = )
(Port = 10001)
)
)

SID_LIST_PORTALS =
(SID_LIST =
(SID_DESC =
(SID_NAME = PORTALS)
(ORACLE_HOME = /opt/oracle920)
)
)

T01 =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = tcp)
(Host = 10.0.0.101)
(Port = 11001)
)
)

SID_LIST_T01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = T01)
(ORACLE_HOME = /opt/oracle920)
)
)

Based on the startup prcess of the IA does any of this help.

1. First it reads the oratab file to see what services are on the host
a. Is the oratab file in a default location?
b. Is it readable by the agent user?
c. Are the services listed there?

2. Once the oratab file is read it reads the listener.ora from the $ORACLE_HOME specified in the oratab file.
a. Is the listener.ora file in the default location?
b. Is a GLOBAL_DBNAME defined if not it reads tnsnames.ora

This will create the services.ora file, as you do not have any entries in this file looks like there is a mistake in the definition of one of these files.
oratab
listener.ora
tnsnames.ora

Can you review them and check they are okay, if you still cannot resolve the problem post the contents and give the locations back on this thread

Regards

I'll check through all of that, can you tell me where the oratab file should be?

The standard locations can be either /etc or /var/opt/oracle

however you can define a custom one providing you have an environment variable ORATAB which specifies the path

Regards

Cheers, I'll check through it and get back to you.

Allie

The Oratab file is in the /etc directory and can be read by everyone, I have copied the contents of the file below, there is really nothing in it.

# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
# *:/opt/oracle920:N
# *:/opt/oracle920:N
*:/opt/oracle920:N

Can I manually update it with the service that I need to see, and if so can you post the sintax.

The listener is also in it's default location /opt/oracle920/network/admin - it's contents are

PORTALS =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = tcp)
(Host = )
(Port = 10001)
)
)

SID_LIST_PORTALS =
(SID_LIST =
(SID_DESC =
(SID_NAME = PORTALS)
(ORACLE_HOME = /opt/oracle920)
)
)

T01 =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = tcp)
(Host = 10.0.0.101)
(Port = 11001)
)
)

SID_LIST_T01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = T01)
(ORACLE_HOME = /opt/oracle920)
)
)
and the TNSnames.ora is
T01 = (DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)
(PORT=11001)))(CONNECT_DATA=(SID=T01)))

thomas =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.0.0.101)
(Port = 9001)
)
(CONNECT_DATA = (SID = THOMAS))
)


teach57 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.23.0.6)
(Port = 11057)
)
(CONNECT_DATA = (SID = T57))
)

teach37 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.23.0.6)
(Port = 11037)
)
(CONNECT_DATA = (SID = T37))
)

PORTALS.WORLD =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.0.0.101)
(PORT = 10001)
)
(CONNECT_DATA = (SID = PORTALS))

They all look fine to me, and there isn't a connectivity problem as I can connect to PORTALS when I am stand alone,

Thanks for your continuing help.

Alison

You can manually edit the oratab file and it should have an entry for each database in the form of

INSTANCE_NAME:ORACLE_HOME:STARTUP_FLAG

eg

TESTDB:/home/oracle/product/9.2.0.1:Y

Once you've added those entries try removeing the services.ora and snmp*.ora files and stopping and restarting the agent. Once you've done that check to see if the entries are recorded in the services.ora file.

Regards

Sorry still no joy - the oratab file now looks like the one below, but still no mention in the services.ora file

#

# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
# *:/opt/oracle920:N
# *:/opt/oracle920:N
*:/opt/oracle920:N
portals:/opt/oracle920:Y

Not sure if this is important but you should probably match the case in the oratab file to that of the listener defintion.

Also have you tried defining the GLOBAL_DBNAME in the listener eg.

Code:

---

(SID_DESC =
  (GLOBAL_DBNAME = TESTDB)
  (ORACLE_HOME = /oracle/app/oracle/product/9.2.0.1)
  (SID_NAME = TESTDB)
)

---

Intelligent Agent is not so 'intelligent' me thinks :)

Regards

Sorry still no joy - and no it's not very intelegent.

A

Jovery

Thanks for all your help, any further feedback from anyone would be appreciated.

I was asked by a colleague to run the following command:

ora920@cream:~$ oemctl status oms sysman/manager

To stop the management server - unfortunately it gave me the following error.

SIGSEGV 11* segmentation violation
stackbase=BFFFF0EC, stackpointer=BFFFD4A4

Full thread dump:
"SIGQUIT handler" (TID:0x421a62a0, sys_thread_t:0x823b578, state:R, thread_t
: t@2051, sp:0x0 threadID:0x267b, stack_base:0xbf5ffaa0, stack_size:0x200000) pr
io=1075701408
"Finalizer thread" (TID:0x421a6088, sys_thread_t:0x823b450, state:CW, thread
_t: t@1026, sp:0x0 threadID:0x267a, stack_base:0xbf7ffaa0, stack_size:0x200000)
prio=1075701408
"main" (TID:0x421a60b0, sys_thread_t:0x8227710, state:R, thread_t: t@1024, s
p:0x0 threadID:0x266d, stack_base:0xbffff0ec, stack_size:0x200000) prio=10757014
08 *current thread*
java.lang.System.initializeSystemClass(System.java)
Monitor Cache Dump:
Registered Monitor Dump:
Thread queue lock:
Name and type hash table lock:
String intern lock:
JNI pinning lock:
JNI global reference lock:
BinClass lock:
Class loading lock:
Java stack lock:
Code rewrite lock:
Heap lock:
Has finalization queue lock:
Finalize me queue lock:
Waiting to be notified:
"Finalizer thread" (0x823b450)
Monitor registry: owner "main" (0x8227710, 1 entry)
Aborted

I'm sure you have looked at this before but I thought I would mention it anyway. Can you connect to the database on the linux server from another machine? Can you connect to the database on the linux server from the Oracle management machine using sqlplus? Have you tried to ping the linux machine using the computer name? If you are trying to run the management server on windows, I'm not sure why you would look at the oratab file on the linux machine. Either the listener on the linux machine works or it doesn't. Just a few thoughts.

Quote:

---

Originally posted by gandolf989
I'm sure you have looked at this before but I thought I would mention it anyway. Can you connect to the database on the linux server from another machine? Can you connect to the database on the linux server from the Oracle management machine using sqlplus? Have you tried to ping the linux machine using the computer name? If you are trying to run the management server on windows, I'm not sure why you would look at the oratab file on the linux machine. Either the listener on the linux machine works or it doesn't. Just a few thoughts.

---

Just to clarify....

The reason we looked at the oratab file on the Linux host was because it is the discovery of the services on that host that is failing. The intelligent agent which runs on that host is failing to populate the services.ora correctly which is what is used by the OEM management console for discovery. In order for the Intelligent agent to detect sevices it first reads the oratab file on it's local host no matter where the OEM console resides.

Hope that makes sense

Regards

I should have assumed that you tried all of the simple things first.

Thanks gandolf989

Looking though the thread - is there anything that I should have tried that I haven't?

Any help would be great as this is becoming a real problem.

Many thanks

A

Managed to sort it out, there was a problem with the listener, the listener.ora file was just wrong - which is strange because when I went in to OEM stand alone I could look after the database.

Anyway, I created a listener.ora file on my local laptop (pretending I was on the Linex machine) using configuration assistant, and copied the file to the Linex box, stopped and started the Listener and stoped and started the agent.

The portals database now shows up in my service.ora file, and I can see it through Management Server.

Thanks to everyone for there help.

A