Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Using SPFile Does Not Start when Unix Box Rebooted

Re: Database Using SPFile Does Not Start when Unix Box Rebooted

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Mon, 20 Mar 2006 22:38:04 +0100
Message-ID: <6e9345580603201338v2050cd31vb8d4a423fb9d82b6@mail.gmail.com>


 Hi

What script are you using in init.d to start the database? (I think in AIX it´s /etc/rc) Have you tried to run manually that startup script?

Cheers

LSC On 3/20/06, Sam Bootsma <sbootsma_at_gbrownc.on.ca> wrote:
>
> I have two Oracle 9.2.0.6 databases on our AIX 5.1 box. One of the
> databases starts with a pfile, the other one starts with an spfile. If the
> database with spfile is down, I can start it up manually from sqlplus by
> typing in "startup":
>
>
>
> $ export ORACLE_SID=FAST
>
> $ sqlplus '/ as sysdba'
>
> ….
>
> Connected to an idle instance.
>
> SQL> startup
>
> ORACLE instance started.
>
> …
>
>
>
> However, when our AIX 5.1 box is restarted, this database does not start
> automatically. There exists an entry for this database in our /etc/oratab
> file, and the entry specifies "Y", indicating that the database be brought
> up at system boot time. However, the database is not brought up. Can
> anybody tell me what the problem is and what I need to do to fix it? The
> database that uses a pfile does start automatically at system boot time.
>
>
>
> Thanks!
>
>
>
>
>
> *Sam Bootsma*
>
> *Oracle Database Administrator*
>
> *Information Technology Services**
> George Brown College*
>
> *Phone: 416-415-5000 x4933**
> Fax: 416-415-4836
> E-mail: **sbootsma_at_gbrownc.on.ca* <sbootsma_at_gbrownc.on.ca>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 20 2006 - 15:38:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US