Oracle instant client odbc manager mac8/15/2023 ![]() ![]() What are the settings for the connection ? Kerberos and Basic or Kerberos and LDAP. How can I go about getting it to work w/ thin client (the tabs removal from nf etc doesn’t make any difference)Ĭ. Do we need 21c client instead of 12.2 ?ī. got another error : the specified procedure could not be found.Ī. Tried copying the 2 dlls from 21c client. Authentication Type : Kerberos, Connection Type : Basic, Username/Password : blank, Service Name usedĮrror : no ocijdbc21 in Help => About => Properties => oci is “true”Ĭ. Right click on connection : Reset Password is enabled.ī. Tnsnames : C:\12.2.0\client_1\network\admin (We dont use tnsnames. Under Tools => Preferences => Database => Advanced =>Ĭonfig File : C:\12.2.0\client_1\network\admin\nf (SQLPlus)Ĭonfiguring SQL Developer to work w/ Kerberos. Oracle Client : SQL*Plus: Release 12.2.0.1.0 (C:\12.2.0\client_1)Įnabled Kerberos on the databases (Linux) and works just fine w/ the Oracle Client. SQL Developer : Version 20.4.1.407 (C:\sqldeveloper) (giving example paths for help in identifying what I missed) ![]() Followed the article to the T and also the few tips mentioned in the comments. Trying to get kerberos working w/ SQL Developer. At some point we’ll ship with a 12c driver, which means you’ll need a 12c client. That means you’ll want at least an 11.2.0.3 Client for this to be compatible with SQL Developer. SQL Developer 4 ships with an 11.2.0.3 JDBC driver. Two, you can open Help > About and check the properties a la: SQL Developer IS able to load the drivers, you win! One Last Thing If you see ‘Reset Password’ available, you’re golden. One – on a disconnected connection, right click. This just says, we tried to find this in the Path and failed – you can ignore IF you can connect How Do I Know if I Did it ‘Right?’ Note we can only look at the first item in the path, so you may get a false positive, in which case you can ignore by clicking ‘Yes’ here. SQL Developer will attempt to confirm that your Client is available once you click ‘OK.’ If it’s an Instant Client, it will check the OS Path to make sure it’s there. It will use the client specified in the previous preference. This DOES tell SQL Developer to make OCI/Thick connections to your Oracle database. It won’t cause SQL Developer to use the OCI/Thick driver for connections though. It will then use this location to attempt to load the OCI stuff when doing things like a Password Reset on an expired connection. This tells SQL Developer WHERE your client is. You can put the Instant Client anywhere on your machine, but we need the directory location of where we can find these files: We get really picky, so you need to get this RIGHT. “Instant Client: file:/C:/Program Files/Oracle/11203_圆4_InstantClient/instantclient_11_2/” Now you can say what client you want us to use So in version 4, we’ve enhanced the preferences to allow you to tell us exactly what client to use. So not being able to explicitly tell SQL Developer WHICH client to use was problematic. The ‘problem’ here is that many of you have more than one Client on your machine. ![]() Prior to version 4, you would tell SQL Developer to use the ‘OCI/Thick driver’ – by the way, OCI stands for ‘Oracle Client Interface.’ Yes or No, basically So, if you’re on-board with the idea of connecting up your Oracle Client with SQL Developer, let’s talk about how to get that going. OCI has better support for advanced data types including XML.OCI does a better job at reliably cancelling queries.JDBC doesn’t do everything that OCI can.If you’re too lazy to go read the above post, here it is in a nutshell: So you can be up and running in usually less than 5 minutes.īut if you DO happen to have a Client on your machine, you’ll be happier. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. You don’t need to have an Oracle Client installed on your machine to use Oracle SQL Developer. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |