oracle11安装及使用

原创

已于 2024-03-12 10:07:14 修改 · 2.6k 阅读

20 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

于 2024-02-28 10:47:22 首次发布

安装oracle11

官网下载地址 Oracle Database 11g Release 2 for Microsoft Windows (x64)

官网下载慢可访问我的资源

也可以网盘获取

链接：https://pan.baidu.com/s/1RDrGkqDA7tfKRnpJXUBMDw
提取码：z3na

上传安装包到服务器

在指定目录下创建文件夹installfile，我是在/newdisk/oracle/installfile，将安装文件上传到该文件夹

禁用防火墙

systemctl stop firewalld.service

systemctl disable firewalld.service

安装依赖包

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

验证依赖包

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel

创建orcale用户

[root@localhost installfile]# groupadd -g 502 oinstall
[root@localhost installfile]# groupadd -g 503 dba
[root@localhost installfile]# groupadd -g 504 oper
[root@localhost installfile]# groupadd -g 505 asmadmin
[root@localhost oracle]# sudo useradd -u 502 -g oinstall -G oinstall,dba,asmadmin,oper -s /bin/bash -m oracle
[root@localhost oracle]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@localhost oracle]#

创建oradata目录，解压oracle安装包

mkdir /oradata

将/newdisk/oracle/oradatainstallfile/文件夹下的压缩包剪切到/oradata下面

drwxr-xr-x. 2 root root 98 Feb 27 00:31 installfile
drwxr-xr-x. 2 root root  6 Feb 27 02:03 oradata
[root@localhost oracle]# cp installfile/* oradata/
[root@localhost oracle]# ls oradata/
p13390677_112040_Linux-x86-64_1of7.zip  p13390677_112040_Linux-x86-64_2of7.zip
[root@localhost oracle]#

将/newdisk/oracle/oradata上的目录内的所有文件和文件夹的归属都修改为oracle用户

chown -R oracle:oinstall /newdisk/oracle/oradata

登录oracle用户将两个压缩文件解压

[root@localhost oradata]# su oracle
[oracle@localhost oradata]$ unzip p13390677_112040_Linux-x86-64_1of7.zip
[oracle@localhost oradata]$ unzip p13390677_112040_Linux-x86-64_2of7.zip

会多一个database文件夹

root用户下修改系统配置参数


[oracle@localhost oradata]$ su root
Password:
[root@localhost oradata]# vim /etc/security/limits.conf

#在最后加上下面配置

oracle          soft    nproc           2047
oracle          hard    nproc           16384
oracle