Re: Init Parameter Filename in Win XP Professional

On 2005-07-25, 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?

When DBCA creates a database, it first creates an init.ora. Then it creates an spfile from said init.ora and renames said init.ora to init.ora.timestamp. Most likely, that happened on your machine in the timestamp is 692005154631.

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

As pointed out, you're probably running with an spfile. Check: show parameter spfile.

If values is not null, you are using an spfile

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/