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> > > >