Help :: TNSNAMES (Client and Server)

[Trevisolli]

Guys, good morning.

I need a help from the DBA's on duty, and even the developers, as they probably have passed through this.


Situation: At first it was installed on my machine C:\oracle, Client of Oracle + Forms + Reports and, in this way access to company bases (such as Client ), without major problems.

But, I had to install a local bank for the development of a projects at home (C: \ oro8i) and, I realized that my SQL Navigator did not access the company's banks.

Reason: SQL "Search" tnsnames of the last facility and, in this there are no banks.

In this last folder, I played above, TNSNames, SQLNET and Listener, so I was able to access the company's banks, but even adding the local address on tnsnames, it does not access the bank of my machine also.

Someone could give me a Help: ???

I have to change Listener, SQLNET ??? Positive case, someone would have an example.

Very grateful,

Trevisolli

[dr_gori]

Strange.
send tnsnames there to look at.

[erthal]

Noble friend,

Three things, for you to use Oracle as server on your machine, this must have fixed IP.

Second you will need to have in your TNSNAMES information about the company's banks and another on the bank that is on your machine.

Third, the listener is installed in the server, so on your machine, and on it should only have Pro Server input that is installed on your machine.

With this correctly configured, everything will work out.

Hugs,

[smarcos]

TNSNAMES is the center of the problem.
You can access how many banks exist in your company. As long as they are set correctly.

In the example below we are accessing 3 different banks in 3 different machines. These banks have the same name in their respective servers but with different alias for calls of a single machine where this tnsnames is:

Select all

MF1= 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.13)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = MF) 
    ) 
  ) 
MF2 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.12)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = MF) 
    ) 
  ) 
 
MF3 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.10)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = MF) 
    ) 
  )