Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Help me : init.ora

Help me : init.ora

2004-02-16       - By Hitchman, Peter
Reply:     1     2     3  

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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --