[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

how to configure listener on oracle client server RHEL 5

Posted on 2011-10-01
22
Medium Priority
?
929 Views
Last Modified: 2013-11-11
Hi,

i want to configure oracle 11gR2 client to listen on port 1522 and forward the request to oracle database over 1521 port.

Is there a procedure to do the same.

-prakash
0
Comment
Question by:prak_seafarer
  • 8
  • 5
  • 4
  • +3
22 Comments
 
LVL 13

Expert Comment

by:George K.
ID: 36896558
Normally you should find the listener.ora file in
$ORACLE_HOME/network/admin forin UNIX systems
and  in %ORACLE_HOME%\network\admin directory for Windows

In this file, you can see as following where to change port number
LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=this-server)(PORT=1521))
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36896675
oracle listener service is only available in database. client does not have this service. So by creating a listener.ora also how will the client listen to the incoming request. i have observed that the port 1521 on the client machine does not start so incoming request would be dropped by the server as the port is not up.

-prakash
0
 
LVL 13

Expert Comment

by:George K.
ID: 36896682
Also see Oracle Connection Manager by which port redirection is configured.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 13

Expert Comment

by:George K.
ID: 36896700
This link might provide you with some more aspects to consider: http://download.oracle.com/docs/cd/E11857_01/install.111/e15838/appdx_setting_up_ssh.htm
0
 
LVL 48

Expert Comment

by:schwertner
ID: 36902759
Client never listens on some port. It is only used to establish and to provide connection to some Oracle instances and to allow some administrative and service functions, like running SQL*Plus, etc.
On Oracle server you can have more then one Listeners each of that listens on one particular port, but different listeners can use  different ports.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 36905912
No, you do not configure listeners on Oracle client machines.  Oracle listeners are only configured on Oracle database server machines.  You can configure the listener to use a non-default port if you want to.  Then you can configure the Oracle clients to use the same non-default port as the listener.
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36908525
my setup is like this,

app server -> oracle client server -> oracle database.

This is how my setup needs to be. No direct communication with database. So for this app server needs to send the request to oracle client means a listener should be there to receive the request.

if i install oracle database software only, then is there any configuration which i can do to forward the incoming request to the main database server. i need a configuration which starts a listener instance for forwarding the requests.

-prakash
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 36910302
The usual configuration for Oracle is like this:

web client  -> app server -> oracle database.

Neither you nor I get to determine how Oracle works.  If you choose to use an Oracle database, you will have to use it how the Oracle corporation designs it to be used.  That is, the database listener runs on the database server (only).   The application server needs to have the Oracle client software installed so it can connect to the listener on the database server.  The application server maintains a direct connection to the database server.

Please help us understand why you think you should have a different configuration that what Oracle support.  If you explain the problem, we may be able to help you find a solution.
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36910367
I am using a oracle RAC setup but one of my application does not allow me to use the RAC configuration. So i have to supply only one ip address and port number. I want to create a gateway like server to which the request can sent which in turn will send the request to the RAC server and do a HA and load balancing.

This is a third party app and the configuration wizard tries to directly connect to the db instance. i want to make the app work with oracle RAC too.

-prakash
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 36910554
It sounds like the tool you need is a "Load Balancer".  I'm not an expert on these, but I think they can listen for requests for a single IP address and direct them to either of two (or possibly three or more) different targets.
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36911938
its not a load balancer but the application is developed for non RAC database. i have to make it work with RAC.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 36912388
Does your application use an Oracle client to connect to your Oracle database?  If yes, you can configure a single TNS entry in the tnsnames.ora file on your application server to connect to either RAC database node, like this example:

prod =
        (DESCRIPTION=
            (ADDRESS_LIST=
                (LOAD_BALANCE=YES)
                (FAILOVER=YES)
                (ADDRESS=(PROTOCOL=tcp)(HOST=host1-vip.organization.com)(PORT=1521))
                (ADDRESS=(PROTOCOL=tcp)(HOST=host2-vip.organization.com)(PORT=1521))
            )
            (CONNECT_DATA=
                (SERVICE_NAME=prod)
            )
        )

(Just replace "host" and "organization" on the two "(ADDRESS...) lines with values that are valid in your system, and of course, make sure the port number is valid in your system.)

If your application doesn't use an Oracle client, you may need to work with the application vendor to see if they offer you a way to connect toan Oracle RAC database.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36916835
I'm far from a RAC expert but it is supposed to have a virtual IP configuration:

http://download.oracle.com/docs/cd/B28359_01/rac.111/b28255/intro.htm

Oracle Clusterware manages all of the Oracle Database processes automatically. Anything that Oracle Clusterware manages is known as a cluster resource, which could be a database, an instance, a service, a listener, a virtual IP (VIP) address, an application process, and so on.
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36917373
RAC has two virtual ip's. the issue is that the app which i have does not respond to the service name. it responds to the sid. so using vip directly also is not possible.

i was wondering if a heterogeneous link can be configured for the oracle db might be of help so if anyone can help me with the configuration for oracle link configuration creation through netmgr would be helpful

 
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36917787
>>it responds to the sid

sid or ALIAS configured in the tnsnames.ora file?

The power of RAC is that you do not know you are connecting to a 'cluster'.  You see it as a single database.  A single node can go down and applications don't even know.

I'm not sure why the app is having an issue unless the RAC install isn't set up properly.
0
 
LVL 3

Author Comment

by:prak_seafarer
ID: 36918817
it tries to trigger the direct connection line sqlplus system/pwd@hostname:1521:sid

and this behaviour i cant change. And when this type of command is triggered the connection fails with no sid found error.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 36918907
Then, as I said earlier, you may need to work with the application vendor to see if they offer you a way to connect to an Oracle RAC database.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36918968
I wonder if you add a local HOST entry replacing 'hostname' with the virtual IP for the cluster?
0
 
LVL 3

Accepted Solution

by:
prak_seafarer earned 0 total points
ID: 36919059
i give the ip address instead of hostname
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36919119
I'm not a RAC Expert and have only played with it a little but if everything is set up properly for the cluster, it should work.

If it didn't, RAC really doesn't work as designed.  If you have Oracle Support I would work directly with them to make sure everything is set up as it should be.

I'll defer to RAC Experts since this is now over my abilities but leave you with this link to verify the listeners are set up properly:
http://www.dannorris.com/2008/07/21/tns-listener-configuration-for-oracle-rac/
0
 
LVL 3

Author Closing Comment

by:prak_seafarer
ID: 36967130
No possible solution found. have contacted oracle support.
0
 
LVL 3

Expert Comment

by:johnsmith1962
ID: 37332309
Do you have the ability to modify the connect string?  Can you use a tns entry instead of the jdbc connect string?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month17 days, 16 hours left to enroll

831 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