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