티스토리 뷰
--listener.ora
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=ORCL)
(ORACLE_HOME=C:\app\homes\OraDB21Home1)
)
)
--tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
'DB > Oracle' 카테고리의 다른 글
oracle free 23ai with vscode (0) | 2025.03.25 |
---|---|
with DOCKER/PODMAN (0) | 2024.06.19 |
23c oraclelinux8 (0) | 2023.04.30 |
oracle21c 설치 및 계정 (0) | 2023.04.17 |