非Oracle Linux下安装Oracle 19c

àì夳堔傛蜴生んèń 2023-07-13 05:58 17阅读 0赞

《[Oracle 19c之RPM安装][Oracle 19c_RPM]》介绍了在Oracle Linux平台下安装Oracle 19c的过程，其实无论是19c，还是11g，用Oracle Linux会为你省不少的事情，毕竟同为Oracle产品，从推广角度看，肯定会相对其他平台提供更多的便利性，例如提前预安装了需要的Package，设置了信号量，创建了各种账号、路径和权限。

这次采用的19c rpm安装，下载地址是，

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

![format_png][]

首先关闭防火墙，

[root@bisal ~]# systemctl stop firewalld.service
    [root@bisal ~]# systemctl disable firewalld.service
    Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
    Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

安装19c前，需要安装preinstall包，做些前提准备，但是在这之前，需要确认compat-libstdc++-33-3.2.3-72.el7.x86\_64.rpm、ksh、libaio-devel包，再执行，

[root@bisal ~]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

19c默认安装路径是/opt/oracle，需要设置权限，

[root@bisal ~]# chown -R oracle:oinstall /opt/oracle
    [root@bisal ~]# chmod -R 755 /opt/oracle

安装19c软件，

[root@bisal ~]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm 
    warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key
    
    
    ID ec551f03: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:oracle-database-ee-19c-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-19c configure

在创建数据库前，可以改些配置，先备份下配置，将ORCLCDB替换为bisal，将ORCLPDB1替换为bisal，

[root@bisal ~]# cp /etc/init.d/oracledb_ORCLCDB-19c /etc/init.d/oracledb_bisal-19c
    [root@bisal ~]# vi /etc/init.d/oracledb_bisal-19c
    export ORACLE_VERSION=19c
    export ORACLE_SID=bisal
    export TEMPLATE_NAME=General_Purpose.dbc
    export CHARSET=AL32UTF8
    export PDB_NAME=bisal
    export LISTENER_NAME=LISTENER
    export NUMBER_OF_PDBS=1
    export CREATE_AS_CDB=false(从true改为false)

创建数据库，

[root@bisal ~]# ./oracledb_bisal-19c configure
    Configuring Oracle Database bisal.
    Prepare for db operation
    10% complete
    Copying database files
    40% complete
    Creating and starting Oracle instance
    42% complete
    46% complete
    50% complete
    54% complete
    60% complete
    Completing Database Creation
    66% complete
    70% complete
    Executing Post Configuration Actions
    100% complete
    Database creation complete. For details check the logfiles at:
     /opt/oracle/cfgtoollogs/dbca/bisal.
    Database Information:
    Global Database Name:bisal
    System Identifier(SID):bisal
    Look at the log file "/opt/oracle/cfgtoollogs/dbca/bisal/bisal.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.

设置oracle用户的环境变量，

echo "export LANG=en_US" >> ~/.bash_profile
    echo "export ORACLE_BASE=/opt/oracle" >> ~/.bash_profile
    echo "export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1" >> ~/.bash_profile
    echo "export ORACLE_SID=bisal" >> ~/.bash_profile
    echo "export NLS_LANG=AMERICAN_AMERICA.AL32UTF8" >> ~/.bash_profile
    echo "export PATH=$PATH:$ORACLE_HOME/bin" >> ~/.bash_profile

此时，就完成了19c的安装，确实较之前的版本有了很大的改进，但是我们说万变不离其宗，相关的配置和基本原理还是相同的，只是Oracle替我们封装了一些操作，这就是软件设计演进的过程。

**Oracle安装部署相关的历史文章：**

[Oracle 19c之RPM安装][Oracle 19c_RPM]

[数据库安装的两个小错误][Link 1]

[12c CC，不得已的重装][12c CC]

[Oracle 12c CC安装碰见的认证问题][Oracle 12c CC]

[Oracle 12c CC安装部署攻略 (下)][Oracle 12c CC_]

[Oracle 12c CC安装部署攻略 (上)][Oracle 12c CC_ 1]

[Oracle Patch补丁体系和如何打补丁][Oracle Patch]

[客户端ADR配置][ADR]

[安装Oracle Linux碰见的几个问题][Oracle Linux]

[11g Grid Control安装过程的一些“坑”][11g Grid Control]

**近期热文：**

《[公众号600篇文章分类和索引][600]》

《[Oracle ACE，一段不可思议的旅程][Oracle ACE]》

