RE: spfile/listener question

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Mon, 28 Jun 2004 18:40:54 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77C94D@louis.cerebrus.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott.Shafer_at_dcpds.cpms.osd.mil
Sent: 28 June 2004 18:31
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jun 28 2004 - 12:33:46 CDT