Skip to content
This repository has been archived by the owner on Oct 10, 2022. It is now read-only.

Connecting to Oracle DB #138

Closed
kadarius0719 opened this issue Jan 21, 2019 · 2 comments
Closed

Connecting to Oracle DB #138

kadarius0719 opened this issue Jan 21, 2019 · 2 comments

Comments

@kadarius0719
Copy link

kadarius0719 commented Jan 21, 2019

Hello,

I am having trouble trying to connect to an Oracle DB on a server. I installed the Oracle Client per the instructions, am using a tnsnames.ora file that works when trying to connect through DataGrip, and I also know the password and username are correct. However, I get this out put when trying to connect:

PS C:\318\api> typeorm-model-generator -h oradbdev03.pnl.gov -d rexd.dev.pnnl -p 1521 -u "user here" -x "password here" -e oracle -o .
[email protected]
[14:47:24] Starting creation of model classes.
Error connecting to Oracle Server.
Error occured in typeorm-model-generator.
[email protected] [email protected]
If you think this is a bug please open an issue including this log on https://github.com/Kononnable/typeorm-model-generator/issues
ORA-01017: invalid username/password; logon denied
(node:17744) UnhandledPromiseRejectionWarning: Error: ORA-01017: invalid username/password; logon denied
(node:17744) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
(node:17744) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

When using the oracledb module in another project, I specify a "connectString" variable with the tnsnames.ora params I have, which I put here: C:\oracle\instantclient_18_3\network\admin. Do I need to specify that when using the CLI?

Has anyone had any luck with using the modeler with an Oracle DB, and if so can anyone point out possible issues that may be causing the error I am seeing.

@Kononnable
Copy link
Owner

I recall only 1 issue about connecting to oracle - #111. You can check if hardcoding values would help.
I don't have much experience with oracledb so it's might be a longshot, but does your username/password have any special characters which might be captured by console(like characters for specifying env vars). Other reason might be case sensitivity and using older client libraries - https://stackoverflow.com/questions/14476875/ora-01017-invalid-username-password-when-connecting-to-11g-database-from-9i-clie .

@Kononnable
Copy link
Owner

Closing as no answer from the reporter.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants