scripting listener bounce/startup when using password protection

Posted on 2006-06-06
Last Modified: 2013-12-11
I recently had to password protect my oracle listener. Now I am unable to automate the listener commands in my UNIX (AIX) scripts.

Does anyone know how to script stoping, starting , bouncing the listener when you are using password protection on the listener?

From the command line now I have to do my listener commands like this. Now I have to do this manually everytime we shutdown Oracle.

from UNIX command line:  $ lsnrctl
LSNRCTL> set password
Password: <pw entered here>
The command completed successfully
LSNRCTL> status
The command completed successfully

I tried using a UNIX script this way but it does not work .

lsnrctl << EOF
set password ???????    

Has anyone scripted listener commands sucessfully when you have the listener pw protected.
Question by:batzman
    LVL 16

    Accepted Solution

    It is not possible to script listener password for automatic startup

    See the link from asktom

    Author Comment

    Actually you can. Your link provided me with the clue I needed to do this. Thanks a lot.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now