Re: Database Using SPFile Does Not Start when Unix Box Rebooted
- From: "LiShan Cheng" <exriscer@xxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 20 Mar 2006 22:38:04 +0100
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx* <sbootsma@xxxxxxxxxxxxx>
>
>
>
Other related posts:
