oracle11g 起不来,memory target不够
[oracle@hzmc ~]$ cd $ORACLE_HOME/dbs
[oracle@hzmc dbs]$ ls -lrt
total 44
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-rw---- 1 oracle oinstall 1544 Mar 16 23:44 hc_DBUA0.dat -rw-rw---- 1 oracle oinstall 1544 Mar 16 23:48 hc_orcl.dat -rw-r----- 1 oracle oinstall 24 Mar 16 23:49 lkORCL -rw-r----- 1 oracle oinstall 1536 Mar 16 23:55 orapworcl -rw-rw---- 1 oracle oinstall 1544 Apr 1 22:18 hc_test1.dat -rw-r----- 1 oracle oinstall 24 Apr 1 22:20 lkTEST1 -rw-r----- 1 oracle oinstall 1536 Apr 1 22:22 orapwtest1 -rw-r----- 1 oracle oinstall 2560 Apr 2 00:01 spfileorcl.ora -rw-r----- 1 oracle oinstall 2560 Apr 17 15:35 spfiletest1.ora -rw-r--r-- 1 oracle oinstall 915 Apr 17 15:46 inittest1.ora [oracle@hzmc dbs]$ echo $ORACLE_SID
test1
[oracle@hzmc dbs]$ vi init
init.ora inittest1.ora
[oracle@hzmc dbs]$ vi inittest1.ora
test1.__db_cache_size=666894336
test1.__java_pool_size=4194304
test1.__large_pool_size=4194304
test1.__oracle_base='/opt/ora11g'#ORACLE_BASE set from environment
test1.__pga_aggregate_target=4194304
test1.__sga_target=703316480
test1.__shared_io_pool_size=0
test1.__shared_pool_size=155189248
test1.__streams_pool_size=0
*.audit_file_dest='/opt/ora11g/admin/test1/adump' *.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/opt/ora11g/oradata/test1/control01.ctl','/opt/ora11g/flash_recovery_area/test1/control02.ctl' *.db_block_size=8192
*.db_domain=''
*.db_name='test1'
*.db_recovery_file_dest='/opt/ora11g/flash_recovery_area' *.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/opt/ora11g'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=test1XDB)' *.memory_target=842006528
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=838860800
*.undo_tablespace='UNDOTBS1'
~
~
~
~
~
"inittest1.ora" 26L, 915C written [oracle@hzmc dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:48:35 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@hzmc dbs]$ pwd
/opt/ora11g/product/11.2.0/db_1/dbs
[oracle@hzmc dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:48:42 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
pfile='/opt/ora11g/product/11.2.0/db_1/dbs/inittest1.ora'; ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 812M
ORA-01078: failure in processing system parameters SQL> exit
Disconnected
[oracle@hzmc dbs]$ vi inittest1.ora
test1.__db_cache_size=666894336
test1.__java_pool_size=4194304
test1.__large_pool_size=4194304
test1.__oracle_base='/opt/ora11g'#ORACLE_BASE set from environment
test1.__pga_aggregate_target=4194304
test1.__sga_target=703316480
test1.__shared_io_pool_size=0
test1.__shared_pool_size=155189248
test1.__streams_pool_size=0
*.audit_file_dest='/opt/ora11g/admin/test1/adump' *.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/opt/ora11g/oradata/test1/control01.ctl','/opt/ora11g/flash_recovery_area/test1/control02.ctl' *.db_block_size=8192
*.db_domain=''
*.db_name='test1'
*.db_recovery_file_dest='/opt/ora11g/flash_recovery_area' *.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/opt/ora11g'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=test1XDB)' *.memory_target=942006528
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=838860800
*.undo_tablespace='UNDOTBS1'
~
~
~
~
~
"inittest1.ora" 26L, 915C written
[oracle@hzmc dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:49:42
2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
pfile='/opt/ora11g/product/11.2.0/db_1/dbs/inittest1.ora'; ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2218952 bytes
Variable Size 268436536 bytes
Database Buffers 662700032 bytes
Redo Buffers 6139904 bytes
SQL> create spfile from pfile;
File created.
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@hzmc dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:50:11 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2218952 bytes
Variable Size 268436536 bytes
Database Buffers 662700032 bytes
Redo Buffers 6139904 bytes
Database mounted.
Database opened.
SQL> show parameters sga
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 900M sga_target big integer 800M SQL> show parameter memory
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0 memory_max_target big integer 900M memory_target big integer 900M shared_memory_address integer 0
SQL> show parameter pga
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 0