Re: Solaris 10 System Boot and Database Startup

From: Ceri Davies <ceri_usenet_at_submonkey.net>
Date: Mon, 07 Aug 2006 22:26:06 GMT
Message-ID: <26PBg.10366$t%.6031@newsfe7-gui.ntli.net>

On 2006-08-07, Ceri Davies <ceri_usenet_at_submonkey.net> wrote:

> On 2006-08-06, Michael42 <melliott42_at_yahoo.com> wrote:

>> Hello,
>>
>> On a Solaris 10 (sparc) system I am unable to get my Oracle 10
>> listener to start using a technique that I commonly use on Solaris 8
>> systems. My database comes up OK and the script I have will start both
>> the database and listener if I run it manually AFTER the system has
>> booted. In the /ect/init.d my is basically:
>>
>>==================================================================
>> #!/bin/sh
>> #
>> # CREATE pfile'/usr1/home/oracle/product/10.2/dbs/initDB1.ora' FROM
>> spfile;
>>
>> # Set Variables ORA_HOME should be equivalent to the ORACLE_HOME
>> ORA_HOME=/usr1/oracle/product/920
>> ORA_OWNER=oracle
>> LOGDIR=/usr1/oracle/admin
>>
>> case "$1" in
>> 'start')
>> su - $ORA_OWNER -c $ORA_HOME/bin/dbstart 2>&1 >
>> $LOGDIR/dbstart.log
>> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" 2>&1 >
>> $LOGDIR/lsnrstrt.log
>> ;;

>
> For a start, that listener seem to be a 9i one if it's in
> /usr1/oracle/product/920/bin.
>
> Secondly, the listener startup in 10g seems to require that ORACLE_HOME
> is set, which is probably why it works when you run it manually.
>
> See
> http://typo.submonkey.net/articles/2006/06/14/shell-scripting-for-dbms-vendors
> for a rant I wrote about this some time ago.  It also has a solution.

Actually, the script given there may not work - see note 4 about lsnrctl requiring ORACLE_HOME to be set - but I just got fed up of writing about it :) At least there should be enough info in there to help you muddle through it.

Ceri

-- 
That must be wonderful!  I don't understand it at all.
                                                  -- Moliere

Received on Mon Aug 07 2006 - 17:26:06 CDT