Scaffold-DbContext ORA-01017: invalid username/password; logon denied

jb06

I am trying to scaffold some classes from an Oracle database for use with a .NET Core Web API. I have installed the Oracle.EntityFrameworkCore nuget package, v2.18.0-beta3

Scaffold command - Scaffold-DbContext "<span style="color: #242729; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; background-color: #eff0f1;">User ID={UserId};Password={Password};</span>Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcpcom.world)(PROTOCOL=tcp)(HOST={Host})(PORT={Port})))(CONNECT_DATA=(SID={SID})))" {Provider} -o Models

The error I receive: ORA-01017: invalid username/password; logon denied

I can use the connection string from the scaffold command to query the database and return records.

References:

StackOverflow question

Alex Keh-Oracle

The VS Package Manager Console provides a PowerShell interface. I would expect a PowerShell reserved symbol, such as ($), would not be treated as a literal character. What happens when you escape the ($) or have a password without ($)?

Most of the time I encounter these ORA-01017 errors, it's a result of reserved symbols of the language/app that the user tries to log in from.

Alex Keh-Oracle

Does the user name or password have any special characters? If so, what are they and does the issue reproduce if you stick with an user name and password that is strictly alphanumeric?

jb06

It does have special characters, underscore (_) and dollar sign ($).

As for using a password that is alphanumeric, that's not really an option because the passwords assigned to the account are not under our control to change.

Alex Keh-Oracle

The VS Package Manager Console provides a PowerShell interface. I would expect a PowerShell reserved symbol, such as ($), would not be treated as a literal character. What happens when you escape the ($) or have a password without ($)?

Most of the time I encounter these ORA-01017 errors, it's a result of reserved symbols of the language/app that the user tries to log in from.

jb06

This was the issue. I simply added a backtick (`) in front of the ($) and the scaffold command ran successfully (kinda). Now I have another issue, but I will post another question if I can't figure it out.

Thanks for your time and assistance.