rpm -qa|grep "wget"

yum -y install wget

cd /etc

mv yum.repos.d yum.repos.d.bak

mkdir yum.repos.d

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

yum clean all

yum makecache

plugins=0

rpm –q

rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel | grep "not installed"

yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

创建用户组：groupadd oinstall

创建用户组：groupadd dba

创建用户并添加到用户组：useradd -g oinstall -G dba oracle

passwd oracle

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

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 = 1048586

/sbin/sysctl -p

oracle      soft          nproc      2047

oracle      hard        nproc      16384

oracle      soft          nofile       1024

oracle      hard        nofile       65536

oracle      soft          stack       10240

oracle      hard        stack       10240

session  required   /lib64/security/pam_limits.so

session  required   pam_limits.so

if [ $USER = "oracle" ]; then

    if [ $SHELL = "/bin/ksh" ]; then

        ulimit -p 16384

        ulimit -n 65536

    else

        ulimit -u 16384 -n 65536

    fi

fi

source /etc/profile

mkdir -p /data/oracle

chown -R oracle:oinstall /data/oracle

chmod -R 775 /data/oracle

inventory_loc=/data/oracle/oraInventory

inst_group=oinstall

chown oracle:oinstall /etc/oraInst.loc

chmod 664 /etc/oraInst.loc

su - oracle

export ORACLE_BASE=/data/oracle

export ORACLE_SID=orcl

source /home/oracle/.bash_profile

env

yum -y install unzip zip

cd /data/oracle/

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

cd /home/oracle/

mkdir etc

cp /data/oracle/database/response/* /home/oracle/etc/

su - root

chmod 700 /home/oracle/etc/*.rsp

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=centos7

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/data/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN,zh_TW

ORACLE_HOME=/data/oracle/product/11.2.0/db_1

ORACLE_BASE=/data/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=false

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.globalDBName=orcl

oracle.install.db.config.starterdb.SID=orcl

oracle.install.db.config.starterdb.memoryLimit=512

oracle.install.db.config.starterdb.password.ALL=oracle

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

su – oracle

cd /data/oracle/database

./runInstaller -silent -ignorePrereq -responseFile /home/oracle/etc/db_install.rsp

su - root

/data/oracle/product/11.2.0/db_1/root.sh

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE/lib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export LIBPATH=${CLASSPATH}:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

export ORACLE_OWNER=oracle

export SPFILE_PATH=$ORACLE_HOME/dbs

export ORA_NLS10=$ORACLE_HOME/nls/data

source /home/oracle/.bash_profile

env

cd /data/oracle/product/11.2.0/db_1/bin

./netca /silent /responseFile /home/oracle/etc/netca.rsp

#停止监听

lsnrctl stop

#启动监听

lsnrctl start

#查看监听状态

lsnrctl status

GDBNAME="orcl " 

SID="orcl"

SYSPASSWORD = "oracle" 

SYSTEMPASSWORD = "oracle" 

CHARACTERSET="AL32UTF8" 

NATIONALCHARACTERSET="UTF8"

cd /data/oracle/product/11.2.0/db_1/bin

dbca -silent -responseFile /home/oracle/etc/dbca.rsp

orcl:/data/oracle/product/11.2.0/db_1:Y

su oracle -lc "/data/oracle/product/11.2.0/db_1/bin/lsnrctl start"

su oracle -lc /data/oracle/product/11.2.0/db_1/bin/dbstart

chmod +x /etc/rc.d/rc.local

firewall-cmd --zone=public --add-port=1521/tcp --permanent

firewall-cmd --reload

sqlplus / as sysdba

create user abc identified by 123456;

grant connect,resource,dba to abc;

quit

test =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.10)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ORCL)

    )

  )