Link to home
Start Free TrialLog in
Avatar of vsuripeddi
vsuripeddi

asked on

tnsnames.ora file --- including port along with Hostname/ IP address

Can we include the port along with the IP address in tnsnames.ora file to connect to an IP address across a port (not in the same LAN network) ?

eg: HOST = 204.56.64.12 65012 (PORT = 1521)

or HOST = 204.56.64.12  (PORT = 65012)

both the above the examples did not work for me ,

any ideas/inputs/suggestions ?

(Btw, do we always need PORT =1521 to be included for oracle ? or are there any alternatives) ?

SOLUTION
Avatar of jdlambert1
jdlambert1
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial