Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!q9g2000yqc.googlegroups.com!not-for-mail
From: bdbafh <bdbafh@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Ora-12514
Date: Tue, 3 Mar 2009 19:10:37 -0800 (PST)
Organization: http://groups.google.com
Lines: 28
Message-ID: <94aa5521-4d57-4f4a-931f-153188c0f270@q9g2000yqc.googlegroups.com>
References: <a051ab1e-29a8-4958-9939-5920c12057d3@k36g2000pri.googlegroups.com>
NNTP-Posting-Host: 24.152.206.60
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1236136238 30177 127.0.0.1 (4 Mar 2009 03:10:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Mar 2009 03:10:38 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: q9g2000yqc.googlegroups.com; posting-host=24.152.206.60; 
 posting-account=0toJfgkAAAB7KgOxj8byjWUKgIYjMLCa
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6) 
 Gecko/2009011913 Firefox/3.0.6,gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Mar 3, 7:43 pm, Ming伯 <l...@tech-trans.com> wrote:
> Hi!
>
>   My Windows base Oracle server has 2 Oracle instances.  However, when
> I connect to one of instance by sqlplus, Ora-12514 occurs!  How can I
> do? I have tried the following methods
> 1.  set oracle_sid=XXXX
> 2.  sqlplus /nolog | connect sys@XXX as sysdba
> 3.  add names.directory_path = (ONAMES, TNSNAMES, HOSTNAME) in
> sqlnet.ora
>
> Ming

Why would you set the environment variable "ORACLE_SID" if you're
going to connect through the listener?
If you are going to connect locally (bequeath), line #2 should read

sqlplus / as sysdba

in which case sqlnet.ora should read:
sqlnet.authentication_services=(NTS)

and names.directory_path matters not.
On the localhost, bypass the listener entirely.

hth.

-bdbafh