sqlplus 10g and OS X
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