为Go Oracle驱动程序启用NNE（ora，goracle）

Question

I have a go service which communicates with an Oracle database. Now, I need to encrypt that traffic using Oracle NNE (Native Network Encryption). For that, I need to set sql.net.encryption_client parameter on the client to required, as our Oracle server doesn't force encryption (for legacy reasons).

We are using goracle driver and I don't see any ways of setting that parameter. Any ideas?

Answer 1

[Per driver developers], there is no way of programmatically setting that parameter at this time; however there is a workaround (that I've just tested and confirmed working) - create sqlnet.ora file with one line sql.net.encryption_client=required and add an environment variable TNS_ADMIN=<folder path to sqlnet.ora file>.

This will have the driver to require native network encryption on the client.