Hi,

I'm having problems using sqlplus on OS X. I'm trying to connect to my
college's server. They supplied the tnsnames.ora. If I run 10g client
in Windows (via VirtualPC on the Mac, very slow) I can connect fine. In
OS X using sqlplus I get:

./sqlplus mylogin/mypass@grok

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Feb 16 22:59:08 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

I have the following env variables set:

echo $ORACLE_HOME
/Applications/oracle/product/10.1.0/client_1

echo $TNS_ADMIN
/Applications/oracle/product/10.1.0/client_1/network/admin

And my tnsnames.ora file is in the above folder.

tnsping produces the following:

./tnsping grok

TNS Ping Utility for MacOS X Server: Version 10.1.0.3.0 - Production on
16-FEB-2005 23:00:50

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/Applications/oracle/product/10.1.0/client_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = grok)= TCP)(HOST = minerva.humber.ca)(PORT = 1521))
OK (110 msec)

I'm very new to Oracle, but not to Linux/Unix. Any help/suggestions
would be appreciated.

Thanks,
Doug