📢 📢 📢 📣 📣 📣 hello! Hello, everyone, I am [IT Bond], known as Jeames007. I have 10 years of DBA working experience and am a member of China DBA Union (ACDU). I am currently engaged in DBA and program programming 😜😜😜. ❤️❤️❤️ Thank you all! ❤ ️ ❤ ️ ❤ ️

⛳ ️ 1. Profile

Oracle 19C, or Oracle 12.2.0.3, is a stable version of 12C, just like Oracle 11.2.0.4, and is worth the upgrade decision for customers. The position of Oracle 19C can be seen in the version sequence diagram supported by Oracle. Oracle 19C makes stability a core goal of this release, which may be a key factor in making 19C more reliable and enabling customers to decide to upgrade.Copy the code

Oracle 19 c related technical documents address docs.oracle.com/en/database… Speaking of 19C installation, the biggest improvement over 11G, besides supporting graphical, command line, silent installation, is supporting RPM installation

⛳️ 2. What is RPM?

What is RPM? RPM is short for Red-Hat Package Manager. It was originally used by the Red Hat Linux distribution to manage various Linux packages. Due to its gPL-compliant, powerful and convenient functions, RPM is gradually adopted by other distributions. The appearance of RPM suite management makes Linux easy to install and upgrade, which indirectly improves the applicability of Linux. Its file format name bears the RedHat logo, but its original design philosophy is open and now includes OpenLinux, S.U.S.E. Distributions of Linux, such as Turbo Linux, are accepted as industry standards.Copy the code

To install Oracle 19C on Linux, OL7, RHEL7, SLES12 and later versions are required. Oracle Enterprise Linux6 and RedHat Linux6 are not listed in the official list.

To manually install 19C database using RPM, perform two steps: Step 1: Install oracle- database-preinstall-19C-1.0-1.el7.x86_64. RPM Step 2: Install oracle- database-preinstall-19C-1.0-1.el7.x86_64. Install oracle database – ee – 19 – c – 1.0-1. X86_64. RPM

⛳️ 3. Install preinstall

– As the root user, run [root@rhel74 soft]# RPM -ivh oracle-database-preinstall-19C-1.0-1.el7.x86_64. RPM

## yum yum yum yum yum yum yum Create the cd-rom mount directory mkdir -p/MNT /cdrom c. Mount the CD-ROM drive to the/MNT /cdrom directory mount /dev/cdrom/MNT /cdrom d. Testing the success of df -h | tail - n 1 e. Enter the CD catalog view the CD disc/MNT/cdrom && ls f. D /*.repo /etc/yum. Repos. D /yum. Bak g Add a new source of yum configuration file/etc/vi. Yum repos. D/DVD. Add repo:  [RHEL] name=RedHat baseurl=file:///mnt/cdrom gpgcheck=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release enabled=1 h. Yum yum clean all yum makecache yum install tree ## yum install -y KSH * yum install -y libaio* yum install -y compat*Copy the code

Compat-libstdc +± 33-3.3-72.el7.x86_64. RPM

[root@rhel74 soft]# RPM -ivh compat-libstdc+± 33-3.3-72.el7.x86_64. RPM

[root@rhel74 soft]# RPM -ivh oracle-database-preinstall-19C-1.0-1.el7.x86_64

⛳️ 4. Install the database software

The default data file location of RPM is: /opt/oracle/oradata, ensure that there is 7 GB space in the/directory. Run [root@rhel74 soft]# RPM -ivh oracle-database-ee-19C-1.0-1.x86_64. RPM as user root

⛳️ 5. Create an instance

[root@rhel74 /]# /etc/init.d/ oracledb_orclcdb-19c configure Configure dbCdb-19c configure configure dbCdb-19c configure

D/oracledb_orclcdb-19c start

D/oracledb_orclcdb-19c stop

⛳️ 6. Configure the database

🌈 5.1 Installing rLWrap

[root@rhel74 soft]# rpm -ivh rlwrap-0.42-1.el7.x86_64.rpm

🌈 5.2 Configuring User environment Variables

cat >> /home/oracle/.bash_profile << "EOF" export ORACLE_SID=ORCLCDB export ORACLE_BASE=/opt/oracle export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' alias asmcmd='rlwrap Asmcmd 'alias SQL ='sqlplus/as sysdba' EOF ## /home/oracle/.bash_profileCopy the code

⛳️ 7. Perform operations related to the database

`

[root@rhel74 ~]# su - oracle [oracle@rhel74 ~]$sqlplus/as sysdba SQL> show PDBS -- alter PLUggable database  all open; SQL> alter pluggable database all close; SQL> select name,cdb from v$database; SQL> alter session set container = PDB1; SQL> conn/as sysdbaCopy the code

How to become a SQL master PostgreSQL from start to start

You can like, collect, pay attention to, comment on me, there are database related questions to contact me or exchange yo ~!