DB 9i Link to 10g

[rafaellomba]

Personal,

In my work I will need a bank 9i communicates with a 10g bank. I can create the 9i link db for 10g without errors, but when I try to use it it shows an error saying that the tns names can not solve, but I can connect to Banco 9i and 10g without problems with the TNS.

Has anyone ever been through this situation and already managed to solve it?

From now on, thank you.

[ricardofazu]

How is your TNS on the machine that is installed the 9i?
Post that we can help better I believe.

[rafaellomba]

My machine is ok, because I can access the banks normally, even so below is the code of my TNS.

Select all

 
prod= 
 (DESCRIPTION= 
  (ADDRESS_LIST= 
   (ADDRESS= 
    (PROTOCOL=TCP) 
    (HOST=192.168.1.15) 
    (PORT=1521) 
  ) 
 ) 
 (CONNECT_DATA= 
  (SID=prod) 
  ) 
 ) 
 
HM10G = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.58)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = hm10g) 
    ) 
  )

The prod is what is with 9i and HM10G is that it has 10g.

[diegolenhardt]

On the 10G server you have to configure the tnsnames. 99] When this connects, then create dblink with the command:

Select all

 
create public database link banco9i 
  connect to USUARIO identified by "SENHA" 
  using 'BANCO9I'; 

[diegolenhardt]

Is the bank on your machine?

You have to mess with tnnames.ora where Oracle is installed ...

[rafaellomba]

No, the bank is on the database server.
So to work I have to set up the tns names gives machine that is 9i to be able to see the 10g bank?

[diegolenhardt]

exactly ..

=]

[rafaellomba]

I'll make this change and put to say if it worked.

Memo So, thank you.