RE: Help me : init.ora
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Feb 2004 09:56:36 -0500
To start Oracle using a non-default init.ora or spfile use:
startup pfile=location_of_init.ora OR
startup spfile=location_of_spfile
The init.ora can contain a pointer to the spfile. This is actually required
on some platforms for some environments such as RAC on AIX.
Before attempting to start this database using a copy init.ora I would
perform a search for the referenced init.ora file to see if perhaps it is
under a different directory structure as in a different Oracle home.
Multiple versions might be in use.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hitchman, Peter
Sent: Monday, February 16, 2004 9:15 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Help me : init.ora
Hi,
Oracle looks for a file called "init<SID_NAME>.ora" in the ORACLE_HOME
defined in your environment. So considering the files you could find it
looks like you had/have a database instance called JASPERDB running. So,
yes, make a copy of the init.ora file and call it initNSTRADER.ora.
I know of no way of Oracle telling you which init.ora or spfile it actually
used to start up.
Regards
Pete
[END]
-----Original Message-----
From: Kean Jacinta [mailto:jacintakean@xxxxxxxxx]
Sent: 16 February 2004 01:20
To: oracle-l@xxxxxxxxxxxxx
Subject: Help me : init.ora
Can someone please help me . I am using Linux AS with
database 9.2 . Somehow ....my database goes down . I
need to restart the database but it gave this error.
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/database/u01/app/oracle/product/9.2.0/dbs/initNSTRADER.ora'
So i went to the directory
/database/u01/app/oracle/product/9.2.0/dbs/
and found that iniNSTRADER.ora is not there instead
i only have this file :
initdw.ora
init.ora
lkJASPERDB
orapwJASPERDB
spfileJASPERDB.ora
Can you pls tell me should i change the init.ora file
to initNSTRADER.ora so that the database can find this
file.
Apart from this , i would also like to know, is that
possible to know which init file the database file is
currently using ? If i have more than 2 initABC.ora
and initDEF.ora file then how can i check which file
the database is currently using ?
Appreciate
JKean
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
