詳細(xì)講解如何用Oracle創(chuàng)建實(shí)例的參數(shù)需求
我們知道,Oracle在啟動(dòng)過程中,需要讀取參數(shù)文件(pfile/spfile)來創(chuàng)建實(shí)例.Oracle在啟動(dòng)過程中,尋找參數(shù)文件的順序?yàn)?
spfile<sid>.ora,spfile.ora,init<sid>.ora.
而創(chuàng)建實(shí)例的過程中,Oracle需要的最少參數(shù)為一個(gè),即db_name參數(shù).
我們來看一個(gè)測(cè)試,啟動(dòng)一個(gè)任意設(shè)置的實(shí)例,本例ORACLE_SID=julia:
oracle@jumper dbs]$ export ORACLE_SID=julia[oracle@jumper dbs]$ sqlplus '/ as sysdba'SQL*Plus: Release 9.2.0.4.0 - Production on Mon May 8 11:08:36 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup nomount;ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/opt/oracle/product/9.2.0/dbs/initjulia.ora'
Oracle最后檢查的文件為initjulia.ora,讓我們創(chuàng)建這個(gè)文件,然后數(shù)據(jù)庫實(shí)例即可創(chuàng)建:
SQL> ! echo 'db_name=julia' > /opt/oracle/product/9.2.0/dbs/initjulia.oraSQL> startup nomount;ORACLE instance started.Total System Global Area 97588504 bytesFixed Size 451864 bytesVariable Size 46137344 bytesDatabase Buffers 50331648 bytesRedo Buffers 667648 bytes
我們可以看一下缺省的各類文件的存儲(chǔ)地點(diǎn):
SQL> show parameter dump_dest NAME TYPE VALUE --------------- ----------------- -------- background_dump_dest string ?/rdbms/log core_dump_dest string ?/dbs user_dump_dest string ?/rdbms/log SQL> show parameter control_files NAME TYPE VALUE --------------- -----------------control_files string ?/dbs/cntrl@.dbf
我們順便看一下缺省的,警報(bào)日志中記錄的信息:
oracle@jumper dbs]$ cat $ORACLE_HOME/rdbms/log/alert_julia.logMon May 8 11:09:04 2006Starting ORACLE instance (normal)Mon May 8 11:09:04 2006WARNING: EINVAL creating segment of size 0x0000000006400000fix shm parameters in /etc/system or equivalentLICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.4.0.System parameters with non-default values: db_name= juliaPMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7
相關(guān)文章：
1. MySQL找出未提交事務(wù)的SQL實(shí)例淺析2. Oracle中Instance實(shí)例和數(shù)據(jù)庫的區(qū)別3. 實(shí)例講解Oracle數(shù)據(jù)庫自動(dòng)增加ID的sql4. Oracle數(shù)據(jù)庫不完全恢復(fù)實(shí)例5. Oracle存儲(chǔ)過程創(chuàng)建和使用舉例6. MySQL case when使用方法實(shí)例解析7. Mysql入門系列：MYSQL創(chuàng)建、刪除和選擇數(shù)據(jù)庫8. SQL年齡計(jì)算的兩種方法實(shí)例9. 如何手動(dòng)刪除 SQL Server 2000 默認(rèn)實(shí)例、命名實(shí)例或虛擬實(shí)例10. MySQL 索引的優(yōu)缺點(diǎn)以及創(chuàng)建索引的準(zhǔn)則
網(wǎng)公網(wǎng)安備