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