Re: Solaris 10 System Boot and Database Startup

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.

Ceri

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