Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ONAMES questions....
Remember, It's never oracle's fault... always blame the network ;)
Anyway, Oracle Names is similar to DNS. It uses port 1575 by default but is configurable. Check your sqlnet.ora file.
BTW, for sqlnet traffic, I hope the firewall is configured as a sql*net proxy. You just can't open up ports. You will also need to use a connection manager. Lots of good info on this in the Net Admn guide and on metalink.
Later,
Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
"The box said I needed to have windows 98 or better...So I installed linux."
bthater2_at_netscape. net To: oracle-l_at_freelists.org Sent by: cc: oracle-l-bounce_at_fr Subject: ONAMES questions.... eelists.org 04/03/2004 09:43 AM Please respond to oracle-l
OK, so in the process of the outsourcing at my current gig, they've decided to move us from the company offices to the local offices of the contracting company i work for. not a problem, right? NOT.
we use ONAMES to connect to all the databases. so no tnsnames.ora file. now if i understand correctly ONAMES works kind of like a DNS for the databases. that is a request will be made to the ONAMES server for the address where the SID you're connecting to is located and it will return that information which is used to make another request for the actual connection to the database. is my understanding correct? does it return the information on the same port the request is made on?
i'm thinking there a major firewall issues in play here, but i keep being told it's Oracle's fault.
thanks,
Bill " Shrek" Thater