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

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

RE: Database Using SPFile Does Not Start when Unix Box Rebooted

From: Hostetter, Jay M <JHostetter_at_decommunications.com>
Date: Tue, 21 Mar 2006 08:14:41 -0500
Message-ID: <D67EB7CEECD4334F9C85759227553BBC033CCA0D@CL-EXCHANGE1.dande.com>

Create an initFAST.ora file in $ORACLE_HOME/dbs.  The only entry in it
should be spfile=spfileFAST.ora.
 
Jay

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sam Bootsma
Sent: Monday, March 20, 2006 4:31 PM
To: oracle-l_at_freelists.org
Subject: 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> 

 



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 21 2006 - 07:14:41 CST

Original text of this message

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