Coffee Horror

Last Sunday me and a few friends went to Cafe Coffee Day. You can imagine my shock when the menu arrived. The whole goddamn menu was shaped like a MS Window. A quick scan around the place confirmed the worst: the whole place was endorsing MS latest offering Vista. Come on, can’t i have cup of Hot Chocolate in peace.

They even have a Coffee specially for Vista. And just when i think it can’t get any worse, i spot this little paragraph on the menu:

Imagine a TV without channels, or a mobile without a SIM card. That’s just what your PC would be without Windows – a worthless box. Windows is the heart, soul and brain .. blah blah blah

This coupled with the fact that I was sitting opposite a moron who believes that Windows is the only way makes Swen very, very angry.

The weekend is here…

Now what???

Can Wizpy kill the iPod?

That remains to be seen.

Wizpy is the latest offering from TurboLinux. So you must be thinking what kind of a name is Wizpy for a device? Makes it sound like a small, good-for-nothing device that hopes to catch the audiophiles attention.

So what is the Wizpy? Take a look and stand back. Cause you not only get a personal media player but also your portable Operating System. Huh? Say what?

Wizpy, as a standalone, is a personal media player that plays your favourite OGG, MP3, and AAC files. It also plays movies in DivX on its 1.71-inch 256K colours OLED display. Records Mp3 via an inbuilt microphone, displays text and Pictures and also has FM Radio. Neat, huh? But that’s not all.

Wizpy, when connected to PC via USB, boots your own personal Linux OS. So you wont be stuck on anybody else’s desktop with his/her settings but can boot right into your own OS. All files will be stored on the Wizpy without touching the Hard disk of the PC. Just plug Wizpy into a usb slot and restart the PC. Voila.

And that OS has features such as
· Web browser that supports Web 2.0.
· Mail client that supports unsolicited e-mail blocking function, integrated RSS reader, and quick search function.
· Open standard office suite that has adopted OpenDocument format (ODF) standard file format (international standard ISO 26300) is available. You can use word processor, spreadsheet, and presentation software.
· Enjoy communication IP telephone software using the P2P technology is available.
· Media player that supports music file play, album management, jacket picture registration, ID3Tag edit, etc.
· Media player that supports wide variety of formats.
· Has a high-performance image viewer

The specifications are not fully clear but so far I heard that the device costs around $250 and comes with either 2GB or 4GB memory. It’s scheduled to release in Japan February 2007 and later this year globally. Anyways check it out at

http://www.turbolinux.com/products/wizpy/

Oh and wipe that drool of your face will ya ?!

How to create a Database in Oracle 9i manually

Note: Instructions are for Windows XP

1. Create a SID for your new Database

set ORACLE_SID={SID};

Note: Where {SID} is any unique SID created by you.

2. Create suitable database directories within oracle directory.

make folders udump,cdump,bdump within admin/{SID} (optional for logs)
make folder {SID} within oradata

3. Create a initialization parameter file and name it as
init{SID}.ora. Drop this file in

%ORACLE_HOME%/database folder. Contents could look like this.
(Settings and paths will

vary)

# Cache and I/O
DB_BLOCK_SIZE=4096
DB_CACHE_SIZE=20971520

# Cursors and Library Cache
CURSOR_SHARING=SIMILAR
OPEN_CURSORS=300

# Diagnostics and Statistics
BACKGROUND_DUMP_DEST=/oracle/admin/{SID}/bdump
CORE_DUMP_DEST=/oracle/admin/{SID}/cdump
TIMED_STATISTICS=TRUE
USER_DUMP_DEST=/oracle/admin/{SID}/udump

# Control File Configuration
CONTROL_FILES=(“/oracle/oradata/{SID}/control01.ctl”,
“/oracle/oradata/{SID}/control02.ctl”,
” /oracle/oradata/{SID}/control03.ctl”)

# Archive
LOG_ARCHIVE_DEST=’/oracle/oradata/{SID}/archive’
LOG_ARCHIVE_FORMAT=%t_%s.dbf
LOG_ARCHIVE_START=TRUE

# Shared Server
# Uncomment and use first DISPATCHES parameter below when your listener is
# configured for SSL
# (listener.ora and sqlnet.ora)
# DISPATCHERS = “(PROTOCOL=TCPS)(SER=MODOSE)”,
# “(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)”
DISPATCHERS =”(PROTOCOL=TCP)(SER=MODOSE)”,
“(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)”,
“(PROTOCOL=TCP)”

# Miscellaneous
COMPATIBLE=9.2.0
DB_NAME={SID}

# Distributed, Replication and Snapshot
DB_DOMAIN=us.oracle.com
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

# Network Registration
INSTANCE_NAME={SID}

# Pools
JAVA_POOL_SIZE=31457280
LARGE_POOL_SIZE=1048576
SHARED_POOL_SIZE=52428800

# Processes and Sessions
PROCESSES=150

# Redo Log and Recovery
FAST_START_MTTR_TARGET=300

# Resource Manager
RESOURCE_MANAGER_PLAN=SYSTEM_PLAN

# Sort, Hash Joins, Bitmap Indexes
SORT_AREA_SIZE=524288

# Automatic Undo Management
UNDO_MANAGEMENT=AUTO
UNDO_TABLESPACE=undotbs

4. Create a password file with name PWD{SID}.ora and place in
%ORACLE_HOME%/database folder.

Create the password file using the following command:

orapwd file={path\filename} password=oracle

5. Create an instance of this database

oradim -new – -sid {sid}

6. Start SQLPLUS using the following command

sqlplus /nolog

7. Connect to instance of database

connect / as sysdba

8. Startup the instance without mounting

startup nomount

9. Run create database SQL statement

CREATE DATABASE {sid}
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 (‘/oracle/oradata/{sid}/redo01.log’) SIZE 100M,
GROUP 2 (‘/oracle/oradata/{sid}/redo02.log’) SIZE 100M,
GROUP 3 (‘/oracle/oradata/{sid}/redo03.log’) SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE ‘/oracle/oradata/{sid}/system01.dbf’ SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ‘/oracle/oradata/{sid}/temp01.dbf’
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE ‘/oracle/oradata/{sid}/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;