I have a problem with oracle 11g on RHEL 5.6. I did create two new databases and schema. when I try to connect I get "TNS listener does not know of SID ....." not sure the exact message. I figure out that I should set up a listener. Could you tell us how to set up new listeners for two databases so they can up and running?
I also want to access these two databases with SID and Service_name.