RE: spfile/listener question
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Jun 2004 14:34:55 -0400
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@xxxxxxxxxxxxxxxxxx
[mailto:Scott.Shafer@xxxxxxxxxxxxxxxxxx]=20
Sent: Monday, June 28, 2004 2:33 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx]
> 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.
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
