[Oracle] Centos Linux Oracle 19c 설치 (dbca)

[oracle@sua-03 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 14 04:38:12 2024
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

user 생성 

[root@sua-03 ~]# adduser oracle -d /home/oracle -s /bin/bash

root 에서 preinstall package를 설치

1. preinstall package를 download한다. 
curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

2. preinstall package 설치
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

 

 

oracle-database-ee-19c-1.0-1.x86_64.rpm 다운 후 설치 

- 오라클 download page 에서 받을수 있음

yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

 

 

bash_profile 설정 

oracle 계정에서 설

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCL
export PATH=$PATH:$ORACLE_HOME/bin

. ~/.bash_profile

 

 

 

non-cdb로 설치 

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -sid ORCL -sysPassword welcome1 -systemPassword welcome1 -emConfiguration NONE -datafileDestination /opt/oracle/oradata -storageType FS -characterSet AL32UTF8

 

[oracle@sua-03 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -sid ORCL -sysPassword welcome1 -systemPassword welcome1 -emConfiguration NONE -datafileDestination /opt/oracle/oradata -storageType FS -characterSet AL32UTF8

[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
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
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCL/ORCL.log" for further details

 

 

listener 설정

LISTERNER HOST에 host명 입력. SID_NAME에 ORCL, GLOBAL_DBNAME에 ORCL, 그리고 ORACLE_HOME설정. 

$ORACLE_HOME/network/admin/listener.ora

LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=orcl05)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_LISTENER=
   (SID_LIST=
        (SID_DESC=
          (GLOBAL_DBNAME=ORCL)
          (SID_NAME=ORCL)
          (ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)
         )
        )
       )

 

listener start

[oracle@sua-03 ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 14-FEB-2024 04:35:35

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/sua-03/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                14-FEB-2024 04:35:35
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/sua-03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

 

 

접속