Rebboot Windows DB machine and database autostart with spfile
From: Jiang, Lu <Lu.Jiang_at_umassmed.edu>
Date: Tue, 26 Aug 2008 15:19:42 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890AEF7E02@edmtpmail01.ad.umassmed.edu>
Date: Tue, 26 Aug 2008 15:19:42 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890AEF7E02@edmtpmail01.ad.umassmed.edu>
Hi all,
By default database auto starts with init pfile when reboot windows DB machine. In order to make database autostart using spfile, I edited registry key ORA_<SID>_PFILE from '...\init<SID>.ora' to '...\SPFILE<SID>.ora', but database does not auto start when the service restarted or machine rebooted, seems it does not take the binary file.
Is there a way to make the database service use spfile to auto start database on Windows environment?
Thanks,
Lu
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 26 2008 - 14:19:42 CDT