目錄
一、系統檢查與設置
1. 檢查系統版本與磁盤空間
2. 修改系統參數
3. 創建組和用戶
4. 設置主機名
5. 檢查安裝軟件包
6. 設置 oracle 用戶環境變量
二、安裝 Oracle 軟件包
1. 安裝 10.2.0.1 安裝包
2. 安裝 10.2.0.4 補丁
三、建庫
四、配置監聽器
1. 編輯配置文件
2. 啟動監聽器
五、后續
參考：
一、系統檢查與設置
1. 檢查系統版本與磁盤空間
df -hT
cat /etc/redhat-release2. 修改系統參數
vim /etc/sysctl.confkernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144sysctl -p3. 創建組和用戶
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
chown -R oracle:oinstall /data4. 設置主機名
vim /etc/hosts127.0.0.1 ? localhost localhost.localdomain localhost4 localhost4.localdomain4 vvml-yz-oracle.172.168.1.1
::1 ? ? ? ? localhost localhost.localdomain localhost6 localhost6.localdomain6
172.168.1.1 db015. 檢查安裝軟件包
yum -y install binutils.x86_64 compat-db.x86_64 compat-libstdc++-33.i386 compat-libstdc++-33.x86_64 cpp.x86_64 elfutils-libelf.i386 elfutils-libelf.x86_64 gcc-c++.x86_64 gcc.x86_64 glibc-devel.i386 glibc-devel.x86_64 glibc-headers.x86_64 glibc.i686 glibc.x86_64 ksh.x86_64 libaio-devel.i386 libaio-devel.x86_64 libaio.i386 libaio.x86_64 libstdc++.i386 libstdc++.x86_64 make.x86_64 setarch.x86_64 sysstat.x86_64yum -y install openssh-clients
yum -y install mlocate
yum -y install libXp
yum -y install libXp-1.0.0-15.1.el6.i686
yum -y install libXt-1.1.3-1.el6.i686 libXtst-1.2.1-2.el6.i686
yum -y install glibc-devel.i686
yum -y install libgcc.i686
yum -y install rsyncrpm -Uvh --force --nodeps openssl-1.0.1e-15.el6.x86_64.rpm6. 設置 oracle 用戶環境變量
su - oracle
vim .bash_profile...
# User specific aliases and functions
export ORACLE_BASE=/home/oracle/app/oracle;
export ORACLE_HOME=/home/oracle/app/oracle/product/10.2.0/db_1;
export PATH=.:$PATH:$ORACLE_HOME/bin;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/lib32:/lib64:/usr/lib64;
export ORACLE_SID=mvbox;
export NLS_LANG=american_america.AL32UTF8;
alias rman='rlwrap rman';
alias sqlplus='rlwrap sqlplus';source .bash_profile二、安裝 Oracle 軟件包
1. 安裝 10.2.0.1 安裝包
# 用 oracle 用戶的 vnc-client 圖形化執行 ！！！
cd ~/database
./runInstaller -ignoreSysPrereqs# /tmp/OraInstall2024-11-11_10-44-39AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
yum -y install libXp# /tmp/OraInstall2024-11-11_10-49-01AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: wrong ELF class: ELFCLASS64 occurred..
yum -y install libXp-1.0.0-15.1.el6.i686
yum -y install libXt-1.1.3-1.el6.i686 libXtst-1.2.1-2.el6.i686# Exception String: Error in invoking target 'install' of makefile '/home/oracle/app/oracle/product/10.2.0/db_1/ctx/lib/ins_ctx.mk'. See '/home/oracle/app/oracle/oraInventory/logs/installActions2024-11-11_11-28-10AM.log' for details.
# INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
yum -y install glibc-devel.i686# INFO: /home/oracle/app/oracle/product/10.2.0/db_1/lib32//libclntsh.so: file not recognized: File truncated
$ORACLE_HOME/bin/relink all# INFO: /home/oracle/app/oracle/product/10.2.0/db_1/sysman/lib/snmccolm.o: could not read symbols: File in wrong format
# 忽略，安裝 10.2.0.4 補丁即可解決2. 安裝 10.2.0.4 補丁
# 用 oracle 用戶的 vnc-client 圖形化執行 ！！！
cd ~/p6810189_10204_Linux-x86-64/Disk1/
./runInstaller# Error in setting permissions of file/directory /home/oracle/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/example.dmp
# 忽略（沒找到 example.dmp 文件，不影響使用）三、建庫
su - oracle
cd /data
mkdir oracledata# 用 oracle 用戶的 vnc-client 圖形化執行 ！！！
dbca# You need at lease 949248 KB on /data/, You have only -282345472 KB available. Please allocate more free disk space.
# 忽略# 點擊“Finish”沒反應
init 6 重啟系統后再執行 dbca 建庫四、配置監聽器
1. 編輯配置文件
vim /home/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.INBOUND_CONNECT_TIMEOUT_LISTENER = 0
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFFSID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /home/oracle/app/oracle/product/10.2.0/db_1)(PROGRAM = extproc))(SID_DESC =(GLOBAL_DBNAME = mvbox)(ORACLE_HOME = /home/oracle/app/oracle/product/10.2.0/db_1)(SID_NAME = mvbox)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.1)(PORT = 1521))))SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFFLISTNER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.1)(PORT = 1521)))))2. 啟動監聽器
lsnrctl start
lsnrctl status五、后續
rpm -ivh rlwrap-0.37-1.el6.x86_64.rpm
su - oracle
sqlplus / as sysdba參考：
- https://ivan.kartik.sk/oracle/install_ora10gR2_redhat.html
- https://www.cnblogs.com/wish41/p/6673706.html
- http://loadingok.com/wp-content/uploads/2021/09/linux%E7%B3%BB%E7%BB%9F%E5%8F%8Aoracle%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%89%E8%A3%85.pdf
- https://wenku.baidu.com/view/f5b7b15af01dc281e53af07f?aggId=75814379fbb069dc5022aaea998fcc22bdd14323&fr=catalogMain_text_ernie_recall_feed_index:wk_recommend_main3
- https://blog.itpub.net/31397003/viewspace-2146128/
- https://blog.csdn.net/gh57897053/article/details/4498154
安全狗)
)
