1. Oracle site에서 RPM설치파일 다운로드 "oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm"
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#db_ee
2. Oracle preinstall RPM 다운로드 및 설치
[root@localhost home]# curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
[root@localhost home]# ls
aiden oracle-database-ee-19c-1.0-1.x86_64.rpm oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
[root@localhost home]# dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
3. Oracle 설치
[root@localhost home]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
4. Oracle DB 생성 및 구성
[root@localhost home]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
[WARNING] [DBT-11209] Current available memory is less than the required available memory (713MB) for creating the database.
CAUSE: Following nodes do not have required available memory :
Node:localhost Available memory:525.0234MB (537624.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.
5. 방화벽에 포트 추가
[root@localhost init.d]# firewall-cmd --permanent --zone=public --add-port=1521/tcp
success
[root@localhost init.d]# firewall-cmd --permanent --zone=public --list-port
1521/tcp
[root@localhost init.d]# firewall-cmd --list-all
[root@localhost init.d]# systemctl restart firewalld.service
[root@localhost init.d]# firewall-cmd --list-all
6. 환경설정
[root@localhost home]# vi oracle/.bash_profile
# Setting the required environment variables
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"
7. 접속 및 SYSTEM 비밀번호 변경
[root@localhost oracle]# source .bash_profile
[root@localhost oracle]# su - oracle
Last login: Wed Feb 7 06:27:47 PST 2024 on pts/2
Last failed login: Wed Feb 7 06:46:48 PST 2024 from 222.112.0.197 on ssh:notty
There were 3 failed login attempts since the last successful login.
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 7 07:01:10 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
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.
SQL>
8. Listener Stop
[oracle@localhost bin]$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2024 07:17:00
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully
9. Listener Start
[oracle@localhost bin]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2024 07:17:09
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/localhost/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 07-FEB-2024 07:17:09
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/localhost/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
10. startup / shutdown
[oracle@localhost bin]$ sqlplus / as sysdba
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open
ORACLE instance started.
Total System Global Area 750777504 bytes
Fixed Size 9139360 bytes
Variable Size 662700032 bytes
Database Buffers 71303168 bytes
Redo Buffers 7634944 bytes
Database mounted.
Database opened.
11. 원격접속이 안될경우 listener.ora파일에 host에 지정된 localhost 혹은 127.0.0.1을 /etc/hostname과 일치 시킨다.
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=(SID_NAME=ORCLCDB)(ORACLE_HOME=/opt/oracle/product/19c/dbhome_1))
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORCL.daonelab.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)