Problems configuring Listener.ora

[TBou]

I am having difficulty configuring the listener.ora
to access data from another Non-Oracle bank

This to configure the bank to access a Postgre base

99]] I already set the tnsnames.ora

Select all

 
SEMEADOR = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.136)(PORT = 5432)) 
    (CONNECT_DATA = (SERVICE_NAME=SEME) 
    ) 
    (HS = OK) 
  ) 
 

I also set the listener.ora in the listener frame

Select all

 
        (ADDRESS=  
          (PROTOCOL= TCP) 
          (Host= 192.168.100.136) 
          (Port= 5432) 
        ) 
 

Now I do not know what I put in Parameters Oracle_Home, Program, Listener's Envs.ORA in the sid_list_listener frame

Select all

 
    (SID_DESC = 
      (SID_NAME = SEME) 
      (ORACLE_HOME=/home/oracle/megbase/9.0.1) 
      (PROGRAM = tg4mb80) 
      (ENVS=LD_LIBRARY_PATH=non_oracle_system_lib_directory) 
    ) 

I took the link example http://download-east.oracle.com/docs/cd ... m#i1005982

[gilbertoca]

Dude the thing is harder than I thought! : Shock:
Next, for you to access a non-oracle data source, you need to install in an MQ or even in the MQ on which is the installation of the non-oracle source, in this case PostgreSQL, the connection features Through gateways.
This source http://forums.oracle.com/forums/thread. ... ID=1323825 explains how to install and configure to access the MSSQLServer bank.

I looked in the documentation for a gateway for PostgreSQL and I did not find it. Then the alternative is through the generic gateway. Here is the source http://download-east.oracle.com/docs/cd ... m#i1005931

I hope it helps!