Re: Ora-12514
From: <johnbhurley_at_sbcglobal.net>
Date: Tue, 3 Mar 2009 16:50:18 -0800 (PST)
Message-ID: <cb18a62f-aa08-467c-a037-ea5675f5525a_at_i20g2000prf.googlegroups.com>
On Mar 3, 7:43 pm, Ming伯 <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
Date: Tue, 3 Mar 2009 16:50:18 -0800 (PST)
Message-ID: <cb18a62f-aa08-467c-a037-ea5675f5525a_at_i20g2000prf.googlegroups.com>
On Mar 3, 7:43 pm, Ming伯 <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? Received on Tue Mar 03 2009 - 18:50:18 CST