Solved

oracle - multiple databases and multiple listeners

Posted on 2011-09-21
7
576 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 69

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 77

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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 69

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 77

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

679 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