question

MarkJohnson-1065 avatar image
0 Votes"
MarkJohnson-1065 asked AmeliaGu-msft commented

For a linked server to Oracle using LDAP authentication, if the ldap.ora and/or sqlnet.ora files used by the SQL server are modified does the SQL Server need to be restarted?

For a linked server to Oracle using LDAP authentication, if the ldap.ora and/or sqlnet.ora files used by the SQL server are modified does the SQL Server need to be restarted? We need to change the Oracle OID becuase of a corporate reorg and therefore need to update the ldap.ora file. We have seen inconsistent results in testing this in Dev/QA/UAT environments and want to know if it is a requirement that we restart the SQL Server

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi MarkJohnson-1065,
It seems your issue is also related to Oracle. I suggest you open a thread in the corresponding Oracle forum so that people there will help you more effectively.

Best Regards,
Amelia


0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I assume that you are using Oracle's OLE DB provider for the linked server. To get an authoritative answer, you would have to ask Oracle. SQL Server as such does not know how Oracle's OLE DB provider behaves.

You say that you get inconsistent results. My interpretation is that sometimes you have tested, you have been able to change the file without having to restart SQL Server, sometimes not. I would take this that sometimes the provider reads the file, but not on every connection, but it may cache data.

Thus, if you don't want to rely on chance, you need to restart SQL Server.

Please note that I have no experience of working with Oracle at all, nor directly, nor through linked server. I'm just speculating from my experience of how stuff works in general.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.