Alter system register; should get it to see it, but doesn't explain why you cant get it normally on startup -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Scott.Shafer@xxxxxxxxxxxxxxxxxx Sent: 28 June 2004 18:31 To: oracle-l@xxxxxxxxxxxxx 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=3Ddb1 SERVICE_NAMES=3Ddb1.us.acme.com INSTANCE_NAME=3Ddb1 tnsnames.ora entry looks like: db1=3D (DESCRIPTION=3D = (ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3Ddbserver)(PORT=3D1421))) As SYSDBA we've done the: ALTER SYSTEM SET LOCAL_LISTENER=3D'db1'=20 When we check the listener via lsnrctl we can not detect the services. $TNS_ADMIN is set correctly. LSNRCTL> set current_listener db1 LSNRCTL> services Connecting to = (ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dxxx.xxx.xxx.xxx)(PORT=3D1421)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener HPUX Error: 239: Connection refused Anyone out there gone through this exercise successfully? Thanks, Scott ---------------------------------------------------------------- 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 -----------------------------------------------------------------