ORA-01502 Oracle Index in Unusable State

December 30, 2005 Add Comment

ORA-01502 Oracle Index in Unusable State


When 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 state

The error indicates an attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation.

The problem usually happens when using the Direct Path for the SQL*Loader, Direct Load or DDL operations. This requires enough temporary space to build all indexes of the table. If there is no enough space in TEMP tablespace, all rows will still be loaded and imported, but the indices are left with STATUS = ‘INVALID’.

Invalid indexes can be checked with a SELECT * from USER_INDEXES WHERE STATUS = ‘INVALID’; SQL statement.

Solution to this error is simple. You can:

Drop the specified index and/or recreate the index
Rebuild the specified index
Rebuild the unusable index partition
Generally, the following SQL manipulation language will be able to rebuild the unusable index:

ALTER INDEX index_name REBUILD

Oracle Database Link

December 14, 2005 Add Comment

Oracle Database Link


In 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 database on behalf of the local application request.

Database link enable SQL statements to be isolated from the underlying physical network topology. Thus, whenever the location of a remote database changes, only the link need be updated, and not each and every SQL queries, significantly the tasks of programmer.

Oracle database link is defined in a specific database, and may be used only by users of that database. If the same database link name was to be used from all databases in the network, the links must be defined identically with that name in each of each databases. For this scenario, the easier way is to be global database link.

Database Link Creation

Login into Oracle database (with SQL*Plus, for example) as a user who has the privilege to create a database link and execute the following command:

CREATE DATABASE LINK link_name
CONNECT TO user_name IDENTIFIED BY password
USING ‘connection_string’;

where connection_string is an entry is tnsnames.ora (usually located in $ORACLE_HOME/network/admin), which enables the Oracle to know the network path to remote database.

connection_string has the following structure:

(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP) (Host = host_name/ip_address) (Port = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = database_name)
)
)

Database Link Deletion

To delete a database link:

DROP DATBASE LINK link_name;

Important Tools and Utilities in One Google Pack

December 09, 2005 Add Comment

Important Tools and Utilities in One Google Pack


Google 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 ease and flexibility of using computer and while surfing or browsing internet. With the popularity of digital photography and instant messaging nowadays, Google Pack also include best photo management software and popular instant messaging client. Also look out for free artwork and photos and programs that will turns your PC into multimedia center.

Most of the software in Google Pack is freeware, although you may pay to use more than the basic functionality or extend the virus signatures update beyond 6 months.

Software available in Google Pack:


  • Google Earth – Best free 3D earth browser, where you can zoom even till street level.
  • Picasa – Free and feature packed photo organizer, enables you to enhance your photos with just 1 click!
  • Google Desktop – Organize and arrange all your personalized information in one place and search for everything with this invaluable desktop companion.
  • Google Toolbar for Internet Explorer – Enhance Internet Explorer to block pop-ups, search from any web pages and autofill forms.
  • Google Pack Screensaver – A photo screensaver that use your personal collection.
  • Mozilla Firefox with Google Toolbar – Better browser with better security control and tabbed browsing.
  • Ad-Aware SE Personal – One of the best and free spyware removal utility. The antispyware utility can safely detect and remove spyware, beside protect your privacy.
  • Norton Antivirus 2005 Special Edition – Antivirus utility to protect your PC from viruses, worms and Trojan horses, and comes with free 6-month subscription to protection and virus signature updates.
  • Adobe Reader 7 – Read .pdf files
  • Google Talk – Talk with friends and send instant messages to friends for free.
  • RealPlayer – Organize and play various popular media formats of music and videos, and tranfer your favorite music to Apple iPod or other portable media players.
  • GalleryPlayer HD Images – Free high quality images.
  • Trillian – Free install messenger to chat with friends on AIM, ICQ, MSN, and Yahoo! Messenger.

Most importantly, all software application in Google Pack will automatically updated with Google Updater, a new tool that will keep the application up-to-date.

Watch Streaming p2p Live TV on the Internet

December 05, 2005 Add Comment

Watch Streaming p2p Live TV on the Internet


The 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 method of downloading movies, dvds, tv episodes by using bit-torrent or edonkey or other file sharing network, and then watch the videos after completing the download. Nor it’s downloaded short video clips through shoutcast, etc.

p2pTV is freeware which enables you to watch video streams, including live tv channels from pay cable or satellite tv. Thus, it’s possible to make every tv channels in the world to available to all viewers globally.

