Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Database Using SPFile Does Not Start when Unix Box Rebooted
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 <mailto:sbootsma_at_gbrownc.on.ca>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 20 2006 - 15:31:02 CST
![]() |
![]() |