473,695 Members | 1,901 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Strategy and simple Listener Problem Xplained once more..

sir,

I have a small error in Listener configuration.I have two system with
a database in each. I am using Red Hat 9 and Oracle 9i. so i shall
anme the database and system.
system 1 - node2 system 2 - node3
database - apple database - intel

i have installed Oracle on 'node3' by copying the files and then
creating a new database in it. Now i want to configure listener. I
want to have the control of 'intel' database on 'node2' and 'apple'
database on 'node3'.

Since each oracle user have database, a basic listener for local
database is already configured. Now my query is about some
clarifications abt Listener Configuration.

1) I took netmgr on 'node2' and added 'intel' in the service name then
onto the same basic listener.i have given default 1521 as port for
both databse but differrent hostname. now when i give

[oracle@node2 oracle]$ lsnrctl start Listener

'apple' database is started while i get the following error for intel.

TNS-12560 TNS : Protocol adapter error
TNS-00530 TNS : Protocol adapter error
Linux - 113 - No route to host

Wats the problem?? Did i do anything wrong ? I even tried the whole
procedure vice versa on 'node3'. At that time 'apple' database got the
above error. pls a guidance needed..

2) Now i changed my strategy after getting the above errors. i thought
of giving each database a listener. so 'node2' and 'node3' have 2
listeners - 1 for local database and 1 for the other. In this case i
had to give different ports for each Listener. I was successfully able
to start the local database listener but unfortunately i am getting
above error w.r.t other system's database.
Can u help me wat is the cause of error ?

3) if u couldnt get my problems, can u guide me in configuring
Listener so that i can access both database from either system..?

pls reply me URGENTLY.... Thanx in advance

regards,
Cherrish Vaidiyan
Jul 19 '05 #1
1 3735
Cherrish Vaidiyan wrote:
sir,

I have a small error in Listener configuration.I have two system with
a database in each. I am using Red Hat 9 and Oracle 9i. so i shall
anme the database and system.
system 1 - node2 system 2 - node3
database - apple database - intel

i have installed Oracle on 'node3' by copying the files and then
creating a new database in it. Now i want to configure listener. I
want to have the control of 'intel' database on 'node2' and 'apple'
database on 'node3'.

Since each oracle user have database, a basic listener for local
database is already configured. Now my query is about some
clarifications abt Listener Configuration.

1) I took netmgr on 'node2' and added 'intel' in the service name then
onto the same basic listener.i have given default 1521 as port for
both databse but differrent hostname. now when i give

[oracle@node2 oracle]$ lsnrctl start Listener

'apple' database is started while i get the following error for intel.

TNS-12560 TNS : Protocol adapter error
TNS-00530 TNS : Protocol adapter error
Linux - 113 - No route to host

Wats the problem?? Did i do anything wrong ? I even tried the whole
procedure vice versa on 'node3'. At that time 'apple' database got the
above error. pls a guidance needed..

2) Now i changed my strategy after getting the above errors. i thought
of giving each database a listener. so 'node2' and 'node3' have 2
listeners - 1 for local database and 1 for the other. In this case i
had to give different ports for each Listener. I was successfully able
to start the local database listener but unfortunately i am getting
above error w.r.t other system's database.
Can u help me wat is the cause of error ?

3) if u couldnt get my problems, can u guide me in configuring
Listener so that i can access both database from either system..?

pls reply me URGENTLY.... Thanx in advance

regards,
Cherrish Vaidiyan


Hopefully I can shed some light on this situation for you.
I support around 4 dozen Oracle DB spread across a decent
number of Solaris systems; where each system has one or more DBs.

I run a single listener on each system which handles connection
requests for the DBs which are local to that system. By doing
this ANY client, which also includes "remote" DBs, can access
any DB in the network.

While it is possible to run a listener on Node A to handle
connection requests for a database on Node B, I refuse to
do this. My problem with this type of configuration is that
troubleshooting is slightly more difficult & you now have
two separate points of possible failure. You only need a
single listener for any DB.
Keep in mind that a listener is NOT required to run and access
the database; assuming that you are logged directly onto the
database server itself. The listener only is required when
you want to access the DB from a remote (non-local) system.
Also the listener only INITIATES the connection and then is
no longer involved. In other words once a connection to the
remote database has been made, you can shutdown the listener
and the remote session will continue to function.

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3021
by: Steve Jorgensen | last post by:
I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not coming to a firm conclusion over whether it was the better approach, and wonder if I should do it differently the next time I'm faced with a similar issue. I needed an app to automatically import from spreadsheets with a semi-dynamic structure,...
0
2542
by: Cyrille \cns\ Szymanski | last post by:
Hello, I'm benchmarking .NET IO Completion Ports in C#. For that purpose I've written two basic ECHO servers that I'm testing under high load (over 2.000 clients). IOCP in .Net is fantastic, the code is very straightforward and clean, except that I'm having performance problems. The server is actually slower than a native basic 1 thread per client implementation. I must admit however that when I increase the number of clients to...
1
1761
by: jm | last post by:
Easy probably, please read on. I know some of you have commented already about some of my socket question. I appreciate that. I have a Form1: static void Main() { Application.Run(new Form1()); clsListening.AsynchronousSocketListener.StartListening();
2
1872
by: iwdu15 | last post by:
hey, i was wondering if 1) anyone could tell me whats wrong with my code, i did a little fixing to the msdn version fo this, or 2) how to make a simple program that will connect and listen for connections async. if the user pushes the selected buttons. i just want a program that connects to another computer on the port and IP address selected and if the other computer is listening, then connect to it but this code doesnt work : Imports...
6
9157
by: Steve Teeples | last post by:
I have been perplexed by how to best treat an event that spans different classes. For example, I have a form which a user inputs data. I want to broadcast that data via an event to another class (seen globally) having a data structure which saves that form data to disk. Whenever the form updates the data I'd like to broadcast the information and have it saved in my global data structure. The perplexing thing for me though is the...
6
4702
by: Daniel Santa Cruz | last post by:
Hello all, I've been trying to go over my OO Patterns book, and I decided to try to implement them in Python this time around. I figured this would help me learn the language better. Well, I've gotten stuck with my first go at OO patterns with Python. I guess it goes without say that some of the stuff that are taken for granted in most of the books (ie. Interfaces, Abstract classes) don't really apply to Python per say, but the idea...
25
3398
by: marcin.rzeznicki | last post by:
Hello everyone I've got a little problem with choosing the best decoding strategy for some nasty problem. I have to deal with very large files wich contain text encoded with various encodings. Their length makes loading contents of file into memory in single run inappropriate. I solved this problem by implementing memory mapping using P/Invoke and I load contents of file in chunks. Since files' contents are in different encodings what I...
1
1501
by: klubbhead | last post by:
This part of my program needs to read from 4 parameter files and then displays them on the screen by clicking a different radio button. The program itself works, but my professor says that I have to improve the code in the DescriptionPanel 's listener because there are several lines of code that are identical and I should only have them once. Here is the code: import javax.swing.*; import java.awt.*; import java.awt.event.*; import...
1
221
by: Cherrish Vaidiyan | last post by:
sir, I have a small error in Listener configuration.I have two system with a database in each. I am using Red Hat 9 and Oracle 9i. so i shall anme the database and system. system 1 - node2 system 2 - node3 database - apple database - intel i have installed Oracle on 'node3' by copying the files and then creating a new database in it. Now i want to configure listener. I
0
8630
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9115
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8982
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8845
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8825
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7660
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3003
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
1976
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.