Sorry, remove the DESCRIPTION part. The correct syntax should be: alter system set local_listener="(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))"; Tanel. ----- Original Message ----- From: "Tanel Põder" <tanel.poder.003@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Monday, June 28, 2004 8:44 PM Subject: Re: spfile/listener question > Try to set the LOCAL_LISTENER to "DESCRIPTION= > (ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421))" instead of tns alias. > > Tanel. > > ----- Original Message ----- > From: <Scott.Shafer@xxxxxxxxxxxxxxxxxx> > To: <oracle-l@xxxxxxxxxxxxx> > Sent: Monday, June 28, 2004 8:30 PM > Subject: spfile/listener question > > > > Odd question time: > > RTFM'd until we're blue, but we can't get the listener services to > register > > when specified in the init.ora vs a listener.ora file. HR Apps 11.5.7 on > > Oracle 9.2.0.5, HPUX 11.11. > > > > We're trying to set the listener in the init.ora/spfile using the > > parameters: > > LOCAL_LISTENER=db1 > > SERVICE_NAMES=db1.us.acme.com > > INSTANCE_NAME=db1 > > > > tnsnames.ora entry looks like: > > db1= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421))) > > > > As SYSDBA we've done the: > > ALTER SYSTEM SET LOCAL_LISTENER='db1' > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------