Shulou(Shulou.com)06/01 Report--

Last night, I saw that version 12.2.0.1 was released for download in the WeChat account of General Manager Gai, so I immediately boarded edelivery to download it. Now only the 64-bit version of Linux is open.

Today I tested the installation on rhel7.2 of 12.2.0.1.

The general installation procedures are not much different from those in version 12.1. The following are simple configuration and installation procedures

1. Modify the hostname and configure/etc/hosts

2. Install dependency packages

Refer to the official documentation of 12.2, now only provide dependency packages on Oracle Linux, but do not have OEL 7.2, so choose RHEL7.2, there is not much difference

yum install -y binutils*

yum install -y compat-libcap1*

yum install -y compat-libstdc++*

yum install -y glibc*

yum install -y glibc-devel*

yum install -y ksh*

yum install -y libX11*

yum install -y libXau*

yum install -y libXi*

yum install -y libXtst*

yum install -y libaio*

yum install -y libaio-devel*

yum install -y libgcc*

yum install -y libstdc++*

yum install -y libstdc++-devel*

yum install -y libxcb*

yum install -y make*

yum install -y net-tools*

yum install -y nfs-utils*

yum install -y smartmontools*

yum install -y sysstat*

yum install -y unixODBC*

yum install -y binutils*686*

yum install -y compat-libcap1*686*

yum install -y compat-libstdc++*686*

yum install -y glibc*686*

yum install -y glibc-devel*686*

yum install -y ksh*686*

yum install -y libX11*686*

yum install -y libXau*686*

yum install -y libXi*686*

yum install -y libXtst*686*

yum install -y libaio*686*

yum install -y libaio-devel*686*

yum install -y libgcc*686*

yum install -y libstdc++*686*

yum install -y libstdc++-devel*686*

yum install -y libxcb*686*

yum install -y make*686*

yum install -y net-tools*686*

yum install -y nfs-utils*686*

yum install -y smartmontools*686*

yum install -y sysstat*686*

yum install -y unixODBC*686*

3. Configure kernel parameters

vi /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

systemctl -p Apply modifications

Create oracle users and user groups and create directories

groupadd -g 5001 oinstall

groupadd -g 5002 dba

useradd -g oinstall -G dba -u 5001 oracle

passwd oracle

mkdir -p /u01/app/oracle/product/12.2/db1

chown oracle:oinstall -R /u01

5. Modify Oracle user system restrictions

vi /etc/security/limits.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32786

6. Modify oracle user's.bash_profile

vi /home/oracle/.bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2/db1

export ORACLE_SID=orcl

export PATH=$ORACLE_HOME/bin:$PATH

7. Install database software

./ runInstall

Execute root.sh

8. Create a database

When using dbca to create a database containing CDB and PDB, several errors were reported, all inexplicable, such as:

Error while executing "/u01/app/oracle/product/12.2/db1/rdbms/admin/execemx.sql". Refer to "/u01/app/oracle/cfgtoollogs/dbca/orcl/execemx0.log"

Check if the log file is empty.

ORA-00600: internal error code, arguments: [kcrf_make_redokey], [18446744073709551615], [], [],[],[], [],[], [], []

There is no documentation on MOS for 12.2.

So I thought about whether the database without CDB creation would report an error, and the result was normal and successful.

Later, I discussed with my colleague whether there was a problem with manually creating a database, so I tried to manually create a database containing CDB and PDB.

Simple steps to manually create a database:

1. Create pfile

db_name=orcl

enabled_pluggable_database=true #This parameter is required to create CDB/PDB database

control_files='/u01/app/oracle/oradata/orcl/control01.ctl'

2. Create spfile

create spfile from pfile;

3. Execute CREATE DATABASE statement

CREATE DATABASE orcl

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01a.log') SIZE 100M BLOCKSIZE 512,

GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02a.log') SIZE 100M BLOCKSIZE 512,

GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03a.log') SIZE 100M BLOCKSIZE 512

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 1024

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE '/u01/app/oracle/oradata/orcl/cdb/system.dbf'

SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/cdb/sysaux.dbf'

SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oracle/oradata/orcl/cdb/temp.dbf'

SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

UNDO TABLESPACE undotbs1

DATAFILE '/u01/app/oracle/oradata/orcl/cdb/undo.dbf'

SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED

ENABLE PLUGGABLE DATABASE

SEED

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/orcl/cdb/','/u01/app/oracle/oradata/orcl/seed/')

SYSTEM DATAFILES size 125M autoextend on next 10M maxsize unlimited

SYSAUX DATAFILES size 100M autoextend on next 10M maxsize unlimited;

4. Execute the Create Data Dictionary script

1)In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege:

@?/ rdbms/admin/catalog.sql

@?/ rdbms/admin/catproc.sql

@?/ rdbms/admin/utlrp.sql

2)In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:

@?/ sqlplus/admin/pupbld.sql

The creation is complete.

The overall process isn't much different from the 12.1 installation, except for the odd bug in dbca times.

Official Document: docs.oracle.com/database/122/LADBI/toc.htm

http://docs.oracle.com/database/122/ADMIN/creating-and-configuring-an-oracle-database.htm#ADMIN-GUID-18B03451-5C74-4B53-A892-656C3E8A2556

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.