Wednesday, June 17, 2009

Why I love this job.

I'm just getting started using Oracle. So, naturally I need a nice visual client to work with. Even though I run a Mac it's easier to run this on my Parallels Windows/XP session due to VPN issues (don't ask). So, off I go to install a client.

Get Oracle Insta-client 11.01.
Get sqlplus too while I'm at it.
Find and change environment settings in Windows.
Get tnsnames.ora file from a unix box that I know works.
Test sqlplus. Yippee it works!
Get Toad.
Toad crashes; it won't support 11.x. Gotta downgrade to 10.x
Get another Oracle Insta-client 10.2
Change environment settings in Windows again.
Start Toad.
Uh oh. missing DLL.
Find DLL on web, download, install, reboot.
Yea! Toad works and connects.

Life should not be this hard.

No comments:

Post a Comment