Does not appear to support service names as opposed to SIDs

[craigstjean]

When using a secure external password store (http://www.oracle.com/technetwork/database/security/twp-db-security-secure-ext-pwd-stor-133399.pdf), you typically reference your connection as a service.

For example if my TNS name is testdb.world, I could do:

• sqlplus /@testdb.world
• jdbc:oracle:thin:/@testdb.world

Debugging oci8.go, I see that at the end of ParseDSN, if I give it /@testdb.world then all of my variables in dsn are empty, except for port which is some non-numeric data (probably due to oci8.go:420's Atoi).

Is there any way to connect against a password store? Might just require an updated ParseDSN?

[craigstjean]

Looks like OCILogon does not support TNS, would have to use OCISessionPoolCreate?

[craigstjean]

Scratch that, based on https://stackoverflow.com/questions/21762885/using-oracle-wallet-authentication-from-oci need to use OCIServerAttach and OCISessionBegin. I'm hacking away at it, but I've never used OCI before so any assistance is appreciated.

[MichaelS11]

I used TNS names file that use service names, seems to work fine for me.

@mattn Close this?