Installing Oracle 9i on windows xp, in 3 steps

Last week I got a new notebook from development team to test the performance using NTFS based encryption on oracle & jboss installation. Initially these machines were expecting to be ubuntu 7.0 machines but later due to less expertize in linux the communication team complaint against putting Linux in these client machines, because they have to travel to provences & it will be defficult for them to handle different situation there...

Anyhow I have to test all this shit on Windows XP. I when started installing oracle 9i on windows xp, had a small confusion that what are the important steps to keep in mind during oracle 9i installation in windows xp, initially i tried searching some step-by-step for the task but had a hard luck ... i created my own...here it is:

step:1 Define environment vairables,

click on: start -->control panel --> system --> Advance

here you will find a tab "Environment Variables"

"click on that"

you will get a pan you need to add new environment variables as below:

1. Name: ORACLE_BASE
Value: c:\oracle OR "path-for-oracle-installation"

2. Name: ORACLE_HOME
Value: %ORACLE_BASE%\ora92

3. Name: ORACLE_SID
Value: name_of_instance

4. Name: NLS_LANG
Value: american_america.WE8ISO8859P15 "this character set can be used for Portuguese language."


Step 2: insert oracle 9i cd/dvd & start the setup. The rest is pretty smooth. just few clicks like,

1. click on Install
2. click on Next "this screen shows oracle home description"
3. select Oracle 9i database
4. select Enterprise Edition OR "your on choice"
5. select Software only

Step 3: After finishing this installation, you need to patch it for 9.2.0.7.

Download patch id: p4163445_92070_WINNT from metalink.

After running this patch you are ready to use oracle 9i version 9.2.0.7.

Cheers

Last for the road.

It was normal Saturday morning last week, when Carla Judith called on my cell, & told that she will not be able to visit my farm because she has a party at home...just on end of conversation i asked what for this party? she replied, its my elder sister's wedding 10th anniversary so we are enjoying together ! I quickly with surprise 10 years with one husband :D she with anger YEAH !!! WTF you think my sister is like .... anyhow i stop flaming with a tiny sorry...later in the evening when i was as usual sitting with friends in Maputo Shopping Center, watching Indian girls & their new fashion :p...i got a call from Carla Judith, she asked me to come & join the party, i asked her i am really hungry if she can only offer me some meal & later i will quickly sweep back to my home then i will visit her house, she agreed...

Mind you that i really hate people when they are drunk & make noise...! when i reached her house i was standing outside...asked her to bring my meal, she insist to meet her father n mother, because they wants to know my colleagues...i initially hesitated but later went inside her house, there were almost 4 big tables in open air...with African/Mozambican music, ladies & gents were dancing as usual...wine & beer was scattered on tables as normal...anyhow i went to table where her father n mother were sitting...as soon as they saw me with their daughter they stand up & we met, "it looked that they were waiting for me...might be awarded of my visit" anyhow they offered me a chair to sit with them...just in few second Carla came & requested me "Nayyar, porfavor...comer aki...com nos...mha mae, pae gostar que mha coleaga sintar aik" English: "Nayyar, please eat here..my mother n father likes when my coleagues stay our home"...i replied Ok, "mas fazer muito rapido, eu ker ir sedo" English: "ok, but do it fast, i wants to go back soon"...!

Soon, she came with my favorite salad & chicken roast...i asked one Coca cola...things were normal...until, one of the guy suddenly screamed..."vomos embora...vomos embora...vamos beber ate amanha ser...vomos embora..." English: "lets go...lets go...lets drink until next day...lets go..." i quickly realise the guy is DRUNK...and tried to ignore him...he suddenly again shouted with more force...& it started becoming pain in ass...i ask Carla Judith, that if she invite people let them know that you should drink just to the level where they remain human...she started laughing at me...she said, "Nayyar, es normal...", English: "Nayyar, this is normal..." anyhow i tried to forcefully ignore that son of a bitch...but he continuously getting into my nerves...i was playing with my patience...suddenly one guy who was sitting just next to me on table...called her wife..."Amor...vamos casa..." English: "My love lets move home...", & he snatched the big wine bottle in his hands...with screaming voice "LAST FOR THE ROAD..." i wish he will be safely home :-|

Still when i think about that night i get stressed...even when i left the party & came outside Carla's home...the guy was shouting "vomos embora...vomos embora.....", & his voice was reaching until my car...

Today as it is Wednesday...i was trying to forget that night happening, just got a joke from one friend...you just read & try to compare the joke with my Saturday experience...

JOKE:

A rabbit was running towards forest when he saw a giraffe stop & said:

-- O giraffe! Stop smoking...that is shit it hurt you, lets run towards forest! You'll see you feel much better...giraffe thought for one second, and said:

-- You're right, rabbit, and he started running ....

-- he was running with the rabbit. Soon they found a bear sniffing glue. Rabbit jumped immediately in front of Bear:

-- O bear, leave this shit! This can only hurt you, lets run with us and take the fresh air inside your lungs!

The bear jumped to the front and began to run with them until they find an elephant to sniffer cocaine. Rabbit again,

-- O elephant, you're crazy! you are doing this shit! Come with us...

The elephant thought a bit, and decided to join the group, which then found a loin who was about to inject heroine.

-- Again, our rabbit friend..., he jumped towards loin and Said:

-- O loin, this makes you shit, come with us for running....

NEVER.....loin replied...,other animals with strange & anger why you d'nt join us?

-- Are you crazy? Why you are doing this?

--The loin replied:

-- When ever this son of a bitch "Rabbit" takes Heroine, ask me to run...i am not an idiot to run until forest!


Cheers

Delete multi-owner disk set in Solaris.

The more i stuck in Solaris the more i like my Linux :-|

I was continuously in hot waters when unable to delete that fucking test multi-owner disk set from Oracle RAC, almost tried all i could but it was not doing...i left office yesterday almost 30 minute late n was really angry with me about delaying the RAC installation due to this multi-owner disk issue...

Today when i came office, i just started reading the metaset command manual & found -P & -W option/switch that can do it if you use them in sequence.

#metaset -s multi-owner-setname -w

this will release/withdraw host from this set.

#metaset -s multi-owner-setname -P

this will purge the disk set.

PS: these commands should be in same sequence i.e. first withdraw then purge & you should be running them as superuser/root

cheers

Download oracle using wget, A tiny howto

I have been bothered too many times to download oracle installer from otn.oracle.com, whenever i had to do so, i was reluctant just because OTN force us to download their installer using browser, i hate browser based huge files download, my love "wget" always support me...i was thinking that wget has a limit to do this task until today...i found the solution... just arguments usage !!!

Tiny Howto:

1. You have to browse until http://www.oracle.com/technology/software/products/database/index.html

2. select your choice of OS & Oracle version to download.

3. On clicking the link for download it will ask you to provide OTN's username,password that you must have to proceed, if you already singed it, provide it, otherwise you have to create it (its free) :p

4. After providing username,password it will start download your choice oracle installer, now you have to right click on downlaod bar "i am using firefox" & copy the "download link"

5. open command prompt/terminal and use wget as following...

wget -c --http-user=your-otn-username --http-passwd=your-otn-password http://download-llnw.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_db_sol.cpio.gz



cheers