Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I can configure the connection to Oracle server via SSH. What parameters should I define in the Database Registration Info dialog?

April 26, 2017configure connection database define info Oracle parameters registration server SSH

0

Posted

I can configure the connection to Oracle server via SSH. What parameters should I define in the Database Registration Info dialog?

1 Answer

0

Posted

You need to input the following: • In the Connection section: • User name is an Oracle user name. • Password is password of the Oracle user. • In the SSH Tunneling section: • SSH host name is a host where SSH server is activated. • SSH port is a port where SSH server is activated. • SSH user name is a user on Linux machine. (It is a Linux user. It is not a user of Oracle server.) • SSH password is a Linux user password. To connect to Oracle server that is installed on Windows machine, it is necessary to disable Oracle port redirection by entering the registry entry ‘USE_SHARED_SOCKET = TRUE’ in the Windows registry under the HKLM\Software\Oracle branch. Also, connection by SSH should be established by using local naming method (using tnsnames.ora).