Execute Windows Commands from Linux using winexe. Connect from Linux to Windows without SSH

Winexe – is a software on Linux which uses RPC to run remote commands and might even come with your distribution's packages. It depends on Samba for running rpc commands Edit: even if your distro does not have it precompiled and you do not want to compile yourself, you should check out the Build Service … Continue reading Execute Windows Commands from Linux using winexe. Connect from Linux to Windows without SSH

Connect to Linux Desktop from Windows.

  1. Start XVNC11 on the Linux Server $ x11vnc -forever Add a line like x11vnc -forever to the end of your /etc/rc.local file. ## Incase X11vnc not available. Refer to this link to download and install the rpm http://pkgs.repoforge.org/x11vnc/   2. Download TightVNC or RealVNC and enter ip of your linux server and Bam … Continue reading Connect to Linux Desktop from Windows.

Schema Replication using Oracle Goldengate 11g (Installation & Configuration)

GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will be more closely coupled with Oracle products. Golden Gate is relatively simpler to use and monitor than Oracle streams. Below I will demonstrate how to configure ASYNC Schema Replication one side using Oracle GoldenGate 11g … Continue reading Schema Replication using Oracle Goldengate 11g (Installation & Configuration)

MRemote multi-tab remote connection manager

If you have multiple remote connections like VNC/ RDP/ SSH/ TELNET. There is a good software to manage multiple connections and save it for future use. It keeps all connections in a uniform tab-based format. Very powerful and useful tool. The best part : It is completely free and open source ! mRemote : full-featured, … Continue reading MRemote multi-tab remote connection manager

Access Oracle tables in SQL Server 2005

In a heterogeneous environment it sometimes becomes necessary to access information across different database. In this exercise I will demonstrate how you can access Oracle db tables in SQL Server 2005. 1. First you need to install Oracle client on the SQL server 2005 server. You can install using the instant client option. I am … Continue reading Access Oracle tables in SQL Server 2005

Move datafiles to different location.

From time to time a DBA might need move an Oracle database datafile from one location to another. Reasons for this might include: I/O balancing for performance reasons, or to rectify incorrect naming standards etc. In this example we are using non-asm and windows environment. ASM would only use +DATA1 +DATA2 tag etc and for … Continue reading Move datafiles to different location.

Alert log location in Oracle 11gR2

Oracle 11gR2 is a major release upgrade from 10gR2 and 11gR1 both. Many previous parameters like user_dump_dest etc have been deprecated. There is a single parameter called diag_dest.  Many DBA's are so used to the location of alert log and trace files , that it becomes quite inconvenient when you start using Oracle 11g . … Continue reading Alert log location in Oracle 11gR2

How to Add Date and Time to a Filename with Windows Command Line.

Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very liberal with variables you can define yourself eg: expdate=`date '+%d%m%Y'` dat=`date '+%m%d%y %H:%M:%S'` And then go onto define in your script as ./expdp system/system directory=export_dir dumpfile=exp_swx_$expdate.dmp logfile=exp_swx_$expdate.log schemas=swx But on Windows it can be done … Continue reading How to Add Date and Time to a Filename with Windows Command Line.

Delete files older than X days in Windows and Unix

Sometimes when your running an Oracle database,  it becomes necessary to automate some tasks like cleaning your archivelogs. Since in my setup we don't have a tape drive to which we can backup the archivelogs and delete it, we keep a retention period of one week for the archive logs on disk. If the archive … Continue reading Delete files older than X days in Windows and Unix