Re: SQL Developer connection issues

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-l