Flashback table

Using Oracle's FLASHBACK command, it is possible to take any table to its previous state (even after commiting some delete statements)

1) You need to enable row movement on the table
2) You can take the table back to its previous state as of any time period


1) alter table table_name enable row movement;

FLASHBACK TABLE table_name TO TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' minute);
or
FLASHBACK TABLE table_name TO TIMESTAMP (SYSTIMESTAMP - INTERVAL '30' second);

Error Activating Windows 8

So, I installed Windows 8 and it never prompted me to enter my serial.

When I try to activate, I got "DNS name does not exist." with an error code  "0x8007232B"

To Activate Windows

1) Open Command Prompt with "Run as Administrator" option. You think this would be really easy, but with Microsoft way of thinking, not so !!

•   Go to Start Screen
•   Right click any where to get the  "All Apps" icon at the bottom of the screen
• Now locate command prompt icon, right click, choose "Run as Administrator" from the bottom

2) Now that you have the command prompt, type the following slmgr.vbs /ipk followed with your product key, as shown below


slmgr.vbs /ipk XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

iPad XBMC Crashes on start up

It looks like iTunes can sync some of the XBMC settings, So Delete the old XBMC settings and re-install XBMC

Use FileBrowser (like iFile ), and navigate to the following path (Start from your Disk folder ), and delete XBMC folder

var/mobile/Library/Preferences

Re-install XBMC, you are good to go.

Media Server not visible on network

I have a NAS with built in Media Server and one fine day my media server (Twonky) just disappeared from my network. My TV/IPad/Google TV/Apple TV won't find it any longer.

I was able to access my media server through a web browser with the proper port, so I knew it was my router that's preventing it from being discovered.

After 4 months, I figured out the issue. " IGMP Proxy" was enabled on my Verizon Fios Router ( I guess by auto firmware update). Once Disabled, my Twonky Media Server appeared on all devices.

To disable IGMP Proxy, go to your router home page ( usually by typing the default IP Address 192.168.1.1)

1. Click on Advanced Tab/Button
2. Locate IGMP Proxy, 
3. Disable it.

How to Install Logitech Media Server on WD LIVE NAS

It took a while to figure out how to install Logitech Media server for squeezebox on my WD Live NAS. There are couple of forums in the net, but here is the summary. It worked for me in the first attempt

First, You need tool like putty (Free), to access shell. So download Putty from http://www.putty.org/

1) Access your WD Live home page, either by name or ip address

http://192.168.x.x/UI/SSH
or
http://mybooklive/UI/ssh

Enable SSH Access, as shown below.



2) Now launch Putty, Login to SSH with the IP address above



3) Enter the login credentials in the resulting command prompt (ssh)
login as: root
password:welc0me




Now there are 2 options, Logitech Media Server by default uses port 9000. If you have Twonky media server running in your NAS, it already uses 9000.

1) So, you can either change Twonky Port to something else ( say 8000), and install logitech media server
or
2) Install Logitech media server, and it will figure out the next available port (as 9000 is already used), most probably you will end with 9001 or 9002. I went with Option 1

Option 1 ( Change Twonky Port to 8000)
Copy paste the following commands in the above shell prompt,
1) Stop Twonky server

/etc/init.d/twonky stop

Edit Twonky Config file using vi editor. These 3 basic commands should help you.
To save and exit vi editor   :wq  (command includes colon)
to exit without saving (if you mess up )  :q!


2) Open Config in vi editor

vi /CacheVolume/twonkymedia/twonkymedia-server.ini

You can use up/down arrow to scroll through and locate httpport, press letter 'a' to be insert mode, and edit it as shown



 save the file  :wq

3) Start Twonky server,

/etc/init.d/twonky start

4) You can see it running, by access the web page, in my case with my IP
http://192.168.1.1:8000/


Now lets proceed with Option 2 to install Logitech Media server
Option 2
back into shell command, copy paste these commands line by line. third line with wget downloads the file. If you have newer version, just change the file url

cd /DataVolume/shares/Public
aptitude update

wget http://downloads.slimdevices.com/LogitechMediaServer_v7.7.2/logitechmediaserver_7.7.2_all.deb 

dpkg -i logitechmediaserver_7.7.2_all.deb

You are done. Launch your webpage, again with my IP address
http://192.168.1.1:9000/



Good luck