将测试进行到底!
启动oracle数据库时用的是哪个初始化配置
上一篇 /
下一篇 2009-12-25 13:43:10
/ 个人分类:ORACLE
在startup启动oracle数据库时,提示 共享池内存不足(ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes) ,根据startup下面的路径提示,
“LRM-00109: could not open parameter file '/db/oracle/product/10.2/dbs/initQCTEST.ora'”我找到对应的数据库初始化文件initQCTEST.ora,编辑这个文件把shared_pool_size值设置的更大,startup数据库成功。
那在实例启动后,我们怎么看这个实例用的是哪个初始化文件呢?
1、进入sqlplus,conn一个数据库实例
2、show parameter pfile;查看oracle启动时用的是哪个ora文件。
3、自定义选择ora文件启动数据库实例
startup pfile='$ORACLE_HOME/dbs/init.ora';
做个例子,修改shared_pool_size的大小:
SQL>show parameter pfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /db/oracle/product/10.2/dbs/sp fileQCTEST.ora SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> ! [oracle@qc pfile]$ ls init.ora.1117200911214 [oracle@qc pfile]$ pwd /db/admin/QCTEST/pfile [oracle@qc pfile]$ cd [oracle@qc ~]$ ls awrrpt_1_7_8.html awrrpt_20091224_01.html env.properties.7271 install.dir.7271 product [oracle@qc ~]$ cd product/ [oracle@qc product]$ ls 10.2 [oracle@qc product]$ cd 10.2/ [oracle@qc 10.2]$ ls assistants config demo install.platform jlib md oc4j oracore perl rdbms sqlj uix bin crs diagnostics inventory jre mesg odbc oraInst.loc plsql relnotes sqlnet.log wwg cdata css has javavm ldap mgw olap ord precomp root.sh sqlplus xdk cfgtoollogs ctx hs jdbc lib network OPatch oui qc_QCTEST root.sh.old srvm clone dbs install jdk log nls opmn owm racg slax sysman [oracle@qc 10.2]$ cd dbs [oracle@qc dbs]$ ll total 68 -rw-r----- 1 oracle oinstall 1544 Dec 17 11:16 hc_QCTEST.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 24 Dec 17 11:17 lkQCTEST -rw-r----- 1 oracle oinstall 1536 Dec 17 12:19 orapwQCTEST -rw-r----- 1 oracle oinstall 2560 Dec 25 11:04 spfileQCTEST.ora [oracle@qc dbs]$ cp spfileQCTEST.ora spfileQCTEST.ora_bak [oracle@qc dbs]$ ll total 76 -rw-r----- 1 oracle oinstall 1544 Dec 17 11:16 hc_QCTEST.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 24 Dec 17 11:17 lkQCTEST -rw-r----- 1 oracle oinstall 1536 Dec 17 12:19 orapwQCTEST -rw-r----- 1 oracle oinstall 2560 Dec 25 11:04 spfileQCTEST.ora -rw-r----- 1 oracle oinstall 2560 Dec 25 11:16 spfileQCTEST.ora_bak [oracle@qc dbs]$ vi spfileQCTEST.ora ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^E^@^@^@^@^B^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^B^@^@<9c>^C^@^@/Õ^\*^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@QCTEST.__db_cache_size=83886080 QCTEST.__java_pool_size=4194304 QCTEST.__large_pool_size=4194304 QCTEST.__shared_pool_size=71303 修改小一点 QCTEST.__streams_pool_size=0 *.audit_file_dest='/db/admin/QCTEST/adump' *.background_dump_dest='/db/admin/QCTEST/bdump' *.compatible='10.2.0.1.0' *.control_files='/db/oradata/QCTEST/control01.ctl','/db/oradata/QCTEST/control02.ctl','/db/oradata/QCTEST/control03.ctl' *.core_dump_dest='/db/admin/QCTEST/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='QCTEST' *.db_recovery_file_dest='/db/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=QCTESTXDB)' *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=63963136 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=167772160 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/db/admin/QCTEST/udump' @ @ @ @ "spfileQCTEST.ora" [converted] 27L, 2560C written [oracle@qc dbs]$ ll total 76 -rw-r----- 1 oracle oinstall 1544 Dec 17 11:16 hc_QCTEST.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 24 Dec 17 11:17 lkQCTEST -rw-r----- 1 oracle oinstall 1536 Dec 17 12:19 orapwQCTEST -rw-r----- 1 oracle oinstall 2558 Dec 25 11:17 spfileQCTEST.ora -rw-r----- 1 oracle oinstall 2560 Dec 25 11:16 spfileQCTEST.ora_bak [oracle@qc dbs]$ exit exit SQL>startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/db/oracle/product/10.2/dbs/initQCTEST.ora' SQL> ! [oracle@qc pfile]$ ll total 8 -rw-r----- 1 oracle oinstall 2394 Dec 17 11:16 init.ora.1117200911214 [oracle@qc pfile]$ pwd /db/admin/QCTEST/pfile [oracle@qc pfile]$ cd [oracle@qc ~]$ cd product/ [oracle@qc product]$ cd 10.2/ [oracle@qc 10.2]$ cd dbs [oracle@qc dbs]$ ll total 76 -rw-r----- 1 oracle oinstall 1544 Dec 17 11:16 hc_QCTEST.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 24 Dec 17 11:17 lkQCTEST -rw-r----- 1 oracle oinstall 1536 Dec 17 12:19 orapwQCTEST -rw-r----- 1 oracle oinstall 2558 Dec 25 11:17 spfileQCTEST.ora -rw-r----- 1 oracle oinstall 2560 Dec 25 11:16 spfileQCTEST.ora_bak [oracle@qc dbs]$ rm spfileQCTEST.ora [oracle@qc dbs]$cp spfileQCTEST.ora_bak spfileQCTEST.ora [oracle@qc dbs]$ exit exit SQL>startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 79694068 bytes Database Buffers 83886080 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL>show parameter pfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /db/oracle/product/10.2/dbs/sp fileQCTEST.ora SQL> |
自定义选择ora文件启动数据库实例
SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup pfile='$ORACLE_HOME/dbs/init.ora'; ORACLE instance started. Total System Global Area 71303168 bytes Fixed Size 1217740 bytes Variable Size 62917428 bytes Database Buffers 4194304 bytes Redo Buffers 2973696 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> shutdown ORA-01507: database not mounted
ORACLE instance shut down. SQL>
|
收藏
举报
TAG: