Re: Ora-12514
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Tue, 03 Mar 2009 18:52:34 -0600
Message-ID: <njkrl.8147$jZ1.3408_at_flpi144.ffdc.sbc.com>
Ming? 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, 03 Mar 2009 18:52:34 -0600
Message-ID: <njkrl.8147$jZ1.3408_at_flpi144.ffdc.sbc.com>
Ming? 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
did you configure both in your listener.ora and tnsnames.ora? - I see you have ONAMES as the first entry - do you have and did you configure ONAMES? what does tnsping say when you try to connect? what does lsnrctl say? Received on Tue Mar 03 2009 - 18:52:34 CST