ORA-01502 Oracle Index in Unusable StateWhen trying to perform query on Oracle tables with select SQL statement, Oracle returns the following error:ORA-01502: index ‘string.string’ or partition of such index is in unusable stateThe error indicates an attempt has been made to access an index or index...

Oracle Database LinkIn distributed Oracle environments, database links can be used to define a communications path between two databases. A database link defines a network connection, and, optionally, a username and password, to use when Oracle accesses and establishes a database session in the remote...

Important Tools and Utilities in One Google PackGoogle has packed all the most essential and the best software for personal computer in a package named Google Pack for the ease of computer users.These must-have applications will helps to protect computer from virus, adware and spyware, enhances the...

Watch Streaming p2p Live TV on the InternetThe advance of peer-to-peer technology (p2p) has make possible the distribution of video and TV streams via p2p network. p2pTV is the software application that doing basically that, designed to redistribute video streams on a p2p network.p2pTV is not the old...

YouTube Video Sharing and HostingYouTube is a Flickr-like online video service, which provides free video hosting and storage so that users can share it with their friends, family or even to the whole world. In short, YouTube is Flickr for videos.Basically, start by create a new free account at YouTube....

Check Cisco Switch Version and HardwareIn order to check Cisco Catalyst switch software version and hardware information, use the following command:show versionorshow hardwareBoth commands can be used, and the output can be interpreted like the following:Cisco Internetwork Operating System SoftwareIOS...

System Tray Icon Missing from System Tray in Windows XPSymptomsAfter the computer started, not all icons that should be present in the system tray (nowadays also called notification area) of the task bar is showing. Often, one or more icons are missing and disappearing from the task bar notification area.This...

Oracle Database Import Error 3113/3114When trying to import the Oracle export dump into Oracle database, the following errors occur:IMP-00003: ORACLE error 3113 encounteredORA-03113: end-of-file on communication channelIMP-00003: ORACLE error 3114 encounteredORA-03114: not connected to ORACLEThe errors...

Manual and Clean Uninstall Oracle for WindowsWarning: Editing registry may cause problems to your PC.If you facing problems trying to uninstall Oracle from your Windows workstation, or unable to uninstall Oracle installations cleanly and properly, the following steps may be used to uninstall all Oracle...

FireFox 1.5 to Provide Better Web ExperienceThe new version of Firefox has been released by open source group Mozilla Foundation, the not-for-profit organisation that rose from the ashes of Netscape after it lost out in the market to Microsoft in the late 1990s, promising a number of performance enhancements...

Disable Auto Go To (Jump) To Read More TagIn WordPress, it’s possible to a WordPress blog site to display post excerpts on the front or home page, and the visitors have to click on the title or a link to continue reading your post or article.One way of achieving this technique is by using the quicktag...

ppStream Connection Limit in Configuration SettingsNote: The newer version of ppSteream has integrated the configuration into the program’s menu.ppStream comes with a configuration file named setting.ini at the installation folder. It’s possible to tweak the connection limit settings in the configuration...

Easy Way to Upgrade FreeBSD’s PortsBefore you can update and upgrade the FreeBSD’s ports, the Ports Collection needs to be updated. Follow step here to update the Ports Collection.Once you updated your Ports Collection, before attempting a port upgrade, you should check the /usr/ports/UPDATING file....

Making phpBB2 working with PHP5Officially, phpBB 2 (as of this writing, up to version 2.0.17) is not supporting PHP 5. If you install PHP 5, and use it to run phpBB, you will encounter the following symptoms and errors:You cannot post message – When you want to post new topic or reply to a topic, after...

Check Oracle Versionhere are several ways where you can query or retrieve the version number of installed Oracle products:1. If you just want to check the version information of the Oracle database, simply connect and login to the Oracle database with SQL *Plus. Upon login, you will see:SQL*Plus: Release...