Re: Ora-12514

From: <johnbhurley_at_sbcglobal.net>
Date: Tue, 3 Mar 2009 17:34:41 -0800 (PST)
Message-ID: <30858def-75b3-4b95-8498-cc10e8e14d2e_at_p2g2000prf.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

Forgot to add ( since we don't run any of our database on windows systems ) are you setup using a static IP address or if not did you correctly configure a loopback adapter? Received on Tue Mar 03 2009 - 19:34:41 CST

Original text of this message