sqlplus 10g and OS X

From: Doug <some_at_dude.com>
Date: Wed, 16 Feb 2005 23:06:04 -0400
Message-ID: <xSTQd.7735$dZ.502884_at_news20.bellglobal.com>



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_at_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 Received on Thu Feb 17 2005 - 04:06:04 CET

Original text of this message