Re: SQL Developer connection issues
From: Andy Wattenhofer <watt0012_at_umn.edu>
Date: Thu, 9 May 2019 13:41:46 -0500
Message-ID: <CAFU3ey4cTBGHR3zCsmNbOzp5J8BRQGD1uj7Y_C-DJ3DkwadtPQ_at_mail.gmail.com>
Date: Thu, 9 May 2019 13:41:46 -0500
Message-ID: <CAFU3ey4cTBGHR3zCsmNbOzp5J8BRQGD1uj7Y_C-DJ3DkwadtPQ_at_mail.gmail.com>
You probably need to configure SQL D to use the OCI/thick driver.
- Click on Tools | Preferences
- Select Database | Advanced
- Check “Use Oracle Client”
- Click the "Configure" button. Select the client type of "Instant Client" and type in the path to your client (e.g. C:\Oracle\instantclient). Click "OK" to close the "Configure Oracle Client" window and return to the advanced settings.
- Check ”Use OCI/Thick driver”
- Click "OK" to save the changes to your preferences.
You can validate the configuration as follows:
- Click on "Oracle SQL Developer" | "About Oracle SQL Developer"
- Click on the "Properties" tab and search for the following:
- Search for sqldeveloper.oci.available and verify that it says "true."
On Thu, May 9, 2019 at 1:30 PM Leroy Kemnitz <lkemnitz_at_uwsa.edu> wrote:
> Hey –
>
>
>
> Has anyone else experienced problems using SQL Developer to connect to a database using EUS?
>
>
>
> I am getting the below error.
>
>
>
> Status : Failure -Test failed: ORA-28274: No ORACLE password attribute corresponding to user nickname exists.
>
>
>
> I am running Oracle 12.1 on Linux 7.1. I am using SQL D 18.4 and 19.1 to connect to the database as a EUS user. I get the above error.
>
>
>
> It seems to work fine in Toad and sql plus.
>
>
>
> Any ideas??
>
>
>
> LeRoy
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2019 - 20:41:46 CEST