MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Archive for the ‘Oracle Client Mac’ tag

That old $TNS_ADMIN environment variable

without comments

Somebody reminded me that I should include the $TNS_ADMIN variable to avoid unnecessary file searches (minor expense) in the Mac configuration instructions. This eliminates additional searches when running sqlplus and tnsping executables. I’ve updated that blog page with those instructions. It’s not necessary to make it work but it does avoid a read to the local and /etc directories on your Mac OS X for a tns_names.ora file before reading it from the $ORACLE_HOME/network/admin directory.

Written by maclochlainn

November 1st, 2008 at 3:22 am

More on Configuring the Mac OS for Oracle 10g Client

without comments

I’ve been revising and correcting typos plus adding new content to that Configuring Mac OS for the Oracle 10g Client blog page. It’s more complete now. It also shows you how to connect from one virtual machine to another by using host file resolution.

Also, I’ve decided that the network configuration steps for VMWare NAT belong in a separate blog page. I’ll try to get that out after Oracle OpenWorld 2008. For those you can’t wait, you’ll find the networking files here:

Mac OS X:

/Library/Application Support/VMWare Fusion/vmnet8

Linux:

/etc/vmware/vmnet8

Windows:

C:\WINDOWS\System32

You’ll find three files. The dhcpd.conf file configures DHCP. The nat.conf file configures incoming ports to your virtual machines, which is known as port forwarding. The mac.conf file stores the physical layer MAC address for your machine.