How the p2pTV Technology Works?

In the traditional way of video streaming, all viewers connect to the streaming server, thus creating bottlenecks or traffic congestion on the server, slowing down the downloads and viewing pleasure.

With p2pTV technology, only few users need to connect to the main streaming server. Instead each users themselves become a streaming server that broadcasts to other peer while at the same time receiving the streaming video from other peer’s streaming server. This greatly reduces the burden on main video streams hosting server, and increases the sources where the media can be streamed from. Thus, the download speed will be higher, and so do smoothness of media playing.

System Requirements

While each individual p2p TV applications may have its own system requirement, but as a rule of thumb, to have a optimum streaming quality for great viewing pleasure without much lagging, it’s vital to have at least the following:

At least 1,500 Kbps download speed
Windows Media Player 9 and/or Real Player

YouTube Video Sharing and Hosting

December 05, 2005 Add Comment

YouTube Video Sharing and Hosting


YouTube 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. Then you will be able to start uploading your personal videos that you like to share with the world to YouTube digital video repository. Type of video format allowed includes .AVI, .MOV and .MPG formats, which enough to cover most if not all video files generated from digital cameras and mobile phones. The maximum file size of a video is limit to 100 MB though.

Once the video is in YouTube, it may be tagged with keywords to allow other people to find the video through the tags. The video will also be arranged according to related channels.

To share the video, just send the link that points directly to the video’s YouTube page that plays the video to your friends. Beside, YouTube also has embeddable player that allowed videos to be played directly on your web page, without leaving your site. Beside, it’s also possible to displaying a window of your own YouTube videos, or specifically tagged videos on your web page. Or create a link that links to your profile, your videos, or specifically tagged videos on YouTube.

All videos will play back by YouTube Flash Player. And the video cannot be downloaded. But it’s still good for video blog or simply just share your video to the world.

Check Cisco Switch Version and Hardware

December 04, 2005 Add Comment

Check Cisco Switch Version and Hardware


In order to check Cisco Catalyst switch software version and hardware information, use the following command:

show version

or

show hardware

Both commands can be used, and the output can be interpreted like the following:

Cisco Internetwork Operating System Software
IOS ™ GS Software (GS7), Experimental Version 10.2(11829) [pst 113]

System-Type (ImageName) Version Major.Minor(Release.Interim)[Who] Desc

System-Type: Type of system the software is designed to run on.
ImageName: The name of the image. This is different (slightly) for run-from-rom, run-from-flash, and run-from-ram images, and also for subset images which both were and will be more common.
Version: Text changes slightly when, for example, if given a special version of software to try out a bug fix, it will say experimental version.
Major: Major version number, which (in theory) whenever has major feature additions and changes to the softare.
Minor: Minor version number, which counts smaller but still signficant feature added.
Release: Increment of 1, 2, 3, 4… for each maintenance release of released software for every compile in some other places.
Interim: Increment on every build of the release tree in software control, which happens weekly for each release, but is only made into a generically shipping maintenance release every 7 to 8 weeks or so.
[Who]: Who built it, which has “fc 1″ or similar for released software.
Desc: Additional description.

Copyright (c) 1986-1995 by cisco Systems, Inc.
Compiled Thu 09-Mar-95 23:54 by tli
Image text-base: 0×00001000, data-base: 0x00463EB0

Copyright, compilation date, by whom, as well as the starting address of the image.

ROM: System Bootstrap, Version 5.0(7), RELEASE SOFTWARE
ROM: GS Software (GS7), Version 10.0(7), RELEASE SOFTWARE (fc1)

The version of ROM bootstrap software, and the version of IOS in ROM.

demo.cisco.net uptime is 2 weeks, 4 days, 18 hours, 38 minutes
System restarted by reload

How long the router has been up, and why it restarted.

System image file is “sse-current”, booted via flash

How the router was booted.

RP (68040) processor with 16384K bytes of memory.

Type of processor.

G.703/E1 software, Version 1.0.
X.25 software, Version 2.0, NET2, BFE and GOSIP compliant.
Bridging software.
ISDN software, Version 1.0.

Various software options compiled in.

1 Silicon Switch Processor.
2 EIP controllers (8 Ethernet).
2 FSIP controllers (16 Serial).
1 MIP controller (1 T1).
8 Ethernet/IEEE 802.3 interfaces.
16 Serial network interfaces.
128K bytes of non-volatile configuration memory.
4096K bytes of flash memory sized on embedded flash.

