Solved

oracle - multiple databases and multiple listeners

Posted on 2011-09-21
7
573 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:luser9999
  • 3
  • 2
  • 2
7 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 36579060
I can give only generic advice ATM.
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.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36580077
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.
0
 

Author Comment

by:luser9999
ID: 36708600
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
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 68

Assisted Solution

by:Qlemo
Qlemo earned 250 total points
ID: 36708643
It depends. Using different schemas is fine if you want to keep administration simple and a shared memory scenario, that is the instance dynamically decides which of the "databases" to give more memory.
Using different instances is better if you want to keep the data strictly separated from each other, or have more control over how memory is split between the databases.
Remember: Oracle allocates the memory you configure it to allocate, no matter if the memory is needed or not. So 2x 2GB instances might perform worse than 1x 4GB instance.

I would start with a single instance, as that is a much simpler case for administration and maintenance. Should you get into performance issues, splitting it into separate instances is an option.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 36709079
The design is up to you.  You need to look at the individual requirements of the systems.

For example, what happens if a developer runs a bad command in their schema that fills up resources.  Can the other database become unavailable?

You also have backup and recovery concerns.

If the databases are in no way related to one another I might be tempted to build two.  Although this is outside the scope of the question asked.


Back to the question:  
>>So only one listener for all databases.

Yes.  One listener can handle many databases.
0
 

Accepted Solution

by:
luser9999 earned 0 total points
ID: 37029574
I will work on it, thanks
0
 

Author Closing Comment

by:luser9999
ID: 37052416
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now