 | | | Help me : init.ora | Help me : init.ora 2004-02-16 - By Powell, Mark D
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Hitchman, Peter
Sent: Monday, February 16, 2004 9:15 AM
To: 'oracle-l@(protected) '
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@(protected)]
Sent: 16 February 2004 01:20
To: oracle-l@(protected)
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 (See ORA-01078.ora-code.com): 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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|