spfile/listener question
- From: Scott.Shafer@xxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 28 Jun 2004 12:30:57 -0500
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
