Solved

how to configure listener on oracle client server RHEL 5

Posted on 2011-10-01
22
896 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
 
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 47

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 34

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 34

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 34

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 34

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 76

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 76

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 34

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 76

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now