{"id":7840,"date":"2019-06-14T10:28:20","date_gmt":"2019-06-14T02:28:20","guid":{"rendered":"http:\/\/rmohan.com\/?p=7840"},"modified":"2019-06-14T10:28:33","modified_gmt":"2019-06-14T02:28:33","slug":"steps-to-install-oracle-19c-in-centos-7-6-rpm-mode","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7840","title":{"rendered":"Steps to install Oracle 19c in CentOS 7.6 RPM mode"},"content":{"rendered":"\n

Steps to install Oracle 19c in CentOS 7.6 RPM mode<\/p>\n\n\n\n

  1. Download the required installation package:<\/li><\/ol>\n\n\n\n

    1.1 preinstall<\/p>\n\n\n\n

    http:\/\/yum.Oracle.com\/repo\/OracleLinux\/OL7\/latest\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
    \n1.2 Oracle rpm installation package<\/p>\n\n\n\n

    https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html
    \nIt is recommended to download at home or see the VPN proxy download speed in the company.<\/p>\n\n\n\n

    1. Installation.<\/li><\/ol>\n\n\n\n

      yum localinstall -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm<\/p>\n\n\n\n

      Install after installation is complete<\/p>\n\n\n\n

      yum localinstall -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
      \nWait for the installation results.<\/p>\n\n\n\n

      Different servers take different time:<\/p>\n\n\n\n

      The result of my installation here is:<\/p>\n\n\n\n

      Total size: 6.9 G
      \nInstalled size: 6.9 G
      \nDownloading packages:
      \nRunning transaction check
      \nRunning transaction test
      \nTransaction test succeeded
      \nRunning transaction
      \n Installing : oracle-database-ee-19c-1.0-1.x86_64 1\/1
      \n[INFO] Executing post installation scripts\u2026
      \n[INFO] Oracle home installed successfully and ready to be configured.
      \nTo configure a sample Oracle Database you can execute the following service configuration script as root: \/etc\/init.d\/oracledb_ORCLCDB-19c configure
      \n Verifying : oracle-database-ee-19c-1.0-1.x86_64 1\/1 <\/p>\n\n\n\n

      Installed:
      \n oracle-database-ee-19c.x86_64 0:1.0-1 <\/p>\n\n\n\n

      Complete!
      \nNote that the configuration after the installation is complete requires the root user.<\/p>\n\n\n\n

      1. As with previous blogs, you need to modify the character set and other configurations:<\/li><\/ol>\n\n\n\n
        \nhttps:\/\/www.cnblogs.com\/jinanxiaolaohu\/p\/9826653.html\n<\/div><\/figure>\n\n\n\n

        https:\/\/www.cnblogs.com\/jinanxiaolaohu\/p\/10015624.html
        \nThe modified configuration file of oracle19c is:<\/p>\n\n\n\n

        vim \/etc\/init.d\/oracledb_ORCLCDB-19c
        \nThe revised content is mainly the part of the circle<\/p>\n\n\n\n

        Text version:<\/p>\n\n\n\n

        export ORACLE_VERSION=19c
        \nexport ORACLE_SID=ORA19C
        \nexport TEMPLATE_NAME=General_Purpose.dbc
        \nexport CHARSET=ZHS16GBK
        \nexport PDB_NAME=ORA19CPDB
        \nexport CREATE_AS_CDB=true
        \nCorresponding to copy a parameter file<\/p>\n\n\n\n

        cd \/etc\/sysconfig\/<\/p>\n\n\n\n

        cp oracledb_ORCLCDB-19c.conf oracledb_ORA19C-19c.conf<\/p>\n\n\n\n

        1. Configure with the root user.<\/li><\/ol>\n\n\n\n

          The root user executes the command:
          \n \/etc\/init.d\/oracledb_ORCLCDB-19c configure
          \nWait for the Oracle database to perform initialization operations.<\/p>\n\n\n\n

          . Processing after the completion of the execution. <\/p>\n\n\n\n

          Increase environment variable processing<\/p>\n\n\n\n

          vim \/etc\/profile.d\/oracle19c.sh<\/p>\n\n\n\n

          Add content as:
          \nexport ORACLE_HOME=\/opt\/oracle\/product\/19c\/dbhome_1
          \nexport PATH=$PATH:\/opt\/oracle\/product\/19c\/dbhome_1\/bin
          \nexport ORACLE_SID=ORA19C
          \nModify the password of the Oracle user:<\/p>\n\n\n\n

          passwd oracle
          \nUse Oracle login for related processing<\/p>\n\n\n\n

          sqlplus \/ as sysdba
          \nView pdb information<\/p>\n\n\n\n

          show pdbs
          \n5.1 Create a trigger to automatically start pdb (Do not set the PDB boot startup Many programs can not connect to the PDB, it is recommended to use show pdbs to view the status, manual start can also. Can not create business data in the CDB, will prompt to create the user name does not meet c# ##???)<\/p>\n\n\n\n

          CREATE TRIGGER open_all_pdbs
          \n AFTER STARTUP ON DATABASE
          \nBEGIN
          \n EXECUTE IMMEDIATE ‘alter pluggable database all open’;
          \nEND open_all_pdbs;
          \n\/<\/p>\n","protected":false},"excerpt":{"rendered":"\n

          Steps to install Oracle 19c in CentOS 7.6 RPM mode<\/p>\n

          Download the required installation package: <\/p>\n

          1.1 preinstall<\/p>\n

          http:\/\/yum.Oracle.com\/repo\/OracleLinux\/OL7\/latest\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 1.2 Oracle rpm installation package<\/p>\n

          https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html It is recommended to download at home or see the VPN proxy download speed in the company.<\/p>\n

          Installation. <\/p>\n

          yum localinstall -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm<\/p>\n

          Install after installation is complete<\/p>\n

          yum localinstall -y […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7840"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7840"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7840\/revisions"}],"predecessor-version":[{"id":7841,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7840\/revisions\/7841"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}