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@gbrownc.on.ca