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

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

Database Using SPFile Does Not Start when Unix Box Rebooted

From: Sam Bootsma <sbootsma_at_gbrownc.on.ca>
Date: Mon, 20 Mar 2006 16:31:02 -0500
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A18AF516@TCCEML02.gbrownc.on.ca>


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-l
Received on Mon Mar 20 2006 - 15:31:02 CST

Original text of this message

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