Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: spfile/listener question

RE: spfile/listener question

From: Graeme Farmer <>
Date: Tue, 29 Jun 2004 20:40:23 +1000
Message-ID: <>

It is not essential to have a listener.ora, provided you want to have the listener run on the default port (1521) it will start up without a config file.

HOWEVER, that would NOT be a good idea as changing from the default port is mandatory from a security perspective, as is setting a password, admin restrictions, etc, etc...

When using a non-default port, then automatic listener registration is only possible via the LOCAL_LISTENER parameter in (s)pfile. This can be set to a TNS alias that resolves to the correct host/port combination or you can enter a connect descriptor; and, as Ray pointed out, the listener needs to be started prior to any registration or indeed listening taking place!


-----Original Message-----

From: Feighery Raymond [] Sent: Tuesday, 29 June 2004 6:14 PM
To: ''
Subject: RE: spfile/listener question

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.


-----Original Message-----

[] Sent: Monday, June 28, 2004 6:31 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, HPUX 11.11.

We're trying to set the listener in the init.ora/spfile using the parameters:

tnsnames.ora entry looks like:
db1= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421)))

As SYSDBA we've done the:

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)( 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?



Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at

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:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at


This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Tue Jun 29 2004 - 05:37:42 CDT

Original text of this message