Viraj:
Looks like you are playing with Unix scripting. I am not good at this. I just
have two thinking:
1. Why you su to users other than "oracle", unable to see any necessarity.
2. Even you really want replace oracle user, just replace it with another
userid in the syntax. Remember
this is automatic startup or shutdown, you do'nt want to interact with the
scripts. Just try this:
su - USERID -c $ORACLE_HOME/bin/lsnrctl <<eof
start listener
exit
eof
I know this may not answer your question, but this is more reasonable.
William Dong
|--------+----------------------->
| | "Viraj |
| | Luthra" |
| | <viraj999@lyc|
| | os.com> |
| | |
| | 02/14/01 |
| | 01:05 AM |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|--------+----------------------->
>----------------------------------------------|
| |
| To: Multiple recipients of list |
| ORACLE-L <[EMAIL PROTECTED]> |
| cc: (bcc: William Dong/New York |
| Life Asset Management) |
| Subject: RE: automatic startup and |
| shutdown of LISTENER |
>----------------------------------------------|
Hello,
If I want to achieve the following in a shell script, how can I do that:-
I put the following in a shell:-
USERID=$1
PASSWD=$2
su - $USERID -c $ORACLE_HOME/bin/lsnrctl <<eof
start listener
exit
eof
But then when I run the program, by
test oracle8 passwd
, the script expects the password to be passed, I dont want that. Is there any
way I can pass the password at command prompt and the unix shell will get that
and not ask for entering the password?
Do you get what I need?
Regards,
raja
--
On Tue, 13 Feb 2001 12:56:48
William Dong wrote:
>The following may work:
>
>su - oracle -c $ORACLE_HOME/bin/lsnrctl <<eof
>start listener
>exit
>eof
>
>
>
>
>
>
>
>|--------+----------------------------->
>| | "Elliott, Patrick" |
>| | <Patrick.Elliott@be|
>| | stbuy.com> |
>| | |
>| | 02/13/01 03:03 PM |
>| | Please respond to |
>| | ORACLE-L |
>| | |
>|--------+----------------------------->
> >-----------------------------------------------------|
> | |
> | To: Multiple recipients of list ORACLE-L |
> | <[EMAIL PROTECTED]> |
> | cc: (bcc: William Dong/New York Life Asset|
> | Management) |
> | Subject: RE: automatic startup and |
> | shutdown of LISTENER |
> >-----------------------------------------------------|
>
>
>
>
>Change the command to
>
>su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"
>
>You need the double quotes I believe.
>
>> -----Original Message-----
>> From: Van M. Etheridge [SMTP:[EMAIL PROTECTED]]
>> Sent: Monday, February 12, 2001 10:13 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: automatic startup and shutdown of LISTENER
>>
>> I would like to be able tostartup and shutdown the listener when my SA
>> shutsdown and brings the Unix box back up. What happens when my SA brings
>> up
>>
>> the OS is that he gets the lsnrctl prompt rather than listener starting.
>> He
>> can then type the start command and listerner starts. But it should start
>> without him having to key in the command.
>> I have the following in both the /etc/init.d/dbstart and
>> /etc/rc2.d/s99dbstart files:
>> su - oracle -c $ORACLE_HOME/bin/ lsnrctl start
>> (I use the default listener name "LISTENER")
>> Sun SPARC Solaris OS 2.4
>> Oracle7 ServerRelease 7.3.4.0.1 - Production
>> With thedistributed, parallel query and Spatial Data options
>> PL/SQL Release 2.3.4.0.0 - Production
>>
>>
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Van M. Etheridge
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Elliott, Patrick
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (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).
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: William Dong
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (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).
>
Get your small business started at Lycos Small Business at
http://www.lycos.com/business/mail.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Dong
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
