Loading

Connecting to Oracle using SID not Service Name

Дата публикации: Apr 29, 2025
Задача
How to connect to an Oracle database with SID instead of Service Name.
Действия
Change the SERVICE_NAME in the TNSNames.ora file to SID. For example, 
Production =
(DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = prod.corp.com)(PORT = 1521)
  )
 (CONNECT_DATA =
  (SERVICE_NAME= orcl)
  )
 )

should be changed to:
Production =
(DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = prod.corp.com)(PORT = 1521)
  )
 (CONNECT_DATA =
  (SID= orcl)
  )
 )
Номер статьи базы знаний

001457985

 
Загрузка
Salesforce Help | Article