Saturday, August 14, 2021

Oracle 21c on Linux Silent installation

Oracle 21c for Linux platform is available today. You can download from here: https://www.oracle.com/database/technologies/oracle-database-software-downloads.html


To keep the information brief, I will just post commands I used for 21c installation. You can always reference to official installation guide and other posts for more information:


Take note "-sampleSchema true" is not longer supported in 21c.
>> [FATAL] [DBT-12513] Sample schema is not supported in oracle home version 21.0.0.0.0.

And OracleHome is ReadOnly Home

[oracle@ol8 bin]$ orabasehome 
/u01/app/oracle/homes/OraDB21Home1
[oracle@ol8 bin]$ cat $ORACLE_HOME/install/orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/u01/db21c:/u01/app/oracle:OraDB21Home1:Y:

Unzip the software
$ unzip LINUX.X64_213000_db_home.zip -d /u01/db21c

Install the 21c database binary (21c is in-place installation)
$ cd /u01/db21c
$ ./runInstaller  -silent -ignorePrereqFailure -waitforcompletion \
    oracle.install.option=INSTALL_DB_SWONLY \
    UNIX_GROUP_NAME=oinstall \
    INVENTORY_LOCATION=/u01/app/oraInventory \
    ORACLE_HOME=/u01/db21c \
    ORACLE_HOME_NAME='OraDB21Home1' \
    ORACLE_BASE=/u01/app/oracle \
    oracle.install.db.InstallEdition=EE \
    oracle.install.db.OSDBA_GROUP=dba \
    oracle.install.db.OSOPER_GROUP=oper \
    oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
    oracle.install.db.OSDGDBA_GROUP=dgdba \
    oracle.install.db.OSKMDBA_GROUP=kmdba \
    oracle.install.db.OSRACDBA_GROUP=racdba \
    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
    DECLINE_SECURITY_UPDATES=true

Create Listener
export ORACLE_BASE=/u01/app/oracle; export ORACLE_HOME=/u01/db21c; /u01/db21c/bin/netca /orahome /u01/db21c /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /responseFile /u01/db21c/network/install/netca_typ.rsp /lisport 1521 /silent /orahnam OraDB21Home1

Create Database
export ORACLE_HOME=/u01/db21c; export ORACLE_BASE=/u01/app/oracle; /u01/db21c/bin/dbca -silent -createDatabase  -emConfiguration NONE  -templateName 'General_Purpose.dbc' -storageType FS -datafileDestination '/u01/app/oracle/oradata' -datafileJarLocation '/u01/db21c/assistants/dbca/templates' -oratabLocation /etc/oratab  -runCVUChecks false -continueOnNonFatalErrors true -createAsContainerDatabase true -numberOfPDBs 1 -pdbName pdb1 -gdbName 'orcl21c' -sid 'orcl21c' -initParams filesystemio_options=setall -ignorePrereqs -sysPassword WElcome123## -systemPassword WElcome123## -pdbAdminPassword WElcome123## -dbsnmpPassword WElcome123##   

Verify Database

[oracle@ol8 bin]$ sqlplus / as sysdba


SQL*Plus: Release 21.0.0.0.0 - Production on Sat Aug 14 22:12:48 2021

Version 21.3.0.0.0


Copyright (c) 1982, 2021, Oracle.  All rights reserved.



Connected to:

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0


SQL> select banner from v$version;


BANNER

--------------------------------------------------------------------------------

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production


SQL> select comp_name,version,status from dba_registry;


COMP_NAME     VERSION   STATUS

----------------------------------- ------------------------------ ---------------

Oracle Database Catalog Views     21.0.0.0.0   VALID

Oracle Database Packages and Types  21.0.0.0.0   VALID

Oracle Real Application Clusters    21.0.0.0.0   OPTION OFF

JServer JAVA Virtual Machine     21.0.0.0.0   VALID

Oracle XDK     21.0.0.0.0   VALID

Oracle Database Java Packages     21.0.0.0.0   VALID

OLAP Analytic Workspace     21.0.0.0.0   VALID

Oracle XML Database     21.0.0.0.0   VALID

Oracle Workspace Manager     21.0.0.0.0   VALID

Oracle Text     21.0.0.0.0   VALID

Oracle Multimedia     21.0.0.0.0   VALID

Oracle OLAP API     21.0.0.0.0   VALID

Spatial     21.0.0.0.0   VALID

Oracle Locator     21.0.0.0.0   VALID

Oracle Label Security     21.0.0.0.0   VALID

Oracle Database Vault     21.0.0.0.0   VALID


16 rows selected.


SQL> select name,description,type,priority from v$bgprocess where paddr<>'00' order by name;


NAME  DESCRIPTION       TYPE  PRIORITY

----- ---------------------------------------- ----- --------

AQPC  AQ Process Coord     TS

BG00       SLAVE TS

BG00       SLAVE TS

BG00       SLAVE TS

BG01       SLAVE TS

BG01       SLAVE TS

BG01       SLAVE TS

CJQ0  Job Queue Coordinator     TS

CKPT  checkpoint     TS

CL00  process cleanup slave       SLAVE TS

CLMN  process cleanup     TS

D000  Dispatchers       SLAVE TS

DBRM  DataBase Resource Manager      TS

DBW0  db writer process 0     TS

DIA0  diagnosibility process 0     TS

DIAG  diagnosibility process     TS

FENC  IOServer fence monitor     TS

GEN0  generic0     TS

GEN1  generic1     TS

GEN2  generic2     TS

LG00  Log Writer Slave       SLAVE TS

LG01  Log Writer Slave       SLAVE TS

LGWR  Redo etc.      RT

LREG  Listener Registration     TS

M000  MMON slave class 1       SLAVE TS

M001  MMON slave class 1       SLAVE TS

M002  MMON slave class 1       SLAVE TS

M003  MMON slave class 1       SLAVE TS

M004  MMON slave class 1       SLAVE TS

MMAN  Memory Manager     TS

MMNL  Manageability Monitor Process 2     TS

MMON  Manageability Monitor Process     TS

OFSD  Oracle File Server BG     TS

P000  Parallel query slave       SLAVE TS

P001  Parallel query slave       SLAVE TS

P002  Parallel query slave       SLAVE TS

P003  Parallel query slave       SLAVE TS

PMAN  process manager     TS

PMON  process cleanup     TS

PSP0  process spawner 0      TS

PXMN  PX Monitor     TS

Q002  QMON MS       SLAVE TS

Q003  QMON MS       SLAVE TS

QM02  QMON MS       SLAVE TS

RCBG  Result Cache: Background     TS

RECO  distributed recovery     TS

S000  Shared servers       SLAVE TS

SCMN       SLAVE TS

SCMN       SLAVE TS

SCMN       SLAVE TS

SCMN       SLAVE TS

SMCO  Space Manager Process     TS

SMON  System Monitor Process     TS

SVCB  services background monitor     TS

TMON  Transport Monitor      TS

TT00  Redo Transport       SLAVE TS

TT01  Redo Transport       SLAVE TS

TT02  Redo Transport       SLAVE TS

VKRM  Virtual sKeduler for Resource Manager     TS

VKTM  Virtual Keeper of TiMe process     RT

VOSD  VOS Daemon     TS

W000  space management slave pool       SLAVE TS

W001  space management slave pool       SLAVE TS

W002  space management slave pool       SLAVE TS

W003  space management slave pool       SLAVE TS

W004  space management slave pool       SLAVE TS

W005  space management slave pool       SLAVE TS

W006  space management slave pool       SLAVE TS

W007  space management slave pool       SLAVE TS


69 rows selected.

No comments:

Post a Comment