linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
cat /etc/redhat-release && free -h | grep G
CentOS Linux release 7.8.2003 (Core)
Mem: 6.8G
cp -pv /etc/redhat-release /etc/redhat-release.bak
echo redhat-7 > /etc/redhat-release && cat /etc/redhat-release
redhat-7
cp -pv /etc/sysctl.conf /etc/sysctl.conf.bak
echo net.ipv4.tcp_syncookies = 1 >> /etc/sysctl.conf
echo net.ipv4.tcp_tw_reuse = 1 >> /etc/sysctl.conf
echo net.ipv4.tcp_tw_recycle = 1 >> /etc/sysctl.conf
echo net.ipv4.tcp_fin_timeout = 10 >> /etc/sysctl.conf
echo net.ipv4.ip_forward= 1 >> /etc/sysctl.conf
sysctl -p
groupadd oinstall && groupadd dba
useradd -g oinstall -g dba -m oracle
echo oracle | passwd --stdin oracle
mkdir -pv /data/{oracle,oraInventory,database}
mkdir -pv /data/oracle/product/11.2.0/db_1
yum install -y binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.*
yum install -y glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* glibc-devel-2.*
yum install -y libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh*
cat /etc/sysctl.conf
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max= 4194304
net.core.wmem_default= 262144
net.core.wmem_max= 1048576
net.ipv4.tcp_fin_timeout=2
net.ipv4.tcp_tw_reuse=1
net.ipv4.tcp_tw_recycle=1
cp -pv /etc/security/limits.conf /etc/security/limits.conf.bak
tail -n4 /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
cp -pv /home/oracle/.bash_profile /home/oracle/.bash_profile.bak
tail -n7 /home/oracle/.bash_profile
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
source /home/oracle/.bash_profile
unzip linux.x64_11gR2_database_1of2.zip -d /data/database/
unzip linux.x64_11gR2_database_2of2.zip -d /data/database/
chown -R oracle:oinstall /data/database/database/
chown -R oracle:oinstall oraInventory
chown -R oracle:oinstall oracle/
export DISPLAY=localhost:2
xhost +
access control disabled, clients can connect from any host
docker部署oracle12
mkdir -pv /usr/local/oracle
mkdir -pv /usr/local/oracle/data
docker pull docker pull absolutapps/oracle-12c-ee
docker run -itd -p 1521:1521 -p 8080:8080 --restart=always
-v /usr/local/oracle/data:/data/oracle
--name oracle absolutapps/oracle-12c-ee
docker logs oracle -f 檢視oracle容器日志
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-JAN-2022 11:22:23
Starting /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait...
System parameter file is /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/e1be87ea6966/listener/alert/log.xml
Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/e1be87ea6966/listener/alert/log.xml
docker exec -it oracle /bin/bash 進入oracle容器
docker save absolutapps/oracle-12c-ee > oracle12_images.tar.gz 備份oracle鏡像
docker load oracle12_images.tar.gz 恢複oracle鏡像
docker export oracle > oracle_docker.tar.gz 備份oracle容器
docker improt oracle_docker.tar.gz 恢複oracle容器
netstat -tuplna | grep 1521
tcp6 0 0 :::1521 :::* LISTEN 1730/docker-proxy
netstat -tuplna | grep 8080
tcp6 0 0 :::8080 :::* LISTEN 1719/docker-proxy
http://serverip:8080/em/login
oracle預設使用者名 system
oracle預設驗證 oracle