Re: Init Parameter Filename in Win XP Professional

"Edmond" <Edmond_at_edmond.com> wrote:

>I just installed Oracle 9iR2 (9.2.0.1.0) in Windows XP Professional SP2. I
>selected the Personal Edition and requested a the starter database to be
>created.
>
>However, the init parameter file created is called
>
>ORACLE_HOME\admin\db_name\pfile\init.ora.692005154631
>
>instead of 'init.ora'.
>
>What does the .692005154631 extension means? Or is my installation correct
>at all? I have deinstalled a version failed during installation once before
>installing the current version. Would that be causing any problem?
>
>I am able to do all kinds of thing in my current installation (running
>PLSQL, creating table, etc) but just dont know which init parameter file to
>edit!! How do I verify if my installation is correct or not?

Check out Oracle\ora92\database and the file SPFILE_yourdb_.ORA - that is your init.ora file. I don't know whey they keep that old one.

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.