| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: automatic startup and shutdown of LISTENER
Viraj:
In your case, oracle8 should be a valid UNIX user who is also the owner of your
database. Is that true?
I do not know if I understand you. But I test this
su - oracle -c $ORACLE_HOME/bin/lsnrctl in my system. it worked fine without asking password, instead it broght up the LSNRCTL> prompt. so. Hope you get work soon, Good luck
|--------+----------------------->
| | "Viraj |
| | Luthra" |
| | <viraj999_at_lyc|
| | os.com> |
| | |
| | 02/14/01 |
| | 08:50 PM |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|--------+-----------------------> >----------------------------------------------| | | | To: Multiple recipients of list | | ORACLE-L <ORACLE-L_at_fatcity.com> | | cc: (bcc: William Dong/New York | | Life Asset Management) | | Subject: RE: automatic startup and | | shutdown of LISTENER | >----------------------------------------------|
william,
I also dont want the user to interact, i want it to remain as a automated startup and shut down process. At this time, even if I run it as,
su - oracle8 -c $ORACLE_HOME/bin/lsnrctl <<eof
the script asks for oracle8's password, which I dont want; some how I could pass the user id and password just like I can pass from a shell file to sqlplus like,
test.sh
sqlplus $USER/$PASSWD <<EOM
do what ever
EOM
Then do
test.sh oracle8 passwd
so in a similar way can I pass userid and passwd, so that the shell does not ask the user the passwd when i do
su - oracle8 -c $ORACLE_HOME/bin/lsnrctl <<eof
Do u understand the problem.....
Raja
-- On Wed, 14 Feb 2001 06:20:53 William Dong wrote: >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_at_lyc| >| | os.com> | >| | | >| | 02/14/01 | >| | 01:05 AM | >| | Please | >| | respond to | >| | ORACLE-L | >| | | >|--------+-----------------------> > >----------------------------------------------| > | | > | To: Multiple recipients of list | > | ORACLE-L <ORACLE-L_at_fatcity.com> | > | 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_at_be| >>| | stbuy.com> | >>| | | >>| | 02/13/01 03:03 PM | >>| | Please respond to | >>| | ORACLE-L | >>| | | >>|--------+-----------------------------> >> >-----------------------------------------------------| >> | | >> | To: Multiple recipients of list ORACLE-L | >> | <ORACLE-L_at_fatcity.com> | >> | 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:VanE_at_UANET.ORG] >>> 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: VanE_at_UANET.ORG >>> >>> 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: 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). >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Elliott, Patrick >> INET: Patrick.Elliott_at_bestbuy.com >> >>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: 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). >> >> >> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: William Dong >> INET: William_Dong_at_nylim.com >> >>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: 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). >> > > >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: viraj999_at_lycos.com > >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: 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). > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: William Dong > INET: William_Dong_at_nylim.com > >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: 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). > 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: viraj999_at_lycos.com 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Dong INET: William_Dong_at_nylim.com 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: 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 Thu Feb 15 2001 - 10:33:55 CST
 |
 |