C/C++教程

oracle

本文主要是介绍oracle,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

linux.x64_11gR2_database_1of2.zip

linux.x64_11gR2_database_2of2.zip


free -h | grep G

Mem:           6.8G   


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


cp -pv /etc/redhat-release /etc/redhat-release.bak

echo redhat-7 > /etc/redhat-release &&  cat /etc/redhat-release

redhat-7


yum install -y binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh*


cp -pv /etc/sysctl.conf /etc/sysctl.conf.bak

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

sysctl -p


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


1.jpg


2.jpg


3.jpg


4.jpg


5.jpg


6.jpg


7.jpg


8.jpg


9.jpg


10.jpg


11.jpg


12.jpg


13.jpg


14.jpg

这篇关于oracle的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!