centos7安装Oracle
安装Oracle 需要的软件 将链接放下面了 如找不到请联系或者评论我
链接:https://pan.baidu.com/s/10bknxq3hUo79l97T3kGsPg
提取码:e23h
安装部署oracle
安装前注意
1、剩余内存空间必须大于120MB
2、交换空间必须大于150MB
1配置交换空间
dd if=/dev/zero of=/home/swap bs=1M count=2048
mkswap /home/swap
chmod 600 /home/swap
swapon /home/swap
2查看
swapon -s
一、配置yum源
mv CentOS-Base.repo CentOS-Base.repo.bak
wget -O /etc/yum.repos.d/CentOSBase.repo http://mirrors.aliyun.com/repo/Centos-7.repo
二、安装编译环境
yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake pcre pcre-devel openssl openssl-devel jemalloc-devel tlc libtool bash-completion
三、修改主机名添加到host
hostnamectl set-hostname xiaoming
四、oracle依赖包安装
yum -y install binutils compat-libstdc++-33 elfutils-libelf-devel elfutils-libelf-devel-static elfutils-libelf-devel ksh libaio libaio-devel numactl-devel sysstat unixODBC unixODBC-devel pcre-devel
五、添加组用户
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
5.1根据官网修改内核参数
vim /etc/sysctl.conf
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 = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
5.2修改用户限制
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
5.3创建安装目录及权限
mkdir -p /opt/oracle/product/11.2.0
mkdir /opt/oracle/oradata
mkdir /opt/oracle/inventory
mkdir /opt/oracle/fast_recovery_area
chown -R oracle:oinstall /opt/oracle
chmod -R 775 /opt/oracle
六、解压oracle安装包
mkdir /opt/software
cd /opt/software
unzip linux.x64_11gR2_database_1of2.zip && unzip linux.x64_11gR2_database_2of2.zip
得到一个database文件 该文件应该在/opt/software下
七 、配置环境变量(使用oracle用户操作)
vim /home/oracle/.bash_profile
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export DISPLAY=192.168.73.73:0.0
如下 :
八、编辑oracle配置文件
vim /opt/software/database/response/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=xiaoming
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/opt/oracle/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/opt/oracle/product/11.2.0
ORACLE_BASE=/opt/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true
九、oracle安装(使用oracle用户操作)
./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /opt/software/database/response/db_install.rsp
出现以下说明成功
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
十、执行所需脚本
source /opt/oracle/inventory/orainstRoot.sh
source /opt/oracle/product/11.2.0/root.sh
十一、oracle配置监听
netca -silent -responseFile /opt/software/database/response/netca.rsp
注意配置监听时候可能会出现两种错误
①出现display问题
去Oracle用户家目录添加以下环境变量即可
vim /home/oracle/.bash_profile
export DISPLAY=192.168.73.73:0.0
source .bash_profile
②出现178行已放弃问题
问题是主机名为默认主机名,需修改主机名
出现以下说明成功
Oracle Net Services configuration successful. The exit code is 0
十二、查看端口是否正常监听
netstat -anpt | grep 1521
十三、配置oracle用户实例
vim /opt/software/database/response/dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl"
SID = "orcl"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
SYSMANPASSWORD = "oracle"
DBSNMPPASSWORD = "oracle"
DATAFILEDESTINATION =/opt/oracle/oradata
RECOVERYAREADESTINATION=/opt/oracle/fast_recovery_area
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "1638"
十四、实例安装 (Oracle用户执行)
dbca -silent -responseFile /opt/software/database/response/dbca.rsp
证明成功
##修改监听配置文件(默认为主机名)
vim $ORACLE_HOME/network/admin/listener.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =xiaoming)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
##一般不用修改 因为都改好了
十五、启动关闭
1.关闭监听
lsnrctl stop
2.关闭实例
sqlplus / as sysdba
SQL> shutdow immediate;
3.启动实例
sqlplus / as sysdba
SQL> startup;
4.启动监听
lsnrctl start
5.配置local_listener参数
sqlplus / as sysdba
6.配置参数
alter system set local_listener="(address = (protocol = tcp)(host = 192.168.73.73)(port = 1521))";
7.查看show parameter local_listener;
8.启动监听 lsnrctl status
嘻嘻~ 到这里就证明宁已经成功了~
我出门总是带着五瓶药水,手中的卡牌不停切换到位。
别跟我撒娇也别叫我宝贝,就算我一个人也不会后退。
以下 为可选操作 :
创建数据库文件
CREATE TABLESPACE MyDataBase LOGGING DATAFILE '/opt/oracle/oradata/orcl/MyDataBase.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
创建数据库临时文件
create temporary TABLESPACE MyDataBase_temp tempfile '/opt/oracle/oradata/orcl/MyDataBase_temp.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
创建用户与上述两个文件形成映射关系
CREATE USER xiaoming IDENTIFIED BY Admin123 DEFAULT TABLESPACE MyDataBase TEMPORARY TABLESPACE MyDataBase_temp;
添加用户权限
grant connect,resource,dba to xiaoming;
grant create session to xiaoming;
删除数据库
conn sys/dwh as sysdba;
drop tablespace MyDataBase including contents and datafiles;
drop tablespace MyDataBase_temp including contents and datafiles;
删除用户
drop user xiaoming cascade;