Re: RE: New Listener Question

2001-07-18 Thread Jon Walthour
; > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:52 PM > > To: Multiple recipi

RE: RE: New Listener Question

2001-07-18 Thread Deshpande, Kirti
Sent: Wednesday, July 18, 2001 1:52 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: New Listener Question > > instance_name has default value ORACLE_SID and service_name has default > value db_name.db_domain - so you do not need to define these paramete

RE: New Listener Question

2001-07-18 Thread Mike J Kurth
According to the doc, the default value for service_names is db_name.db_domain. Shouldn't the default value be sufficient? (I haven't actually tried it yet). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Se

RE: RE: New Listener Question

2001-07-18 Thread Hillman, Alex
instance_name has default value ORACLE_SID and service_name has default value db_name.db_domain - so you do not need to define these parameters for dynamic service registration. Alex Hillman -Original Message- Sent: Wednesday, July 18, 2001 2:25 PM To: Multiple recipients of list ORACLE-

RE: New Listener Question

2001-07-18 Thread Glenn Travis
You are right, sir! I stand corrected. and thanks! -Original Message- Wilton Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L On Wed, 18 Jul 2001, Glenn Travis wrote: > I disagree. Mine only registers itself if I have the "service_names" entry > in the

RE: RE: New Listener Question

2001-07-18 Thread Jon Walthour
Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour >--- Original Message --- >F

RE: New Listener Question

2001-07-18 Thread Jeremiah Wilton
On Wed, 18 Jul 2001, Glenn Travis wrote: > I disagree. Mine only registers itself if I have the "service_names" entry > in the init.ora file. Comment this line out and see what happens... Actually, the parameter that controls instance registration with listeners for dedicated server is LOCAL_L

RE: New Listener Question

2001-07-18 Thread Glenn Travis
I disagree. Mine only registers itself if I have the "service_names" entry in the init.ora file. Comment this line out and see what happens... -Original Message- Smith Sent: Tuesday, July 17, 2001 1:31 PM To: Multiple recipients of list ORACLE-L In Oracle 8i a database will self regis

RE: New Listener Question

2001-07-17 Thread Kimberly Smith
In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L First Off,

Re: New Listener Question

2001-07-17 Thread Jay Hostetter
With 8i, the databases automatically register with the listener. You can disable it by pointing to a port that is not used by a listener. In the initSID.ora put the following entry: local_listener = "(address = (protocol = tcp)(host = mymachine.mydomain.com)(port = 1522))" Jay Hostetter O

RE: New Listener Question

2001-07-17 Thread Hillman, Alex
In 8i you do not need to include services in the listener. Listener itself can find out what databases are running and need it services Alex Hillman -Original Message- Sent: Tuesday, July 17, 2001 12:35 PM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyo