Centos7 RPM 安装oracle 18.3c
oracle于今日发布了oracle database 18c的RPM安装包,特来体验一把。
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
选择Linux版本,进入Linux版本之后选择RPM下载:
操作系统:
1.下载预先安装的包:
#curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
-- 下载oracle的安装包:
# wget http://download.oracle.com/otn/linux/oracle18c/180000/oracle-database-ee-18c-1.0-1.x86_64.rpm?AuthParam=1539962668_5311e130d1cfb704834cf88b9c9c5e5c
# mv oracle-database-ee-18c-1.0-1.x86_64.rpm\?AuthParam\=1539962668_5311e130d1cfb704834cf88b9c9c5e5c oracle-database-ee-18c-1.0-1.x86_64.rpm
2.安装
## yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
会自动安装依赖的软件包。
Dependencies Resolved
======================================================================================================
Package Arch Version Repository Size
======================================================================================================
Installing:
oracle-database-preinstall-18c x86_64 1.0-1.el7 /oracle-database-preinstall-18c-1.0-1.el7.x86_64
55 k
Installing for dependencies:
bc x86_64 1.06.95-13.el7 base 115 k
bind-libs x86_64 32:9.9.4-61.el7_5.1 updates 1.0 M
bind-utils x86_64 32:9.9.4-61.el7_5.1 updates 204 k
compat-libcap1 x86_64 1.10-7.el7 base 19 k
compat-libstdc++-33 x86_64 3.2.3-72.el7 base 191 k
glibc-devel x86_64 2.17-222.el7 base 1.1 M
glibc-headers x86_64 2.17-222.el7 base 678 k
gssproxy x86_64 0.7.0-17.el7 base 108 k
kernel-headers x86_64 3.10.0-862.14.4.el7 updates 7.1 M
keyutils x86_64 1.5.8-3.el7 base 54 k
ksh x86_64 20120801-137.el7 base 885 k
libICE x86_64 1.0.9-9.el7 base 66 k
libSM x86_64 1.2.2-2.el7 base 39 k
libX11 x86_64 1.6.5-1.el7 base 606 k
libX11-common noarch 1.6.5-1.el7 base 164 k
libXau x86_64 1.0.8-2.1.el7 base 29 k
libXext x86_64 1.3.3-3.el7 base 39 k
libXi x86_64 1.7.9-1.el7 base 40 k
libXinerama x86_64 1.1.3-2.1.el7 base 14 k
libXmu x86_64 1.1.2-2.el7 base 71 k
libXrandr x86_64 1.5.1-2.el7 base 27 k
libXrender x86_64 0.9.10-1.el7 base 26 k
libXt x86_64 1.1.5-3.el7 base 173 k
libXtst x86_64 1.2.3-1.el7 base 20 k
libXv x86_64 1.0.11-1.el7 base 18 k
libXxf86dga x86_64 1.1.4-2.1.el7 base 19 k
libXxf86misc x86_64 1.0.3-7.1.el7 base 19 k
libXxf86vm x86_64 1.1.4-1.el7 base 18 k
libaio x86_64 0.3.109-13.el7 base 24 k
libaio-devel x86_64 0.3.109-13.el7 base 13 k
libbasicobjects x86_64 0.1.1-29.el7 base 25 k
libcollection x86_64 0.7.0-29.el7 base 41 k
libdmx x86_64 1.1.3-3.el7 base 16 k
libevent x86_64 2.0.21-4.el7 base 214 k
libini_config x86_64 1.3.1-29.el7 base 63 k
libnfsidmap x86_64 0.25-19.el7 base 50 k
libpath_utils x86_64 0.2.1-29.el7 base 28 k
libref_array x86_64 0.1.5-29.el7 base 26 k
libstdc++-devel x86_64 4.8.5-28.el7_5.1 updates 1.5 M
libtirpc x86_64 0.2.4-0.10.el7 base 88 k
libverto-libevent x86_64 0.2.5-4.el7 base 8.9 k
libxcb x86_64 1.12-1.el7 base 211 k
lm_sensors-libs x86_64 3.4.0-4.20160601gitf9185e5.el7 base 41 k
mailx x86_64 12.5-19.el7 base 245 k
net-tools x86_64 2.0-0.22.20131004git.el7 base 305 k
nfs-utils x86_64 1:1.3.0-0.54.el7 base 407 k
psmisc x86_64 22.20-15.el7 base 141 k
quota x86_64 1:4.01-17.el7 base 179 k
quota-nls noarch 1:4.01-17.el7 base 90 k
rpcbind x86_64 0.2.0-44.el7 base 59 k
smartmontools x86_64 1:6.5-1.el7 base 460 k
sysstat x86_64 10.1.5-13.el7 base 310 k
tcp_wrappers x86_64 7.6-77.el7 base 78 k
unzip x86_64 6.0-19.el7 base 170 k
xorg-x11-utils x86_64 7.5-22.el7 base 114 k
xorg-x11-xauth x86_64 1:1.0.9-1.el7 base 30 k
Updating for dependencies:
bind-libs-lite x86_64 32:9.9.4-61.el7_5.1 updates 734 k
bind-license noarch 32:9.9.4-61.el7_5.1 updates 85 k
libstdc++ x86_64 4.8.5-28.el7_5.1 updates 303 k
Transaction Summary
======================================================================================================
Install 1 Package (+56 Dependent packages)
Upgrade ( 3 Dependent packages)
3.安装oracle-database-servrer:
# rpm -ivh oracle-database-ee-18c-1.0-1.x86_64.rpm
warning: oracle-database-ee-18c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-ee-18c-1.0-1 ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-18c configure
注意:上述安装部署比较耗时,需要耐心等待。
4.参看配置文件:
# cat /etc/sysconfig/oracledb_ORCLCDB-18c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracledb_ORCLCDB configure'.
#Please use this file to modify the default listener port and the
#Oracle data location.
# LISTENER_PORT: Database listener
LISTENER_PORT=1521
# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/opt/oracle/oradata
# EM_EXPRESS_PORT: Oracle EM Express listener
EM_EXPRESS_PORT=5500
5.配置:
## /etc/init.d/oracledb_ORCLCDB-18c configure
执行脚本之后将创建一个容器数据库(ORCLCDB)和一个可插拔数据库(ORCLPDB1),并且配置的默认监听端口是1521.
--详细信息:
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
6.进程和端口查看:
#端口查看
# netstat -nultp | grep -E '1521|5500'
tcp6 0 0 :::1521 :::* LISTEN 590400/tnslsnr
tcp6 0 0 :::5500 :::* LISTEN 590400/tnslsnr
# ps -ef | grep -i orcl | grep -v grep
oracle 604203 1 0 00:08 ?00:00:00 ora_pmon_ORCLCDB
oracle 604205 1 0 00:08 ?00:00:00 ora_clmn_ORCLCDB
oracle 604207 1 0 00:08 ?00:00:00 ora_psp0_ORCLCDB
oracle 604210 1 0 00:08 ?00:00:00 ora_vktm_ORCLCDB
oracle 604214 1 0 00:08 ?00:00:00 ora_gen0_ORCLCDB
oracle 604216 1 2 00:08 ?00:00:04 ora_mman_ORCLCDB
oracle 604220 1 0 00:08 ?00:00:00 ora_gen1_ORCLCDB
oracle 604223 1 0 00:08 ?00:00:00 ora_diag_ORCLCDB
oracle 604225 1 0 00:08 ?00:00:00 ora_ofsd_ORCLCDB
oracle 604228 1 0 00:08 ?00:00:00 ora_dbrm_ORCLCDB
oracle 604230 1 0 00:08 ?00:00:00 ora_vkrm_ORCLCDB
oracle 604232 1 0 00:08 ?00:00:00 ora_svcb_ORCLCDB
oracle 604234 1 0 00:08 ?00:00:00 ora_pman_ORCLCDB
oracle 604236 1 0 00:08 ?00:00:01 ora_dia0_ORCLCDB
oracle 604238 1 0 00:08 ?00:00:00 ora_dbw0_ORCLCDB
oracle 604240 1 0 00:08 ?00:00:00 ora_dbw1_ORCLCDB
oracle 604242 1 0 00:08 ?00:00:00 ora_dbw2_ORCLCDB
oracle 604244 1 0 00:08 ?00:00:00 ora_dbw3_ORCLCDB
oracle 604246 1 0 00:08 ?00:00:00 ora_dbw4_ORCLCDB
oracle 604248 1 0 00:08 ?00:00:00 ora_dbw5_ORCLCDB
oracle 604250 1 0 00:08 ?00:00:00 ora_lgwr_ORCLCDB
oracle 604252 1 0 00:08 ?00:00:00 ora_ckpt_ORCLCDB
oracle 604254 1 0 00:08 ?00:00:00 ora_lg00_ORCLCDB
oracle 604256 1 0 00:08 ?00:00:00 ora_smon_ORCLCDB
oracle 604258 1 0 00:08 ?00:00:00 ora_lg01_ORCLCDB
oracle 604260 1 0 00:08 ?00:00:00 ora_smco_ORCLCDB
oracle 604262 1 0 00:08 ?00:00:00 ora_reco_ORCLCDB
oracle 604264 1 0 00:08 ?00:00:00 ora_w000_ORCLCDB
oracle 604266 1 0 00:08 ?00:00:00 ora_lreg_ORCLCDB
oracle 604268 1 0 00:08 ?00:00:00 ora_w001_ORCLCDB
oracle 604270 1 0 00:08 ?00:00:00 ora_pxmn_ORCLCDB
oracle 604274 1 0 00:08 ?00:00:01 ora_mmon_ORCLCDB
oracle 604276 1 0 00:08 ?00:00:00 ora_mmnl_ORCLCDB
oracle 604278 1 0 00:08 ?00:00:00 ora_d000_ORCLCDB
oracle 604280 1 0 00:08 ?00:00:00 ora_s000_ORCLCDB
oracle 604282 1 0 00:08 ?00:00:00 ora_tmon_ORCLCDB
oracle 604304 1 0 00:08 ?00:00:00 ora_m000_ORCLCDB
oracle 604306 1 0 00:08 ?00:00:00 ora_m001_ORCLCDB
oracle 604321 1 0 00:08 ?00:00:00 ora_tt00_ORCLCDB
oracle 604323 1 0 00:08 ?00:00:00 ora_tt01_ORCLCDB
oracle 604325 1 0 00:08 ?00:00:00 ora_tt02_ORCLCDB
......
7.切换账号登录系统:
# su - oracle
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
原因:
$ echo $ORACLE_HOME
/opt/oracle/product/18c/dbhome_1
$ echo $ORACLE_SID
$
解决办法:
$ export ORACLE_SID=ORCLCDB
$ ./sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Oct 20 00:30:17 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
--版本查询:
SQL> select banner from sys.v_$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production 0
8.若需要正常使用还需要配置环境变量:
# cat /etc/profile.d/oracle.sh
#/bin/bash
export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=ORCLCDB
# source /etc/profile.d/oracle.sh
$ sqlplus / as sysdba
9.若在虚拟机中安装体验rpm包的oracle:
$ du -sh /opt/
12G /opt/
/opt 目录至少需要12G,此外还需要考虑RPM的oracle安装文件。
--删除oracle实例:
以oracle的账号登录删除实例,删除监听,再以root的账号删除软件。
$ cd $ORACLE_HOME/bin
$ ./dbca
$ cd $ORACLE_HOME/bin
$ ./netca
# yum -y remove oracle-database-ee-18c
参考文档:
https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/running-rpm-packages-to-install-oracle-database.html#GUID-BB7C11E3-D385-4A2F-9EAF-75F4F0AACF02