Oracle 11g一键自动安装代码（oracle11g安装使用）

#!/bin/bash

# 安装依赖软件包

yum install -y binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

# 创建oracle用户

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1

mkdir -p /u01/app/oracle/admin/orcl/adump

chown -R oracle:oinstall /u01

chmod -R 775 /u01

# 静默安装Oracle

cd /tmp

curl -O https://example.com/oracle-11g-linux-x64.zip # 替换为oracle安装文件的下载链接

unzip -q oracle-11g-linux-x64.zip

cd database

./runInstaller -silent -responseFile /tmp/db_install.rsp

# 配置Oracle环境变量

echo "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1" >> /home/oracle/.bash_profile

echo "export PATH=\$ORACLE_HOME/bin:\$PATH" >> /home/oracle/.bash_profile

echo "export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib" >> /home/oracle/.bash_profile

# 安装完成后执行的脚本

echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf

echo "fs.file-max = 6815744" >> /etc/sysctl.conf

echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf

echo "kernel.shmmax = 4294967296" >> /etc/sysctl.conf

echo "kernel.shmall = 2097152" >> /etc/sysctl.conf

echo "kernel.shmmni = 4096" >> /etc/sysctl.conf

echo "oracle soft nofile 1024" >> /etc/security/limits.conf

echo "oracle hard nofile 65536" >> /etc/security/limits.conf

echo "oracle soft nproc 2047" >> /etc/security/limits.conf

echo "oracle hard nproc 16384" >> /etc/security/limits.conf

echo "oracle soft stack 10240" >> /etc/security/limits.conf

echo "oracle hard stack 32768" >> /etc/security/limits.conf

# 重新加载配置文件

sysctl -p

# 启动Oracle服务

su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName orcl -sid orcl -sysPassword oracle -systemPassword oracle

-- 创建数据库

CREATE DATABASE mydb

USER SYS IDENTIFIED BY sys_password

USER SYSTEM IDENTIFIED BY system_password;

-- 创建表空间

CREATE TABLESPACE myts

DATAFILE '/u01/app/oracle/oradata/mydb/myts01.dbf'

SIZE 10M AUTOEXTEND ON;

-- 创建用户并授权

CREATE USER myuser IDENTIFIED BY my_password

DEFAULT TABLESPACE myts

TEMPORARY TABLESPACE temp;

GRANT CONNECT, RESOURCE TO myuser;