云計(jì)算服務(wù)
服務(wù)器租用
DDOS 防護(hù)
虛擬主機(jī)
域名服務(wù)
基礎(chǔ)設(shè)施
關(guān)于我們
CentOS下Oracle數(shù)據(jù)庫(kù)的部署與管理指南
環(huán)境準(zhǔn)備與安裝前配置
系統(tǒng)要求驗(yàn)證
# 驗(yàn)證內(nèi)存與交換空間
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
# 檢查磁盤空間
df -h /opt依賴包安裝
yum install -y binutils compat-libcap1 gcc-c++ glibc libstdc++ libaio
make sysstat unixODBC unixODBC-devel ksh內(nèi)核參數(shù)調(diào)整
編輯/etc/sysctl.conf：
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmax = 4294967296Oracle 19c安裝流程
圖形化安裝步驟
./runInstaller -ignorePrereq -waitforcompletion
-responseFile /opt/database/response/db_install.rsp靜默安裝配置
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY數(shù)據(jù)庫(kù)實(shí)例創(chuàng)建
dbca -silent -createDatabase
-templateName General_Purpose.dbc
-gdbName orcl -sid orcl -characterSet AL32UTF8日常運(yùn)維操作
服務(wù)啟停管理
sqlplus / as sysdba
STARTUP
SHUTDOWN IMMEDIATE監(jiān)聽器配置
lsnrctl start
lsnrctl status性能優(yōu)化策略
內(nèi)存參數(shù)調(diào)整
ALTER SYSTEM SET sga_max_size=4G SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=2G;SQL執(zhí)行計(jì)劃分析
EXPLAIN PLAN FOR SELECT * FROM large_table;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);備份與恢復(fù)機(jī)制
rman target /
RUN {
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
BACKUP DATABASE PLUS ARCHIVELOG;
}典型問題處理方案
ORA-12541: TNS無(wú)監(jiān)聽程序
ps -ef | grep tnslsnr
lsnrctl reload表空間擴(kuò)容操作
ALTER DATABASE DATAFILE '/u01/oradata/users02.dbf' RESIZE 10G;安全加固建議
SELECT username FROM dba_users WHERE account_status != 'OPEN';
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS 3;
.png)
.png)
