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 -----------------------------------------------------------------