Did not run Startup Migrate

I did not run a catpatch.sql after I upgrade from Oracle 9.2.0.1 to 9.2.0.7 !

When I do a catexp.sql, the database lock some tables. I panic!

Luckily we have a DBA in the house. He found out I forgot to run catpatch and I run it. It works like a charm now...

Humorus Contest 2006

I am going for Humorous speech contest on 4th Sept. But first I have to do speech No. 6 first because minimum requirement to do contest is to do at least 6 speeches... After the 6, I will ask my EXCOs to pick up my most humours speeche either between 5th or 6th to use it for contest.

My 6th will be about my Computer Game Addiction.

---- ---- ---- ---- ---- ----
Another life embarassing moment happened to me last Sunday. I was short of $ when I want to pay dinner for 4 of us (1 guy and 3 girls)! Cost $67, and I only got $35! I thought I heard $17 so pay $20 but the girl beside me, M** :) pay another $50.... Oh Dear! I am so embarassing!

Hopefully I can still call her out later :(

SMS to her yesterday but no reply :(

Never go out with girls with empty $ - Rule No. 2 when go dating!

How to do the Object Library?

I have a big headache here! the K*** project object library is all screw up! It's shared by 8 modules and each components is not refereing back to the project object library!

How to make it a 'whole' again?

Now is .NET and PG4MQ conflict!

Try to for PG4MQ gateway with a .NET application, gateway having conflicts with .NET oracle components.

Maybe a tnsnames or listnener problem. Not sure yet.

----
14/7/2006

Thank god I solve the problem 2 weeks later. Problem with the path. The PATH should call ora9i first before calling 10gr2, because suppose to pick up ora9i libraries, not 10gr2.

So many things I can do

Last Saturday COT training has come out with a VPPR list. Should I give suggestion to form another Yahoogroups? It doesn't last long sometimes. Wonder good Idea to do?

Sometimes you do not know what is your priority in life...

When the students of LB ask me how to juggle between thier studies, work, etc. I always ask them to look at what is thier initial plan to come here, Malaysia?

Thier priority here is to study. If they can get extra money, it's a bonus!

But sometimes... I do not know my own priority.

32 bit or 64 bit ?

How to know if your are running 32 or 64 bit windows? Look at the environment variables:

Environment Variable \ Program Bitness : PROCESSOR_ARCHITECTURE
32bit Native : x86
64bit Native : AMD64 or IA64
WOW64 : x86

Environment Variable \ Program Bitness :PROCESSOR_ARCHITEW6432
32bit Native : undefined
64bit Native : undefined
WOW64 : AMD64

Another New Project and J* in TM

Just discuss with 2 old ex-collegues. Going to put thumb print and photos in application. Need to do a Proof of Concept 1st. Need New machine to do PoC. Also need time. Where to find time?

Saturday got COT for TM. 1.30 to 6pm, also, where to find time?

Just found out J* just join TM in Digi. Surprise she joint.

TME No.3 and The girl

I just did TME the third time yesterday. Talking about the ThosaiMaster joke. The GE said that I did it too long. I should just do one liner, and that's enough!

I invited her to my meeting. By the way, I ask her out on saturday, and we had dinner, movie, and starbucks! It's a great time with her!

After the meeting, I feel like I want to talk to her more, but because it's late, and the time, etc. etc. feel like want to take her home and take care of her... Same feeling I had with my 1st one.

Wonder how she feel about me? Wonder I am getting the wrong signal? She likes me because I am a Toastmaster, or the real me?

TME Next Monday!

I am the TME for next Monday! I am going to talk about ThosaiMaster this time! :)

How to check what's inside an Oracle dump file.

This is just a reminder for me, always forget how to check an oracle dump file.

imp userid=username/passwd@sid rows=n full=y file=the_dump.dmp show=y indexfile=the_dump.txt

MQ and Oracle

Finaly I know how to install MQ and Oracle! When I install MQServer, I should have uninstall MQClient first but instead I install MQServer in the same directory as MQCleint! What a big mistake I made! This only found out by Oracle Support later...

This should be the sequence:

1) MQClient or Server
2) Install Database
3)Install Gateway

3options and CMA -> MQ

I found out 3 options to connect to the MQ.

1. Use a 'host' command: amqsput Q1 QM_APPLE < a.text
but using amqsputc only allow 100 characters! and somemore Host command



****************************************************
Finally Oracle Support give me a solution on how to do a CMA->MQ, (last Thursday)! But I can only do this on my PC, OracleHome9.2.0.7, OracleGateway9.2.0.7, and IBM MQ Series V6.

Also found out that:

1. the Gateway executable is in the Oracle_Gateway_Home\bin\pg4mqc92, not in oracle_gateway_home\pg4mqseries\bin as describe in the docs

2. The Gateway should install separately from the Oracle Database Home.

3. Need to use a different port, NOT the database port 1521. Using 1522 for the Gateway!

Try to do it on my customer site but failed. I also found out that the OracleListenere in the System Control Panel can give login name and password. Really learn a lot from this project :)

TM meeting, Dell, and CMA->MQ

Long time never update. keep on forgetting.

First time do a humorous soeech no one laugh! I talk about T-Shirt wear inside out and backward front!

Got Dell new notebook with duo core T2300, 1.6 Mhz. cost $4800. Manage to sell my old compaq for $1500. good deal?

CMA->MQ project big headache. What to do?

**** introduce new girl *** to me. Surprise she's an ex-TM !
I think she's very nice. must get to know her more!

Getting a Dell Duo Core

I just order online from Dell a Duo core yesterday! I decide to put 15G for WinXP alone, 20G for Linux and the rest is just pure data. Figure out a way to run WinXP and Linux at the same time... VMware can do or not?

Another Invocation on Monday.

Wrote another Invo on Monday but not sure can make it or not because got meeting 2.30pm in KL (regarding the CMA-MQ-idoc) project. But promised A will send speech to him if cannot make it. Wonder who will do the invo if I cannot make it?

New contract with Mr. D and Manage to get book!

Yesterday went to discuss New project/ contract (CMA-MQ-idoc) with Mr. D. It's a 5 days Oracle PL/SQL data loading project. Look easy. Have to write script to load file to MQ. MQ will update to idoc. Idoc will return message back to MQ and back to CMA (my script).

Great learning oppurtunity!

Manage to download the e-book! Cannot wait to print out all the PDF and read!

Borders

Just visited Borders last Sunday. First time spend 2 hours in a Book Store just by reading a book on a sofa! Should do this often. Found one book, tempted to buy but must wait for sale on 27th this month! Can't wait! Also found the book's seed in bit torrent. Ask R to help download for me. Wonder can get it?

Can use my printer to print all books! Save a lot of money that way.

TME on 10/4/2006 - Rehearse, upload and download

I am a TME on 10/4/2006, theme title 'Fast and Furious'.

I tied my tounge all the time! I don't feel nervous but I just tied my tounge! I have problem pronouncing, ne-go-tia-tion and op-ti-mis-ti-cal. K said that I did not rehearse well. I have to read my script once to 'upload' and when I am on the lecturn, I should just do a 'auto-download'

Rehearse, upload and download. That's the way to do it!

Dog days are here!

Oh dear! I have CILA user training on Wednesday! Do not know how many bugs to fix!? I got TM meeting on Monday, where I am the TME. Tommorrow Saturday got Division Contest, want to go and see, but cannot go to work! R and B is having holiday, R in Redang and B in India! Want to call W out for movie, just knew her last week. Nice to talk to. Wonder how she feels about me? Oh! Dog days are here again!