[Linux/Unix] CentOS Stream 9에서 Oracle 19c 설치하기

CentOS Stream 9에서 Oracle 19c 설치하기 | Linux/Unix

2025.03.23 04:33:07 | 2025.03.23 14:14:38 | 39 | Aiden

❮ ❯

1. hostname 설정

[root@localhost etc]# hostnamectl set-hostname centos9100.daonelab.com
[root@localhost etc]# hostname
centos9100.daonelab.com

2. hosts 설정

[root@centos9100 etc]# vi /etc/hosts

127.0.0.1       localhost centos9100.daonelab.com
::1             localhost centos9100.daonelab.com
192.168.209.100 centos9100.daonelab.com centos9100

3. hostname 설정확인

[root@centos9100 etc]# hostnamectl status
 Static hostname: centos9100.daonelab.com
       Icon name: computer-vm
         Chassis: vm 🖴
      Machine ID: bd233d4bb75d479a8468e9cc26b7c9c9
         Boot ID: a2dfa34b416a46e98869a5118f7b4dea
  Virtualization: vmware
Operating System: CentOS Stream 9                 
     CPE OS Name: cpe:/o:centos:centos:9
          Kernel: Linux 5.14.0-572.el9.x86_64
    Architecture: x86-64
 Hardware Vendor: VMware, Inc.
  Hardware Model: VMware Virtual Platform
Firmware Version: 6.00

4. reboot

[root@centos9100 etc]# shutdown -r now

5. hostname 설정확인

[root@centos9100 ~]# dnf install -y java-1.8.0-openjdk
[root@centos9100 ~]# java -version
openjdk version "1.8.0_362"
OpenJDK Runtime Environment (build 1.8.0_362-b08)
OpenJDK 64-Bit Server VM (build 25.362-b08, mixed mode)

6. Download Oracle preinstall

[root@centos9100 software]# curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm

7. Download Oracle19c

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#db_ee

[root@centos9100 software]# ls
oracle-database-ee-19c-1.0-1.x86_64.rpm  oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm

7. Install Oracle preinstall

[root@centos9100 software]# dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm

8. Install Oracle19c

[root@centos9100 software]# dnf -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

9. oracle 계정 비번변경

[root@centos9100 software]# cd /home/oracle
[root@centos9100 oracle]# passwd oracle

10. oracle 계정 .bash_profile 설정

[root@centos9100 oracle]# vi .bash_profile 

# User specific environment and startup programs
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

export ORACLE_VERSION=19c
export ORACLE_SID=ORCLCDB
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=AL32UTF8
export PDB_NAME=ORCLPDB1
export LISTENER_NAME=LISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=true

# General exports and vars
export PATH=$ORACLE_HOME/bin:$PATH
LSNR=$ORACLE_HOME/bin/lsnrctl
SQLPLUS=$ORACLE_HOME/bin/sqlplus
DBCA=$ORACLE_HOME/bin/dbca
NETCA=$ORACLE_HOME/bin/netca
ORACLE_OWNER=oracle
RETVAL=0
CONFIG_NAME="oracledb_$ORACLE_SID-$ORACLE_VERSION.conf"
CONFIGURATION="/etc/sysconfig/$CONFIG_NAME"

[root@centos9100 oracle]# source .bash_profile

11. Oracle DB 생성 및 구성

[root@centos9100 oracle]# /etc/init.d/oracledb_ORCLCDB-19c configure

Configuring Oracle Database ORCLCDB.
[WARNING] [DBT-11209] Current available memory is less than the required available memory (694MB) for creating the database.
   CAUSE: Following nodes do not have required available memory :
 Node:centos9100		Available memory:565.2578MB (578824.0KB)

Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

12. 방화벽에 포트 추가

[root@centos9100 oracle]# firewall-cmd --permanent --zone=public --add-port=1521/tcp
[root@centos9100 oracle]# firewall-cmd --permanent --zone=public --list-port

13. 접속 및 SYSTEM 비밀번호 변경

[root@centos9100 ~]# su - oracle
[oracle@centos9100 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 23 13:55:01 2025
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

SQL> select instance_name, version, status from v$instance;

INSTANCE_NAME	 VERSION	   STATUS
---------------- ----------------- ------------
ORCLCDB 	 19.0.0.0.0	   OPEN

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> alter user system identified by "비밀번호";

User altered.

14. startup / shutdown

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup open
ORACLE instance started.

Total System Global Area  729805744 bytes
Fixed Size		    9139120 bytes
Variable Size		  494927872 bytes
Database Buffers	  218103808 bytes
Redo Buffers		    7634944 bytes
Database mounted.
Database opened.

15. Listener Stop / Start (oracle 계정으로)

[oracle@centos9100 ~]$ cd /opt/oracle/product/19c/dbhome_1/bin/
[oracle@centos9100 bin]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-MAR-2025 14:09:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully

[oracle@centos9100 bin]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-MAR-2025 14:09:49

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/centos9100/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                23-MAR-2025 14:09:49
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/centos9100/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully