十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
年底了一直很忙,今天忙中偷闲安装了一下Oracle18C的RPM包安装方法。总的感觉还是比较方便的,大大的简化了oracle 的安装,让非专业的DBA也有了比较好的安装体验。下面就带来我安装过程中的一些步骤分享:
创新互联公司是一家成都做网站、网站制作,提供网页设计,网站设计,网站制作,建网站,按需开发,网站开发公司,从2013年开始是互联行业建设者,服务者。以提升客户品牌价值为核心业务,全程参与项目的网站策划设计制作,前端开发,后台程序制作以及后期项目运营并提出专业建议和思路。环境介绍:
OS: Redhat 7.5 , Mem 4G, CPU 4C,DISK 200G
Red Hat Enterprise Linux Server release 7.5 (Maipo)
下载rpm安装包:
oracle-database-ee-18c-1.0-1.x86_64.rpm
oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
安装步骤
3.1 配置yum
#cd /etc/yum.repos.d
[rhel7.5]
name=my_repo
baseurl=file:///mnt
gpgcheck=0
3.2 安装依赖包:
yum -y install xorg-x11-xauth xorg-x11-utils libstdc++-devel libaio-devel ksh compat-libcap
注意:在redhat7.5中,compat-libstdc++-33这个包是没有,请自行下载,并手动安装。
3.3 安装数据库
1)yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
安装提示的信息比较多,此处省略。。。。。
2)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
3.4 配置数据库
在root下执行:
3.5 安装完成后检查
该步骤执行的时间较长,需要耐心的等待。。。。
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.
3.5 安装检查
1)Oracle配置环境变量:
[oracle@rhel75-dev-31-81 ~]$ vi .bash_profile
export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
export ORACLE_VERSION=18c
export ORACLE_SID=ORCLCDB
PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin
export PATH
2)检查监听
lsnrctl status
Service "7f7a654558113bdde055025056a8c790" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDBXDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "orclpdb1" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
The command completed successfully
3)登录数据库
sqlplus / as sysdba
[oracle@rhel75-dev-31-81 ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Jan 15 14:50:55 2019
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
当然还有很多的新的特性,后续的文章会向大家一一阐述,时间有限难免有出错的地方,如有问题请大家及时指正。欢迎讨论。
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。