Enjoy life as it comes...

Stephen Weblog

All about me…
Subscribe

Archive for May, 2008

WAMP5

May 23, 2008 By: admin Category: Tech No Comments →

Really had a tough time configuring php, mysql and apache together. Not sure what all the extensions we need to add to enable mysql with php. In came WAMP server which had one point solution for all the three.

Steps to work with wamp:

1. Download WAMP5 from here
2. Run the installer
3. Once installation is complete, open up your browser and give http://localhost
4. Thats it you are all set

Thanks,

Mozilla password exporter

May 23, 2008 By: admin Category: My Own No Comments →

I also fell prey for not remembering my online account passwords, so started using “Remember Password” option and was happily using this. Not always you stick to you own laptop or desktop you will have to change it when you move. So I desperately wanted to know what all passwords I used to save (but nothing came up to my mind). In came yet another Mozilla add-ons i.e., Password Exporter.

Steps to use:

1. Download Password Exporter
2. Install it and restart Mozilla
3. Goto Tools -> Add-ons
4. Select option from Password Exporter
5. Export all the password and import to any other machine

Thanks,

The Prestige

May 21, 2008 By: admin Category: Movies No Comments →

The Prestige - Hugh Jackman and Christian Bale both have their career as magicians and trying to outsmart the other by their own way. At one point of time Robert Angier (Jackman) gets bemused by the illusion magic show done by Alfred Borden (Bale). He then tries to run around Borden trying to find the secret behind the illusion. Angier getting desperate about the illusion magic moves to Colorado to meet Tesla and learn about the illusion magic. He in turn creates one illusion machine which runs on the basis of Physics law. Angier starts performing the real illusion with this machine which provokes Borden and tries to find out the mystery behind that plot. Climax is the ultimate part of the movie, I would not write anything about the climax here, just go ahead and watch it if you have not. One of the best classical movies which I have come across in quite some time.

Remove Blocking session

May 20, 2008 By: admin Category: Oracle Apps 2 Comments →

At times during patch application we might get into a deadlock situation, In order to remove the blocking session follow the below mentioned steps.

SQL> select process,sid, blocking_session from v$session where blocking_session is not null;

PROCESS SID BLOCKING_SESSION
———— ———- —————-
1234 361 367
1234 367 361

SQL> select SERIAL# from v$session where sid = 361 ;

SERIAL#
———-
42

SQL> alter system kill session ‘361,42′;

System altered.

SQL> select process,sid, blocking_session from v$session where blocking_session is not null;

no rows selected

Oracle Apps Cloning

May 19, 2008 By: admin Category: Oracle Apps No Comments →

Just out of interest started to write about my Oracle Apps Experience, so here goes my first blog on Oracle Apps i.e., Rapid Clone of Oracle Applications:

1. Pre-clone Apps Tier and DB Tier in the source system:

  • cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
  • perl adpreclone.pl dbTier
  • cd <COMMON_TOP>/admin/scripts/<CONTEXT_NAME>
  • perl adpreclone.pl appsTier

2. Copy the below mentioned directories from source to the target machine:

  • rcp -r visappl <<user>>@<<hostname>>:<<target location>>
  • rcp -r viscomn <<user>>@<<hostname>>:<<target location>>
  • rcp -r visora <<user>>@<<hostname>>:<<target location>>
  • rcp -r visdata <<user>>@<<hostname>>:<<target location>>
  • rcp -r visdb <<user>>@<<hostname>>:<<target location>>

3. Configure target system:

  • cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
  • perl adcfgclone.pl dbTier
  • cd <COMMON_TOP>/clone/bin
  • perl adcfgclone.pl appsTier

4. Post checks

Concurrent Managers might not come up in the cloned instance because some of the CM tables will still hold the source instance details, so to bring up CM run this script and bounce CM.

$FND_TOP/patch/115/sql/afdcm037.sql

Thats it, you are all set with your cloned instance.

IPL Cricket fever

May 19, 2008 By: admin Category: My Own 1 Comment →

Now that IPL cricket fever is on, and every body is trying to get into top4 slots… if you happen to miss out on any of your favorite match then don’t worry here you go watch matches online when you are free…

http://cricket4ever.net/index.php/Table/IPL-Indian-Premier-League-2008-T20-Tournament/

Not bad

May 16, 2008 By: admin Category: My Own No Comments →

Good one

Hosting on Wordpress!!!

May 16, 2008 By: admin Category: My Own 9 Comments →

Website hosting was always a black box for me until I figured out Wordpress. One of the most easiest way of hosting website. I had a great experience in hosting my site with Wordpress, so I thought of listing out what need to be done so that others can also have fun with their own.

There are two main thing which need to be done:

  1. Get your domain name registered with any of service provider, I had registered my site with godaddy.They took around 18$ from providing domain name for 2 years validity. We need to keep renewing the account. Use paypal for paying your funds.
  2. Then you need to find some place where you want to host your website. There are many providers who will provide server space for free. One such provider is 11omb. I created free account with 110mb and uploaded my contents.

You can also get server space from the service provider also, but you might have to pay them a bit more $’s. To do some cost cutting I hosted on 110MB.com and did a Name space mapping from godaddy.com to 110mb.com.

DNS records should be set to: NS1.110MB.COM & NS2.110MB.COM

Just login 110mb.com with your user name and password and start uploading the files and access it with you domain name.

Now that you have your domain name and hosting area, how do you develop a website which is very easy to maintain. Wordpress is one point solution for all these, just down load wordpress and follow the read me, now just upload all the files to 11omb and you are all set with your site. Also note that wordpress does require mysql support so purchase Mysql support from 11omb by paying 10$.

If you have any further help on hosting site please feel free to contact me. Hope this helps many aspirants who are hoping to host their own sites.

Thanks,

Hyundai i10 advertisement

May 12, 2008 By: admin Category: My Own No Comments →

Not sure how many would have closely noticed Hyundai i10 advertisement which is done by SRK. This add keeps coming in during IPL matches - when the add starts watch SRK’s hand when he changes the gear, he will not be wearing any watch. After couple of seconds they will show SRK and in this time watch his hand closely while driving. He will be wearing watch on his left hand. Which means that initial part of the add was done by someone else… Poor add maker released this add with a bug :)

Ctrl+Alt+Del… No longer works until ???

May 06, 2008 By: admin Category: My Own 1 Comment →

Last week Trojan hit my laptop via IE and it disabled my Ctrl+Alt+Del option. Checked in the net and did not find anything useful… Until Vasanth found me this (Spyware doctor from Google Updater), downloaded this Spyware and installed it and ran Complete scan, it found around 80 infected files and fixed all of them. Now my Ctrl+Alt+Del is back again.Dont ask how these Trojan hit my laptop :)