startup using spfile on Windows
Hello,
I know this is going to come across as a really stupid question, but I rarely ever deal with Oracle on Windows. I deal purely with Oracle on several flavors of unux. Unfortunately, we have a couple of Windows servers with Oracle configured on them, which I now have to support.
environment: Oracle 11.2, Windows Server 2003, SP2, 32bit
My question is how to I set the automatic startup of the Oracle service for the database to startup using the spfile instead of the pfile.
Naturally, I want to keep an updated pfile in place, but I want Windows to startup the database using the spfile.
First, I found that Oracle puts the pfile in the $OH/database directory instead of the $OH/dbs directory as it does on unix.
I've created spfile and it was created by default in the $OH/database directory.
But when I bounce the server, the database is started up with the pfile, even though both pfile and spfile exist in the $OH/database directory.
I should add: The OracleService<sid> shows the following startup command:
c:\oracle\apps\oracle\product\11.2.0\db_1\bin\ORACLE.EXE <SID> (where <SID> is our database name)
THanks in advance for your help.
Edited by: user12159859 on Jan 6, 2012 7:37 AM