Re: Ora-12514(B
From: Ming$BGl(B <leo_at_tech-trans.com>
Date: Wed, 4 Mar 2009 08:15:53 -0800 (PST)
Message-ID: <e0ce260b-179c-47cc-8736-14e64526bcfd_at_k9g2000prh.googlegroups.com>
On 3$B7n(B4$BF|(B, $B>e8a(B9$B;~(B34$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
>
> 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?
Date: Wed, 4 Mar 2009 08:15:53 -0800 (PST)
Message-ID: <e0ce260b-179c-47cc-8736-14e64526bcfd_at_k9g2000prh.googlegroups.com>
On 3$B7n(B4$BF|(B, $B>e8a(B9$B;~(B34$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
>
> 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?
It is static IP! Received on Wed Mar 04 2009 - 10:15:53 CST