Maclochlainn's Weblog

Michael McLaughlin's Old Technical Blog

Posts Tagged ‘Oracle Client Mac

That old $TNS_ADMIN environment variable

leave a comment »


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 1, 2008 at 3:22 am

More on Configuring the Mac OS for Oracle 10g Client

with one comment


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.