CentOS7下安装配置Oracle的操作步骤教程
程序员文章站
2022-06-21 21:17:44
1.安装centos7
配置如下：
安装时必须安装ghome桌面
安装完成后，以root用户登录，然后执行
#需要联网
yum update
yum upgrade
2.安装java 环...
1.安装centos7
配置如下：
安装时必须安装ghome桌面
安装完成后，以root用户登录，然后执行
#需要联网 yum update yum upgrade
2.安装java 环境
#查询出默认安装java rpm -qa | grep java #删除查询出结果 rpm -e --nodeps #安装java rpm -ivh jdk-7u80-linux-x64.rpm #配置环境变量 vim /etc/profile #在末尾添加 #set java environment java_home=/usr/java/jdk1.7.0_80 jre_home=/usr/java/jdk1.7.0_80/jre class_path=.:$java_home/lib/dt.jar:$java_home/lib/tools.jar:$jre_home/lib path=$path:$java_home/bin:$jre_home/bin:/usr/local/mysql/bin export java_home jre_home class_path path
3.安装 oracle 11r2
首先下载oracle 11r2 安装包
linux.x64_11gr2_database_1of2.zip linux.x64_11gr2_database_2of2.zip
创建用户和用户组 groupadd oinstall #用户组 groupadd dba #用户组 useradd -g dba -g oinstall -m oracle #创建用户oracle,并加入dba,oinstall passwd oracle #设置密码 创建oracle安装目录 mkdir -p /oracle/orainventory #oracle 数据库配置目录 chown -r oracle:oinstall /oracle #设置目录所有者为 oinstall 用户组的 oracle 用户 chown -r oracle:oinstall /oracle/orainventory 修改系统标识 vim /etc/redhat-release #编辑 把 centos linux release 7.0.1406 (core) 修改为 #centos linux release 7.0.1406 (core) red hat enterprise linux 6 修改系统内核 vim /etc/sysctl.conf #编辑，在最后添加以下代码 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 = 1048576 net.ipv4.icmp_echo_ignore_broadcasts = 1 vim /etc/security/limits.conf #在末尾添加以下代码 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 配置oracle用户环境变量 vim /home/oracle/.bash_profile #在最后添加以下代码 export oracle_base=/oracle #oracle 数据库安装目录 export oracle_home=$oracle_base/product/11.2.0/db_1 #oracle 数据库路径 export oracle_sid=orcl #oracle 启动数据库实例名 export oracle_unqname=$oracle_sid export path=$oracle_home/bin:/user/sbin:$path #添加系统环境变量 export ld_library_path=$oracle_home/lib:$ld_library_path #添加系统环境变量
安装oracle数据库所需要的软件包
yum install gcc* gcc-* gcc-c++-* glibc-devel-* glibc-headers-* compat-libstdc* libstdc* elfutilslibelf-devel* libaio-devel* sysstat* unixodbc-* pdksh-*
4.重启下系统，以oracle身份登录系统
5.解压oracle安装包
unzip linux.x64_11gr2_database_1of2.zip unzip linux.x64_11gr2_database_2of2.zip
6.
cd database
7.
export lang=en_us #防止乱码
8.运行安装程序(不要使用xshell操作,直接在桌面打开终端操作)
./runinstaller
等待......
取消默认选择,点击next
点击yes
点击next
选择server class ,点击next
点击next
选择 advanced install 点击 next
添加简体中文,点击next
点击next
设置好环境变量了，这里会自动填充路径，点击 next
默认inventory directory为/orainventory,修改为/oracle/orainventory 点击next
点击yes，弹框可能显示不出来,按方向键左键,按enter
点击next
点击next
配置字符集，点击 next
点击next
点击next
点击next
选择统一设置密码，点击 next
点击yes，弹框可能显示不出来，按方向键左键，按enter
点击next
勾选ignore all，点击next
点击finish
进入安装过程
安装到 68%的时候会有如下提示，直接点击 continue,弹框可能无法展示,直接按enter
点击ok
以下窗口可能被缩成一条竖线在中间，用鼠标拉开即可看到，安装过程如出现窗口变暗，但是没有弹框弹出，即为此类情况
9.打开命令行窗口
su 输入 root 帐号密码，运行 /oracle/orainvertory/orainstroot.sh /oracle/product/11.2.0/dbhome_1/root.sh
10.安装完成后，把系统标识修改回来
vim /etc/redhat-release #编辑 把 #centos linux release 7.0.1406 (core) red hat enterprise linux 6 修改为： centos linux release 7.0.1406 (core)
11.登录oracle
[oracle@localhost ~]$ lsnrctl stop #先关闭监听服务 [oracle@localhost ~]$ lsnrctl start #开启监听服务 [oracle@localhost ~]$ sqlplus / as sysdba #登入 sql> shutdown immediate #立即关闭数据库服务（一般是关闭状态） sql> startup #开启数据库服务（重要，必输） sql> exit #退出 sql> sqlplus scott/tiger@192.168.47.131/orcl #连接scott用户 sql> select * from tab; #test查询表
12，使用pl/sql连接时,可能会“ora-12514 tns 监听程序当前无法识别连接描述符中请求服务”
解决办法简述：
1.修改\oracle\product\11.2.0\db_1\network\admin\listener.ora中的(host)bt-199-039.bta.net.cn改为192.168.47.131
2.修改\oracle\product\11.2.0\db_1\network\admin\tnsnames.ora中的(host)bt-199-039.bta.net.cn 改为192.168.47.131
3.修改后，重启oracle，监听，并注册，主win10上的plsql就可以远程连接虚拟机上的数据库了.
具体操作步骤如下：
一、修改数据库服务器中listener.ora文件内容
[oracle@localhost admin]$ vim /oracle/product/11.2.0/db_1/network/admin/listener.ora
原始内容:
# listener.ora network configuration file: /oracle/product/11.2.0/db_1/network/admin/listener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1521))
(address = (protocol = tcp)(host = bt-199-039.bta.net.cn)(port = 1521))
)
)
adr_base_listener = /oracle
修改为 # listener.ora network configuration file: /oracle/product/11.2.0/db_1/network/admin/listener.ora # generated by oracle configuration tools. sid_list_listener = (sid_list = (sid_desc = (global_dbname = orcl) (oracle_home = /oracle/product/11.2.0/db_1) (sid_name = orcl) ) ) listener = (description = (address = (protocol = tcp)(host = 192.168.47.131)(port = 1521))) adr_base_listener = /oracle
修改数据库服务器中tnsnames.ora文件内容
[oracle@localhost admin]$ vim /oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
原始内容:
# tnsnames.ora network configuration file: /oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# generated by oracle configuration tools.
orcl =
(description =
(address = (protocol = tcp)(host = localhost)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = orcl)
)
)
修改后的内容：
# tnsnames.ora network configuration file: /oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# generated by oracle configuration tools.
orcl =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.47.131)(port = 1521))
)
(connect_data =
(sid = orcl)
)
)
在数据库服务器中启动监听并更新注册
1、命令： [oracle@localhost ~]$ lsnrctl stop #先关闭监听服务 输出： lsnrctl for linux: version 11.2.0.1.0 - production on 19-feb-2017 21:19:42 copyright (c) 1991, 2009, oracle. all rights reserved. connecting to (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) the command completed successfully [oracle@localhost ~]$ 2、命令： [oracle@localhost ~]$ lsnrctl start #开启监听服务 输出: lsnrctl for linux: version 11.2.0.1.0 - production on 19-feb-2017 21:24:22 copyright (c) 1991, 2009, oracle. all rights reserved. starting /data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... tnslsnr for linux: version 11.2.0.1.0 - production system parameter file is /data/oracle/product/11.2.0/db_1/network/admin/listener.ora log messages written to /data/oracle/diag/tnslsnr/localhost/listener/alert/log.xml listening on: (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) connecting to (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) status of the listener ------------------------ alias listener version tnslsnr for linux: version 11.2.0.1.0 - production start date 19-feb-2017 21:24:22 uptime 0 days 0 hr. 0 min. 0 sec trace level off security on: local os authentication snmp off listener parameter file /data/oracle/product/11.2.0/db_1/network/admin/listener.ora listener log file /data/oracle/diag/tnslsnr/localhost/listener/alert/log.xml listening endpoints summary... (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) services summary... service "orcl" has 1 instance(s). instance "orcl", status unknown, has 1 handler(s) for this service... the command completed successfully [oracle@localhost ~]$ 3、命令： [oracle@localhost ~]$ sqlplus / as sysdba #登入 输出： sql*plus: release 11.2.0.1.0 production on sun feb 19 21:27:40 2017 copyright (c) 1982, 2009, oracle. all rights reserved. connected to: oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production with the partitioning, olap, data mining and real application testing options sql> 命令： sql> shutdown immediate #立即关闭数据库服务 输出： database closed. database dismounted. oracle instance shut down. sql> 命令: sql> startup #开启数据库服务 输出： oracle instance started. total system global area 1586708480 bytes fixed size 2213736 bytes variable size 939526296 bytes database buffers 637534208 bytes redo buffers 7434240 bytes database mounted. database opened. sql> 命令： sql> alter system register; #注册 输出： system altered. sql> 命令： sql> quit #登出 输出： disconnected from oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production with the partitioning, olap, data mining and real application testing options [oracle@localhost ~]$ 命令： [oracle@localhost ~]$ lsnrctl status #查看监听状态 输出： lsnrctl for linux: version 11.2.0.1.0 - production on 19-feb-2017 21:37:20 copyright (c) 1991, 2009, oracle. all rights reserved. connecting to (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) status of the listener ------------------------ alias listener version tnslsnr for linux: version 11.2.0.1.0 - production start date 19-feb-2017 21:24:22 uptime 0 days 0 hr. 12 min. 57 sec trace level off security on: local os authentication snmp off listener parameter file /data/oracle/product/11.2.0/db_1/network/admin/listener.ora listener log file /data/oracle/diag/tnslsnr/localhost/listener/alert/log.xml listening endpoints summary... (description=(address=(protocol=tcp)(host=192.168.78.130)(port=1521))) services summary... service "orcl" has 1 instance(s). instance "orcl", status unknown, has 1 handler(s) for this service... the command completed successfully [oracle@localhost ~]$