| tnsnames question [message #63213] |
Sat, 18 September 2004 18:15  |
chetna
Messages: 21
Registered: July 2004
|
Junior Member |
|
|
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) ?
Thanks
|
|
|
|
| Re: tnsnames question [message #63216 is a reply to message #63213] |
Sun, 19 September 2004 06:42  |
easywebtech.com
Messages: 6
Registered: September 2004
|
Junior Member |
|
|
yes, you can include the port like this
.....
(ADDRESS = (PROTOCOL = TCP)(HOST =HOST-IP)
(PORT = 1521)).
You can use any port other than 1521.
For that you need to listen to that port from the server, Hence you need to cahnge listener.ora
webmaster
www.easywebtech.com
|
|
|
|
| Re: tnsnames question [message #63217 is a reply to message #63216] |
Sun, 19 September 2004 13:57 |
chetna
Messages: 21
Registered: July 2004
|
Junior Member |
|
|
thank u very much.
Can we listen on Dynamic and/or Private Ports are those from 49152 through 65535 ?
Or is there a valid range of ports on which Oracle can listen ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
