RE: spfile/listener question

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 Jun 2004 15:15:03 -0400

Scott,

Are you saying that with the entry below in the init.ora file, you =
database
did not register with the listener after a db bounce?  Did the spfile =
still
exists after th4e db bounce?  If it did, then the init.ora changes were
skipped - the db started using the spfile.

Try adding the entry to the init.ora file. =20
Shut down the db. =20
Rename, delete or recreate the spfile.
Start the db.

Check the listener again (lsnrctl services).

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Scott.Shafer@xxxxxxxxxxxxxxxxxx
[mailto:Scott.Shafer@xxxxxxxxxxxxxxxxxx]=20
Sent: Monday, June 28, 2004 1:57 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: spfile/listener question


Already tried it both ways, with the same result.  Metalink is no help =
so
far.  I appreciate the responses - keep 'em coming. Scott Shafer


-----Original Message-----
From: Tanel P=F5der [mailto:tanel.poder.003@xxxxxxx]

Try to set the LOCAL_LISTENER to "DESCRIPTION=3D
(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3Ddbserver)(PORT=3D1421))" instead of =
tns alias.

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 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@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: