Problem:
After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.
Solution:
When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.
Microsoft Windows [Version 6.0.6001] Copyright (c) 2006 Microsoft Corporation. All rights reserved. C:Windowssystem32>cd oracleDEV1dbtech_st11.1.0 C:oracleDEV1dbtech_st11.1.0>DEV1_ittl-hrmstest.cmd ECHO is off. ECHO is off. Mon 10/01/2012 03:44 PM DEV1_ittl-hrmstest.cmd exiting with status 0 C:oracleDEV1dbtech_st11.1.0>sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Mon Oct 1 15:44:39 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter pfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1352100 bytes Variable Size 427822684 bytes Database Buffers 629145600 bytes Redo Buffers 13012992 bytes Database mounted. Database opened. SQL> show parameter pfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string C:ORACLEDEV1DBTECH_ST11.1 .0DATABASESPFILEDEV1.ORA SQL>
I am not sure how to start the database with the spfile via the Windows Services panel.
0 Comments.