home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 2,004 of 2,288   
   Doug to All   
   sqlplus 10g and OS X   
   16 Feb 05 23:06:04   
   
   From: some@dude.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@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca