RE: spfile/listener question

  • From: Feighery Raymond <Raymond.Feighery@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Jun 2004 09:13:39 +0100

You haven't started the listener.
Dynamic registration via the init.ora file means you don't have to modify
the listener.ora for each new database entry (e.g. you don't have to add an
extra SID_LIST entry). However, you still have to define the LISTENER in the
listener.ora for the listener itself and start it.

Ray

-----Original Message-----
From: Scott.Shafer@xxxxxxxxxxxxxxxxxx
[mailto:Scott.Shafer@xxxxxxxxxxxxxxxxxx] 
Sent: Monday, June 28, 2004 6:31 PM
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=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' 

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=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1421))
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

___________________________________________________________________________ 


This email and any attached to it are confidential and intended only for the
individual or entity to which it is addressed.  If you are not the intended
recipient, please let us know by telephoning or emailing the sender.  You
should also delete the email and any attachment from your systems and should
not copy the email or any attachment or disclose their content to any other
person or entity.  The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 

Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: