Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i does not use spfile on W2k?

Re: Oracle 9i does not use spfile on W2k?

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 10 Jun 2002 15:41:43 -0700
Message-ID: <ae39v70jo7@drn.newsguy.com>


In article <PM0003A314590AE7C4_at_hades.none.local>, Lothar says...
>
>Pete Sharman wrote:
>> In article <PM0003A2F9A086FDE5_at_hades.none.local>, Lothar says...
>>>
>>>Hello out there,
>>>yesterday we installed Oracle 9i on a W2k Server. I created a spfile
>>>from the init.ora and it is used when I startup the database from
>>>SQL*Plus but it is not used when the database is started
>> automatically
>>>after server reboot.
>[...]
>> Create the spfile in the default directory and naming convention where
>> Oracle
>> expects it and Oracle will use it. The search mechanism if you just
>> say STARTUP
>> is the SPFILE, then the PFILE.
>>
>I did it:
>
>create spfile from pfile='...';
>
>so the spfile is created in the default location and it is used when I
>startup the database manually. But the automatic statup still uses the
>pfile.
>When I say "show parameter spfile", the entry is empty.
>I think I'll try Klaus's solution.
>
>Regards,
>Lothar
>
>--
>Lothar Armbrüster | la_at_oktagramm.de
>Hauptstr. 26 | la_at_heptagramm.de
>D-65346 Eltville | lothar.armbruester_at_t-online.de

Alternatively create the service by running oradim without specifying PFILE=. It's an option that you don't need.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Mon Jun 10 2002 - 17:41:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US