본문 바로가기
DB/Oracle

oracle21c listener.ora tnsnames.ora

by newlibra 2024. 10. 5.

--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