Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle General >> General Oracle questions >> can't stopping Listener
        
(Message started by: Pete Finnigan on Sep 12^th, 2007, 3:49pm)

Title: can't stopping Listener
Post by Pete Finnigan on Sep 12^th, 2007, 3:49pm

Hi guys, my name is Javier and I’m totally new in oracle.

I’ve an easy question for you guys. I’m using Oracle10g version 10.2.0 running in windows 2003.

My problem is that I want to stop the listener in the Database control and I can’t. I did it in DOS command line and just stopping windows services, but I want to do it in Database console also.

The problem is, when I’m going to stopping it, I’ve to put and user and password in order to stop it, then I did it putting a new password in DOS command line with LSNRCTL command, just like says in this article:
http://orafaq.com/node/567

And my listener configuration file look like this now:

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g)(PORT = 1521))
)
)

#----ADDED BY TNSLSNR 12-SEP-2007 09:27:16---
PASSWORDS_LISTENER = 8CDEAA943B32F19F
#--------------------------------------------

And the encrypted password is “topsecurity007” and when I put it and the user is just the “administrator” user for windows 2003, it still says “wrong password”.

What I’m doing wrong?

Thanks a lot!

Javier

Title: Re: can't stopping Listener
Post by Pete Finnigan on Sep 12^th, 2007, 10:22pm

Javier,

In Oracle 10g/11g you should NOT use a listener password. Using a listener password in 10g/11g opens your listener against external administration.

If you don't use external procedures in your application you should remove the entry for extproc (for security reasons).

Regards

Alexander

--
Alexander Kornbrust

Title: Re: can't stopping Listener
Post by Pete Finnigan on Sep 13^th, 2007, 4:30am

that's ok,

well I'll follow your suggestions!!

thanks a lot Alexander

Javier