However, I do not know how I can connect to my test database. I only have one Oracle Home directory, and one portlist.ini file, with one relevant port number. How does it know which database to connect to and how can I set both up? I know I can't view both through one session, but I must be able to see them separately surely?
Ah, this would make sense. I realised that you cannot see many databases within one db console, for that you need Grid Control, but I didn't know that you could not have more than one dbconsole per server.
Sorry for the confusion. I don't know that you "Can't" have more than one DBConsole per server. In my shop we decided we didn't "want" more than one DBConsole running per server because of the performance impacts. The seperate DBConsoles did not play well together.
It is possible to have more than one DBConsole running per server - we have 4 on one of ours (one per database).
What OS are you running on and what version of the database? When we tried with 10.2.0.3 on AIX 5.2, we ran into a lot of performance issues and dbconsole hangs. That was with just two or three DBConsoles running. we have a couple of servers with 10-15 databases, so we went the Grid Control path instead.
Just intereted in hearing more on your experiences with dbconsole.