From oracle-l-bounce@freelists.org Wed Aug 17 17:13:26 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7HMDQKk012659 for ; Wed, 17 Aug 2005 17:13:26 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7HMDLIP012646 for ; Wed, 17 Aug 2005 17:13:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 231A11E02B6; Wed, 17 Aug 2005 17:13:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21776-05; Wed, 17 Aug 2005 17:13:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9F0491E0255; Wed, 17 Aug 2005 17:13:15 -0500 (EST) Message-ID: <35197.156.153.255.126.1124316685.squirrel@webmail.zephyrus.com> In-Reply-To: <40357.156.153.255.134.1124315323.squirrel@webmail.zephyrus.com> References: <40357.156.153.255.134.1124315323.squirrel@webmail.zephyrus.com> Date: Wed, 17 Aug 2005 15:11:25 -0700 (PDT) Subject: Re: Shutdown/Startup on Linux - won't work at server level From: "Keith Moore" To: kmoore@zephyrus.com Cc: oracle-l@freelists.org User-Agent: SquirrelMail/1.4.4 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 24149 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kmoore@zephyrus.com Precedence: normal Reply-To: kmoore@zephyrus.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 I finally got it working. I had to change the dbstart and dbstop lines to remove the ampersand at the end of the line. Is that the minor change you made? Oracle has the ampersand in their documentation, which runs the command in the background. I assume what was happening is that dbstart would run until the parent process ended and that would cause dbstart to terminate before the database could be actually opened. Since dbstart was executing and then mysteriously dying when sqlplus was called, I did not pay too much attention to dbora and never thought about how the background process would work. I feel like Oracle owes me several hours of my life I'll never get back. I guess I'll just add it to their 'tab'. Keith > >> Well, under 10g Release 2, Redhat WS 4 I have it working with a minor >> error in the dbora script (see script below). There is a couple of >> other errors but it does not affect the startup or shutdown. Once the >> file was created in /etc/init.d with permissions 750, I issued >> 'chkconfig --add dbora' then validated that using >> >> find /etc -name '*dbora*' >> >> where the scripts were created. Also, I did a >> >> chkconfig --list | grep 'dbora' >> >> and it shows that dbora startups under levels 345. >> >> Mike >> >> Here is dbora: >> #!/bin/sh >> # chkconfig: 345 99 10 >> # description: Oracle auto start-stop script. >> # >> # Set ORA_HOME to be equivalent to the $ORACLE_HOME >> # from which you wish to execute dbstart and dbshut; >> # >> # Set ORA_OWNER to the user id of the owner of the >> # Oracle database in ORA_HOME. >> ORA_HOME=/u01/oracle/product/10.2.0 >> ORA_OWNER=oracle >> if [! -f $ORA_HOME/bin/dbstart] >> then >> echo "Oracle startup: cannot start" >> exit >> fi >> case "$1" in >> 'start') >> # Start the Oracle databases: >> # The following command assumes that the oracle login >> # will not prompt the user for any values >> echo "Starting Oracle databases" >> su - $ORA_OWNER -c $ORA_HOME/bin/dbstart >> echo "Starting Oracle Listener" >> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start listener_seed" >> echo "Starting Oracle Enterprise Manager" >> su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" >> ;; >> 'stop') >> # Stop the Oracle databases: >> # The following command assumes that the oracle login >> # will not prompt the user for any values >> echo "Stopping databases" >> su - $ORA_OWNER -c $ORA_HOME/bin/dbshut >> echo "Stopping Oracle Enterprise Manager" >> su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole" >> echo "Stopping Oracle Listener" >> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop listner_seed" >> ;; >> esac >> >> -- http://www.freelists.org/webpage/oracle-l