Data Gateway Direct Acces Oracle Error ORA-28547

[ManuelRühl]

Hi,

I want to connect to an Oracle Database via Direct Access.
We checked hostname, database name, port and credentials with Qlik Desktop and a 32bit-Driver.

But using the Qlik Cloud Oracle Connector we get the following error:

Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message:
Please check the values for Username‚ Password‚ Host and other properties. Description: General error - ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-28547: connection to server failed, probable Oracle Net admin error

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-28547: connection to server failed, probable Oracle Net admin error
[Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-28547: connection to server failed, probable Oracle Net admin error
")

Any tips or insights would be super helpful—thanks in advance!

[hugo_andrade]

Hi @ManuelRühl ,

How is the configuration for the TNSNAMES.ora?

The Gateway uses the file that is available on C:\Program Files\Qlik\ConnectorAgent\QvOdbcConnectorPackage\oracle\lib\network\admin\tnsnames.ora

Make sure the correct file is placed there and let us know the results.

[ManuelRühl]

@hugo_andrade Thanks for reply.

I didnt place any files in this folder at all.

I copied the sample-files in this folder and tried adjust the correct information, but it didnt work either.
Is it just the tsnames.ora or do I need to configure the sqlnet.ora as well?

My tsnames.ora looks like this at the moment:

ECHT =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 0.0.0.0) -> correct IP entered
(PORT = 1521)
)
(CONNECT_DATA =
(SID = xxx) -> correct SID entered
)
)