Oracle: Difference between revisions
Jump to navigation
Jump to search
(Created page with "In the "Server" box you must use the following format to connect to Oracle: By Service Name: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=...") |
No edit summary |
||
Line 2: | Line 2: | ||
By Service Name: | By Service Name: | ||
<syntaxhighlight> | |||
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))) | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))) | ||
</syntaxhighlight> | |||
By SID: | By SID: | ||
<syntaxhighlight> | |||
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SID=mySID123))) | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SID=mySID123))) | ||
</syntaxhighlight> |
Latest revision as of 15:59, 20 February 2018
In the "Server" box you must use the following format to connect to Oracle:
By Service Name:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))
By SID:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SID=mySID123)))