Re: Ora-12514(B

From: Ming$BGl(B <leo_at_tech-trans.com>
Date: Wed, 4 Mar 2009 08:15:03 -0800 (PST)
Message-ID: <3af7d750-cda8-4d47-9346-06bdaea6393c_at_40g2000prx.googlegroups.com>

On 3$B7n(B4$BF|(B, $B>e8a(B8$B;~(B50$BJ,(B, johnbhur..._at_sbcglobal.net wrote:
> On Mar 3, 7:43 pm, Ming$BGl(B <l..._at_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_at_XXX as sysdba
> > 3. add names.directory_path = (ONAMES, TNSNAMES, HOSTNAME) in
> > sqlnet.ora
>
> > Ming
>
> What version of oracle and windows?
>
> Maybe the instance is down or something wrong in your listener config?
>
> Can you check if both instances are running?
>
> What exactly do your listener.ora, tnsnames.ora and sqlnet.ora files
> contain?

Windows 2003 server Enterprise Edition with Oracle 10.2.0.4.0 At the same time, I go to check the status of Oracle instance therefore I use sqlplus /nolog Received on Wed Mar 04 2009 - 10:15:03 CST