9i unix startup / shutdown with listener password

This page has been moved to http://www.andrewfraserdba.com/?p=4

About these ads

8 Responses to “9i unix startup / shutdown with listener password”

  1. laurent schneider Says:

    note that you never need a password to start a listener 8)
    take care if you have more than one listener

  2. Andrew Fraser Says:

    Thanks again. Had I known password wasn’t needed for startup, I might have been tempted to be lazy and skip the listener shutdown step, since I’m a lot less bothered about a listener not being cleanly shutdown than a database.

  3. Kevin Says:

    I’m following these steps exactly, but seeing that my script is not able to set variables within the “su – ” routine.

    This is happening both on my RHES Linux 4.0 and hpux 11.11 servers.

    If I put all the oracle commands in a separate script, then everything is fine, but I’m wondering if anyone knows why the example above wouldn’t work for me?

    cheers,
    Kevin

  4. Andrew Fraser Says:

    Not sure why that happens, but I just replicated it on a solaris test machine. Fix I used there was to take the environment variable line:

    ENCRYPTED_PASSWORD=`grep -i password /etc/listener.ora | awk -F= ‘{print $2}’ -`

    to be before the su.

    I’ve updated the original post to have that fix in.

  5. Kevin Says:

    Ahh, that did it Andrew. Thanks so much

  6. Uneniosits Says:

    Thanks for the post

  7. Listener passwords: always for 9i, never for 10g « Andrew Fraser DBA Says:

    [...] makes system shutdown commands a little more complex, see this post for [...]

  8. 9i unix startup / shutdown with listener password « Andrew Fraser DBA Says:

    [...] on how to handle listener passwords in scripts. [Update 12-Jan-2007 – ammended script following Laurent's comment, and update 09-Feb-2007 – ammended script following Kevin's [...]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: