From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Tim X Newsgroups: gmane.emacs.help Subject: Re: Help for sql-oracle mode Date: Thu, 28 Feb 2008 19:14:51 +1100 Organization: Rapt Technologies Message-ID: <87bq614hvo.fsf@lion.rapttech.com.au> References: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: ger.gmane.org 1204188108 32079 80.91.229.12 (28 Feb 2008 08:41:48 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Thu, 28 Feb 2008 08:41:48 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Feb 28 09:42:14 2008 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1JUeLB-0007sj-LM for geh-help-gnu-emacs@m.gmane.org; Thu, 28 Feb 2008 09:42:09 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JUeKf-00021q-9H for geh-help-gnu-emacs@m.gmane.org; Thu, 28 Feb 2008 03:41:37 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!postnews.google.com!news3.google.com!sn-xt-sjc-04!sn-xt-sjc-09!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.0.60 (gnu/linux) Cancel-Lock: sha1:XAejxq/ymu2tFIh2Wzz+4HyRlxI= Original-X-Complaints-To: abuse@supernews.com Original-Lines: 50 Original-Xref: shelby.stanford.edu gnu.emacs.help:156563 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:51931 Archived-At: "misskiss wang" writes: > Dear Friends, > > I like to using sql-oracle in emacs, but now I met a problem: The database I > logged on no need to input username and password, both fields are empty. If I > ran M-x sql-oracle in emacs, and I press ENTER butter two times and then input > Server string, for example like DB1, I got an error like this: > > SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 28 14:03:40 2008 > > Copyright (c) 1982, 2005, Oracle. All Rights Reserved. > > Enter user-name: > ERROR: > ORA-12560: TNS:protocol adapter error > > Enter user-name: > ERROR: > ORA-12560: TNS:protocol adapter error > > Enter user-name: > ERROR: > ORA-12560: TNS:protocol adapter error > > SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus > > Process SQL exited abnormally with code 1 > Can you access the database just running SQL-Plus? Oracle is natorious for providing misleading error messages. For example, you will get that same error message if you specify the wrong SID. The first thing I wold do is try sqlplus DB1 and hit enter when prompted for the username and password. If that works, then we know the problem isn't with Oracle and have to look closer at sqlplus. Tim P.S. I've never seen an Oracle database that didn't require a username - the username determines the schema - I guess you can have one, just never come across it before. -- tcross (at) rapttech dot com dot au