解決ORA-00824: cannot set sga_target due to existing，sgatarget
今天Linux服務器機子重啟了下，Oracle啟動不起來，提示：解決ORA-00824: cannot set sga_target due to existing
看了很多解決方法，發現下面這個特別好，特別簡單
轉：http://blog.chinaunix.net/uid-22448653-id-388649.html
按照這種思路：
1、我們完全可以先用pfile的配置參數啟動數據庫實例
2、通過pfile重建spfile文件（create spfile from pfile）
3、關閉數據庫實例
4、正常啟動數據庫實例
具體的操作如下：
su - oracle
[oracle@redhat pfile]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 20 00:20:19 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL>lsnrctl start
這條語句運行後，會出現pfile文件，把這個文件弄出來備份，然後，再運行下面的語句
SQL> startup pfile='/home/oracle/admin/zgz/pfile/init.ora.82220096537'
--“通過pfile文件啟動oracle實例”
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='/home/oracle/admin/zgz/pfile/init.ora.82220096537';--“通過pfile重建spfile文件”
File created.
SQL> shutdown immediate
--"關閉數據庫實例"
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup --"通過spfile文件正常啟動oracle實例"
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL>