《[Oracle 19c之RPM安装][Oracle 19c_RPM]》

《[应用执行慢的问题排查路径][Link 2]》

《[ACOUG年会感想][ACOUG]》

《[千万级表数据更新的需求][Link 3]》

《[探寻大表删除字段慢的原因][Link 4]》

《[一次Oracle bug的故障排查过程思考][Oracle bug]》

《[新增字段的一点一滴技巧][Link 5]》

《[对recursive calls的深刻理解][recursive calls]》

《[《Oracle Concept》第三章 - 12][Oracle Concept_ - 12]》

《[幂等性][Link 6]》

《[一次惊心动魄的问题排查][Link 7]》

《[Java日期中“y”和“Y”的区别][Java_y_Y]》

《[英超梦幻之行][Link 8]》

《[藤子不二雄博物馆之行][Link 9]》

《[传控Tiki-Taka战术解惑][Tiki-Taka]》

[Oracle 19c_RPM]: https://blog.csdn.net/bisal/article/details/100909708
[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9hMXE2NGljODZQYW12RjhoeUhPRHVBQWZLb0NCZkxpY0Y4bHUwSGlhbnhTQW5mZGc0eFpzWUVHZ2RPVlJhV0JFUm9DaWNFSHpwclczcTdIc0ZpY0E2R2t4bUN3LzY0MA?x-oss-process=image/format,png
[Link 1]: https://blog.csdn.net/bisal/article/details/98694200
[12c CC]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea8148dfddf6c1c93bc2ca9a3e0ec496a5f6ea7e4e422e940d2e30727d8edb0d2a277ab26ad0&idx=1&mid=2247486764&scene=21&sn=5f86cf780a12f6e867db9d4188266f9f#wechat_redirect
[Oracle 12c CC]: https://blog.csdn.net/bisal/article/details/78150512
[Oracle 12c CC_]: https://blog.csdn.net/bisal/article/details/54743908
[Oracle 12c CC_ 1]: https://blog.csdn.net/bisal/article/details/54743923
[Oracle Patch]: https://blog.csdn.net/bisal/article/details/53365818
[ADR]: https://blog.csdn.net/bisal/article/details/52664867
[Oracle Linux]: https://blog.csdn.net/bisal/article/details/52551438
[11g Grid Control]: https://blog.csdn.net/bisal/article/details/51821856
[600]: https://blog.csdn.net/bisal/article/details/104548761
[Oracle ACE]: https://blog.csdn.net/bisal/article/details/94386471
[Link 2]: https://blog.csdn.net/bisal/article/details/102480420
[ACOUG]: https://blog.csdn.net/bisal/article/details/103675746
[Link 3]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea814beaddf6c2fcd242591e4892a3ac21a272f3307b9771a8ca9b76ef96b1a7bd8249c564fa&idx=1&mid=2247487001&scene=21&sn=15394f15aedee7f8f261fa7294df08a5#wechat_redirect
[Link 4]: https://blog.csdn.net/bisal/article/details/86635285
[Oracle bug]: https://blog.csdn.net/bisal/article/details/101729688
[Link 5]: https://blog.csdn.net/bisal/article/details/103626212
[recursive calls]: https://blog.csdn.net/bisal/article/details/100074863
[Oracle Concept_ - 12]: https://blog.csdn.net/bisal/article/details/100788405
[Link 6]: https://blog.csdn.net/bisal/article/details/92802477
[Link 7]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea8149e8ddf6c0fea92181efe658b69c6acd52b691cd562e830f0e63a565215a136105272d27&idx=1&mid=2247486491&scene=21&sn=584c4ac132b69a1e319b2a2bedfd49e2#wechat_redirect
[Java_y_Y]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea815467ddf6dd717251b9f1b6ccd1ec838908ff11d6981159db79c56a2fa554ea5f483c969f&idx=1&mid=2247487892&scene=21&sn=7aa998ef83b3ba3308615808dc3ceba2#wechat_redirect
[Link 8]: https://blog.csdn.net/bisal/article/details/103044518
[Link 9]: https://blog.csdn.net/bisal/article/details/103379370
[Tiki-Taka]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea814e5cddf6c74a763ac9fac98f94e538bca009fdcff3795533026269686983ceae190fe883&idx=1&mid=2247486383&scene=21&sn=d4c54d7033fc9a21d622e5937cddf64e#wechat_redirect