Re: 오늘의 마지막 문제. 12c 설치하고 위의 sqldelveloper 로 scott으로 접속한 창과...

[21기_이풍혁]

1. 리스너를 통한 접속

---

2. 리스너와 데이터베이스 자동 재시작 (서비스로 등록)

Connection to 172.16.3.129 closed. -> reboot로 커넥션 끊어짐

PS C:\Users\poonghyeok\Documents\prac_fastapi> ssh oracle@172.16.3.129 -> 재접속
oracle@172.16.3.129's password: 
Last login: Mon Aug 25 16:36:48 2025
[oracle@localhost ~]$ lsnrctl status -> 리스너 상태확인

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-AUG-2025 16:36:02

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                25-AUG-2025 16:35:31
Uptime                    0 days 0 hr. 0 min. 31 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "3d2c4c77abae4142e065000000000001" has 1 instance(s).
  Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12c" has 1 instance(s).
  Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12cXDB" has 1 instance(s).
  Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12pdb" has 1 instance(s).
  Instance "orcl12c", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ sudo systemctl status oracle-db.service -> 등록한 오라클디비 서비스 상태 확인
[sudo] password for oracle: 
● oracle-db.service - Oracle Database and Listener
   Loaded: loaded (/etc/systemd/system/oracle-db.service; enabled; vendor preset: disabled)
   Active: active (running) since Mon 2025-08-25 16:35:42 KST; 53s ago
  Process: 785 ExecStart=/u01/app/oracle/product/12.2.0.1/db_1/bin/dbstart $ORACLE_HOME (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/oracle-db.service
           ├─ 836 /u01/app/oracle/product/12.2.0.1/db_1/bin/tnslsnr LISTENER -inherit
           ├─1652 ora_pmon_orcl12c
           ├─1654 ora_clmn_orcl12c
           ├─1660 ora_psp0_orcl12c
           ├─1725 ora_vktm_orcl12c
           ├─1729 ora_gen0_orcl12c
           ├─1731 ora_mman_orcl12c
           ├─1735 ora_gen1_orcl12c
           ├─1739 ora_diag_orcl12c
           ├─1741 ora_ofsd_orcl12c
           ├─1745 ora_dbrm_orcl12c
           ├─1747 ora_vkrm_orcl12c
           ├─1749 ora_svcb_orcl12c
           ├─1751 ora_pman_orcl12c
           ├─1753 ora_dia0_orcl12c
           ├─1755 ora_dbw0_orcl12c
           ├─1757 ora_lgwr_orcl12c
           ├─1759 ora_ckpt_orcl12c
           ├─1761 ora_lg00_orcl12c
           ├─1763 ora_smon_orcl12c
           ├─1765 ora_lg01_orcl12c
           ├─1767 ora_smco_orcl12c
           ├─1769 ora_reco_orcl12c
           ├─1771 ora_w000_orcl12c
           ├─1773 ora_lreg_orcl12c
           ├─1775 ora_w001_orcl12c
           ├─1777 ora_pxmn_orcl12c
           ├─1781 ora_mmon_orcl12c
           ├─1783 ora_mmnl_orcl12c
           ├─1785 ora_d000_orcl12c
           ├─1787 ora_s000_orcl12c
           ├─1789 ora_tmon_orcl12c
           ├─1799 ora_tt00_orcl12c
           ├─1801 ora_tt01_orcl12c
           ├─1803 ora_tt02_orcl12c
           ├─1805 ora_aqpc_orcl12c
           ├─1810 ora_p000_orcl12c
           ├─1812 ora_p001_orcl12c
           ├─1814 ora_p002_orcl12c
           ├─1816 ora_p003_orcl12c
           ├─1818 ora_p004_orcl12c
           ├─1820 ora_p005_orcl12c
           ├─1822 ora_p006_orcl12c
           ├─1824 ora_p007_orcl12c
           ├─1826 ora_p008_orcl12c
           ├─1828 ora_p009_orcl12c
           ├─1830 ora_p00a_orcl12c
           ├─1832 ora_p00b_orcl12c
           ├─1834 ora_p00c_orcl12c
           ├─1836 ora_p00d_orcl12c
           ├─1838 ora_p00e_orcl12c
           ├─1840 ora_p00f_orcl12c
           ├─1871 ora_cjq0_orcl12c
           ├─2109 ora_s001_orcl12c
           ├─2115 ora_qm02_orcl12c
           ├─2117 ora_qm03_orcl12c
           ├─2119 ora_q002_orcl12c
           └─2121 ora_q003_orcl12c

Aug 25 16:35:31 localhost.localdomain systemd[1]: Starting Oracle Database and Listener...   
Aug 25 16:35:31 localhost.localdomain dbstart[785]: Processing Database instance "orcl12c": log file /u01/app/oracle/product/12.2.0.1/db_1/startup.log
Aug 25 16:35:42 localhost.localdomain systemd[1]: Started Oracle Database and Listener.