| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: spfile/listener question
Scott,
I don't think the intent of the spfile was to do away with the =
listener.ora
file.
Stange thing the init.ora. You can put the listener entry into the =
int.ora
to have the database "self-register" with the listener. In this way, =
you do
not need an entry in the listener.ora file for each database.
But if you are using the intelligent agent for use with Orcle OEM, you =
need
the databases listed in the listener.ora file for the agent to find the
databases. A silly contradiction that someone at Oracle missed.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Scott.Shafer_at_dcpds.cpms.osd.mil
[mailto:Scott.Shafer_at_dcpds.cpms.osd.mil]=20
Sent: Monday, June 28, 2004 2:33 PM
To: oracle-l_at_freelists.org
Subject: RE: spfile/listener question
And that is what is puzzling us... The goal is to get rid of the listener.ora file, and use the spfile only. The way the docs read, the listener should be started at instance startup via the LOCAL_LISTENER init.ora param.
Scott Shafer
-----Original Message-----
From: Tanel P=F5der [mailto:tanel.poder.003_at_mail.ee]
> LSNRCTL> set current_listener db1
> LSNRCTL> services
> Connecting to=20
> (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
Sorry again, I didn't read your post thoroughly enough, but this error message shows that your listener isn't running at all!
Tanel.
-- 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 - 13:31:41 CDT
 |
 |