linux - Prestodb cli Oracle Conenction - need help -Error running command: Authentication failed: Unauthorized

Question

Can presto installed in one instance query data from Oracle installed in another instance ??

Steps executed

Had Oracle in windows instance .

I have installed Presto in a linux server ,

* config.properties :
coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
query.max-memory=10GB
query.max-memory-per-node=1GB
discovery-server.enabled=true
discovery.uri=http://localhost:8080

Created a catalog "oracle.properties " with the valid connection details placed it in : /root/Presto/presto-server-0.245.1/etc/catalog

connector.name=oracle
connection-url=jdbc:oracle:thin:@3.2.2.2:1521/Databasename
connection-user=Username
connection-password=Passowrd

I have placed the cli jar in bin : made it executable chmod +x presto

Launched presto : bin/launcher start

started at 28562 Use command to run cli :

presto --server localhost:8080 --catalog oracle --schema Databasename

Cli is started ,

presto:Databasename>

But when a query is executed it is showing error Error running command: Authentication failed: Unauthorized All the details entered in the oracle.properties are valid . Any suggestion is appreciated , Thanks .

question from:https://stackoverflow.com/questions/65844150/prestodb-cli-oracle-conenction-need-help-error-running-command-authenticatio

Answer 1

Waitting for answers