oracle初始化0,启动oracle数据库时用的是哪个初始化配置-CSDN博客

本文档记录了Oracle数据库的参数文件（pfile）与服务器参数文件（spfile）的操作过程，包括查看、备份、修改和恢复。在修改spfile后，遇到了数据库启动失败的问题，通过排查解决了这个问题，最终成功启动数据库。

摘要由CSDN通过智能技术生成

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>