Strategy and simple Listener Problem Xplained once more..

Cherrish Vaidiyan

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

Subscribe Reply

3737

Ana C. Dent

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

Similar topics

3023

Import/Normalize strategy - More issues - New thread

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,...

Microsoft Access / VBA

2545

IOCP io strategy benchmarking

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...

C# / C Sharp

1761

Not understanding Sockets Probably Simple

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();

C# / C Sharp

1873

simple connect

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...

Visual Basic .NET

9158

An Event Listener

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...

C# / C Sharp

4705

Strategy Design Pattern

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...

Python

3405

Decoding strategy

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...

C# / C Sharp

1503

Need Help To Edit Simple Program Thanks

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...

Java

221

Strategy and simple Listener Problem Xplained once more..

by: Cherrish Vaidiyan | last post by:

Oracle Database

8801

What is ONU?

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...

General

8707

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9174

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7953

AI Job Threat for Devs

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...

Career Advice

6634

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5947

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4464

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4725

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2520

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP