How to Change IP Address in Bitnami Tomcat and configure SSH properly?

         How to change IP Address in Bitnami Tomcat and configure SSH properly?

        While Configuring Bitnami Tomcat VM, I have to face an issue with IP address change and SSH Server was not working. But after an hour of research and struggle,I have found an easy way to change the IP address and bring up the SSH server so that I can access it from putty.

So let start configuration of Bitnami Tomcat Stack:

1)  In console open following path

cd /etc/systemd/network

Use sudo vi /99-dhcp.network to edit file.

2) Edit Below Detail in file

[Match]
Name=Interface Name

[Network]
Address=192.168.1.1/24
Gateway=192.168.1.1
DNS=192.168.1.50

  3) After Editing is completed save file using below command

      Press ESC  and :wq to save File

  4) After file is save reboot system using below command:

       Sudo Reboot.

  5) After system rebooted you can see above mention IP will get assign to Bitnami VM.     

SSH Configuration 

    First we have to remove openssh server from Bitnami Tomcat. use below command to remove Openssh Server

 sudo apt-get remove openssh-server                                        

sudo apt-get purge openssh-server (to remove all config file)              

       After you remove Openssh-server from Bitnami Stack reboot system.

      Install OpenSSH-Server again using following command.

 sudo apt install openssh-server 

After Install is completed you can check ssh service status as running  .

sudo systemctl status ssh

You can also see port 22 is open using netstat -tnlp command.                                    

           

 

 

Oracle Driver Installation for SSIS, SSRS & Power BI Connectivity with Oracle Database Server.

How to Connect SSIS, SSRS and Power BI Server to Oracle DB Server using Oracle Drivers?

Installation of oracle driver is Little bit tricky but you can install it by following below steps for Oracle driver Installation:

Step 1: First, you have to remove the Oracle driver which you have installed in the system previously.

Step 2: After that reboot system.

Step 3: Download this setup from Oracle WebSite:

https://www.oracle.com/database/technologies/oracle18c-windows-180000-downloads.html(32 or 64 bit any one of this will work).

Kindly Note That Visual Studio is require for proper installation of oracle drivers

I have downloaded setup file and i have kept it on my server. You can download the setup file and keep it in  your system anywhere you like.

Step 4: After executing the setup.exe, following cmd screen will be shown. Let the process complete, it will go ahead automatically.

Step 5: Select the language accordingly.

Step 6: Create a folder in C Drive as ORACLE32(for 32bit) or ORACLE64(for 64bit)

Select the following location in Oracle Base and then it will automatically set location for Software location directory based on the Oracle base location provided.

Step 7: Select user as required. I will select Windows Built-in Account.

Step 8: Select the features required. Mostly select all except the sample ODAC files.

Step 9: In this step, you may be asked to setup Visual Studio before going ahead.This visual studio error can also occur after the setup of SSDT. There is a different visual studio setup available for this.

Do the visual studio setup and re-run this setup again , the error wont be available

.

Step10: Pre-requisite checks

Step 11: Summary

Step 12: After the installation completes, visit the following link :

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15


Follow step mention in above link for SSRS, SSIS & Power BI Server for oracle driver configuration or just follow Step 13 mention below 

Step 13: Perform this steps after oracle client setup.

This concludes the Oracle 18c Client Setup.After this try  to connect with Oracle database from SSIS, SSRS and Power BI Server.

I hope this article was helpful to you in the oracle driver configuration.If you have any issues kindly mention in the comment and I will try to solve your problem.

Default gateway on CentOS

On Cent OS you can check the routing table with the following command:

$ route -n

The above command prints a table like this below:

Kernel IP routing table
Destination     Gateway        Genmask         Flags Metric Ref    Use Iface
10.254.1.0      0.0.0.0        255.255.255.0   U     0      0        0 eth0
192.168.185.0   0.0.0.0        255.255.255.0   U     0      0        0 eth1
0.0.0.0         192.168.185.2  0.0.0.0         UG    0      0        0 eth1

The last line of the table indicates the default gateway of the machine. In this case:

0.0.0.0         192.168.185.2  0.0.0.0         UG    0      0        0 eth1

Change default gateway

You can control default gateway using route command:

$ route del default gw <default_gateway_ip>
$ route add default gw <default_gateway_ip>

Keep in mind that this changes are only temporary. To change default gateway permanently you need to edit the file /etc/sysconfig/network and change to:

GATEWAY=<new_default_gateway_ip>

With many interfaces on the same sub-net it's also possible choose the preferred route to the default gateway with below command:

GATEWAYDEV=<network_interface>