Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus wrong?

Re: sqlplus wrong?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sun, 10 Oct 2004 15:42:38 +0200
Message-ID: <70fim0l4sbns5oi907b7m9qoc1mi179pcu@4ax.com>


On Sun, 10 Oct 2004 01:28:53 -0400, "MaoXuePeng" <mxp123q_at_126.com> wrote:

>I can not connect to the server by the sqlplus through
>"user/password_at_servername".
>But it is successfully connected while tested by the "Net Manager", and
>tnsping is successful also.
>
>What's the problem?
>Is my sqlplus wrong?
>
>Thanks!
>MaoXuePeng.

without Oracle version and any pertinent error message it is impossibly to help you. Right now I can only guess you get ora-12154 and have multiple tnsnames.ora floating around, or multiple oracle homes, or didn't set tns_admin.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Oct 10 2004 - 08:42:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US