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
Version TNSLSNR for Linux: Version 188.8.131.52.0 - Production
Start Date 19-NOV-2002 11:58:53
Uptime 15 days 22 hr. 9 min. 26 sec
Trace Level off
Listener Parameter File /home/portals/NETWORK/ADMIN/listener.ora
Listener Log File /opt/oracle920/network/log/listener.log
Listening Endpoints 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)
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.
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.
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.
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
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"