Re: 9i on Redhat 3.8

ton de w schrieb:
> Hello,
> I have tried to autostart an oracle instance by following the
> instructions here:
> http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php
> following an install described here:
> http://download-east.oracle.com/docs/html/B13670_06/toc.htm
>
> But the database fails to start.
> Please what should I do to troubleshoot this install?
>
> TIA
>
> Ton
> [root]# ./dbora start
>
> LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 03-JAN-2008
> 13:23:26
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting /u01/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 9.2.0.4.0 - Production
> System parameter file is /u01/app/oracle/product/9.2.0/network/admin/
> listener.ora
> Log messages written to /u01/app/oracle/product/9.2.0/network/log/
> listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webtop)
> (PORT=1521)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)
> (PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.2.0.4.0 -
> Production
> Start Date 03-JAN-2008 13:23:26
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/
> listener.ora
> Listener Log File /u01/app/oracle/product/9.2.0/network/log/
> listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webtop)(PORT=1521)))
> The listener supports no services
> The command completed successfully
>
> Can't find init file for Database "HIST".
> Database "HIST" NOT started.

Probably, the simpliest way would be (as OS user oracle) export ORACLE_HOME=/u01/app/oracle/product/9.2.0 export ORACLE_SID=HIST
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
sqlplus / as sysdba
create pfile from spfile;
exit

sudo su -
./dbora start

Alternatively, you can adjust $ORACLE_HOME/bin/dbstart script, to make it looking not only for pfile but for spfile as well...

Best regards

Maxim Received on Thu Jan 03 2008 - 06:53:44 CST