Oracle DBA Place

Last week I needed to connect a database from remote using VPN. The VPN is connected to a secured network, so I couldn’t connect directly to the database. Since I am using Toad for Oracle which is based on oracle client – I needed a transparent solution for that connection. At the past I wrote a post about Using ssh X11 tunnel through a bastion host to connect to a database server  , at that post I described how to forward SSH and X11. Now I will describe a way to connect to the database using SQL*Net (usually port 1521) on Windows. Download plink from https://www.putty.org , you can download putty package or just standalone plink. Run the following command line: plink -N -L localport:dbserver:dbport getwayuser@getwayserver Do this on both machines (REMOTE PC Windows machine and the server you have access to - Gateway) to chain the SSH tunnels. Example: Gateway server (assuming Linux): ssh -N -L1521:dbserver:1521 dbserveruser@dbserver Your PC: plink -N...

Connection manager is working as oracle SQL*NET proxy and firewall. In this example, I am using Connection Manager of Oracle Database 12c Release 2 running on Linux x86_64 Footprint Storage: 1.7 G Memory: 5~28.4 MB Requires: Installation of Oracle Client in a separated folder than the database software Register the connection manager in the grid infrastructure as a cluster resource Configure and install on the intermediate host Download Oracle Database 12c Release 2 Client unzip linuxx64_12201_client.zip Change response file /client/response/client_install.rsp: UNIX_GROUP_NAME= INVENTORY_LOCATION= ORACLE_HOME= ORACLE_BASE= oracle.install.client.installType=Custom oracle.install.client.customComponents=oracle.network.cman:12.2.0.1.0 Start silent installation: cd /client ./runInstaller -silent -responseFile /client/response/client_install.rsp -ignoreSysPrereqs -ignorePrereq -noconfig -waitforcompletion -force -showProgress run root.sh sudo /oracle/prod...

Hi, Trying to configure dNFS with multipath I ran into the need of routing traffic from a specific devices (10G), this article describing how to do this in the Operating System (Centos/Redhat/Oracle). There are 2 different ways of configuring persistent static routes. The first approach requires adding entries for each device (NIC) to the files /etc/sysconfig/network-scripts/route-eth[X] For eth0, the file would be /etc/sysconfig/network-scripts/route-eth0 Example: echo "192.168.10.30 via 192.168.10.10" >> /etc/sysconfig/network-scripts/route-eth0 echo "192.168.10.32 via 192.168.10.12" >> /etc/sysconfig/network-scripts/route-eth1 To add the routes instantly, run the script /etc/sysconfig/network-scripts/ifup-routes. It takes the device name as input. The script is always run at boot time so the static routes are recreated after reboots. Example: /etc/sysconfig/network-scripts/ifup-routes eth0 /etc/sysconfig/network-scripts/ifup-ro...