Hardware configuration.

Configuration register is 0×102

Lastly, the “configuration register”, which may be set via software in recent release.

System Tray Icon Missing from System Tray in Windows XP

December 02, 2005 Add Comment

System Tray Icon Missing from System Tray in Windows XP


Symptoms

After 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 is known problem, or a bug of Windows XP. It has nothing to do with Hide Inactive Icons that tidy up your notification area.

Cause

The exact cause for the problem is unknown. According to Microsoft, the problem can be caused by the Simple Service Discovery Protocol (SSDP) which discovers Universal Plug and Play devices on your network.

However, Microsoft Knowledge Base may not exactly the same symptom with notification area icons do not appearing issue, as it also has other symptoms:

The pointer changes to an hour glass when you move it over the taskbar.
Some icons do not appear in the notification area.
When you click Start, nothing happens.
The Start button does not work for several minutes, and then it starts to work.
When you restart the computer, the icons in the notification area are missing. If you log off and log on with the same user account, the icons appear.
When you click any icon in the Quick Launch bar immediately after starting the computer, the pointer changes to an hourglass.
Solutions

Possible solutions are many, although none confirmed to be working perfectly. If you have the symptoms as mentioned by Microsoft above, you can try out resolution suggested by Microsoft to resolve this behavior. Note that Microsoft’s solution will disable the SSDP Discovery Service, which caused new devices on the network cannot be found automatically.

1. Right-click My Computer, and then click Manage.
2. Click Services and Applications.
3. Double-click Services.
4. In the Services list, right-click SSDP Discovery Service, and then click Properties.
5. On the General tab, in the Startup type drop-down list, click Disabled.
6. Click OK.

If it doesn’t work, the alternative would be disable both SSDP Discovery Service and Universal Plug and Play Device Host. Repeat the above steps for both services.

You may try to choose Automatic at step 5 instead of Disabled, as it’s reported some people has success with this.

If you need Universal Plug and Play services and wouldn’t want to disable it, Francesco Ostuni suggested Ostuni Workaround which does not disable the uPNP service. The steps as below (only applicable on Windows XP with Service Pack 2):

1. Open My Network Places.
2. Click Hide Icons for Networked uPnP Devices at the Tasks panel.
3. For Windows Classic theme users, click Tools and the Folder Options in Windows Explorer, and then select Show Common Tasks in Folders to see the option specified in step 2.

Or,

1. Open Control Panel.
2. Click Add or Remove Programs.
3. Click Add/Remove Windows Components.
4. Select Networking Services.
5. Click Details button.
6. Uncheck (remove) the UPnP User Interface.
7. Click OK.

The most reliable way to solve the problem is to logout and then login again to Windows XP.

If you don’t want to logout and login Windows XP after starting the PC, Disable Automatic Logon is a possible way to solve the issue by the following steps:

1. Click on Start.
2. Click on Run.
3. Type “control userpasswords2″.
4. Click OK.
5. Check (Select) Users must enter a user name and password to use this computer.
6. Click OK.

Oracle Database Import Error 3113/3114

November 14, 2005 Add Comment

Oracle Database Import Error 3113/3114


When trying to import the Oracle export dump into Oracle database, the following errors occur:

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00003: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE

The errors occur on Oracle database installed in Windows machine too. Actually the problem can occurs in any platform of Oracle database. It usually happens when try to import into new database.

The problem occurs because imp utiliy encounters error out when trying to execute some commands.

The solution to solve the problem is as following:

Login as sys in the SQLPLUS and run the following sqls

$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb

After executing the above sql scripts, retry the import. The error should disappears.

Manual and Clean Uninstall Oracle for Windows

November 12, 2005 Add Comment

Manual and Clean Uninstall Oracle for Windows



Warning: 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 products currently install on the workstation:

Uninstall all Oracle components using the Oracle Universal Installer (OUI).
Delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key which contains registry entries for all Oracle products by using regedit.
Delete any references to Oracle services/components in the following registry 



location: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/. Looks for key entries that starts with “Ora” which are obviously related to Oracle.



Reboot the workstation.



Delete the ORACLE_BASE directory. (i.e C:\Oracle)
Delete the C:\Program Files\Oracle directory.
Empty the temp directory.
Empty the recycle bin.
With this, the computer is more or less clear of any Oracle components, which allows you to reinstall Oracle if needed.

