CODEWITHSUNDEEP
databaseoracle-databaseintellij-ideasshdatagrip
Searene
Searene

Reputation: 27594

SSH tunnel doesn't work in DataGrip

I have an Oracle database that is located on server_c and are only accessible if you are on server_b. So in order to connect to this Oracle database, I have to first log in to server_b via SSH, and type in the following command to connect to it.

sqlplus username/password@server_c:1571/service

I would like to connect to the Oracle database in DataGrip, first I typed in my username and password in the SSH/SSL tab.

ssh tab

Then I typed in the general database information.

enter image description here

I thought it would be fine, but when I clicked on the Test Connection, I got an error.

Error: Connection to Oracle - @server_c failed. ORA-00604: error occurred at recursive SQL level 1 ORA-20001: Server is not in the List of Valid Application Servers ORA-06512: at line 28

This error occurs if I try to connect to the database directly without logging in to server_b beforehand. In other words, I think DataGrip doesn't connect to the SSH tunnel first before connecting the database.

I'm not sure if I'm using SSH/SSL tab correctly in this way. So if you have any idea why it doesn't work or any solution to it, please let me know.

Upvotes: 9

Views: 8460

Answers (1)

user9721842
user9721842

Reputation:

The clue is in the error message:

Error: Connection to Oracle - @server_c failed. ORA-00604: error occurred at recursive SQL level 1 ORA-20001: Server is not in the List of Valid Application Servers ORA-06512: at line 28

Check with your DBA either of:

  1. a sqlnet.ora valid node checking tcp.validnode_checking = ...

or more likely:

  1. a login trigger that prevents "unknown servers" from logging in.

Upvotes: 1

Related Questions