search

OmniDB / OmniDB

Web tool for database management
https://omnidb.org
MIT License
3.17k stars 445 forks source link

Error Login Oracle #912

Open anubischpc opened 5 years ago

anubischpc commented 5 years ago

image

I'm having this problem when i try to SAVE my oracle database

image

This is my pc info: SO: Windows 10 64 bits Version: OmniDB 2.14.0 Oracle Package: Oracle Instant Client Version 18.5.0.0.0 (Basic Package) --Enviroments Variables-- PATH: C:\OmniDB-app\resources\app\omnidb-server\instantclient_18_5 (i'm only download and unzip the file in the directory of the omni db server, according the documentation i don't have to do nothing more, also i try whit others oci package as 12.2 and the problem is the same) TNS_ADMIN: C:\OmniDB-app\resources\app\omnidb-server\instantclient_18_5\network\admin (I try without this enviroment variable and the message is the same)

And if i try to connect whit the "Connection String" option y have this other error message:

image

Whit this conection String:

image

Plis ur help, i want to try this amazing management in my oracle's databases~

wind39 commented 5 years ago

Hi @anubischpc ,

Please move the contents of the folder C:\OmniDB-app\resources\app\omnidb-server\instantclient_18_5 to its parent folder, i.e., C:\OmniDB-app\resources\app\omnidb-server\. Then restart OmniDB.

Try again filling the connection information as you did the first time.

If you want to use connection string instead of specific fields, for Oracle the supported format is:

oracle://username@hostname:port/databasename

Best regards,

William

anubischpc commented 5 years ago

Hi @wind39 ,

I try it and i have the same message of install spartacus, i try also changing the Path of the OCI to its parent folder and there's no change about the message.

The only different was when i try to connect by the conection string, now the message have change for the same spartacus's message.

Edit:

When I click the "SAVE" button several times appears this new message

image

but my oracle database have don't block the conections, i install pl/sql developer managment to prove it, and make the conection well.

hj0707 commented 5 years ago

i met the same issue, but use OmniDB server , and i don't know how to install the oracle instant on OmniDB server, what is the path?

shyding commented 5 years ago

my path is "D:\OmniDB-server", where should put the oracle instant path?