luser9999
asked on
oracle - multiple databases and multiple listeners
Hi Team,
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.
Please help
thanks
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.
Please help
thanks
You only need one listener, one listener.ora and one tnsnames.ora.
By chance are you coming from a SQL Server background?
Do you really need two databases?
Please post your listener.ora and tnsnames.ora files and the instance names of your databases.
By chance are you coming from a SQL Server background?
Do you really need two databases?
Please post your listener.ora and tnsnames.ora files and the instance names of your databases.
ASKER
So only one listener for all databases.
I need to two databases/schemas
do you think one database with many schemas will work? (In mysql I usally create two different databases , one for Bug tracking tool and another database for CMS)
I will post those shortly
I need to two databases/schemas
do you think one database with many schemas will work? (In mysql I usally create two different databases , one for Bug tracking tool and another database for CMS)
I will post those shortly
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
You set up one listener only per machine. All instances will try to register automatically with that listener, but that might last some time (several minutes), or require a instance restart. If you want to change that, edit the listener.ora file - read the manual regarding that.