Hi, I want to understand listener.ora, tnsnames.ora and lsnrctl. How to
set them up properly and 'nuances' such as SID vs. instance_name
vs. service_names vs. db_name (which are all set to the same thing in my
config). Also I guess global_names is related.

I can send all the relevant files (I think), but like I said, I would like
to get to grips with this problem. (I get error messages via tnsping).

Can someone please point to a document that covers these issues? (the
simpler the better!).

All the best,
Dan.

On Tue, 9 Nov 2004 18:35:01 +0000, Dan Bolser <dmb@mrc-dunn.cam.ac.uk>
wrote:

>
>Hi, I want to understand listener.ora, tnsnames.ora and lsnrctl. How to
>set them up properly and 'nuances' such as SID vs. instance_name
>vs. service_names vs. db_name (which are all set to the same thing in my
>config). Also I guess global_names is related.
>
>I can send all the relevant files (I think), but like I said, I would like
>to get to grips with this problem. (I get error messages via tnsping).
>
>Can someone please point to a document that covers these issues? (the
>simpler the better!).
>
>All the best,
>Dan.


online net administrator manual should do.


--
Sybrand Bakker, Senior Oracle DBA

On Tue, 9 Nov 2004, Dan Bolser wrote:

>
>Hi, I want to understand listener.ora, tnsnames.ora and lsnrctl. How to
>set them up properly and 'nuances' such as SID vs. instance_name
>vs. service_names vs. db_name (which are all set to the same thing in my
>config). Also I guess global_names is related.
>
>I can send all the relevant files (I think), but like I said, I would like
>to get to grips with this problem. (I get error messages via tnsping).
>
>Can someone please point to a document that covers these issues? (the
>simpler the better!).
>

Well... I found

http://download-uk.oracle.com/docs/h...n.htm#sthref59

and

bin/netca


And then I poked around for a long time...

I have tnsping working now, but please don't ask me how...



>All the best,
>Dan.
>
>