FireFox 1.5 to Provide Better Web Experience

October 29, 2005 Add Comment

FireFox 1.5 to Provide Better Web Experience


The 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 to the world’s second most popular internet browser, including speedier browsing, swifter updates and better pop-up blocking.

Firefox 1.0 was introduced just over one year ago, and Firefox 1.5 is the browser’s first major update. Since then, Firefox has emerged as one of the most popular alternatives to Microsoft’s Internet Explorer, with more than 100 million copies downloaded in the first year, more than 40 million active users and about 8 percent of the browser market.

New features in Firefox 1.5 include:

Automated update to streamline product upgrades. Notification of an update is more prominent, and updates to Firefox may now be half a megabyte or smaller. Updating extensions has also improved.
Faster browser navigation with improvements to back and forward button performance.
Drag and drop reordering for browser tabs.
Improvements to popup blocking.
Clear Private Data feature provides an easy way to quickly remove personal data through a menu item or keyboard shortcut.
Answers.com is added to the search engine list.
Improvements to product usability including descriptive error pages, redesigned options menu, RSS discovery, and “Safe Mode” experience.
Better accessibility including support for DHTML accessibility and assistive technologies such as the Window-Eyes 5.5 beta screen reader for Microsoft Windows. Screen readers read aloud all available information in applications and documents or show the information on a Braille display, enabling blind and visually impaired users to use equivalent software functionality as their sighted peers.
Report a broken Web site wizard to report Web sites that are not working in Firefox.
Better support for Mac OS X (10.2 and greater) including profile migration from Safari and Mac Internet Explorer.
New support for Web Standards including SVG, CSS 2 and CSS 3, and JavaScript 1.6.
Many security enhancements.

Disable Auto Go To (Jump) To Read More Tag

October 14, 2005 Add Comment

Disable Auto Go To (Jump) To Read More Tag


In 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 called “more”. The quicktag “more” is inserted into the post at the desired break-off (or cut-off) point so that everything above it become an excerpted content of the post and everything below it will only be readable when the visitors click on the title or a link to view the whole post.

The quicktag “more” is implemented by inserting the following line of code into the post:

However, by default, when a visitor click on the Read More link, the web page loads and then automatically forwards or jumps to the spot where the tag is set in the post. If you do not want this kind of positioning, you can change the default function of how this works by editing the following line in wp-includes/template-functions-post.php:

$output .= ‘ <a href="’. get_permalink() . "#more-$id\">$more_link_text</a>";

to

$output .= ‘ <a href="’. get_permalink() ."\">$more_link_text</a>";

or

$output .= ‘ <a href="’. get_permalink() ."”>$more_link_text</a>’;

After the change, the Read More link will load the blog post and stop at the top of page instead of position where the quicktag “more” were.

NOTE: When upgrading WordPress, this file will be replaced so make a note of the change so you can change it again after upgrading.

ppStream Connection Limit in Configuration Settings

October 14, 2005 Add Comment

ppStream Connection Limit in Configuration Settings


Note: 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 file to achieve optimum bandwidth speed for best viewing experience. It’s a good answer to solve some problem when viewing channel with ppStream such as streaming lagging, frequent disconnection, slow buffering etc.

The available configuration settings are as below:

remotepeerlimit = 41
localpeerlimit = 35
totalpeerlimit = 51
simulconnectingpeer = 30

The value of above is the default setting. All of the settings are quite self-explanatory as its name. You may not see the above lines in setting.ini configuration file. If it’s not in the setting.ini, add it in.

It’s hard to determine the best setting for all as each user’s computer and network configuration is different. So the best way is to try it out yourself and determine for yourself. I set all my 4 settings to 100, and able to achieve a very smooth streaming and almost without disconnection.

Some people has even set the limit to even higher than 100. But note that it’s not almost works. As currently ppStream has no ability to limit upload bandwidth speed, if you set connection limit too high, it’s good to have a lot of source peer to download. But remember that your workstation is a peer too that will upload to other peers. If upload takes up too much bandwidth, it will adversely affect the download speed, especially on ADSL broadband.

Easy Way to Upgrade FreeBSD’s Ports

October 09, 2005 Add Comment

Easy Way to Upgrade FreeBSD’s Ports


Before 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. This file describes various issues and additional steps users may encounter and need to perform when updating a port.

