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

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

Original text of this message