RE: lsnrctl -utility, passing password in a command file

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 21 Mar 2003 07:59:56 -0500
Message-Id: <24738.322694@fatcity.com>

Kalle,

I do something similiar by creating a command file with lsnrctl commands and then executing them like this:

@rem
@rem First set the log file name via lsnrctl so we can rename it in dos
@rem
@if exist %oracle_home%\network\log\%listenerlog%_temp.log del

%oracle_home%\network\log\%listenerlog%_temp.log		>> %JobLog%


@echo set current_listener %listenerlog%	>  h:\dba\temp\lsncmd.lsn

@echo set log_file %listenerlog%_temp.log	>> h:\dba\temp\lsncmd.lsn

@echo exit						>>

h:\dba\temp\lsncmd.lsn

@%oracle_home%\bin\lsnrctl <h:\dba\temp\lsncmd.lsn >> %JobLog%
@del h:\dba\temp\lsncmd.lsn

You could certainly put your "set password" command in the place of set current_listener above and give it a try.

Good luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Joshua Becker [mailto:jbecker_sweden_at_yahoo.se] Sent: Friday, March 21, 2003 5:44 AM
To: Multiple recipients of list ORACLE-L Subject: lsnrctl -utility, passing password in a command file

Hi all,

is there any way how to start password protected listener from certain
.bat file.

I am using Windows NT and I don't know how to pass a password to lsnrctl
-utility when I am doing like this lsnrctl reload PASSWORD. All tips are welcome...

Rgds,

Kalle

---

Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Joshua=20Becker?=
  INET: jbecker_sweden_at_yahoo.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Mar 21 2003 - 06:59:56 CST