Re: tnsnames.ora, listener.ora examples

>2 things:
>1. Oracle7 defaults to PORT=1521

Yeah, but I'm paranoid enough not to use the default settings. (It probably doesn't make much difference, but it works for me).

>2. i always use HOST names, HOST=dbhost, instead of IP addresses.
> though, i have found situations where customers do not run DNS
> or do not have their PCs configured properly. at that time,
> i usually configure their PCs.
>

I used to use hostnames until I found that the domain name servers were fairly unreliable in the environments I was working with.

Thanks for adding your examples to the discussion.

Mike

-- 
mmarolda_at_onramp.net
Bristol Database Resources Inc.
http://bdr.com/ - Providing Integrated Oracle and WWW Solutions