Solved

oracle - multiple databases and multiple listeners

Posted on 2011-09-21
7
577 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 70

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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 70

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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql views 3 57
Dbms_job.change procedure 16 37
how to resize column length with primary ket 4 34
Set a variable value in SQL Procedure 3 26
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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…

752 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