Re: Ora-12514
From: bdbafh <bdbafh_at_gmail.com>
Date: Tue, 3 Mar 2009 19:10:37 -0800 (PST)
Message-ID: <94aa5521-4d57-4f4a-931f-153188c0f270_at_q9g2000yqc.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 19:10:37 -0800 (PST)
Message-ID: <94aa5521-4d57-4f4a-931f-153188c0f270_at_q9g2000yqc.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
Why would you set the environment variable "ORACLE_SID" if you're
going to connect through the listener?
If you are going to connect locally (bequeath), line #2 should read
sqlplus / as sysdba
in which case sqlnet.ora should read:
sqlnet.authentication_services=(NTS)
and names.directory_path matters not.
On the localhost, bypass the listener entirely.
hth.
-bdbafh Received on Tue Mar 03 2009 - 21:10:37 CST