Oracle full client for MacOS
A reader, July 26, 2018 - 8:36 pm UTC
Instant client does not support Kerberos auth. We need enable Kerberos auth for users using MacOS, which requires Oracle full client, including OCI and advancednetwork
July 27, 2018 - 6:50 am UTC
I spoke to the internal team - there are no plans for a MacOS full client
Another option...
J. Laurindo Chiappa, July 27, 2018 - 1:05 pm UTC
How about to use SQLDEVELOPER connecting with JDBC thin (no Oracle client needed) ? MOS note "How To Use Kerberos Authentication to connect to a database with SQL Developer with thin JDBC" (Doc ID 1609359.1) explain how to do Kerberos authentication in it, see if it works for you....
Regards,
Chiappa
July 27, 2018 - 3:28 pm UTC
Good suggestion
Yet another possibility....
J. Laurindo Chiappa, July 27, 2018 - 4:32 pm UTC
We really were unable to use Kerberos (or any other ASO-related options/features) with Instant Client 11g (see MOS note "Kerberos Troubleshooting Guide" (Doc ID 185897.1 for refs), but this changed in 12c : MOS note "How To Configure Kerberos Authentication In A 12c Database" (Doc ID 1996329.1) textually says :
"
Instant Client:
As of 12c one can uses Instant Client to authenticate with Kerberos using Windows Internal cache. Tnsnames.ora and sqlnet.ora are not provided with Instant client so one needs to set a TNS_ADMIN variable pointing to a directory with sqlnet.ora and tnsnames.ora.
The sqlnet.ora settings are the same as for a thick client:
SQLNET.KERBEROS5_CONF=<path for krb5.conf file>
SQLNET.KERBEROS5_CONF_MIT=TRUE
SQLNET.AUTHENTICATION_SERVICES=(KERBEROS5PRE)
SQLNET.KERBEROS5_CC_NAME=OSMSFT://
Instant Client provides only libraries and sqlplus utility, the oklist and okdstry utilities are not available so it is not possible to manually request a ticket with okinit.
"
The note speak about Windows, but maybe similar configs could be done in macOS - try and see... And probably, together with Instant Client all the OCI and auxiliar libs must be present, too - see them all on the Instant Client 12c for macOS download page.
July 28, 2018 - 4:22 am UTC
Thanks for the input - I was unaware of this development
database connection problem on macbook air
RAGHUVEER, March 09, 2023 - 4:07 pm UTC
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=NB4OqyDRRnCUQsHdaOasng==)
how to resolve this problem on macbook please help
March 14, 2023 - 1:17 am UTC
Try adding this to sqldeveloper.conf
AddVMOption -Doracle.net.disableOob=true
D. Hale, November 07, 2024 - 4:45 pm UTC
What's missing from the instant client? orapki for wallet management would be nice. With the instant client you need to manage wallets on a system with a full client, then transfer the wallet to mac. It would also be nice to have access to tnsping.
November 11, 2024 - 6:46 am UTC
check out "ping" which is now natively available from within SQL Plus (23 onwards)