From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Misskiss Newsgroups: gmane.emacs.help Subject: Re: Help for sql-oracle mode Date: Thu, 28 Feb 2008 09:05:03 -0500 Message-ID: <87fxvdi3cg.fsf@Bashee.pd.intel.com> References: <87bq614hvo.fsf@lion.rapttech.com.au> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: ger.gmane.org 1204248643 27454 80.91.229.12 (29 Feb 2008 01:30:43 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Fri, 29 Feb 2008 01:30:43 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Feb 29 02:31:08 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 1JUu5Z-0005no-9r for geh-help-gnu-emacs@m.gmane.org; Fri, 29 Feb 2008 02:31:05 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JUu52-0001cT-Sx for geh-help-gnu-emacs@m.gmane.org; Thu, 28 Feb 2008 20:30:32 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1JUu4m-0001cN-02 for help-gnu-emacs@gnu.org; Thu, 28 Feb 2008 20:30:16 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1JUu4j-0001c8-I0 for help-gnu-emacs@gnu.org; Thu, 28 Feb 2008 20:30:14 -0500 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JUu4j-0001c5-BW for help-gnu-emacs@gnu.org; Thu, 28 Feb 2008 20:30:13 -0500 Original-Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1JUu4j-0003le-3A for help-gnu-emacs@gnu.org; Thu, 28 Feb 2008 20:30:13 -0500 Original-Received: from root by ciao.gmane.org with local (Exim 4.43) id 1JUu4Y-0006mr-Ew for help-gnu-emacs@gnu.org; Fri, 29 Feb 2008 01:30:06 +0000 Original-Received: from 222.212.132.25 ([222.212.132.25]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 29 Feb 2008 01:30:02 +0000 Original-Received: from misskiss.wang by 222.212.132.25 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 29 Feb 2008 01:30:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 65 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 222.212.132.25 User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.0.60 (gnu/linux) Cancel-Lock: sha1:4NeWGx8rk3WlIVFWzrXwuHwNbKc= X-detected-kernel: by monty-python.gnu.org: Linux 2.6, seldom 2.4 (older, 4) 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:51953 Archived-At: Tim X writes: > "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 > Thanks a lot for the help! I tried "sqlplus DB1", it's the same problem, I still cannot login DB server. However, if I use a GUI tool to login the server, leave both user name and password as blank, I can login the server. It's really unconvininet for me... Is there any good solutions? Thanks a lot! Misskiss -- You are always busy.