Keeping the ports up to date can be a tedious job. Just for example, to upgrade a port you need to go to the ports directory, build the port, deinstall the old port, install the new port, and then clean up after the build. If there are numerous ports that need to be upgrade, it will be very troublesome. This was a large problem for system administrators to deal with, and FreeBSD have utilities which do this automatically, and that’s sysutils/portupgrade utility.

To install sysutils/portupgrade utility, use the command just as to install any other port: make install clean.

Create a database with the following command: pkgdb -F

The command will read the list of installed ports and create a database file in the /var/db/pkg directory.

Run portupgrade -a to start to update the ports.

The portupgrade will read the database file created by pkgdb -F and the ports INDEX file. Finally, portupgrade will begin to download, build, backup, install, and clean the ports which have been updated.

Portupgrade utility has a lot of options for different uses, the most important ones listed below.

If you want to upgrade only a certain application, not the complete database, use portupgrade pkgname, include the flags -r if portupgrade should act on all those packages depending on the given package as well, and -R to act on all packages required by the given packages.

To use packages instead of ports for installation, provide -P. With this option portupgrade searches the local directories listed in PKG_PATH, or fetches packages from remote site if it is not found locally. If packages can not be found locally or fetched remotely, portupgrade will use ports. To avoid using ports, specify -PP.

To just fetch distfiles (or packages, if -P is specified) without building or installing anything, use -F.

Note: It is important to regularly update the package database using pkgdb -F to fix inconsistencies, especially when portupgrade asks you to. Do not abort portupgrade while it is updating the package database, this will leave you an inconsistent database.

Making phpBB2 working with PHP5

September 20, 2005 Add Comment

Making phpBB2 working with PHP5

Officially, 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 writing your message, when you click “Submit”, a blank page or screen or error message is shown with address bar showing posting.php, instead of posting confirmation message.
You unable to search – When you want to search by clicking oh “Search”, no search results are been returned, or a black page or screen, or error message is shown.
To enable PHP 5 to work properly with phpBB, some changes to the phpBB source code needs to be done. Just follow steps as below:
OPEN
admin/admin_ug_auth.php
FIND
if( $forum_access[$i][$auth_field] == AUTH_ACL && isset($change_acl_list[$forum_id][$auth_field]) )
REPLACE WITH
if( $forum_access[$i][$auth_field] == AUTH_ACL && isset($change_acl_list[$forum_id]) )
FIND
( !isset($auth_access[$forum_id][$auth_field]) && !empty($change_acl_list[$forum_id][$auth_field]) ) ) ||
REPLACE WITH
( !isset($auth_access[$forum_id][$auth_field]) && empty($change_acl_list[$forum_id][$auth_field]) ) ) ||
Finally, some changes are needed so that functions that get called with functions as parameters are not called ‘by reference’ with functions:
OPEN
includes/functions_post.php
FIND
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_message, &$poll_title, &$poll_options, &$poll_length)
REPLACE WITH
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, $post_username, $post_subject, $post_message, $poll_title, &$poll_options, &$poll_length)
OPEN
includes/functions_search.php
FIND
function clean_words($mode, &$entry, &$stopword_list, &$synonym_list)
REPLACE WITH
function clean_words($mode, $entry, &$stopword_list, &$synonym_list)
FIND
function split_words(&$entry, $mode = ‘post’)
REPLACE WITH
function split_words($entry, $mode = ‘post’)
For the above, the changes involved are some parameters have been stripped off the “&” sign.

Check Oracle Version

September 17, 2005 Add Comment

Check Oracle Version

here 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 9.2.0.6.0 – Production on Tue Oct 18 17:58:57 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 – Production

The first italic number is the version of the SQL*Plus client and the second italic number is the version of Oracle database which you are connected to .

2. Retrieve the version information from v$version table by using SQL*Plus. In this table you can find version information on Oracle, PL/SQL, etc.

To retrieve the version information for Oracle, you execute the following SQL statement:

select * from v$version where banner like ‘Oracle%’;

It should return something like this:

Banner
————————————————————————————–
Oracle9i Enterprise Edition Release 9.2.0.1.0 – 64bit Production

3. Version information can also be checked from Installed Products from the Oracle Universal Installer. It will tells you what products is installed on the machine and also its version information too.

In Unix, the installer is located at $ORACLE_HOME/bin/runInstaller.
In Windows, access the installer by Start -> All Programs -> Oracle Installed Products -> Universal Installer.